I am trying to import invoices into Quickbooks 2018 pro desktop. I have found several examples of the iif file, but none of them have worked. I finally stumbled on another format in the Intuit website that seems to be getting closer. The problem I am facing now is it complains that the sales tax cannot be left out. I have tried adding the taxcode field TRNS record. I have also tried adding a tax code line to the spl area. That throws an error that the Sales Tax Payable account cannot be referenced. Does anyone know how to set the tax in an invoice.
Also, does each line item have to be set in advance in the items list?
Here is my test file
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT NAMEISTAXABLE ADDR1 ADDR3 TERMS SHIPVIA SHIPDATE TAXCODE
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE OTHER2 YEARTODATE WAGEBASE
!ENDTRNS
TRNS 120001 INVOICE 7/18/98 Accounts Receivable SpeedShore 40.00 1903 N Y N 12/31/24 TAX
SPL 120002 INVOICE 12/31/24 Sales - Billable Hours Billable Hours -20 1903 Billable Hours N -1 20 Framing N 0 0
SPL 120003 INVOICE 12/31/24 Sales - Billable Hours Billable Hours -10 1903 Billable Hours N -1 10 Wood Door:Exterior Y 0 0
SPL 120004 INVOICE 12/31/24 Sales - Billable Hours Billable Hours -10 1903 Billable Hours N -1 10 Hardware:Doorknobs Std Y 0 0
ENDTRNS
It's great to hear you've found another format you can follow for your Intuit Interchange Format (IIF), mlcporter. It's correct that you'll need to set up your items in your QuickBooks. Let me discuss this further.
Before uploading your IIF file, ensure that your items are properly configured to prevent them from being overlooked during the import process. Additionally, there are two downloadable versions available. One of these uses sales tax, and one does not.
Therefore, if the Sales Tax preference is enabled in your company file, download the .iif file with tax included, even for transactions that don't involve charging tax (enter a zero in the sales tax column for transactions without tax).
To find out more about IIF and view additional sample files, you can use this resource as a guide when creating IIF: IIF Overview: import kit, sample files, and headers.
If you wish to edit your IIF files, please refer to this material: Export, import, and edit IIF files.
I'll be glad to assist you again while you're in the process of importing your IIF file, mlcporter. Please let me know by replying to the comment section below.
Thanks for the reply. I was able to get it working. I found a 3rd version of the example on Intuit's web site and it worked perfectly. For anyone who might need it, here is the example file I was able to import.
Thanks for the reply. I was able to get it working. I found a 3rd version of the example on Intuit's web site and it worked perfectly. For anyone who might need it, here is the example file I was able to import.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here