I have been importing into QuickBooks 2019 for a long time now. However, one of my clients went to import and it came back with a error about the header date needed to match match the distribution line date. BOTTOM LINE, IT APPEARS THE IIF FILE IS DIFFERENT NOW... AND THE FILES I HAVE BEEN CREATING WILL NO LONGER WORK.
I need help... attached is a couple iif imports that I have been doing... what should it look like now for it to import?
There is one invoice sale.. one cash and one check. From the little bit I have looked, it looks like that the items are in one set of lines... and then ENDTRANS.. and then a second set of lines if there is a payment.. and then again ENDTRANS
Any help would be much appreciated!
Hello there, @Iceguy.
I'm glad you've reached out to the QuickBooks Community. I'm here to help ensure you're able to import transaction in QuickBooks Desktop.
When importing lists or transactions into QuickBooks, you'll need to use the Intuit Interchange Format (.IIF) files. You can download and install the .IIF import kit to guide you when creating and working with .IFF import files.
You can also download the other sample IIF file in the article below and check if your format is correct: IIF Overview: import kit, sample files, and headers.
For additional reference, you can visit these articles:
If you need further assistance with the steps, I recommend to contact our QuickBooks Desktop Support Team. They have the tools to pull up your account and do a remote session.
Here's how to contact our customer support:
This will get you on the right track. Fill me in if you have additional questions about importing transactions in QuickBooks. I'm always here to help. Have a good one.
I found this kit.. and from what I see... it only covers up to version 2007. I did not see anything about the new 2019 version.
I did however find a person who posted this.
So QB does have a way to keep importing your older format... they try to tell you not to do it.. but it does work.
I need the specific examples of the import files based on the file I attached.
Hi there, @Iceguy.
Thanks for the quick response. I'm here to help share additional input about importing transactions into QuickBooks.
The sample .IIF files (QB 2007 & Enterprise 7.0 and later) in the kit can still be used as templates for your own data in QuickBooks 2019. The files are available for QuickBooks 2007 to the latest version.
You can use it with the sample company file backup to practice importing. Download the company file separately and restore it in QuickBooks. Also, please take note that when importing transaction file, there are usually three file header lines that occupy the first, second, and third rows (!TRNS, !SPL, and !ENDTRNS).
You may refer to the example attached below which shows the file headers in an .IIF file lines in a check transaction.
For additional help, feel free to reach out to our Customer Care Support. They have tools to help you get to a resolution quickly. You can follow the steps provided by my colleague, JanyRoseB to get their contact information.
Please know that I'm just a post away if you have any other questions about importing data to QuickBooks. I'll be happy to help you out. Have a great day ahead.
Yes, there are a lot of change sin QB 2019 for import. Some cause issues like you're seeing that don't need to be issues. In this case there is only one date on a transactions, from the TRNS row, and so it matters not in the least what the dates on the SPL rows are.
If you follow our recommendations you should be able to get it to work as-is. See QuickBooks 2019 IIF Import Changes and Recommendations
Do you know of anyone who can help me move from using the old iif format and onto the new one? Basically I want someone to look at my current data file and instruct me how we should export my sales out of my software so it is in the correct iif format for 2019.
Thanks for coming back to the Intuit Community, @Iceguy.
To ensure the old IIF format is transferred to the new file format, I recommend using a third-party application. The Intuit Marketplace site is a place where users can find add-on applications that are approved by Intuit.
Make sure to enter a keyword in the Search field to narrow down the process. For example, IIF importer.
QuickBooks will show lists of supported apps. Just select one that matches your business needs.
Your sales will now be exported to the current IIF format.
Please leave me a comment with an update about how things go. I want to make sure that you're taken care of.
I have always been able to just go File - Utilities - Import - iif files. Why would I want to go to third party app if the tools are right there to import? I am currently doing it now with virtually no fails... in fact been doing it since 2004. I just want to adjust it to work with 2019 format.. all I need is to know where things needs to be in the iif file.
I guess I am a bit confused. Is QB trying to promote the sales of third party apps to do this?
Hi there, Iceguy.
We don't recommend any third party applications to import Intuit Interchange Format (.IIF) files. However, we provide available resources when you need help with creating or importing .IIF files.
Among these are:
To import your .IIF file into QuickBooks 2019, you can check out the Improved IIF Import in QuickBooks 2019 article for the steps and details.
You can also follow the recommended troubleshooting steps provided by BRC.
Feel free to reply to this post if you need anything else with importing .IIF files in QuickBooks.
Interesting subject @ iceguy.
quickbooks have some hidden menu and solution exist there. Any transaction you want to import in proper manner in a particular version of qb US, UK, AUS, Can etc.; your knowledge about the qb data base will help you. Do your know qb give you that facilities but most of Adviser don't know or don't like to share such kind of techniques which escape 3rd party import tools.
List of qb you can import/export file>Utility>export/import iif menu give your export of list in iif format but no transaction data. Export of transaction from one version other version of qb; you can utilize qb hidden menu. how?
Help menu>About QB and than use key combination of Control+shift+D+B. Now click anywhere in qb. Then go to help menu and you will see and new menu will be appear tech support menu. Now you can export lists and qb transaction data from there in iif format so you will get any transaction import template from transaction file (open it in ms excel) accordingly qb you working.
Does anyone have a suggestion for my following problem. Importing into Quickbooks would be awesome if I had help figuring it out.
I have 2 companies I need importing into. The country club and pro shop. They are separate businesses so I have to keep a separate set of books. However, I have the same members (customers). How could I import the same information once to both companies?
Also I have a bank draft with 900 transactions each month that needs to be posted to members(customers) accounts and also debited to our bank account as a deposit.
Any Suggestions would be greatly appreciated!!!
Hi there, adishion.
Currently, QuickBooks doesn't have the option to import data at once into both companies. I suggest importing the transactions manually to each company file using the IIF file. You can download and install the.IIF import kit to save time and improve your results. You can also see the steps provided by my colleague JanyRoseB in installing the .IIF kit for additional information.
Here's how you can import list and transactions using IIF.
1. Sign in to your Company file as an admin.
2. Select File menu and choose Switch to Single-user Mode.
3. Make a backup of your company file. This way, you can restore it if the data doesn't import.
4. Click the File menu and choose Utilities then, Import.
5. Select Import IIF Files.
6. Browse to your IIF file. Choose it and then select Open.
7. Hit OK.
If you want to edit an IIF file, please follow the steps below.
1. From Microsoft Excel, go to File and click Open.
2. Browse to your IIF file.
3. In the File type drop-down list, select All Files.
4. Select the IIF and then choose Open.
5. From the Text Import Wizard, choose Next. Then Next and Finish.
6. Make the changes to your IIF file.
7. Select File menu. Then select Save.
8. Hit Yes.
9. Close Excel. You'll get a prompt to save the IIF again. Select Don't Save.
Please check this article what are different types of files to store different types of data: File types and extensions used by QuickBooks Desktop.
Please let me know if you have other questions related with QuickBooks. I'm always here to help you.
If you are more familiar with CSV/XLS, explore one of these importer tools for your needs.
Hope it helps.
Does anyone know how to get help on importing files as ChristieAnn suggested? I am very unfamiliar with this process and was hoping to find a Pro Advisor or someone to help me get things set up and tutor me with the process. I didn't know if I should do this or reach out to Transaction Pro for help?
Hi there, adishion.
Thank you for choosing QuickBooks and for posting in the Community.
I will help you import your list of customers and bank transactions to your QuickBooks company files.
In this case, you'll need to import your list of customers first before your list of transactions, and you'll want to do this to each company file. It's a good thing that you have the IIF file with your customers' data. Have you tried following the second set of steps that Christine shared? If yes, what are your challenges? The import kit also contains sample files and manuals to do this process. You can create a dummy company file and try to import the file on the kit for your practice.
Alternatively, you can import your list of customers in MS Excel files. I would say that this is much easier. Here's the article with detailed steps: Import or export MS Excel files.
As for your bank transactions, QuickBooks only supports files in .QBO format to be imported into the Bank Feeds section. This is where you manage them by assigning payees and categories before adding them to your bank register in the Chart of Accounts. This is why it's important to import your list of customers first before your transactions. You can also connect your bank account after the import, so moving forward, your future transactions will just be downloaded in the Bank Feeds section for you.
This article will guide you to connect your bank account and manage your downloaded transactions: Download Bank Feed transactions in QuickBooks Desktop. Just click on the article titles on the box.
Please go back to this thread if you have additional questions about the process. Rest assured that you can count on us in setting up your company files.
Glad to have you here, rnelson010.
Let me share some insights about import scheduling in Quickbooks Desktop. The option to set a scheduled import in QBDT is currently unavailable. You'll want to look for a third-party application that has many features as Export and Schedule Import.
You can find it here: https://quickbooks.intuit.com/app/apps/. There are lots of apps you can test to check if it suits your business needs.
I am adding these articles you can check about importing in Quickbooks Desktop for reference:
Please let me know if you have any other concerns. I'll be around to help.
i have been importing invoices into my quickbooks for years now and its worked great. we have decided to move to a class accounting and I noticed that there is 2 fields in invoices that say class. One is on the main information of the invoice and the other is in the data of amounts and taxes. i can get the class to go into the second area but not the first. any idea what the name of that field is?
Thanks for joining this thread, @warrenh.
Allow me to share some info when importing transactions into QuickBooks Desktop (QBDT). The fields of your invoice will depend on the setup columns before importing the transaction. To fix this, review your invoice columns set up and remove the other class field since in QuickBooks there is only one field for class.
For more info about importing invoices in QuickBooks Desktop (QBDT), please see this article: Export, import, and edit IIF files.
Also, I've added this helpful article that can guide you in tracking your account balances in QBDT using different classes: Set up and use class tracking in QuickBooks Desktop.
You can always get back to me here in the Community if you have any other questions about importing invoices in QBDT. I'll always be around to help.
You may utilize an exporter tool to export your current Invoice template to XLS. Then you may modify the data and import it back to your company file.
You may find the Class field and the Item Class field 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|
WHY hasn't INTUIT made a shortcut icon "Import from IIF"?????? All of us have been asking for YEARS. You have Import from Excel as an option. WHY NOT Import from IIF????? You say you don't promote add on programs - but you have the ability to add this EASILY and won't help us?
WHY hasn't INTUIT made a shortcut icon "Import from IIF"?????? All of us have been asking for YEARS. You have Import from Excel as an option. WHY NOT Import from IIF????? You say you don't promote add on programs - but you have the ability to add this EASILY and won't help us? We don't understand why you won't do this for us...