IIF Importing Invoices


T

Trevor Tucker

I am trying to import invoices in to QuickBooks 2003, but it is importing
them as deposits. I then added the "Paid" field and set them all to "N" and
it then imported them as transfers.

Here is a sample of the file:

!TRNS TRNSTYPE DATE ACCNT AMOUNT REP
!SPL TRNSTYPE DATE ACCNT AMOUNT
!ENDTRNS
TRNS INVOICE 12/01/03 ABBOTT G A 8.18 ASGARD - HEAD OFFICE
SPL INVOICE 12/01/03 Upfront - FUA -8.18
ENDTRNS

Any help would be greatly appreciated.

Trev
 
Ad

Advertisements

L

Larry Stinson

I can't tell from your accounts, but my guess is that "Abbott G A" is not an
accounts receivable account. For invoices, I believe the TRNS must be the
debit to accounts receivable and the SPL is the split (offset).

If that does not work, you may need to add the field names "ToPrint" and
"Terms" to the TRNS header (TRNS!) line and add "Y" and the appropriate
Terms to the respective field values on the TRNS line.
 
Ad

Advertisements

G

Guru

This does not look like it has all the proper information (missing
customer name, and unless ABBOTT G A is an account of the type
Accounts Receivable then it is also missing the proper account).

I suggest going to www.quickbooks.com/support and doing a Search for
"IIF". Your results will include a listing of Sample IIF Files. Open
the Invoice and use that as a template, just replacing the specifics
with your data (such as date, name, amounts, etc).
 

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

USA Import IIF Invoices 0
Importing Invoices using IIF 1
.IIF import of invoices error 3
IMPORT INVOICE IIF SAMPLE 2
UK IIF invoice import issue 0
.iif import problem 2
IIF import not working 1
Import IIF error 3

Top