QuickBooks IIF File: What It Is and How to Import One

A QuickBooks IIF file is an Intuit Interchange Format file, a tab-delimited plain text file with a .iif extension that QuickBooks Desktop uses to import and export lists and transactions. To import one, go to File, then Utilities, then Import, then IIF Files, pick your .iif file, and let the QuickBooks 2019-and-later import tool scan it for errors before it loads. IIF is a Desktop-only format; QuickBooks Online does not import or export IIF files.

IIF has been around since the early days of QuickBooks Desktop, and people still reach for it to move chart-of-accounts lists, customers, vendors, and batches of transactions between systems. It is powerful but unforgiving: the structure has to be exact, and a single bad character can stop the whole import. This guide explains what the format is, how to import and export it, why imports fail, and when a CSV or a converted .qbo file is the easier choice.

What is an IIF file in QuickBooks?

IIF stands for Intuit Interchange Format. It is a plain text file, tab-delimited, with a .iif extension, used to import and export data between QuickBooks Desktop and other applications. Each line is one record, fields are separated by tabs, and the first lines are header rows that tell QuickBooks what kind of data follows, such as !CUST for customers, !VEND for vendors, or !TRNS for transactions.

How do I import an IIF file into QuickBooks Desktop?

Open QuickBooks Desktop, go to File, then Utilities, then Import, then IIF Files. Browse to your .iif file and select Open. In QuickBooks 2019 and later, the improved import tool scans the file first and reports any rows it cannot read so you can fix them before committing. Always back up your company file before an IIF import, because the changes are not easy to reverse.

How do I export an IIF file from QuickBooks?

Go to File, then Utilities, then Export, then Lists to IIF Files. Choose the lists you want, such as the chart of accounts, customers, vendors, or items, and save the .iif file. Exporting is the safest way to get a correctly structured template, because the file QuickBooks writes already has the exact headers and field order an import expects.

Where do I get an IIF template?

Use the sample files in Intuit's IIF Import Kit, or export a list from QuickBooks to get a working template with the right headers. The Import Kit contains sample .iif files, header references, and instructions. Starting from a known-good template, then replacing the data while leaving the header rows untouched, avoids most formatting errors.

Why won't my IIF file import?

An IIF import almost always fails because of formatting: the wrong delimiter instead of tabs, a missing required field, special characters, or a date in the wrong format. Open the file in a plain text editor and confirm the headers match the data rows, every required field has a value, and the delimiters are real tabs. Fix the flagged rows and re-import.

Why should I edit an IIF file in Notepad, not Excel?

Open and edit IIF files in Notepad, Notepad++, or another plain text editor, not Excel. When Excel opens an .iif file it can convert tabs to spaces, change the date format, drop leading zeros, and reformat numbers, which silently breaks the file. A plain text editor leaves the tab delimiters and raw values exactly as QuickBooks needs them.

Can an IIF file have special characters?

No. The IIF format does not allow special characters such as ampersands or plus signs in the data. If a customer name or memo contains an & or a +, the import throws an error. Remove or replace those characters before you import, and watch for hidden ones that get pasted in from other programs.

Can I import an IIF file into QuickBooks Online?

No. QuickBooks Online does not support IIF files for import or export; IIF is a QuickBooks Desktop format only. To move data into QuickBooks Online you use its own tools instead: import lists and bank transactions from a CSV, or bring bank activity in through the bank feed with a .qbo, QFX, or OFX file.

Should I use IIF to import bank transactions?

For bank transactions, IIF is rarely the best tool. It is finicky, Desktop-only, and easy to break. For a batch of bank activity, a Web Connect .qbo file imported through Bank Feeds is cleaner, matches against the feed, and supports reconciliation. Reserve IIF for list data and one-off batches where you already have a tested template.

What is the difference between IIF and QBO files?

An IIF file is a tab-delimited text file for importing lists and transactions into QuickBooks Desktop. A .qbo file is a Web Connect bank file that carries downloaded bank transactions and imports through Bank Feeds in Desktop or the upload tool in QuickBooks Online. For getting statement activity into either product, .qbo is the format built for that job.

Does opening an IIF file in Excel break it?

It can. Excel often converts the tab delimiters to spaces, reformats dates, and strips leading zeros when it opens an .iif file, all of which cause import errors. If you opened one in Excel and saved it, the file may already be corrupted. Re-export a fresh copy from QuickBooks or rebuild from a clean template using a text editor.

How do I get a bank statement into QuickBooks without IIF?

Convert the PDF or CSV bank statement into a .qbo Web Connect file and import that. It skips the tab-delimited formatting, special-character rules, and header alignment that make IIF imports fail. The .qbo file drops straight into the bank feed, where you review, categorize, and reconcile the transactions the normal way.

IIF still has its place for list data, but for bank activity a converted file is faster and far less error-prone. When you need months of history that the feed will not pull, import old bank statements into QuickBooks by converting them to .qbo, then reconcile bank statements in QuickBooks so everything ties out. Because IIF was never built for bank activity, a bank statement to QBO converter is the cleaner route when you start from a PDF. If your bank only offers a spreadsheet, see how to import a CSV file into QuickBooks, then match transactions and fix any .qbo file that won't import. For workflows that span other tools, you can convert statements to Excel, turn a CSV into a .qbo file, or digitize paper with receipt OCR software.