cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit
3 helpful votes

Export, import, and edit IIF files

Learn how to import and export Intuit Interchange Format (IIF) files to and from QuickBooks Desktop.

IIFs are used to export or import QuickBooks Desktop data. You can import things like your bank transactions, accountant’s changes, general journal entries, and batch transactions. You can import lists like your customer and vendor lists.

You can export lists like your customers and vendors, price levels set up on a percentage basis, and payroll data from Intuit payroll services.

Tip: If you use QuickBooks 2019 and later, see Improved IIF Import in QuickBooks 2019 and later.

Note: Intuit doesn't offer assisted technical support for creating or importing IIFs. If your IIF came from a third-party app, please contact the app’s technical support for help.

  • You can import transactions but you can't export them from QuickBooks.
  • You can only import a certain number of list items. See maximum number of list entries for more info.
  • IIF files you import don't create links between transactions. When you import an invoice and its payment, they aren't linked after you import. Link your transactions using the Receive Payments or Pay Bills windows. You can find third-party app solutions that link transactions from the Intuit Marketplace.
  • When you import assembly items, you can't import data in the item's custom fields.
  • You can't export or import price levels that are set up on a per-item or percentage basis.
  • You can't use IIFs to export payroll data from QuickBooks Desktop to other products. You can use them to export payroll data from Intuit Online Payroll and Intuit Full Service Payroll to QuickBooks Desktop.
  • You can't import IIFs from one country's version of QuickBooks to a different country's version. For example, from the US version of QuickBooks to the Canadian version.
  • Avoid enter numbers with leading zeros in Microsoft Excel when you create an IIF file. As a workaround, format the column cells as Custom.

Export IIFs

  1. Sign in to your company file as an admin.
  2. Go to the File menu and select Switch to Single-user Mode.
  3. Go to the File menu and select Utilities then Export. Select Export IIF Files.
  4. From the Save in drop-down, select the location you want to save the IIF. For example, your Windows desktop.
  5. Enter a name in the File name field and select Save.
  6. Select OK.

Import IIFs

  • Chart of Accounts
  • Employees
  • Vendor types
  • Items
  • Shipping methods
  • To dos
  • Notes
  • Sales tax codes
  • Customers and customer:jobs
  • Other names
  • Classes
  • Payment terms
  • Customer messages
  • Sales reps
  • Vendors
  • Customer and job types
  • Payment methods
  • Budgets
  • Price levels
  • Account beginning balances
  • Cash sales to customers
  • Checks
  • Deposits
  • Invoices
  • Account transfers of funds
  • Vendor bills
  • Cash refunds to customers
  • Credit card transactions
  • Estimates
  • Payments from customers
  • Vendor bill refunds
  • Credit card refunds to customers
  • Credit memos to customers
  • General journal entries
  • Purchase orders
  1. Sign in to your company file as an admin.
  2. Go to File and select Switch to Single-user Mode.
  3. Make a backup of your company file. This way you can restore it if the data doesn't import the way you expected.
  4. Go to the File menu and select Utilities then Import. Select Import IIF Files.
  5. Browse to your IIF file. Select it and then select Open.
  6. Select OK to confirm your data was imported.

Edit an IIF file

  1. In Microsoft Excel, go to File and select Open.
  2. Browse to your IIF file.
  3. In the File type drop-down, select All Files.
  4. Select the IIF and then select Open.
  5. In the Text Import Wizard, select Next, then Next and Finish.
  6. Make the changes to your IIF file.
  7. Go to the File menu and select Save.
  8. Select Yes.
  9. Close Excel. You'll get a prompt to save the IIF again. Select Don't Save.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us