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


Export .IIF files

Import .IIF files

Limitations

  • 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.
    • Search the QuickBooks Learn and Support site (US or Canada), or In-Product Help (Within QuickBooks, press F1 on your keyboard).
  • Imported IIF files do not create links between transactions. When you import an invoice and a payment for the invoice, 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 developers.
  • You must be in single-user mode to import or export data.
  • Only the QuickBooks administrator can import or export data.
  • 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 can import transactions but you cannot export transactions.
  • The amount of imported data. Refer to Maximum number of list items and transactions QuickBooks can process for details.
  • 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 export from the U.S. version of QuickBooks and import into the Canadian version of QuickBooks, or vice versa
  • When importing assembly items, you cannot import data in the item's custom fields.
  • 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.

Back to topic list

1001066 SLN42725