import BILL

Sunnie
Sunnie Member Posts: 5
edited December 2019 in Accounts Hosted
I am most desperate for help, please. We need to import over 1000 bills & receipts to enter in Accounts Hosted. I've read and followed so many different advises on how to set up iif file format but have not been successful. What am i doing wrong?
A test tax invoice i am trying to import is from AAPT, $4,560.14 (inc GST $414.56), dated 1st Oct 2019. Inv no. is 14540584 with the description of Monthly charge Sept 19.
I'd REALLY appreciate if someone could advise...

!TRNS TRNSID TRNSTYPE DATE DOCNUM NAME DUEDATE AMOUNT ACCNT MEMO TOPRINT
!SPL SPLID TRNSTYPE DATE DOCNUM NAME DUEDATE AMOUNT ACCNT MEMO TAXABLE TAXCODE TAXAMOUNT
!ENDTRNS

TRNS 1 BILL 10/01/19 14540584 AAPT 10/30/19 -4560.14 8000 · Accounts Payable Monthly charge Sep 19 Y
SPL 2 BILL 10/01/19 14540584 AAPT 10/30/19 4145.58 2430 · Telephone Monthly charge Sep 19 Y NCG 414.56
ENDTRNS


Comments