Convert IIF to QuickBooks Online CSV | IIF to QBO

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

IIF (Intuit Interchange Format) is QuickBooks Desktop's proprietary tab-delimited format for importing/exporting data. It uses header rows (!TRNS, !SPL, !ENDTRNS) and data rows (TRNS, SPL, ENDTRNS) to represent double-entry accounting transactions with splits.

IIF was designed for QuickBooks Desktop's complex double-entry accounting with splits, classes, and custom fields. QuickBooks Online simplified its import process to use basic CSV format (3-4 columns) for bank transactions. IIF's tab-delimited, multi-row structure doesn't fit QBO's CSV import model.

Our converter is ideal for migrating bank transactions and historical transaction data from IIF to QBO CSV format. For complete migration (customers, vendors, chart of accounts), use QuickBooks' official migration service alongside our tool to fill gaps the official migration misses.

IIF files use TRNS (header) + SPL (split) rows to represent splits. This tool extracts only TRNS row amounts, which represent the net transaction total. Split category details are lost in CSV conversion - you'll need to categorize in QBO after import using bank rules.

QuickBooks Online's CSV bank import doesn't support classes, custom fields, or categories. Only Date, Description, and Amount transfer. IIF CLASS and custom fields are ignored. You'll need to set up QBO bank rules to re-apply classes/categories after import.

Yes! IIF format has been remarkably stable since QuickBooks 2002. Files from QuickBooks Pro, Premier, Enterprise, and even old versions (2005-2025) will convert successfully. The core TRNS/SPL structure hasn't changed.

IIF requires double-entry balance (TRNS + SPL = 0). This tool validates that transactions are balanced but only extracts TRNS rows for CSV. The balance validation is informational - if a transaction is unbalanced, it's a QuickBooks Desktop data issue.

First transactions are free to preview. Full conversions use credits based on transaction count (0.5 credits per 1,000 rows, minimum 5 credits).

Absolutely. All conversion happens in your browser. Your IIF file is never uploaded to servers. Your financial data never leaves your computer.

No, QuickBooks Online doesn't support IIF files natively. Our converter transforms your IIF files into the CSV format QuickBooks Online accepts, so you can import without needing any third-party subscriptions.