Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowFrom everything I've read in these posts, I'd say we've been pretty lucky. Our invoice IIF file import works well... except for the "Due Date". There is no "Due Date" field in the IIF header, but there is a field for "Date" and "Terms". I ASSUMED QB would calculate the Due Date from there, but it doesn't. Whenever I import an invoice IIF file, QuickBooks inserts the current date as the due date. Is there something I'm missing. I've read all the IIF documentation - nothing there. I've contacted QuickBooks, but they do not support IIF files.
We're using the "invoice with no sales tax" headers and sample file. Here's a quick pic with dummy data.
Any help would be greatly appreciated!
Solved! Go to Solution.
RE: Thank you - I had a feeling that [QuickBooks won't calculate the due date] was the answer all along, but was hoping I was wrong.
While technically true, you can set the due date as well as the terms in the IIF file so you don't have to edit each invoice after import.
To set the due date, add the field DUEDATE to the !TRNS definition row.
Then, on TRNS rows, specify the due date as a date in the same date format as you use for the rest of the file.
You can see this and much more in the IIF files that our BRC IIF Transaction Creator Pro creates. Use it in trial mode to create IIF files for review (you might even like it and want to purchase it.)
I'll help with your question about importing data into QuickBooks, gfilson.
You can edit your IIF file and add a column for due date. Here's how:
Exit Excel. Then, you'll get a prompt to save the IIF again. Select Don't Save. After that, you can import your file once again. Let me share these articles for additional guidelines and reference:
Don't hesitate to reach out to us again if you need anything else. We're always here to help.
Thank you for the reply. If I understood you correctly, you seemed to say that I can add a column for "Due Date". I don't see a code in the header section for Due Date - what would it be? And does it have to be in any particular position order (like before "Terms")? The IIF sample and header information in the links had nothing for Due Date.
Again, the help is greatly appreciated!
Thanks for the clarification, @gfilson.
The due date of your invoice will be calculated under the Terms column. Once uploaded to your QuickBooks, the program will calculate the due date for you.
To ensure a smooth process, you’ll want to check that all fields are entered when importing your IIF. File.
For more insights and guidelines about the process, you can refer to the links shared by my colleague above.
Additionally, you might want to check this link for guidance in case you need to manually import your bank transactions in your QuickBooks Desktop (QBDT) software.
If you have other questions or clarifications about importing IIF files, let me know in your reply. You’re always welcome in the Community space. Have a great day and keep safe.
You may prepare the Invoice data with the following template
Customer | Transaction Date | RefNumber | PO Number | Terms | Class | Template Name | To Be Printed | Ship Date | BillTo Line1 | BillTo Line2 | BillTo Line3 | BillTo Line4 | BillTo City | BillTo State | BillTo PostalCode | BillTo Country | ShipTo Line1 | ShipTo Line2 | ShipTo Line3 | ShipTo Line4 | ShipTo City | ShipTo State | ShipTo PostalCode | ShipTo Country | Phone | Fax | Contact Name | First Name | Last Name | Rep | Due Date | Ship Method | Customer Message | Memo | Cust. Tax Code | Item | Quantity | Description | Price | Is Pending | Item Line Class | Service Date | FOB | Customer Acct No | Sales Tax Item | To Be E-Mailed | Other | Other1 | Other2 | Unit of Measure | AR Account | Currency | Exchange Rate | Sales Tax Code | |
Anne's Bakery | 01/09/2020 | 100 | Y | 15/09/2020 | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | (123) 456-7890 | Non | Cabinets | 10 | Cabinets | 1000 | Non | ||||||||||||||||||||||||||||||||
Anne's Bakery | 01/09/2020 | 100 | Y | 15/09/2020 | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | (123) 456-7890 | Non | Hardware | 10 | Hardware | 50 | Non | ||||||||||||||||||||||||||||||||
John's Barber Shope | 02/09/2020 | 101 | Y | 15/09/2020 | John's Barber Shope | 1 Main Street | Anytown | NY | 12345 | USA | John's Barber Shope | 1 Main Street | Anytown | NY | 12345 | USA | (999) 888-8888 | Non | Blueprints | 1 | Blueprints | 500 | Non | ||||||||||||||||||||||||||||||||
Main St Bank | 03/09/2020 | 102 | N | 16/09/2020 | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | (888) 888-8888 | Non | Door | 1 | Door | 300 | Non | ||||||||||||||||||||||||||||||||
Main St Bank | 03/09/2020 | 102 | N | 16/09/2020 | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | (888) 888-8888 | Non | Handles | 1 | Handle | 10 | Non |
then explore these importer tools
https://transactionpro.grsm.io/qbd
https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
Thank you JasroV, but unfortunately it didn't work. Here's a clip of the IIF file:
And here's a clip of the result:
As you can see, the Invoice Date (3/1/21) imported correctly, the terms (Net 30) imported correctly, but the Due Date simply defaulted to the current date.
Thank you Fiat Lux - ASIA, but we would really like to avoid purchasing tools to make QuickBooks do what it's supposed to do natively. This should be a straightforward import question, and everything else is coming in as expected. I don't understand why the Due Date is not working as intended, but I'm sure there's an answer out there somewhere.
Thanks for keeping us updated, gfilson.
I understand that you need to import the invoices with due dates on them. Currently, the program is unable to automatically calculate the due date of imported invoices based on the transaction date and terms. Rest assured, I'll take note of your ideas and suggestions to help improve your QuickBooks experience.
For now, you can open the invoice and manually change the term to 60 (or any other term) from the drop-down menu. Then, reselect 30 days again to set the due date correctly.
You'll also want to consider visiting QuickBooks Desktop Marketplace to find a third-party importer tool so you don't have to manually edit each invoice. Once you're in, just select your product version from the QuickBooks Compatibility section and then enter "import invoice" in the search bar to filter the results.
In addition, here are some articles that you can read to learn more about the transactions that you can import and export using Intuit Interchange Format (IIF) files:
I'll be right here if you need a guide in managing your invoices or handling your other transactions. Have a great rest of the day.
Thank you - I had a feeling that was the answer all along, but was hoping I was wrong. I'll check out the third-party options. Thanks again!
RE: Thank you - I had a feeling that [QuickBooks won't calculate the due date] was the answer all along, but was hoping I was wrong.
While technically true, you can set the due date as well as the terms in the IIF file so you don't have to edit each invoice after import.
To set the due date, add the field DUEDATE to the !TRNS definition row.
Then, on TRNS rows, specify the due date as a date in the same date format as you use for the rest of the file.
You can see this and much more in the IIF files that our BRC IIF Transaction Creator Pro creates. Use it in trial mode to create IIF files for review (you might even like it and want to purchase it.)
Thank you greatly. This actually WORKED! One final question, is there any way to include "Date Serviced" in the import? That would wrap things up for us nicely.
Thanks again!
What header can be used for "Date Ordered"?
I'd be happy to help you prepare your invoice IIF file with the Date Ordered header, @cwilkinson11. Let me share with you some insights about this feature.
We have a ready-made kit and samples for your IIF file per transaction. You can download the samples from here: IIF Overview: import kit, sample files, and headers. Once downloaded, you can open the file, then add a column for the date ordered. You can use "Date Ordered" as the header.
If your IIF file came from a third-party app and you need to include the Date Ordered, I recommend contacting your app's technical support. From there, they can advise you on what header to use for this information.
Once done, you're now ready to bring your file to QuickBooks. You can learn more about importing and exporting Intuit Interchange Format (IIF) files from this article: Export, import, and edit IIF files.
Feel free to get back to me in the comment section below if you have other questions. I'm always here to help. Have a good one!
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.