Automatically Support Tax Split

[flywire]

QuickBooks supports automatically splitting tax in the GUI based on a Chart Of Accounts field.

eg For Australia there are various taxes under Other Current Liability but the most common is GST taxed at 10%.

Sub-accounts are created if the account exists:

Tax Payable:GST:Tax Collected
Tax Payable:GST:Tax Paid

!TRNS.pdf

---

Note: QuickBooks will create accounts that don't exist but it will screw it up so ensure accounts exist before importing them from an iif file.

---

Extract from 2004 Cash Sale (Sales Tax Preference=On).iif - IIF Import Kit (USA) with slightly different tax code:

!TRNS	TRNSID	TRNSTYPE	DATE	ACCNT	NAME	CLASS	AMOUNT	DOCNUM	MEMO	CLEAR	TOPRINT	NAMEISTAXABLE	ADDR1	ADDR2	ADDR3	ADDR4	ADDR5	DUEDATE	TERMS	PAID	PAYMETH	SHIPVIA	SHIPDATE	OTHER1	REP	FOB	PONUM	INVTITLE	INVMEMO	SADDR1	SADDR2	SADDR3	SADDR4	SADDR5	PAYITEM	YEARTODATE	WAGEBASE	EXTRA	TOSEND	ISAJE																		
!SPL	SPLID	TRNSTYPE	DATE	ACCNT	NAME	CLASS	AMOUNT	DOCNUM	MEMO	CLEAR	QNTY	PRICE	INVITEM	PAYMETH	TAXABLE	VALADJ	REIMBEXP	SERVICEDATE	OTHER2	OTHER3	PAYITEM	YEARTODATE	WAGEBASE	EXTRA																																		
!ENDTRNS																																																										
TRNS	98	CASH SALE	7/27/2006	Undeposited Funds	Customer		210	100	Memo Goes Here	N	N	Y						7/27/2006		N			7/27/2006																N	N																		
SPL	99	CASH SALE	7/27/2006	Income Account		Class Name	-100			N	-10	10	Sales Item		N	N	NOTHING																																									
SPL	100	CASH SALE	7/27/2006	Income Account		Class Name	-100			N	-10	10	Sales Item		Y	N	NOTHING																																									
SPL	101	CASH SALE	7/27/2006	Sales Tax Payable	Vendor		-10	100	Sales Tax	N		10.00%	Sales Tax		N	N	NOTHING							AUTOSTAX																																		
ENDTRNS