Convert CSV to QuickBooks Desktop IIF Format
Create mathematically balanced .IIF files for QuickBooks Desktop with proper TRNS, SPL, and ENDTRNS double-entry blocks.
Convert your statement
100% private in browser memory. Bank files never leave your device.
Drop your statement here, or browse files
CSV, QBO, OFX, QFX, IIF, QIF, MT940, and CAMT.053 XML. Multi-file batch upload supported.
Why this conversion is required
Intuit discontinues older versions of QuickBooks Desktop and disables Web Connect .QBO imports. However, QuickBooks Desktop imports .IIF files indefinitely without an active subscription.
Technical Compliance Guarantees
- ✓ Generates balanced double-entry: TRNS amount + SPL amount === 0.00
- ✓ Configurable bank account name and offset account (e.g., Ask My Accountant)
- ✓ Uses tab-delimited formatting with CRLF line breaks per Intuit specification
- ✓ Assigns proper TRNSTYPE (CHECK, DEPOSIT, CREDIT CARD, CCARD REFUND)
Frequently Asked Questions
How do I import bank transactions into discontinued QuickBooks Desktop without paying for a subscription? +
When Intuit discontinues support for older QuickBooks Desktop editions, Web Connect .QBO imports are blocked. Converting your CSV statement to balanced .IIF format allows you to import transactions directly via File > Utilities > Import > IIF Files without an active subscription.
Does IIF import require an active QuickBooks subscription? +
No. QuickBooks Desktop versions (Pro, Premier, Enterprise from 2018–2024+) allow .IIF file imports locally without any Intuit subscription or online banking connection.
How are the double-entry rows balanced? +
Each transaction generates a TRNS row posting to your Bank/Credit Card account and an equal-and-opposite SPL row posting to your selected offset account (e.g., Ask My Accountant or Uncategorized Expense).
Should I back up my company file before an IIF import? +
Yes. IIF imports write directly to QuickBooks account registers without a preliminary bank feed staging screen. It is best practice to create a quick QuickBooks backup (.QBB) before importing any batch file.
Full format & repair matrix
60+ high-intent financial converters, diagnostics, and institutional bank presets.
Core accounting file converters
CSV to QBO
Turn any bank or credit card CSV download into an official QuickBooks Web Connect (.QBO) file with valid OFX 1.02 SGML headers.
QBO to CSV
Extract transactions from archaic SGML .QBO files into clean CSV format ready for Microsoft Excel, Google Sheets, or Apple Numbers.
CSV to IIF
Create mathematically balanced .IIF files for QuickBooks Desktop with proper TRNS, SPL, and ENDTRNS double-entry blocks.
QBO to IIF
Import transactions from bank .QBO downloads directly into discontinued or older QuickBooks Desktop editions using balanced .IIF syntax.
OFX to IIF
Transform Open Financial Exchange (.OFX) and Quicken (.QFX) downloads into balanced double-entry QuickBooks Desktop IIF files.
OFX to CSV
Extract financial transactions from bank OFX downloads into clean, organized CSV rows.
CSV to OFX
Generate standardized OFX files from any bank, credit card, or payment processor CSV export.
QFX to CSV
Parse Quicken .QFX statement downloads into clean Excel and Google Sheets spreadsheets.
CSV to QFX
Create Quicken-compatible .QFX Web Connect files from any bank statement CSV.
QFX to QBO
Quickly patch and convert Quicken statement files so QuickBooks recognizes and imports them into bank feeds.
OFX to QBO
Transform standard Open Financial Exchange (.OFX) files into QuickBooks Web Connect (.QBO) files.
CSV to QIF
Generate classic Quicken Interchange Format (.QIF) files from any bank or credit card CSV export.
QIF to CSV
Extract historical financial records from legacy QIF files into modern spreadsheet tables.
QIF to QBO
Upgrade legacy Quicken .QIF statements into modern QuickBooks Web Connect (.QBO) files.
QIF to IIF
Transform Quicken QIF files into double-entry balanced IIF files for QuickBooks Desktop Pro, Premier, and Enterprise.
IIF to CSV
Parse complex QuickBooks IIF ledger files into readable spreadsheet rows.
MT940 to CSV
Parse international SWIFT MT940 bank statements into standard CSV format.
MT940 to QBO
Import international SWIFT MT940 corporate statements into QuickBooks Online and Desktop.
CAMT.053 to CSV
Extract transactions from modern ISO 20022 CAMT.053 XML bank statement files into clean CSV tables.
QuickBooks CSV Formatter
Format messy bank CSV downloads into the exact 3-column (Date, Description, Amount) or 4-column (Date, Description, Credit, Debit) layout required by QuickBooks Online.
Xero CSV Formatter
Transform any bank download into Xero-compliant 5-column CSV format ready for immediate import.
QuickBooks error & diagnostic utilities
Fix OL-222 Error
Repair corrupt .QBO files that trigger QuickBooks Error OL-222 with automated character sanitization and field capping.
Fix OL-301 / OL-393
Repair .QBO files rejected by QuickBooks due to expired, unrecognized, or discontinued financial institution identifiers.
Merge QBO, OFX, CSV
Combine multiple monthly statements into a single unified file sorted chronologically, with duplicate transactions automatically removed.
Credit Card CSV Flipper
Instantly flip debit and credit signs on credit card statements so charges import as expenses rather than deposits.