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 | IIF to QBO

🥦

QuickBooks Online CSV Format

valid rows

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

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Sample IIF

Valid IIF file with sample transactions

Sample IIF File

How to Convert IIF to QBO

Export from Banking

File → Utilities → Export → Lists to IIF Files

Upload and Configure

Upload IIF QuickBooks Transactions CSV and choose Bank Transaction CSV (3-Column) format

Preview and Download

Review converted data, download Quickbooks Online-ready file

Import to QuickBooks Online

Banking → Select Account → Upload from Computer → Import CSV

Output is in QuickBooks Online CSV format — ready to import directly, no manual reformatting needed.

How People Use IIF to QBO

We handle QuickBooks Desktop to Online migrations for dozens of clients each year. The official migration tool misses older transactions, so I converted IIF exports to QuickBooks Online CSV to fill the gaps. The 3-column format imports cleanly without any rejected rows.

When I switched from QuickBooks Pro to QuickBooks Online, I needed my historical transactions to come along. I exported each year as IIF and converted them to QBO CSV format. The conversion preserved my transaction dates and payee names exactly as they were in Desktop.

Three of my clients decided to migrate from QuickBooks Desktop to Online simultaneously. Converting their IIF transaction files to QuickBooks Online CSV format let me import bank transactions that the native migration service skipped. The TRNS extraction handled double-entry perfectly.

IIF to QBO Conversion Questions

Is the IIF to QBO converter free to use?

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

Is my QuickBooks data safe?

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

Can I import IIF directly into QuickBooks Online?

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.

Why Convert IIF to CSV for QuickBooks Online?

Migrating from QuickBooks Desktop to Online

IIF (Intuit Interchange Format) is QuickBooks Desktop's native format. When migrating to QBO: - QBO doesn't support IIF imports - Historical data needs to transfer from Desktop - Closed periods and locked transactions need migration - Selective import of specific date ranges or accounts QuickBooks Online only accepts CSV for manual uploads, so IIF files must be converted first.

What This Tool Does

Converts IIF tab-delimited files to QBO's 3-column CSV (Date, Description, Amount). Extracts TRNS header rows, ignores SPL split lines. Preserves transaction dates, payees, and amounts. Handles IIF's double-entry structure and outputs simple CSV that QuickBooks Online accepts for bank transaction upload.

Your IIF to QBO Conversion is Secure

Browser-Only Processing

All conversion runs in your browser. Files are never uploaded to any server.

No Data Retention

Nothing is stored after conversion. Close the tab and your data is gone.

GDPR Compliant

Full EU data protection compliance. Your privacy rights are fully protected.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

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 the IIF to QBO Converter?

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

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.