QB Issue Resolution:
When importing an IIF file, you may see an error message with format:
Error on Line XX: (Message varies)
Why this is happening
The error message and root cause will vary based on the information that is being imported here are a few examples:
Error on line XX: You can’t change the type of an account.
Occurs when the account name or account number on line XX is already being used in the file and the account is of a different type.
Importing an Invoice or Bill with an account type other than Accounts Receivable (Invoice) or Accounts Payable (Bill).
Importing a transaction with an account that has not been created prior to the import.
How to fix it
Intuit recommends more than one solution for this problem. The first solution may solve your problem, or you may need to try all of them to resolve the issue. For best results, perform the solutions in the order shown.
Solution 1: Edit or delete the row in the IIF file that is generating the error.
To edit the row:
Right-click on the IIF file and select Open with Microsoft Office Excel
Locate the row number referenced in the error message.
Look in the Chart of Accounts in QuickBooks for an with the same account name and/or account number but a different type.
Make the necessary corrections in QuickBooks or the IIF.
Save the IIF file and click Yes to the message: Do you want to keep the workbook in this format?
Import the IIF file again.
To delete the row:
Right-click on the IIF file and select Open with Microsoft Office Excel.
Locate the row number referenced in the error message.
Right-click on the row number referenced in the error, click Delete.
Save the file and click Yes to the message: Do you want to keep the workbook in this format?
Import the IIF file again.
Note: Solutions 2 and 3 should be used only if you are receiving the error when importing transactions with an IIF file.
Solution 2: Verify that Invoices and Bills that are being imported are using the correct account type.
Follow steps in Solution 1 to edit the row of the IIF file in excel so that Invoices and Bills are mapped to the the correct account type.
Solution 3: Manually create the account with the correct account type being used for transactions being imported.
Open the IIF file in Excel
Find the row in Excel that is referenced in the error.
Identify the Account Name and Account Type being used in this row.
Follow steps in this article to create a new account with the correct account type in QuickBooks.
Import the IIF file again.
Resolution for Issue 'Error on line XX when importing IIF Files' available: Yes (Solved).
Source: Intuit Community forum.
Error on line XX when importing IIF Files: this issue or error code is a known issue in Quickbooks Online (QBO) and/or Quickbooks. Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Quickbooks issue to ensure minimal downtime and continue running your business. First try to resolve the issue yourself by looking for a resolution described below. If it is a complex issue or you are unable to solve the issue, you may contact us by clicking here or by using other support options.
Support for IIFQuickbooks Repair Pro will resolve it efficiently and affordably. Guaranteed resolution of your issue, or you pay nothing!
Error Recovery for IIF [Canada]
E-Tech is the #1 Quickbooks data migration and Conversion service provider.
Additional Support Options: