IIF to CSV Converter

IIF stands for Intuit Interchange Format. It is a proprietary, tab-delimited text format created by Intuit for importing and exporting data in QuickBooks Desktop. IIF files have been part of the QuickBooks ecosystem since the earliest versions of the software in the mid-1990s.

Unlike CSV files which are simple row-and-column data, IIF files use a structured record system. Each transaction begins with a header row prefixed by !TRNS that defines the column layout, followed by a TRNS row for the primary transaction entry, one or more SPL rows for split lines, and an ENDTRNS row that closes the transaction block.

The !TRNS header typically includes columns like TRNSID, TRNSTYPE, DATE, ACCNT, NAME, CLASS, AMOUNT, DOCNUM, and MEMO. The SPL rows carry the same column structure but represent the offsetting entries in the double-entry system. For example, a single check payment might have one TRNS line debiting the bank account and two SPL lines crediting different expense categories.

QuickBooks Desktop uses IIF for bulk operations: importing lists of customers, vendors, items, and chart of accounts entries, as well as importing journals, invoices, bills, and general transactions. Many third-party accounting tools export data in IIF format specifically for QuickBooks Desktop integration.

IIF files are designed exclusively for QuickBooks Desktop. They cannot be opened in Excel, Google Sheets, or any other spreadsheet application without preprocessing. If you try to open an IIF file in Excel, the tab-delimited structure will import, but the !TRNS, TRNS, SPL, and ENDTRNS markers will create a confusing mess of data that is nearly impossible to work with.

Converting IIF to CSV solves several common problems for accountants and bookkeepers:

QuickBooks Desktop to cloud migration — when moving from QuickBooks Desktop to QuickBooks Online, Xero, Wave, or FreshBooks, none of these cloud platforms accept IIF files. CSV is the universal import format they all support. Converting IIF to CSV is the essential bridge for data migration.

Historical data analysis — accountants who need to analyze years of QuickBooks Desktop data in Excel need the transactions in a flat CSV format. This enables pivot tables, VLOOKUP formulas, and custom categorization workflows.

Client data portability — when a client changes bookkeepers or accounting firms, providing the historical data as CSV ensures the new firm can import it into whatever system they use, without needing QuickBooks Desktop installed.

Audit preparation — auditors need transaction data in formats they can load into their own analysis tools. CSV is universally accepted for audit sampling, substantive testing, and transaction analysis.

Third-party integrations — many fintech tools, expense management platforms, and ERP systems accept CSV imports. Converting IIF data opens up integration possibilities that the proprietary format locks out.

Step 1: Export your data from QuickBooks Desktop. Open QuickBooks Desktop and go to File > Utilities > Export > Lists to IIF Files (for list data) or use a transaction report and export it as IIF. Save the .iif file to your computer.

Step 2: Open the IIF to CSV converter on FinanceConvert and drop your .iif file into the upload zone.

Step 3: The converter parses the IIF structure. It reads the !TRNS header row to identify column names, then processes each TRNS/SPL/ENDTRNS block as a complete transaction. Split lines are preserved in the memo field so no detail is lost.

Step 4: Each transaction is output as a clean CSV row with standardized columns: Date, Description, Memo, Debit, Credit, Balance, Amount, Currency, and FITID. Amounts from IIF AMOUNT fields are split into separate Debit and Credit columns for compatibility with accounting software import requirements.

Step 5: Download the CSV file. It is ready for immediate use in Excel, Google Sheets, or import into cloud accounting platforms.

Step 6: Import into your target system. In Xero, go to Bank accounts > Import a statement. In QuickBooks Online, go to Banking > Upload transactions. In Wave, go to Banking > Upload a bank statement. Each platform will recognize the standard CSV column structure.

One of the most complex aspects of IIF files is split transactions. In QuickBooks Desktop, a single payment can be allocated across multiple expense accounts, classes, or jobs. This is represented in IIF by having one TRNS row (the bank account side) followed by multiple SPL rows (the category allocation side).

For example, a single vendor payment of 1,500 dollars might be split into 800 dollars for Office Supplies, 500 dollars for Equipment Rental, and 200 dollars for Shipping. In the IIF file, this appears as one TRNS line for -1,500 against the checking account, and three SPL lines for 800, 500, and 200 against the respective expense accounts.

When converting to CSV, FinanceConvert handles splits by creating the primary transaction row with the total amount and appending the split details into the Memo column. This preserves the allocation information while producing a flat CSV structure that spreadsheets and accounting platforms can process.

For accountants who need the full split detail in separate rows, the Business tier API offers an expanded split mode where each SPL line becomes its own CSV row linked by a common transaction identifier. This is particularly useful for detailed expense analysis where you need to filter and pivot on individual split categories.

The converter also handles edge cases common in IIF exports: transactions with no SPL lines (simple entries), transactions where the TRNS and SPL amounts do not perfectly balance due to rounding, and transactions with empty or missing column values.