IIF connotes Intuit Interchange Format. These files are used in QuickBooks desktop for importing or exporting the transaction list across different platforms. As such, transferring the transactions becomes much easier and systemized. In this context, the IIF Import kit is a comprehensive guide that facilitates the easy importing of IIF files in QuickBooks. While importing the IIF files, users may encounter the IIF Import error. Within the purview of this article, we shall discover the various strategies to fix IIF Import Error in QuickBooks Desktop.

File Not Imported Error - Image

A brief info about the IIF Import kit

The Intuit Interchange Format (IIF) Import kit is an easy approach to importing bulk data in QuickBooks Desktop. This tool allows users to import their data pretty easily and efficiently. Users can download and install the IIF Import tool from the official website of Intuit and run the same to import critical data in QuickBooks Desktop. What‘s best is that users can download a sample to be used for importing QuickBooks Transactions.

The IIF Kit constitutes the following:

  • IIF Import Manual: It discusses some of the common .iif issues and procedures for rectification.
  • IIF Example Files: It is a folder that contains some samples of .iif transactions that are specific across versions.
  • IIF Header Help: The column headings are used for importing the list data in QuickBooks Desktop.

You may read it also: What are the Solutions of QuickBooks Script Error?

How to download and Install the IIF Import Kit?

The procedure given below will help you in downloading and installing the IIF Import kit.

  • Initially, head to the official website of Intuit and therein, search for the IIF Import kit and download the same.
  • Use the Winzip extractor to extract the contents of the tool.
  • Open the IIF Import kit folder to view the contents including the IIF import manual, IIF Example Files, IIF Header Help.

What types of Lists can be Imported in QuickBooks Desktop?

The following lists can be imported:

Vendor typesItems Import Chart of Accounts
Employees Classes Sales tax codes Price level Payment terms
Customers and Customer: jobs Customer messages Customer and job types
Budgets QuickBooks Import Inventory Import Sales Receipt
Import Invoices into QuickBooks Shipping methods

Important tips before fixing IIF import error in QuickBooks Desktop

If you are experiencing an IIF import error in QuickBooks Desktop, there are a few tips you can take to try and resolve the issue:

Verify that the IIF file is formatted correctly

Make sure that the IIF file you’re trying to import into QuickBooks Desktop is properly formatted. You can open the file in a text editor to check that it matches the IIF file format specified by QuickBooks.

Verify that your QuickBooks version is compatible with IIF files

IIF files are only compatible with certain versions of QuickBooks Desktop. Make sure that you are using a version of QuickBooks that supports IIF files. You can check the QuickBooks support site for more information on compatibility.

Check for special characters

IIF files can have problems with special characters such as “&” and “+” signs. Make sure to remove any special characters from your file before importing.

Split the IIF file into smaller files

If you are importing a large IIF file, try splitting it into smaller files and importing them individually. This can help to isolate any errors or issues that may be causing the import to fail.

Consider using a third-party tool

If you are still experiencing issues with importing IIF files, you may want to consider using a third-party tool to assist with the process. There are a variety of tools available that can help to streamline the import process and minimize errors.

If none of these steps resolve the issue, you may follow the below given advanced troubleshooting steps:

Read Also: How to Add a User License to your QuickBooks Software?

Steps to Fix IIF Import Error in QuickBooks Desktop

The procedure for resolving IIF Import Error in QuickBooks is discussed below:

  • To start off, run QuickBooks and then switch to the Single user mode.
  • After that, hit on the File menu.
  • Herein, choose the Utilities option.
Navigate Utilities Option - Screenshot
  • In the Utilities tab, hit on the Import option.
Import option in QuickBooks - Screenshot Image
  • After that, click on the option to Import IIF files
Import IIF file 0 Image
  • Subsequently, click on Browse and pick the file to Import.
  • Upon choosing the file, click on Import it for me. I’ll fix it later option.
Import IIF file - Image 1
  • After that, hit on OK button.

How can I Import Transactions in QuickBooks Desktop?

The steps to import transactions in QuickBooks Desktop are as follows:

  • Begin by signing as the Administrator to the company file.
  • After that, head to the File tab.
  • Choose the option to switch to the Single-User Mode option.
Switch company file to single-user mode - Screenshot
  • Now, take a company file backup.
  • Subsequent to that, click on the File menu.
  • Now, go to Utilities.
  • After that, click on Import option and choose the Import IIF Files option.
Import IIF file 0 Image
  • Search for the IIF file.
  • Right-click on the file and click on Open.
  • Finally, hit on Ok.

Also See: How to Resolve QuickBooks Error Code Skipped 111?

Winding Up!

The current blog explained all the facets of the IIF Import Error, including the steps to fix IIF Import Error in QuickBooks Desktop. You can reach out to our QuickBooks desktop support experts at the helpline i.e. 1-800-761-1787 to get any of your queries sorted out.


When you import IIF files it doesn’t link transactions?

When you import IIF files into QuickBooks, it should create new transactions or update existing ones in the appropriate areas of the software, such as invoices, bills, and bank transactions.

Can an IIF File be imported into QBO?

Yes, IIF (Intuit Interchange Format) files can be imported into QuickBooks Online (QBO) using a third-party conversion tool or through a manual process

How do I import an IIF File into Excel?

To import an IIF (Intuit Interchange Format) file into Excel, you can follow these steps:
1st Step. Open Microsoft Excel on your computer and click on the Data tab on the top navigation bar.
2nd Step. Select Get External Data from the drop-down menu, and then select From Text option.
3rd Step. Navigate to the location where your IIF file is saved and select it.
4th Step. In the Import Wizard window, select Delimited as the file type and click Next.
5th Step. Select the delimiter that separates the data in your IIF file, which is usually a comma or a tab, and then click Next.
6th Step. In the Data Preview window, you can review your data and make any necessary adjustments, such as formatting or removing unnecessary columns.
7th Step. Lastly, hit a click on Finish to complete the import process, and your IIF file data will now be displayed in Excel.

What are Common IIF Import Errors in QuickBooks?

Here are some of the most common IIF import errors in QuickBooks:
“Duplicate Name Exists”, “Invalid Account Type”, “Invalid Date”, “Transaction Amounts Are Out of Balance”, “Unable to Determine the Account Type for This Transaction”

To avoid these errors, it’s important to review and validate the IIF file before importing it into QuickBooks


Similar Topics:

How to Check QuickBooks Desktop Version and Release?

Steps to Fix QuickBooks Won’t Accept Product Number During Installation Error

How to Reconcile Payroll Liabilities in QuickBooks?

Call Now +1-800-761-1787