QuickBooks HelpQuickBooksHelpIntuit

Tasks you can do with IIF files

by Intuit Updated 3 weeks ago

If you are using QuickBooks 2019, please see Improved IIF Import in QuickBooks 2019.

Intuit Interchange Format (.IIF) files are cross-platform text files that can help you better manage your QuickBooks Desktop company data. This article details tasks you can do using IIF.

Generally, you can:

  • Export lists from one QuickBooks company file and import them into another
  • Import lists or transactions into QuickBooks from another program
  • Export list to and Import data from the QuickBooks Pro Timer.
  • Share data between different QuickBooks editions and platforms (such as Pro, Premier, and Enterprise, or between Windows and Mac)
Note: Intuit does not offer assisted technical support for creating or importing .IIF files

Specifically, these are some of the tasks you can do with IIF:

Bulk edit your lists

In some cases, you can bulk edit list element information (data) for customers, suppliers, items, or other list entries.

  1. Export the lists to your desktop.
    1. Go to the QuickBooks File menu, select Utilities then Export and then IIF Files.
    2. Select the checkbox corresponding to the list/s you want to export then click OK.
    3. Type a file name and choose the location where you want to save the IIF file.
  2. Open the file and edit data as desired.
    1. Right-click the export file. Select Open With and select Microsoft Office Excel.
    2. Click Yes if a warning about incompatible features is displayed.
    3. Edit the data in the file then select File and then Save.
    4. Close Excel. (If prompted to save again, click No.)
  3. Backup your company data file because imports cannot be undone.
  4. Import the edited IIF file to QuickBooks
    1. Go to the QuickBooks File menu,  select Utilities then Import and then .IIF Files.
    2. Locate the edited IIF file then select Open.

Import a supplier's IIF file to update your costs

Many businesses have large inventory lists provided by a few suppliers. You can update these lists with an .IIF from your supplier. Simply import the file into your company file (backup your file first) to record the changes.

Update other list entries

You can update list entries from one company file to another.

  1. Open the QuickBooks company containing the lists to transfer.
  2. Export the lists you need to edit.
    1. From the File menu, select Utilities then Export and then IIF Files.
    2. Note the location to which you are saving the file. Enter a name for the .IIF file and click Save.
  3. Open and edit the IIF file.
    1. Double-click the .IIF file and select Microsoft Excel as the program to open with.
    2. Edit the cost and/or prices and save. (The price and costs are in columns "AM" and "MN".)
    3. Click Yes to the message, Filename.iif may contain features that are not compatible with Test (tab delimited). Do you want to keep the workbook in this format?
    4. Close and save the file.
  4. Import IIF to the Company File.
    1. Close the exporting company, and then open the company file you want to import the lists to.
    2. Backup your company file before doing the import.
    3. Go to the QuickBooks File menu and select Utilities then Import and then .IIF Files.
    4. Locate the edited IIF file then select Open.
  5. When the import is complete ensure, the costs are updated in the list.

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this