UK .iif import quickbooks re Invoices - VAT & terms query


Joined
Dec 19, 2017
Messages
1
Reaction score
0
Country
United Kingdom
I am trying to create a simple template to upload lots of invoices on one supplier. The .iif sample file provided by quickbooks is too complicated. I have had moderate success with the template below however it is not picking up the VAT and making it Z as requested, it is creating it as 0 which I don't want. I am also making it 30 days net terms which is inputting correctly in the field but it is not actually amending the due date to 30 days. Any help gratefully received. Thank you.

!TRNS,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,DOCNUM,MEMO,CLEAR,TERMS
!SPL,TRNSTYPE,DATE,ACCNT,INVITEM,MEMO,VAT,AMOUNT
!ENDTRNS
TRNS,BILL,19/12/2017,Accounts Payable,Puma UK Ltd,-3,10101010,,N,Net 30
SPL,BILL,19/12/2017,Cost of Goods Sold:Teamwear,12859,Z,3
ENDTRNS
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UK Invoicing queries 1
UK VAT on goods from EU query 1
IIF Importing Invoices 3
USA Import IIF Invoices 0
UK VAT re professional fees on new houses 1
Importing Invoices using IIF 1
.IIF import of invoices error 3
Importing TERMS on an Invoice 0

Top