cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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? 

5 Comments
Established Community Backer *

Re: 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.

Established Community Backer *

Re: 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. 

Not applicable

Re: Import IIF Line error message

THANK YOU THANK YOU THANK YOU!!!!!!!

Not applicable

Re: 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

Re: 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!

Need to get in touch?

Contact us