Quickbooks IIF import: VAT (sales tax) codes in invoice

I am importing invoices into Quickbooks Desktop 2012 UK.

I created a IIF import file:

!TRNS   TRNSTYPE    DATE    ACCNT   NAME    AMOUNT  CLEAR   TOPRINT DUEDATE TERMS
!SPL    TRNSTYPE    DATE    ACCNT   NAME    AMOUNT  CLEAR   QNTY    INVITEM EXTRA
!ENDTRNS                                    
TRNS    INVOICE 07/08/2016  Accounts Receivable SOME_NAME   120 N   N   07/08/2016  
SPL INVOICE 07/08/2016  Income Account      -100    N   -1  9217    
SPL INVOICE 07/08/2016  VAT Liability Online    Receiver General    -20 N   -1  VAT AUTOSTAX
ENDTRNS                                 

(sorry there is no table option in the markdown)

This mostly works. When I view it in Quickbooks, the VAT is not actually displayed as a line but the Total VAT field at the bottom of the invoice displays it. That is exactly what I wanted.

Unfortunately, the VAT column on the invoice, used for displaying the VAT code, always shows O. I would like to be able to import invoices with the correct VAT code (S).

The IIF format used to support columns like VATCODE but they are depreciated. Quickbooks now insist that the VAT be added as a line item. Can any details like VAT code be specified?

(Just to get to this stage took a lot of googling, and looking at the IIF files from the examples and Big Red.)

Recent Questions...