Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Quickbooks issues Rate Topic   - - - - -

 
  • mink
  • Developer
  • Authorized Reseller
  • Join Date: 03-Oct 12
  • 27 posts

Posted 03 October 2012 - 09:01 AM #1

Dear CS-Cart users,

My name is Sergey Minukevich and I am a CS-Cart developer.

Here is the list of the reported issues related to export from CS-Cart to Quickbooks in IIF format:

1) Your export still deletes the "cost"
2) It still changes the item description when it should NOT
3) It still deletes the "preferred vendor"
4) It still changes the default account


The fields cost, item description, preferred vendor and default account do not exist in CS-Cart database, so when CS-Cart generates an IIF file such fields are empty in the exported file.

Unfortunately, I am not fully aware of all the Quickbooks IIF import peculiarities, but it seems like all product data including description, cost, preferred vendor and default account are overwritten on import.

Therefore even if we remove these fields from the CS-Cart export script or leave them blank, Quickbooks import script overwrites them with default values.

As an alternative, we might add these fields to the product editing page in the CS-Cart administration panel and export these values in IIF files.

The disadvantage of this solution is that the administrator will have to manually synchronize the appropriate field values between CS-Cart and Quickbooks.

Please let me know if you have any other issues with Quickbooks or any suggestions about these 4 issues.

Thank you.
Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER
LICENSES | DEVELOPMENT | ADD-ONS | DESIGNS | UPGRADES

 
  • webjive
  • Junior Member
  • Members
  • Join Date: 27-May 11
  • 38 posts

Posted 04 October 2012 - 12:24 PM #2

What I found works best is Quickbooks integration from Webgility.com (eccCloud)
Eric Caldwell - CEO
Web-JIVE LLC
www.web-jive.com
501-58801979

 
  • clips
  • Aged Resident Loon
  • Members
  • Join Date: 14-Jan 07
  • 1650 posts

Posted 04 October 2012 - 01:54 PM #3

The interesting part is Webgility, Write It Once and others are able to take the orders in and not mess up Quickbooks. So maybe you should get with them and see what they are doing. The bottom line is something in your .iif file messes up QBs and when I use Write it Once to import a file I exported from CS-Cart and put it into Write it Once (Shopping Cart Assistant) then the Write it Once program post it in to Quickbooks it doesn't mess up anything.
Regards,
Jim

 
  • knoxbury
  • Senior Member
  • Members
  • Join Date: 14-Jan 08
  • 483 posts

Posted 04 October 2012 - 02:21 PM #4

You should be using Intuit Anywhere like Pinnacle and Webgility . . . otherwise you're just putting a bandaid on a gaping wound.

 
  • Magpie Don
  • Senior Member
  • Members
  • Join Date: 01-Apr 09
  • 814 posts

Posted 04 October 2012 - 03:58 PM #5

I had to learn how to write and edit iif files. IIF files are Quickbook's standard import format.
I don't know how a person expects to import data from any sales program (like CSCart) into the backend accounting software without knowing how to edit the IIF file output included with CSCart's IIF Template.
It was not difficult - Quickbooks provides you with many samples to work with.

I should mention that I use Manufacturing and Wholesale edition of Quickbooks. Most of my products are what QB calls "Builds".

I do not export the product date, so I'm not importing any cost fields.
I only export the customer and order data - because QB is accounting software, and that's all you should need to export from your sales frontend.

I DID export the product data from CS-Cart the first time I set up Quickbooks, because I had my product data in CSCart first and I wanted all my part numbers to match up, but if a company was a long time Quickbooks user (or at least used Quickbooks prior to setting up their CS-Cart store), they would not need to do this - in fact they would be going the other direction.

IMO most of the impatience with Quickbooks is over CS-Cart users not wanting to learn how to write IIF files. If you had read the examples that QB provides, you know that you do not need to import the cost for a product when you are setting it up.
I don't know how CS-Cart can do that all this for you - but I have not looked at QB's other web integration or synchronization processes.
IF CS-Cart implements some synch process I hope it doesn't overwrite my product Build data. Synching inventory quantities would be nice, but not if it modifies the product data. My backend will often times have different values than the frontend in the data.

IF CS-Cart is going to improve the existing process, I would suggest at least the following:
1. option for exporting product data only
2. option for exporting order data only
3. option for customers that pay sales tax / do not pay sales tax
4. change the sequence for building the order so order discounts can be imported as line items, and sales tax and shipping charges get imported in the proper order and assigned to the correct sales account. Sales tax should not be a line item.

Here is a copy of the IIF template I have used for the last two years after much experimentation (I have not applied this to v3 yet):

{* $Id: export_to_iif.tpl 10030 2010-07-09 11:41:11Z andyye $ *}
{*!ACCNT{$_d}NAME{$_d}ACCNTTYPE{$_d}SCD{$_d}EXTRA{$_d}HIDDEN
ACCNT{$_d}{$addons.quickbooks.accnt_tax}{$_d}INC{$_d}{$_d}{$_d}
*}
{******************** EXPORT CUSTOMERS *******************}
!CUST{$_d}NAME{$_d}BADDR1{$_d}BADDR2{$_d}BADDR3{$_d}BADDR4{$_d}BADDR5{$_d}SADDR1{$_d}SADDR2{$_d}SADDR3{$_d}SADDR4{$_d}SADDR5{$_d}PHONE1{$_d}FAXNUM{$_d}EMAIL{$_d}CONT1{$_d}SALUTATION{$_d}COMPANYNAME{$_d}FIRSTNAME{$_d}LASTNAME{$_d}TAXABLE{$_d}SALESTAXCODE{$_d}TAXITEM
{foreach from=$order_users item="order"}
{if $order.b_state == "OH"}{*** state sales taxable customer ***}
CUST{$_d}{$order.lastname}, {$order.firstname}{$_d}{$order.b_firstname} {$order.b_lastname}{$_d}{$order.b_address} {$order.b_address_2}{$_d}{$order.b_city}{$_d}"{$order.b_state}, {$order.b_zipcode}"{$_d}{$order.b_country_descr}{$_d}{$order.s_firstname} {$order.s_lastname}{$_d}{$order.s_address} {$order.s_address_2}{$_d}{$order.s_city}{$_d}"{$order.s_state}, {$order.s_zipcode}"{$_d}{$order.s_country_descr}{$_d}{$order.phone}{$_d}{$order.fax}{$_d}{$order.email}{$_d}{$order.lastname}, {$order.b_firstname}{$_d}{$order.title}{$_d}{$order.company}{$_d}{$order.firstname}{$_d}{$order.lastname}{$_d}Y{$_d}Tax{$_d}Ohio Sales Tax
{else}{*** no state sales tax ***}

CUST{$_d}{$order.lastname}, {$order.firstname}{$_d}{$order.b_firstname} {$order.b_lastname}{$_d}{$order.b_address} {$order.b_address_2}{$_d}{$order.b_city}{$_d}"{$order.b_state}, {$order.b_zipcode}"{$_d}{$order.b_country_descr}{$_d}{$order.s_firstname} {$order.s_lastname}{$_d}{$order.s_address} {$order.s_address_2}{$_d}{$order.s_city}{$_d}"{$order.s_state}, {$order.s_zipcode}"{$_d}{$order.s_country_descr}{$_d}{$order.phone}{$_d}{$order.fax}{$_d}{$order.email}{$_d}{$order.lastname}, {$order.b_firstname}{$_d}{$order.title}{$_d}{$order.company}{$_d}{$order.firstname}{$_d}{$order.lastname}{$_d}N{$_d}Non{$_d}
{/if}
{/foreach}
{******************** EXPORT ITEMS - commented out
!INVITEM{$_d}NAME{$_d}INVITEMTYPE{$_d}DESC{$_d}PURCHASEDESC{$_d}ACCNT{$_d}ASSETACCNT{$_d}PRICE{$_d}TAXABLE{$_d}SALESTAXCODE
{foreach from=$order_products item="product"}
INVITEM{$_d}{if $product.product_code}{$product.product_code}{else}{$product.product_id}{/if}{$_d}INVENTORY{$_d}{$product.product}{$product.selected_options}{$_d}{$product.product}{$product.selected_options}{$_d}{$addons.quickbooks.accnt_product}{$_d}{$addons.quickbooks.accnt_asset}{$_d}{$product.price}{$_d}{if $order.taxes}Y{else}N{/if}{$_d}{if $order.taxes}Tax{else}Non{/if}
{/foreach}
{hook name="quickbooks:export_items"}
{/hook}
*******************}
{******************** EXPORT ORDERS *******************}
!TRNS{$_d}TRNSTYPE{$_d}DATE{$_d}ACCNT{$_d}NAME{$_d}CLASS{$_d}AMOUNT{$_d}DOCNUM{$_d}MEMO{$_d}ADDR1{$_d}ADDR2{$_d}ADDR3{$_d}ADDR4{$_d}ADDR5{$_d}PAID{$_d}SHIPVIA{$_d}SADDR1{$_d}SADDR2{$_d}SADDR3{$_d}SADDR4{$_d}SADDR5{$_d}TOPRINT
!SPL{$_d}TRNSTYPE{$_d}DATE{$_d}ACCNT{$_d}NAME{$_d}CLASS{$_d}AMOUNT{$_d}DOCNUM{$_d}MEMO{$_d}PRICE{$_d}QNTY{$_d}INVITEM{$_d}TAXABLE{$_d}SALESTAXCODE{$_d}EXTRA
!ENDTRNS
{foreach from=$orders item="order"}
{********* SHIPPING **********}
{if $order.shipping_cost > 0}
{assign var="ship_name" value=""}
{foreach from=$order.shipping item=ship}
{if $ship_name}{assign var="ship_name" value="$ship_name; "}{/if}
{assign var="ship_name" value="$ship_name`$ship.shipping`"}
{/foreach}
{/if}
TRNS{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}Accounts Receivable{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}{$order.total}{$_d}{$order.order_id}{$_d}Website Order: {$order.details|replace:"\r":" "|replace:"\n":" "|replace:"\t":" "}{$_d}{$order.b_firstname} {$order.b_lastname}{$_d}{$order.b_address} {$order.b_address_2}{$_d}"{$order.b_city}, {$order.b_state} {$order.b_zipcode}"{$_d}{$order.b_country_descr}{$_d}{$_d}{if ($order.status == "P" || $order.status == "C")}Y{else}N{/if}{$_d}{$ship_name|truncate:15:""}{$_d}{$order.s_firstname} {$order.s_lastname}{$_d}{$order.s_address} {$order.s_address_2}{$_d}"{$order.s_city}, {$order.s_state} {$order.s_zipcode}"{$_d}{$order.s_country_descr}{$_d}{$_d}N
{********* PRODUCTS **********}
{foreach from=$order.items item="item"}
{strip}
{assign var="_tax" value=0}
{assign var="p_id" value=$item.cart_id}
{************* calculate tax for product *********}
{foreach from=$order.taxes item=tax}
{foreach from=$tax.applies item=tax_value key=cart_id}
{if ($tax_value > 0) && ($item.cart_id==$cart_id|substr:2) && $tax.price_includes_tax == "Y"}
{math equation="tax + tax2" tax=$_tax|default:"0" tax2=$tax_value|default:"0" assign="_tax"}
{/if}
{/foreach}
{/foreach}
{************* calculate tax for product *********}
{math equation="price*amount - tax" price=$item.price|default:"0" amount=$item.amount|default:"1" tax=$_tax|default:"0" assign="p_subtotal"}
{if $order_products.$p_id.product_code}
{assign var="p_code" value=$order_products.$p_id.product_code}
{else}
{assign var="p_code" value=$order_products.$p_id.product_id}
{/if}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_product}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}-{$p_subtotal|fn_format_price}{$_d}{$order.order_id}{$_d}{$order_products.$p_id.product}{$order_products.$p_id.selected_options}{$_d}{$item.price|fn_format_price}{$_d}-{$item.amount}{$_d}{$p_code}{$_d}{if $order.taxes}Y{else}N{/if}{$_d}{if $order.taxes}Tax{else}Non{/if}{$_d}{/strip}

{/foreach}


{*** PRODUCT TAXES ***}
{foreach from=$order.taxes item=tax}
{assign var="tax_total" value=0}
{foreach from=$tax.applies item=tax_value key=cart_id}
{math assign="tax_total" equation="x + y" x=$tax_total|default:0 y=$tax_value|default:0}
{/foreach}
{/foreach}

{********* GIFT CERTIFICATES **********}
{hook name="quickbooks:export_gift_certificates"}
{/hook}
{********** DISCOUNT **********}
{if $order.subtotal_discount > 0}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_discount}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}{$order.subtotal_discount}{$_d}{$order.order_id}{$_d}Order Discount{$_d}-{$order.subtotal_discount}{$_d}-1{$_d}DISCOUNT{$_d}N{$_d}
{/if}
{********* SHIPPING **********}
{if $order.shipping_cost > 0}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_shipping}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}-{$order|@fn_order_shipping_cost}{$_d}{$order.order_id}{$_d}{$ship_name}{$_d}{$order|@fn_order_shipping_cost}{$_d}-1{$_d}SHIPPING{$_d}N{$_d}
{/if}
{********* SURCHARGE **********}
{if $order.payment_surcharge > 0}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_surcharge}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}-{$order.payment_surcharge}{$_d}{$order.order_id}{$_d}Payment processor surcharge{$_d}{$order.payment_surcharge}{$_d}-1{$_d}SURCHARGE{$_d}N{$_d}
{/if}
{********* PAID BY REWARD POINTS **********}
{***NEEDS REVIEWED FOR V3***}
{if $order.points_info.in_use.cost > 0}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_discount}{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$addons.quickbooks.trns_class}{$_d}{$order.points_info.in_use.cost}{$_d}{$order.order_id}{$_d}Reward Points Used{$_d}-{$order.points_info.in_use.cost}{$_d}-1{$_d}POINTS USED{$_d}N{$_d}
{/if}
{********* PAYMENT BY GIFT CERTIFICATE **********}
{***NEEDS REVIEWED FOR V3***}
{hook name="quickbooks:export_payments"}
{/hook}
{********** AUTO TAX ************}
{if $order.taxes}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_tax}{$_d}Ohio Sales Tax{$_d}{$addons.quickbooks.trns_class}{$_d}-{$tax_total|fn_format_price}{$_d}{$order.order_id}{$_d}{$tax.description}{$_d}{include file="common_templates/modifier.tpl" mod_value=$tax.rate_value mod_type=$tax.rate_type}{$_d}-1{$_d}Ohio Sales Tax{$_d}N{$_d}{$_d}AUTOSTAX
{/if}
{if !$order.taxes}
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_tax}{$_d}Ohio Sales Tax{$_d}{$addons.quickbooks.trns_class}{$_d}-0{$_d}{$order.order_id}{$_d}{$tax.description}{$_d}0{$_d}-1{$_d}Out of State{$_d}N{$_d}{$_d}AUTOSTAX
{/if}
{**********
SPL{$_d}INVOICE{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}{$addons.quickbooks.accnt_tax}{$_d}Ohio Sales Tax{$_d}{$addons.quickbooks.trns_class}{$_d}0{$_d}{$order.order_id}{$_d}Out of State{$_d}0{$_d}0{$_d}Out of State{$_d}N{$_d}AUTOSTAX
************}

ENDTRNS
{/foreach}
{******************** PROCCESSED ORDERS *******************}
!TRNS{$_d}TRNSTYPE{$_d}DATE{$_d}ACCNT{$_d}NAME{$_d}AMOUNT{$_d}PAYMETH{$_d}DOCNUM
!SPL{$_d}TRNSTYPE{$_d}DATE{$_d}ACCNT{$_d}NAME{$_d}AMOUNT{$_d}DOCNUM
!ENDTRNS
{foreach from=$orders item="order"}
{if ($order.status == "P" || $order.status == "C")}
TRNS{$_d}PAYMENT{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}Undeposited Funds{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}{$order.total}{$_d}{$order.payment_method.payment}{$_d}{$order.order_id}
SPL{$_d}PAYMENT{$_d}{$order.timestamp|date_format:"%m/%d/%Y"}{$_d}Accounts Receivable{$_d}{$order.b_lastname}, {$order.b_firstname}{$_d}-{$order.total}{$_d}{$order.order_id}
ENDTRNS
{/if}
{/foreach}

Since each accounting backend configuration is going to be different, I don't see how you can set up one config that will work for all.
Lots of mapping I suppose, and plenty of more options for the variables in the output.
Options for exporting product data and/or customer data and/or sales orders is a step in the right direction though.
A range for product data import would be handy too. Sometime I set up the product in CS-Cart first and instead of duplicating the work, I will just export the products and delete all but the new ones.

Hope this helps - from a guy who actually uses what's included out of the box with CS-Cart.

edit: 2/2013 - highlighted some values excluse to Ohio Sales Tax that any other user will have to change and highlighted some values that will include State Sales Taxes properly in orders.

CS-Cart Ultimate ver 4.3.5


 
  • Magpie Don
  • Senior Member
  • Members
  • Join Date: 01-Apr 09
  • 814 posts

Posted 04 October 2012 - 04:57 PM #6

"Therefore even if we remove these fields from the CS-Cart export script or leave them blank, Quickbooks import script overwrites them with default values."

This is not true. Quickbooks will leave description, cost, preferred vendor empty. I'm not sure you can import an items without an account defined. An asset account is required - but you already support that.

"As an alternative, we might add these fields to the product editing page in the CS-Cart administration panel and export these values in IIF files."

That would be kind of silly, since CS-Cart is a sales tool, not accounting software.
A Cost field would be nice to have in CS-Cart, for a quick reference ONLY, but keeping the cost value in CS-Cart up to date would be a nightmare without running SQL queries - which most users are not going to do. It is safe to omit the cost field from the exported data - it won't overwrite the values in QB if it is not included in the export.

But I can't emphasize enough that you do not need to export the product data from CS-Cart at all during Order exporting.
Exporting product data is a ONE TIME event if you are setting up QB AFTER CS-Cart is set up. It is also convenient to have the option to export NEW product data - but is a poor practice for an administrator to work this direction.

Here's how the business flow SHOULD work:
1. Set up new product in QB.
2. Create Purchase Order in QB.
3. Receive product in QB.
4. Pay invoice from Purchase Order in QB.
5. Set up new product in CS-Cart.
Step 5 CAN be done prior to Step 3 IF you set up products for advanced sales (define an Availability date) in CS-Cart.

In no real world case, should you be adding products to your CS-Cart store prior to adding them to your accounting software. There is no need to export product data to QB, unless you are setting up QB AFTER set up CS-Cart product data and don't have any other accounting software to export the product data from!

CS-Cart Ultimate ver 4.3.5


 
  • Flow
  • Super Duper and Amazingly Sexy Senior
  • Members
  • Join Date: 13-Oct 10
  • 2292 posts

Posted 06 October 2012 - 07:06 PM #7

Sergey, my advice would be to dump quickbooks and write an add-on for Xero instead. Now THAT would make cs-cart so much more attractive for new customers! Also it would give you a massive amount of free publicity by being listed on their website. Xero is growing extremely fast!

When life hands you lemons, bring on the Tequila baby!


 
  • webjive
  • Junior Member
  • Members
  • Join Date: 27-May 11
  • 38 posts

Posted 06 October 2012 - 08:37 PM #8

We use Wave Accounting (free!) http://www.waveaccounting.com

LOVE this system.... QB is too much for a hosting and development biz like we have. I had some clients switch to Wave as well who didn't need QB and all the features.
Eric Caldwell - CEO
Web-JIVE LLC
www.web-jive.com
501-58801979

 
  • Struck
  • Teetering on Genious
  • Members
  • Join Date: 07-Mar 09
  • 2502 posts

Posted 06 October 2012 - 11:26 PM #9

Sergey, my advice would be to dump quickbooks and write an add-on for Xero instead. Now THAT would make cs-cart so much more attractive for new customers! Also it would give you a massive amount of free publicity by being listed on their website. Xero is growing extremely fast!


Flow, I just spent about an hour checking this out and was amazed to find that it has No built-in Purchase Order nor Inventory Control capabilites?

Pretty interface, but that isn't going to really help me run my business! ;-)

How can some of you guys compare this to Quickbooks which covers most every essential accounting business need from A-Z?
Cooking with Gas on Version 4.1.2 (But proceeding with caution....)

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4576 posts

Posted 07 October 2012 - 06:55 AM #10

No built-in Purchase Order nor Inventory Control capabilites?


This is a must for me, we use Sage Line 50 at the moment but would love an compatible programme

John

Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • Flow
  • Super Duper and Amazingly Sexy Senior
  • Members
  • Join Date: 13-Oct 10
  • 2292 posts

Posted 09 October 2012 - 09:02 AM #11

Flow, I just spent about an hour checking this out and was amazed to find that it has No built-in Purchase Order nor Inventory Control capabilites?

Pretty interface, but that isn't going to really help me run my business! ;-)

How can some of you guys compare this to Quickbooks which covers most every essential accounting business need from A-Z?


Xero has inventory: http://www.xero.com/...ware/inventory/ and PO is in the making. It's actually seen as the best replacement for quickbooks by just about anyone who tries it. Here's a nice review:
http://vm-associates...aas-consultant/

My plan to have ready by 1-1-2013:

Sync inventory with the shops (if I sell something online xero is updated. If I place an order and update inventory in xero, the shops will be updated. And so on).
Reconciliate the orders from our shops with payment processors (paypal orders are imported by xero automagically)
Xero also works great together with some POS tools... so if you can connect Xero and cs-cart, you will also have a POS.

I don't really need purchase orders yet as we are still small and we just send spreadsheets that we get from our vendors.

Also check out this site on which an accountant is compiling multiple online accounting software reviews: http://www.smallbusi...and-comparison/

When life hands you lemons, bring on the Tequila baby!


 
  • Flow
  • Super Duper and Amazingly Sexy Senior
  • Members
  • Join Date: 13-Oct 10
  • 2292 posts

Posted 09 October 2012 - 09:36 AM #12

We use Wave Accounting (free!) http://www.waveaccounting.com LOVE this system.... QB is too much for a hosting and development biz like we have. I had some clients switch to Wave as well who didn't need QB and all the features.


Eric, I tried Wave some time ago but found it very limited and time consuming compared to Xero. I can imagine they have improved.
Do you also upload cs-carts transactions into wave? Or do you only use psp feeds to get orders into Wave?

When life hands you lemons, bring on the Tequila baby!


 
  • Struck
  • Teetering on Genious
  • Members
  • Join Date: 07-Mar 09
  • 2502 posts

Posted 09 October 2012 - 10:35 PM #13

Xero has inventory: http://www.xero.com/...ware/inventory/ and PO is in the making. It's actually seen as the best replacement for quickbooks by just about anyone who tries it. Here's a nice review:
http://vm-associates...aas-consultant/

My plan to have ready by 1-1-2013:

Sync inventory with the shops (if I sell something online xero is updated. If I place an order and update inventory in xero, the shops will be updated. And so on).
Reconciliate the orders from our shops with payment processors (paypal orders are imported by xero automagically)
Xero also works great together with some POS tools... so if you can connect Xero and cs-cart, you will also have a POS.

I don't really need purchase orders yet as we are still small and we just send spreadsheets that we get from our vendors.

Also check out this site on which an accountant is compiling multiple online accounting software reviews: http://www.smallbusi...and-comparison/


Thanks for the comments Flow,

Best I can tell, Xero does not offer "Inventory Tracking" as in monitoring business inventory item counts without purchasing a 3rd party add-on with an additional monthly fee (which costs at least as much as the inital Xero monthly fee). There are many Xero forum posts of people wondering what the thinking was in omitting this capability from an otherwise nifty package.........

So, if you have a business that needs to manage inventory stock levels and create purchase orders against these items, then Xero does not currently offer these capabilties and you would also need to use 3rd party addons to handle these needs. Xero claims they are looking to add these features, although I could not find any definitive time frame or detailed plans.

I like alot of what I see in Xero, although, lack of any real inventory management will be a definite dealbreaker for many current Quickbooks, Sage, MYOB, & Peachtree users.

Xero will be an interesting contendor if & when they implement these key features.

One thing I did find quite nifty and could appreciate about Xero was that they offer a "Personal Finances" version as well so a user could scroll between working on both business as well as personal finances with the same platform.
Cooking with Gas on Version 4.1.2 (But proceeding with caution....)

 
  • mink
  • Developer
  • Authorized Reseller
  • Join Date: 03-Oct 12
  • 27 posts

Posted 10 October 2012 - 06:06 AM #14

Dear users,

Thank you for the comments.

You see, it is impossible to fix the issue described above by modifying the export file format. The fields will be overwritten anyway.

Integrating Quickbooks API for inventory and order update must solve the problem (similar to the Webgility solution), but at the moment this integration is not planned due to its high cost.

So we suggest you use specially designed solutions like the one made by our partner — http://www.webgility.com/

Their "eCC Cloud" solution can integrate your CS-Cart store with Quickbooks and allow you to exchange data quite conveniently.

Thank you.
Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER
LICENSES | DEVELOPMENT | ADD-ONS | DESIGNS | UPGRADES

 
  • Flow
  • Super Duper and Amazingly Sexy Senior
  • Members
  • Join Date: 13-Oct 10
  • 2292 posts

Posted 10 October 2012 - 11:36 AM #15

Thanks for the comments Flow........


Thanks Struck. I honestly just assumed this was what their inventory feature was. Looking at competitors now... Kashflow: http://www.kashflow.com/features/ looks pretty cool, and also http://www.e-conomic...onmodules/stock

But maybe a full blown ERP program like Openerp is the way to go.

When life hands you lemons, bring on the Tequila baby!


 
  • Struck
  • Teetering on Genious
  • Members
  • Join Date: 07-Mar 09
  • 2502 posts

Posted 10 October 2012 - 03:12 PM #16

Thanks Struck. I honestly just assumed this was what their inventory feature was. Looking at competitors now... Kashflow: http://www.kashflow.com/features/ looks pretty cool, and also http://www.e-conomic...onmodules/stock

But maybe a full blown ERP program like Openerp is the way to go.


You might as well choose a well tested, mature program that will get the job done right for you Flow!

http://quickbooksonline.intuit.com/

8)
Cooking with Gas on Version 4.1.2 (But proceeding with caution....)

 
  • Flow
  • Super Duper and Amazingly Sexy Senior
  • Members
  • Join Date: 13-Oct 10
  • 2292 posts

Posted 10 October 2012 - 03:50 PM #17

Darn! I though this was a mature program! http://www.e-conomic.net/

It's done cloud accounting since before quickbooks discovered internet :D

I'm trying quickbooks now though, however I am in Europe (germany) and e-conomic has a BIG German firm so this might have some advantages (for example, it can spit out Datev files, which just about every accountant / tax attorney uses here. I don't like the look at all though so am hoping quickbooks online or kashflow (which is also very mature already and has great service and has German settings) will do the trick. Also, because my German sucks! I'm Dutch!

Update: Quickbooks now has an EU version! Since last month apparantly. Hooray... gonna check it out. I still hope I'll go for Kashflow though, their service is great and I'm just an underdog kinda guy! Can't help it!

When life hands you lemons, bring on the Tequila baby!


 
  • Struck
  • Teetering on Genious
  • Members
  • Join Date: 07-Mar 09
  • 2502 posts

Posted 30 October 2012 - 01:32 AM #18

It's done cloud accounting since before quickbooks discovered internet :D


Well, Intuit (Quickbooks/Turbotax) has been accurately counting, manipulating & dispersing my "Beans" before the term Internet even became a term! And besides, I now have 18 Billion Quickbooks users (daily beta testers) making sure my bean counts, payroll taxes, inventory, etc. continues to stay accurate.......

Although, you did inspire me Flow, so after using Quickbooks desktop versions over the last 17-18 years, I am strongly considering switching our desktop versions to Quickbooks Online version for 2013. 8)

And PS: For Personal Finance Mgmnt, gotta check out Moneydance
Cooking with Gas on Version 4.1.2 (But proceeding with caution....)

 
  • Struck
  • Teetering on Genious
  • Members
  • Join Date: 07-Mar 09
  • 2502 posts

Posted 30 October 2012 - 01:47 AM #19

So we suggest you use specially designed solutions like the one made by our partner — http://www.webgility.com/


Highly recommended alternative to manual order entry, or manually exporting/importing orders into Quickbooks (as well as posting shipment details back to your store, etc, etc.) ;)
Cooking with Gas on Version 4.1.2 (But proceeding with caution....)

 
  • clips
  • Aged Resident Loon
  • Members
  • Join Date: 14-Jan 07
  • 1650 posts

Posted 31 October 2012 - 01:08 AM #20

You see, it is impossible to fix the issue described above by modifying the export file format. The fields will be overwritten anyway.


Sorry, it is not impossible. The program we use from writeitonce simply imports your file and the exports it to QBs but it does not change information. So there is a way to do it.

Integrating Quickbooks API for inventory and order update must solve the problem (similar to the Webgility solution), but at the moment this integration is not planned due to its high cost.


First of all, if you are giving up this quick then you should take reference of QBs off your selling information and at places like...
https://www.cs-cart....ort-export.html
Likewise, you should remove it from your software as it still shows you can take the orders and "Export to Quickbooks".

Finally, we have used other software (like bigc) and we were able to import files right from their export with no errors, no overrights.

So it can be done.
Regards,
Jim