What IIF export file format does this tool accept?

This tool accepts IIF File (QuickBooks Desktop) files. Export from IIF and upload the Desktop) file directly.

Can I convert IIF CSV to QuickBooks Online?

Yes, this tool converts IIF File (QuickBooks Desktop) exports directly to QuickBooks Online CSV format compatible with QuickBooks Online.

How do I import IIF file (quickbooks to QuickBooks Online?

Export your file (quickbooks from IIF, upload the CSV file to this converter, then import the converted file to QuickBooks Online.

Convert IIF to QuickBooks Online CSV | Free IIF to QBO Converter

🥦

QuickBooks Online CSV Format

valid rows

Transform IIF (Intuit Interchange Format) transaction files from QuickBooks Desktop into QuickBooks Online's 3-column CSV format. Free converter for seamless QuickBooks migration.

No API required

Browser-based processing

Run on Google Cloud Platform

Download Sample IIF

Valid IIF file with sample transactions

Sample IIF File

How It Works

Export IIF from QuickBooks Desktop

File → Utilities → Export → Lists to IIF Files | Or export specific transactions to IIF

Upload IIF File

Drop your IIF file here or click to browse

Download QBO CSV

Get your converted CSV file ready for QuickBooks Online

Import to QuickBooks Online

In QBO: Banking → Upload Transactions → Select account → Upload CSV

Why Convert IIF to CSV for QuickBooks Online?

Migrating from QuickBooks Desktop to Online

IIF (Intuit Interchange Format) is QuickBooks Desktop's native import/export format. When migrating to QuickBooks Online: - Format incompatibility: QBO doesn't support IIF file imports - Historical data: You need to bring over past transactions from Desktop - Closed periods: Transactions from locked accounting periods - Selective migration: Import specific date ranges or accounts - Testing imports: Validate data before full migration QuickBooks Online only accepts manual transaction uploads in CSV format, so IIF files must be converted first.

What This Tool Does

We convert your IIF tab-delimited file to QuickBooks Online's required CSV format: Input (IIF - tab-delimited with headers): !TRNS TRNSTYPE DATE ACCNT NAME AMOUNT TRNS CHECK 01/18/2025 Checking Amazon.com -150.50 SPL CHECK 01/18/2025 Expenses Amazon.com 150.50 ENDTRNS Output (QBO CSV): Date,Description,Amount 01/18/2025,Amazon.com,-150.50 The tool extracts TRNS (header) rows and converts them to simple CSV, preserving transaction dates, payees, and amounts.

Your Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files are processed directly in browser. No calls to our servers.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

Field Mapping

How Banking Iif fields map to Quickbooks Online Bank Transaction

Banking Iif	Source Value		Quickbooks Online Bank Transaction	Target Value	Note
`DATE`	`01/18/2025`	→	`Date`	`01/18/2025`	IIF date (MM/DD/YYYY) → MM/DD/YYYY
`AMOUNT`	`-150.50`	→	`Amount`	`-150.50`	TRNS row amount (negative for expenses, positive for income)

Why Use This Tool?

Desktop to Online Migration

Seamlessly convert QuickBooks Desktop IIF exports to QuickBooks Online CSV

Double-Entry Handling

Extracts TRNS header rows, ignores SPL split lines (QBO CSV doesn't support splits)

Tab-Delimiter Parsing

Correctly parses IIF's tab-delimited format (not comma-separated)

Transaction Type Preservation

Includes transaction type (CHECK, DEPOSIT, etc.) in description

Browser-Based Security

All processing in your browser - your QuickBooks data stays private

All QB Desktop Versions

Works with IIF from QuickBooks Pro, Premier, Enterprise (2015-2025)

Data Transformation

Multiple IIF rows (TRNS + SPL) become one CSV row

Tab-delimited TRNS header + SPL splits

Key columns: TRNS row (header), SPL row(s) (splits), ENDTRNS (delimiter)

N:1 — Multiple input rows aggregate to one output row

Simple CSV format with 3 columns (TRNS row only)

Transaction Extract date from TRNS row

Description Combine payee and memo from TRNS row

Amount Extract amount from TRNS row (ignores SPL)

Amounts must be numeric; dates must be valid; SPL rows are informational only

Common Bank Transaction CSV (3-Column) Import Errors

Issues you might encounter when importing IIF QuickBooks Transactions data to Bank Transaction CSV (3-Column) - and how we solve them

Invalid IIF File

File is not a valid tab-delimited IIF format

CSV file with commas or corrupted IIF

Valid IIF file from QuickBooks Desktop

Ensure you're exporting IIF format from QuickBooks Desktop

Go to QuickBooks Desktop → File → Utilities → Export → Lists to IIF Files

Missing !TRNS Header

IIF file doesn't contain required !TRNS header row

IIF without !TRNS line

!TRNS TRNSTYPE DATE ACCNT ...

IIF files must start with header rows (!TRNS, !SPL, !ENDTRNS)

Re-export from QuickBooks Desktop ensuring IIF format is selected

Unbalanced Transaction

TRNS + SPL amounts don't sum to zero (double-entry requirement)

TRNS: -100, SPL: 90 (missing $10)

TRNS: -100, SPL: 100 (balanced)

IIF requires double-entry accounting; all transactions must balance

Tool extracts TRNS row amounts only; balance issues are informational

Multiple SPL Rows

Transaction has multiple split lines (SPL rows)

1 TRNS + 3 SPL rows with different categories

Converted to single CSV row with TRNS amount

Only TRNS row is used; SPL split details are not preserved

Use bank rules in QBO to re-categorize after import

Frequently Asked Questions

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.

This tool is best for migrating bank transactions and historical transaction data. For complete migration (customers, vendors, invoices, chart of accounts), use QuickBooks' official migration service or third-party tools like SaasAnt or Transaction Pro. This tool helps 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.

Yes! Preview the first 5 rows free. Full conversion costs 0.5 credits per 1,000 rows (minimum 5 credits). Typical IIF exports are reasonable size - a year of transactions usually costs 5-10 credits.

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