Quickbooks IIF Overview

What is Quickbooks IIF file? IIF stands for Intuit Interchange Format. IIF files are text files that QuickBooks uses to import and export data. You can use IIF files to do the following:

  • Export lists from one QuickBooks company file and import them into another.
  • Import transactions into QuickBooks from another program.
  • Import QuickBooks Timer activities into a company file.
  • Share data between different QuickBooks editions and platforms (such as Pro, Premier, and Enterprise; or Windows and Macintosh)

Limitations of IIF files:

  • Imported IIF files do not create links between transactions. This means you have to manually link, for example, an invoice to a payment.
  • You must be in single-user mode to import or export data.
  • Only the Admin user can import or export data.
  • Payroll data cannot be imported or exported.
  • Transactions can be imported but not exported.
  • The amount of imported data.

Lists that can be imported and exported using IIF files:

Chart of Accounts Payment Terms Budgets
Customer Message Price Level Class
Customer Type Sales Rep Employee
Customer:Job Sales Tax Code Item
Other Names List Shipping Method Job Type
Payment Method To Do Notes Vendor
Vendor Type

Transactions that can be imported using IIF files:

Account beginning balances Checks Cash sales to customers
Account transfers of funds Deposits Credit card transactions
Cash refunds to customers Estimates General journal entries
Credit card refunds to customers Invoices Purchase orders
Credit memos to customers Vendor bills Vendor bill refunds
Payments from customers

You can download the Quickbooks IIF Import Kit to work with IIF import files. It contains the following components:

  • IIF Import Manual (a PDF document that outlines IIF common pitfalls and best practices)
  • IIF Header Help (the column headings used to import list data)
  • IIF Example Files (a folder that contains version specific IIF transaction examples)