Invoice imported through iif file is shown as successful but no invoice found on reckon

Faisal Ali

I am trying to import iff file with following data:

!TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM CLEAR
!SPL SPLID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM CLEAR TAXABLE
!ENDTRNS
TRNS 1 TAX INVOICE 06/20/17 Consulting fees Vincent 200 234 N
SPL 2 INVOICE 06/20/17 Consulting fees Vincent -100 234 N Y
ENDTRNS

Reckon Accounts Hosted shows that the import was successful, but I cant see any invoice under Customers > Transaction > Invoices (or for that matter, under any item under transaction)

what am I doing wrong.. also, I have a new account, so the only thing that I created is a customer (Vincent)..

Linda ABC

Hi Faisal - I am away from my normal computer at present so I can't check 100% but I am pretty sure the problem is with the word TAX INVOICE - I think this should just say INVOICE, the same as the split line... you are also missing the taxcode field and the taxamount fields?  I think you have done this because its what the help file says? (I believe this relates to the old US version and isnt completely accurate?) but in my experience with POS and importing tranactions - these fields should contain the same name on both the TRNS and the SPL lines...  I think perhaps get on to Reckon tech support and ask them to send you the format for Australia?