Import IIF Line error message

Forum|Forum|7 years ago
April 5, 2019
2 replies
0 views

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?

QuickBooks Desktop

QBsguru

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.

melissayahnAuthor

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

QBsguru

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.

melissayahnAuthor

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

Moderator

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!

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded