1

How can a transaction be created with an iif file so it contains the auto-calculated Tax Amt and Tax Total? The following iif file does not create the required Tax Amt as shown in the image below:

!INVITEM,NAME,REFNUM,TIMESTAMP,INVITEMTYPE,ACCNT,PRICE,TAXABLE,TAXCODE,,,,,,,,
INVITEM,Item,2,,SERV,,0,N,FRE,,,,,,,,
INVITEM,Sales Item,1,,SERV,Income Account,,Y,GST,,,,,,,,
!ACCNT,NAME,TIMESTAMP,ACCNTTYPE,EXTRA,TAXCODE,,,,,,,,,,,
ACCNT,Income Account,,INC,AUTOSTAX,GST,,,,,,,,,,,
!TRNS,TRNSID,TRNSTYPE,DATE,ACCNT,NAME,CLASS,AMOUNT,DOCNUM,NAMEISTAXABLE,,,,,,,
!SPL,SPLID,TRNSTYPE,DATE,ACCNT,NAME,CLASS,AMOUNT,DOCNUM,QNTY,PRICE,INVITEM,TAXABLE,EXTRA,TAXCODE,TAXRATE,TAXAMOUNT 
!ENDTRNS,,,,,,,,,,,,,,,,
TRNS,98,CASH SALE,7/27/06,Savings,,,210,100,Y,,,,AUTOSTAX,,,
SPL,99,CASH SALE,7/27/06,Income Account,,Class Name,-100,,-10,10,Sale,N,,,,
SPL,100,CASH SALE,7/27/06,Income Account,,Class Name,-110,,-10,10,Sales Item,Y,AUTOSTAX,GST,,-10
ENDTRNS,,,,,,,,,,,,,,,,
                                                            

Note: This site converts tabs to spaces so save above text to file with an iif extension since QuickBooks supports both tab and comma delineators.

The file was based on the 2004 Cash Sale (Sales Tax Preference=On).iif example in the .IIF import kit linked in the USA site using the Australian version help file. The items and accounts (except for the Savings account created as default Bank type) are created before they are used in the transaction file.

Detail from help file under #Transactions (TRNS and SPL).

TRNS - column headings for transactions:
* TAXCODE The tax code for the transaction.
* TAXRATE The tax rate.
* TAXAMOUNT The amount of the tax.

SPLID - column headings for distribution lines:
* TAXABLE Indicates that a line item on an invoice, credit memo, or sales receipt is taxable.
* AUTOSTAX Identifies a Tax item as the automatic tax rate you set up for your QuickBooks company.

Special Australian tax codes hidden from most reporting (which is net tax):

Account                            Type
Tax Payable                        Other Current Liability
Tax Payable:GST                    Other Current Liability
Tax Payable:GST:Tax Collected      Other Current Liability
Tax Payable:GST:Tax Paid           Other Current Liability

The following GST transaction created in the Australian QuickBooks GUI is what is required from the iif file import:

2
  • As a workaround using the GUI the tax can be deducted from the iif file transaction total before importing then open the transaction in the GUI and select (or select deselect) "Amts inc TAX" which will use the tax code to calculate any tax amts, tax total, and adjust the total. The transaction can then be saved with the correct tax calculations.
    – flywire
    Commented Apr 26 at 22:48
  • Workaround for Write Cheque is bad, need to toggle Tax field (eg from ADJ to GST) then "Split Tax".
    – flywire
    Commented Apr 27 at 13:54

0

You must log in to answer this question.

Browse other questions tagged .