Quickbooks Addon Bug When Sales Tax was applied

Store Builder Questions
1

I met an Quickbooks import error, “transaction is not in balance. Make sure the amounts in the detail area on the form for this transaction equal the amount at the top of the form.”, when orders has sales tax applied.



I use CS-cart v2.0.12 and the exported Orders.iif from CS-Cart:

<br />
!CUST	NAME	BADDR1	BADDR2	BADDR3	BADDR4	BADDR5	SADDR1	SADDR2	SADDR3	SADDR4	SADDR5	PHONE1	FAXNUM	EMAIL	CONT1	SALUTATION	COMPANYNAME	FIRSTNAME	LASTNAME<br />
CUST	linh, Anna	Anna Linh	1891 valley view st 	anaheim	"CA, 92811"	United States	Anna Linh	1891 valley view st 	anaheim	"CA, 92811"	United States	7145899866		linh@ecolandinc.com	linh, Anna			linh	linh<br />
<br />
!INVITEM	NAME	INVITEMTYPE	DESC	PURCHASEDESC	ACCNT	ASSETACCNT	COGSACCNT	PRICE	COST	TAXABLE<br />
INVITEM	12067W1	INVENTORY	Organic cotton baby blanket and knot hat set; Product options: color - size: White - one size;	Organic cotton baby blanket and knot hat set; Product options: color - size: White - one size;	Sales:Product	Inventory Asset	Cost of Goods Sold	19.50	0	N<br />
<br />
<br />
!TRNS	TRNSTYPE	DATE	ACCNT	NAME	CLASS	AMOUNT	DOCNUM	MEMO	ADDR1	ADDR2	ADDR3	ADDR4	ADDR5	PAID	SHIPVIA	SADDR1	SADDR2	SADDR3	SADDR4	SADDR5	TOPRINT<br />
!SPL	TRNSTYPE	DATE	ACCNT	NAME	CLASS	AMOUNT	DOCNUM	MEMO	PRICE	QNTY	INVITEM	TAXABLE	EXTRA<br />
!ENDTRNS<br />
TRNS	INVOICE	02/04/2010	Accounts Receivable	linh, Anna	Website:Retail	41.30	10	Website Order: 	Anna linh	1891 valley view st 	"anaheim, CA 92811"			N		Anna Linh	1891 valley view st 	"anaheim, CA 92811"			Y<br />
SPL	INVOICE	02/04/2010	Sales:Product	linh, Anna	Website:Retail	-19.5	10	Organic cotton baby blanket and knot hat set; Product options: color - size: White - one size;	19.5	-1	12067W1	N	<br />
SPL	INVOICE	02/04/2010	Website:Tax	linh, linh	Website:Retail	-1.8	10	VAT 9.25% FOR 12067W1	0	-1	TAX	N	<br />
<br />
<br />
SPL	INVOICE	02/04/2010	Sales:Shipping	linh, Anna	Website:Retail	-20	10	Custom shipping method	20	-1	SHIPPING	N	<br />
ENDTRNS<br />
<br />
!TRNS	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	PAYMETH	DOCNUM<br />
!SPL	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	DOCNUM<br />
!ENDTRNS<br />
2

I have finally figured out what the bug in when exporting an .iif file to quickbooks… CS-Cart will not set the tax flag correctly for the items that are sold, and it will not add the necessary line for tax. (or I have my settings wrong and can't find anyplace to tell me how they should be)



I have attached an .iff file with comments that you can look at in a spreadsheet program to identify what needs to be changed and whats missing.



Good luck… this has taken me over a year to figure out.

QBSALESTAXORDER-FIX.IIF.zip