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.
Convert IIF to QuickBooks Online CSV | IIF to QBO
or drop files here .iif, .txt (up to 50 MB)
Free 5-row preview · No sign-up required
Invoice import blocked if Sales Tax enabled in QBO
Convert Complete
Your converted file is ready!
Download now before closing this page
QuickBooks Online CSV Format
Showing valid rows only (download includes all rows + errors)
All rows valid
| $ |
|---|
+ more rows
valid rows
invalid rows skipped from preview
credits
| Row | Column | Value | Error |
|---|---|---|---|
Showing first 50 errors. more errors not shown.
more errors hidden. Download the full validation report to see all errors.
Validation Report Download
The download includes your original file with an added "Validation Error" column showing error messages for each row. Valid rows have an empty error column.
• credits
Use credits to download
Click any download button to use your credits
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
for credits
One-time payment
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle
Want to save on credits?
Buy bundles and get up to 27% off. Perfect for recurring monthly conversions.
Liked the preview?
Upload your actual file to get the real conversion
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
How to Convert Your File
1
Export from Banking
File → Utilities → Export → Lists to IIF Files
2
Upload and Configure
Upload IIF QuickBooks Transactions CSV and choose Bank Transaction CSV (3-Column) format
3
Preview and Download
Review converted data, download Quickbooks Online-ready file
4
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 This
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.
A client running QuickBooks Enterprise 2018 needed to move to QuickBooks Online. The IIF files from Enterprise converted to QBO CSV without issues, even with thousands of transactions. Much simpler than paying for a third-party migration subscription.
We consolidated three QuickBooks Desktop company files into one QuickBooks Online account. I converted each location's IIF export to CSV, imported them sequentially, and used bank rules to re-categorize. The QuickBooks Desktop to Online migration went smoother than our consultant expected.
Several clients still on QuickBooks Desktop needed their transaction data in QuickBooks Online for my firm's workflow. I converted their IIF files to QBO CSV format in bulk, covering date ranges going back to 2019. The tab-delimiter parsing handled even the older IIF file versions flawlessly.
Common Conversion Questions
Is this tool free?
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 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.
// PRICING //
Choose the plan that fits your needs
Pay as you go
Just start processing on any tool page
$1/credit
Tools processing starts from 5 credits. Then 1 credit = 1k rows. No sign-up needed.
OR
Credit Bundles
$
/Credit
One-time purchase
- No monthly commitment
- Credits valid for one year
- Access to all tools
- Full file downloads
Monthly Bundles Pro
$
/Credit
Best for professionals and content creators
Annual Discount
Per month, billed annually:
Save 20% more
- Credits refresh monthly
- Priority processing
Purchase Credits
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
for credits
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle
Do unused credits expire?
One-time credit bundles are valid for one year. Subscription credits refresh monthly. You can use credits across any tool, anytime.
Is my data secure?
Files process entirely in your browser. We're GDPR compliant with TLS encryption.
Can I get a refund?
Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.
Powered by
Paddle
Terms of service applies. VAT included where applicable.
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 This 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
Input
IIF Transaction Block
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
Output
QuickBooks Online CSV Row
aggregated rows per
input
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
Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.
No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.
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.
Banking → Quickbooks Online Data Ecosystem
All available data flows from Banking to Quickbooks Online
Banking
Bank CSV Transactions
Generic bank CSV export with flexible column detection
→
Quickbooks Online
Bank Transaction CSV (3-Column)
QuickBooks Online bank transaction import - 3-column format
Date → DTPOSTED
Description/Payee → NAME
Memo → MEMO
Banking
Bank CSV Transactions
Generic bank CSV export with flexible column detection
→
Quickbooks Online
Bank Transaction CSV (3-Column)
QuickBooks Online bank transaction import - 3-column format
Date → Date
Description/Payee/Memo → Description
Amount → Amount
Banking
Bank CSV Transactions
Generic bank CSV export with flexible column detection
→
Quickbooks Online
Bank Transaction CSV (3-Column)
QuickBooks Online bank transaction import - 3-column format
Date → DTPOSTED
Description/Payee → NAME
Memo → MEMO
Banking
IIF QuickBooks Transactions
Intuit Interchange Format for QuickBooks Desktop (tab-delimited)
→
Quickbooks Online
Bank Transaction CSV (3-Column)
QuickBooks Online bank transaction import - 3-column format
DATE → Date
NAME + MEMO → Description
AMOUNT → Amount
Banking
OFX/QFX/QBO Bank Transactions
Bank and credit card transactions in Open Financial Exchange format
→
Quickbooks Online
Bank Transaction CSV (3-Column)
QuickBooks Online bank transaction import - 3-column format
DTPOSTED → Date
NAME + MEMO → Description
TRNAMT → Amount
Banking
OFX/QFX/QBO Bank Transactions
Bank and credit card transactions in Open Financial Exchange format
→
Quickbooks Online
Bank Transaction CSV (3-Column)
QuickBooks Online bank transaction import - 3-column format
DTPOSTED → Date
NAME + MEMO → Description
TRNAMT → Amount
Banking
QIF Bank Transactions
Quicken Interchange Format transactions for bank and credit card accounts
→
Quickbooks Online
Bank Transaction CSV (3-Column)
QuickBooks Online bank transaction import - 3-column format
D → Date
P + M → Description
T → Amount
🥦
Quick question before you go
Help us improve—what stopped you today?
🎉
Thank you!
Enter your email to claim your welcome bonus