Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
Showing results for 
Search instead for 
Did you mean: 
Level 1

Import IIF Line error message

I have just set up my Program to Import an IIF file.  All the accounts match my chart of accounts however, I am getting an error message that says "Error on line 14: You can't change the type of account".  I have went through everything probably 10 times and I can't seem to get it right.  Can someone give me some suggestions as I can't review the report to see where the error is? 

Level 7

Import IIF Line error message

Copy your IIF file.  On the copy, rename and change the extension from IIF to XLSX.  You can then double click on it an open in Excel.  Navigate to line 14 and see what the issue is.

Level 7

Import IIF Line error message

Chances are you have two accounts in QuickBooks with the same name but different account types.  Change the one doesn't match slightly.  For instance, if you have payroll taxes set up as both a liability and an expense account and you are not using account numbers, the IIF file doesn't know what account to post to. 

Level 1

Import IIF Line error message


Level 1

Import IIF Line error message

I am not too smart on these files.  I can't get it to open up in anything.  If I choose save as I don't have an option to save it as anything else out of this program I am working out of.

QuickBooks Team

Import IIF Line error message

Hi there, @melissayahn.


Please allow me to join the thread and help you open the file successfully.


To open the file successfully, you must open an Excel and drag the file or the IIF file to Excel.


You can see attached screenshots for additional reference.

a1 error when opening the IIf file.PNG

a1 drag to EXCEL.PNG

a1 IIf file.PNG


On the other hand, to learn more about importing/exporting IIF files, you can check this article: Export or import Intuit Interchange Format (.IIF) files.


Please know that I'm always here to help you if you have any other questions about exporting/importing IIF files. Have a wonderful day ahead!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us