Import IIF Line error message

melissayahn · ‎April 05, 2019

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?

QBsguru · ‎April 05, 2019

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.

QBsguru · ‎April 05, 2019

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.

melissayahn · ‎April 05, 2019

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

melissayahn · ‎April 05, 2019

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.

Angelyn_T · ‎April 05, 2019

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.

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!

Topics

Training

Community

Resources

Import IIF Line error message