Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I exported the vendor list to an IIF file. I'm attempting to import that IIF file into another company, and I keep getting the error message shown above. In Notepad (and Excel), the IIF file looks fine at and around Line xxx.
Solved! Go to Solution.
This means the account type on that line (bank, credit card, income, expense) is different from an account already on the chart of accounts. QB doesn't let you import an account on top of another of the same name when the type is different.
This means the account type on that line (bank, credit card, income, expense) is different from an account already on the chart of accounts. QB doesn't let you import an account on top of another of the same name when the type is different.
How do i find out what account that line is
How can i find out what is on that line that is creating the error
Hello dear, Beccic.
We have there the Review now button that helps you to review and identify what's on the line that caused an error. We can see the Review now button when we import the list to another company file.
Here are the few steps that can help you find the error:
Once everything is okay, you can now save this as IIF File again and import them properly. Also, you can visit these articles for additional reference:
You can always post here again if you have other questions. I'll be around to help you figure them out. Thanks. Take care!
I too am having problems locating the errors. Not a valid record type...how do i find what record it refers to???
Hello, @maryellen02.
You can click on the Review now button as suggested by SarahannC above so you have the option to find the invalid record. Make sure that the details of your file contain valid information. For an additional guide about checking the errors, you can read the details from this link: Improved IIF Import in QuickBooks 2019 and later.
Post again if you have any other questions. I'm a few clicks away to help. Keep safe!
How do you remove the chart of accounts from the iif file?
I'm glad to see you here in QuickBooks Community. @senright24.
I'd be happy to help and share some information about IIF files and how to create and import them in QuickBooks.
When importing a Chart of Accounts using an IIF format, QuickBooks formats the file for you to help you record lists/transactions easier, especially if you have a large amount of data to be imported.
If you want to export the Chart of Accounts to Excel and remove/add accounts, you can follow the steps below:
After that, here's how you can import accounts from Excel:
With IIF files, we can also edit your lists, import the vendor's IIF file to update your costs, and update your list entries.
If there's any else that I can help you with, please don't hesitate to drop a comment below. Stay safe and healthy.
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