Intuit Interchange Format (.IIF) files are used to export or import QuickBooks Desktop data, to and from different platforms, for better management of company records. This article will serve as a guide to exporting, importing, and editing .IIF files.


This article is part of a series that covers basic information about .IIF files in QuickBooks Desktop.


Exporting and Importing Limitations

  • You can import transactions, but you cannot export transactions from QuickBooks.
  • There is a maximum number of list entries which QuickBooks can process.
  • Imported IIF files do not create links between transactions.

    When you import an invoice and its payment, they are not linked after the import. You must link them, and all other pairs, in the Receive Payments window or Pay Bills window. If you need an import solution that links transactions, refer to the Intuit Marketplace for third-party applications.

  • When importing assembly items, you cannot import data in the item's custom fields.
  • You cannot import or export Price Levels set up on a Per Item basis. You can import and export Price Levels set up on a Percentage basis.
  • You cannot use IIF files to export payroll data from QuickBooks Desktop accounting to other products. You can, however, use them to export payroll data from Intuit Online Payroll and Intuit Full Service Payroll to QuickBooks Desktop accounting products (applies to US only).
  • You cannot export from the U.S. version of QuickBooks and import into the Canadian version of QuickBooks, or vice versa.
  • You cannot enter numbers with leading zeros in Microsoft Excel when creating and IIF import file.

    Work around: Change the format to "Custom" and put a non-numeric character in front of the number.

  • Intuit does not offer assisted technical support for creating or importing .IIF files. However, there are resources available if you need help:
    • If the .IIF file was created by a third-party application, contact the application's technical support department.
    • Refer to the documentation provided with the import kit you used.
    • Search the QuickBooks Learn and Support site (US or Canada), or In-Product Help (Within QuickBooks, press F1 on your keyboard).

Export .IIF files

Import .IIF files

1001066 SLN42725