IIF Converter for QuickBooks: Convert CSV and Bank Statements to IIF

If you have ever tried to import transactions into QuickBooks Desktop, you have likely encountered the IIF format. Whether you need a CSV to IIF converter to move bank data into QuickBooks, or an IIF to CSV converter to pull data back out, understanding the format is the first step to making your bookkeeping workflow faster.

This guide covers what IIF files are, when QuickBooks actually requires them, how to convert bank statement CSVs to IIF step by step, and where modern tools like LedgerLift can save you hours of manual work.

What Is an IIF File?

IIF stands for Intuit Interchange Format. It is a proprietary text-based file format created by Intuit, the company behind QuickBooks. An IIF file is a tab-delimited text file with a .iif extension that QuickBooks Desktop uses to import and export lists and transactions.

The format was designed in the 1990s when QuickBooks Desktop was the dominant accounting tool for small businesses. Each IIF file starts with a header row defining the type of data — transactions, accounts, vendors, or customers — followed by rows of corresponding data.

A typical IIF transaction block looks like this:

!TRNS  DATE        ACCNT            AMOUNT   MEMO
!SPL   DATE        ACCNT            AMOUNT   MEMO
!ENDTRNS
TRNS   06/01/2025  Checking         -150.00  Office Supplies
SPL    06/01/2025  Office Expenses   150.00  Office Supplies
ENDTRNS

If that looks intimidating, it is. Manually creating or editing IIF files is error-prone, and QuickBooks offers almost no feedback when something goes wrong during import.

When Does QuickBooks Use IIF?

IIF files are exclusively a QuickBooks Desktop feature. If you use QuickBooks Online (QBO), you will never encounter IIF files — QBO uses a different import process based on CSV files or live bank feeds.

You need a CSV to IIF converter when you:

• Import bank transactions into QuickBooks Desktop Pro, Premier, or Enterprise
• Migrate transaction history from another accounting system into QuickBooks Desktop
• Add bulk vendor or customer lists without entering each record manually
• Transfer data between two different QuickBooks Desktop company files

A QuickBooks QBO CSV to IIF converter is typically not needed for QuickBooks Online users. However, if you are transitioning from QBO to QuickBooks Desktop, or migrating data in the opposite direction, you may need to convert data between formats during the process.

How to Convert a Bank Statement CSV to IIF

Converting a bank statement CSV to IIF means mapping your CSV columns to the required IIF fields and structuring the output correctly. Here is a step-by-step overview:

Step 1: Export Your Bank Statement as CSV

Most banks allow you to download transactions as a CSV from your online banking portal. The file typically includes columns for Date, Description, Amount, and Balance.

Step 2: Clean and Organize the CSV

Before converting, ensure your CSV is ready:

• Remove header rows or summary rows that are not transactions
• Ensure dates are in a consistent format — MM/DD/YYYY works best for QuickBooks
• Separate debits and credits if your bank combines them into one column using positive and negative values

Step 3: Map CSV Columns to IIF Fields

IIF requires specific fields: TRNS type, date, account name, amount, and memo. You need to map your CSV columns accordingly. The account name must match exactly what appears in your QuickBooks chart of accounts — any mismatch causes the import to fail silently.

Step 4: Use a CSV to IIF Converter Tool

Doing this mapping manually in a spreadsheet is time-consuming and error-prone. Dedicated converter tools automate the column mapping and generate a valid IIF file ready for import.

Step 5: Import the IIF File into QuickBooks Desktop

In QuickBooks Desktop, go to File > Utilities > Import > IIF Files, then select your converted file. If the IIF file has a formatting error, QuickBooks may silently fail to import some or all of your transactions with no clear explanation.

Converting IIF to CSV

The reverse process — IIF to CSV conversion — is useful when you need to:

• Analyze QuickBooks transaction data in Excel or Google Sheets
• Share data with someone who does not use QuickBooks
• Migrate from QuickBooks Desktop to a cloud-based accounting platform
• Back up transaction data in a universally readable format

Since IIF files are tab-delimited text, you can open them in Excel and re-save as CSV. However, the TRNS and SPL multi-row structure means each transaction spans multiple rows, so a simple save-as will not produce a clean, flat CSV without additional restructuring.

Limitations of IIF vs. Newer Formats

IIF was designed for a different era of accounting software. Today it has significant limitations that explain why Intuit has largely moved away from it:

No meaningful error reporting. If your IIF file has a problem, QuickBooks may import nothing and give you only a vague success message or no feedback at all.

QuickBooks Desktop only. IIF has no place in QuickBooks Online. QBO uses CSV imports or live bank feeds for transaction data.

Fragile account name matching. Account names in your IIF file must exactly match your QuickBooks chart of accounts, including capitalization and spacing.

No Unicode support. IIF files are ASCII-only, so business names or memo fields containing special characters — accented letters, ampersands, or non-English text — can cause import failures.

Limited transaction types. IIF handles basic journal entries and bank transactions reasonably well but struggles with payroll, inventory adjustments, and more complex transaction structures.

Modern alternatives include the QBO bank feed file format (a different thing from QuickBooks Online, despite the similar name), direct CSV imports in QuickBooks Online, live bank connections, and API-based integrations that push data directly into QuickBooks without any file conversion at all.

---

Skip the IIF File Entirely with LedgerLift

If you use QuickBooks Online, you do not need a CSV to IIF converter. LedgerLift connects directly to your QBO account and pushes transactions from PDF or CSV bank statements straight into QuickBooks — no file conversion, no IIF format, no manual column mapping required.

Here is what LedgerLift does differently:

• AI-powered extraction reads any bank statement PDF regardless of bank or format — no templates to configure
• Direct QuickBooks Online push sends transactions to QBO without a file intermediary
• Inline editing lets you review and correct extracted data before it reaches QuickBooks
• Cloud storage automation with Google Drive, Dropbox, and OneDrive processes statements automatically when dropped into a monitored folder
• Team and client management built for accountants and bookkeepers handling multiple clients simultaneously
• API access for firms building custom document processing workflows

The free plan covers 120 pages with no credit card required. If you are still on QuickBooks Desktop where IIF is unavoidable, the steps above will help you navigate the format. But if you have any flexibility to work with QuickBooks Online, LedgerLift lets you leave IIF files behind for good.

Try LedgerLift free — no credit card required

---

Frequently Asked Questions

What is an IIF file?

IIF stands for Intuit Interchange Format. It is a tab-delimited text file used by QuickBooks Desktop to import and export transactions, account lists, vendors, and customers.

Does QuickBooks Online support IIF files?

No. IIF files only work with QuickBooks Desktop. QuickBooks Online uses CSV imports or direct bank feeds for transaction data, not IIF.

How do I convert a CSV to IIF for QuickBooks?

You need to map your CSV columns — date, amount, description — to the required IIF fields and output the data in the correct TRNS and SPL header structure. Dedicated converter tools automate this process, but account names in the resulting IIF must exactly match your QuickBooks chart of accounts or the import will fail.

Can I open an IIF file in Excel?

Yes. Since IIF files are tab-delimited text, Excel can open them directly. The TRNS and SPL structure means the data will not appear as a clean flat table, but the content is readable and editable.

What is the difference between IIF format and QBO format?

Despite similar naming, these are two different things. IIF is the older QuickBooks Desktop import format. QBO is a newer bank feed file format, also used by QuickBooks Desktop, that is more reliable and better supported. QuickBooks Online — the cloud subscription product — is an entirely separate product and uses neither IIF nor QBO file imports.

Why does my IIF import fail silently in QuickBooks?

QuickBooks Desktop's IIF importer is notoriously poor at error reporting. Common causes include mismatched account names, incorrect date formats, missing required fields, and special characters in description or memo fields.

Is there a free way to handle bank statements without dealing with IIF?

If you use QuickBooks Online, LedgerLift offers a free plan (120 pages, no credit card required) that converts PDF bank statements using AI and pushes data directly to QBO — no IIF conversion needed at any step.