Quickbooks Addon Bug When Sales Tax was applied

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:


!CUST NAME BADDR1 BADDR2 BADDR3 BADDR4 BADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 PHONE1 FAXNUM EMAIL CONT1 SALUTATION COMPANYNAME FIRSTNAME LASTNAME
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

!INVITEM NAME INVITEMTYPE DESC PURCHASEDESC ACCNT ASSETACCNT COGSACCNT PRICE COST TAXABLE
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


!TRNS TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 PAID SHIPVIA SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 TOPRINT
!SPL TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO PRICE QNTY INVITEM TAXABLE EXTRA
!ENDTRNS
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
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
SPL INVOICE 02/04/2010 Website:Tax linh, linh Website:Retail -1.8 10 VAT 9.25% FOR 12067W1 0 -1 TAX N


SPL INVOICE 02/04/2010 Sales:Shipping linh, Anna Website:Retail -20 10 Custom shipping method 20 -1 SHIPPING N
ENDTRNS

!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT PAYMETH DOCNUM
!SPL TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM
!ENDTRNS

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