I just exported the chart of accounts and item list into a .iif file. When I attempt to load it onto my clients QB program, the new import function is not working. Again Intuit screws up a perfectly good system. Any suggestions?
Hi there, KeithG.
Thanks for joining this thread. Allow me to help ensure you're able to import chart of accounts and item list into a .IIF file successfully.
Once the file is not successfully imported, QuickBooks will then automatically create a new .IIF file for failed records with error info. You will then have 3 options to move forward:
If you encounter the error File not imported, QuickBooks gives you the option to review and resolve the errors found in the .IIF file. To do this, let me provide you the steps below:
For additional reference, you can check these articles:
If you need further assistance with the steps, I recommend calling our QuickBooks Desktop Support Team. They have the tools to do a screen share and walk you through the process.
Here's how you can contact our phone support:
Please let me know how it goes. I'm always here to help if you have any other questions importing lists in QuickBooks. Have a good one.
Please Learn from this input.
Yes, they Broke it; Here is an article for how to understand what they broke and how to Cope, anyway, until Intuit fixes it:
I had this same question - this thread solved my problem. I use QB Pro 2011 Desktop and Windows10. The only thing different was that I had to go to File\Utilities\Export. And when importing into the new company I had to peck around to find where .IFF file was saved. But fairly easy and painless.
That’s what we love to hear, @lplewis!
I appreciate you for sharing your feedback on how the steps from this thread resolve your concern. Also, thank you for sharing the additional steps you’ve performed on your end. These steps will help a lot of customers who are also having the same issue.
For additional insights in navigating around QuickBooks, you can join our webinars: Get the most out of QuickBooks with Webinars.
Swing by here in the Community if you have other questions about getting the most out of QuickBooks full potential. I’m just a few clicks away.
He referred to his 2011 copy of Quickbooks... 2019 and up I am starting to learn may have issues. I am importing in my COAs with corrections but I keep getting the error: "The account number is already in use."
I have ensured that preferences were set for the import to override existing data, but the error persists. I have used Excel and IIF formats but get the same error.
Hello there, hilliardaccounting.
I'm here to show you how we can resolve this error.
We need first to make sure that you have the latest release of QuickBooks Desktop. You'll want to update it by following the steps in this article: Update QuickBooks Desktop.
Also, let's rebuild your company file to fix any issue it may have which can cause this error. You can follow these steps:
In addition, I suggest reaching out to our Customer Support Team if this behavior continues. That way, they can check the file to see the cause of this error. Simply go to the Help menu and select QuickBooks Desktop Help. On the pop-up, click the Contact us.
Please comment again if you need additional help with this. Have a great day!
I understand it can get frustrating having to go through multiple troubleshooting steps and not having any of them work can be a real pain, jehaccounting.
If you encounter an error File not imported, QuickBooks gives you the option to review it. Then, make corrections of the errors found in the .IIF file.
Then, Import the new and corrected .IIF file to QuickBooks Desktop.
For more details about importing your lists and transactions, check out these articles:
If the same thing happens, I'd suggest contacting our Technical Support Team. They'll pull up your account in a secure environment and investigate what's causing this issue.
Here's how to reach them:
I have a link here where you can find articles about managing your business in QuickBooks: https://quickbooks.intuit.com/learn-support/en-us/get-started/07?product=QuickBooks%20Desktop.
Feel free to go back to this thread if you need anything else in QuickBooks. I'll be here to ensure your success. Take care always.
Thanks for keeping in touch with us here in the Community, @jehaccounting.
Allow me to share some ideas about importing IIF files in QuickBooks Desktop (QBDT).
QuickBooks Desktop doesn't based on the account number when importing your file. It based on the account name so it override the accounts name when there's an already existing information. Thus, QuickBooks will prompt you with three options if it detects a duplicate account name. Here's a screenshot for visual information of what I'm referring to:
Also here are some articles that you can refer to learn more about importing files in QuickBooks Desktop:
I'll be around in the Community to help if you have more questions with importing your files in QBDT. Stay safe, @jehaccounting.
The 'review' option is broken... completely broken, when you press the button to review, it fails with a message liek 'unable to open quickbooks file'... horribly frustrating...
thanks to @qbteachmt for providing the solution, which is to NOT click the big green 'Import IIF' button, but to click the small type "Import it for me, I'll fix it later" link.... Thanks, this worked *flawlessly*!
and to think this is just to create a test company to troubleshoot other things that don't work with QB Desktop and QBPOS integration... if Intuit's goal is to frustrate customers, they are doing a great job.