Convert IIF Files to Wave Format Instantly

Why Migrate IIF Files From QuickBooks Desktop to Wave?

IIF (Intuit Interchange Format) is the legacy tab-delimited file format used by QuickBooks Desktop for importing and exporting transactions, chart of accounts, customer lists, vendor lists, and other accounting data. For decades, IIF has been the primary way to bulk-import data into QuickBooks Pro, Premier, and Enterprise. However, if you're migrating away from QuickBooks Desktop to Wave Accounting, IIF files are incompatible with Wave's import system.

Wave only accepts CSV files with three specific columns: Date, Description, and Amount. Our IIF to Wave converter parses the tab-delimited IIF transaction data, extracts the essential fields (date, payee/memo, amount), and generates a clean Wave-compatible CSV — ready for direct upload via Wave's Banking > Connected Accounts > Upload a Statement feature.

Understanding the IIF File Format

IIF files are plain-text, tab-separated files with a specific structure defined by Intuit. A typical IIF transaction file contains:

• Header rows starting with !TRNS and!SPL — these define the column layout for transaction lines and split lines respectively.
• TRNS rows — each represents a transaction with fields for date, account, name (payee), class, amount, memo, and transaction type.
• SPL rows — split lines that accompany each TRNS row, providing the offsetting entry (debit side for credits, credit side for debits).
• ENDTRNS markers — indicate the end of each transaction/split group.

IIF files can also contain non-transaction data like chart of accounts (!ACCNT), customer lists (!CUST), vendor lists (!VEND), and item lists (!INVITEM). When converting to Wave, the tool focuses exclusively on the TRNS transaction data, which is the only data type Wave can import via CSV.

QuickBooks Desktop vs Wave: Cost Comparison

The financial case for migrating from QuickBooks Desktop to Wave is compelling, especially for small businesses and freelancers:

• QuickBooks Desktop Pro — $349.99/year (Intuit discontinued perpetual licenses in 2024, requiring annual subscriptions for all new purchases).
• QuickBooks Desktop Premier — $549.99/year with industry-specific features (retail, nonprofit, manufacturing).
• QuickBooks Desktop Enterprise — Starting at $1,481/year for a single user, up to $4,688/year for 10 users.
• Wave Accounting — Completely free. Invoicing, accounting, receipt scanning, financial reports, and bank imports are all included at no cost.

For businesses that don't need QuickBooks Desktop's advanced inventory management, job costing, or multi-user features, Wave provides a fully capable accounting platform at zero cost. The IIF to Wave converter makes this migration seamless by letting you bring your transaction history along.

What Transfers from IIF to Wave

When converting IIF files to Wave CSV, the following transaction data is preserved:

• Transaction dates — converted from IIF's date format to Wave's MM/DD/YYYY or YYYY-MM-DD.
• Payee names and memos — extracted from the NAME and MEMO columns, with special characters stripped.
• Transaction amounts — positive for deposits, negative for withdrawals, matching Wave's single-Amount convention.

Data that does not transfer (because Wave CSV import does not support it):

• Chart of accounts structure — you'll need to recreate accounts in Wave manually or use our Chart of Accounts Generator.
• Split transaction details — Wave CSV imports are single-line entries without multi-account splits.
• Customer and vendor lists — Wave has its own contact management system.
• Transaction types (Invoice, Bill, Check, Journal Entry) — Wave CSV treats everything as bank transactions.
• Class tracking and job costing data — these are QuickBooks-specific features.

For a complete IIF data inspection before conversion, use our IIF Viewer & Validator to preview all transaction types, account structures, and data fields in your IIF file.

How to Migrate from QuickBooks Desktop to Wave via IIF

1. Export from QuickBooks Desktop — Open QuickBooks Desktop, go to File > Utilities > Export > Lists to IIF Files or use File > Utilities > Export > Transaction File (IIF). Select the transactions and date range you want to migrate.
2. Upload the IIF file — Use this tool to upload your exported IIF file. The parser automatically detects the !TRNS/!SPL header structure and extracts all transaction rows.
3. Preview transactions — Review the extracted data in the preview table. Verify date ranges, transaction counts, and totals.
4. Download Wave CSV — Click “Download Wave CSV” to save the converted file. Import it into Wave via Banking > Connected Accounts > Upload a Statement.
5. Reconcile in Wave — After import, categorize transactions in Wave and match them against invoices, expenses, and bank deposits.

Related Free Accounting Tools

The IIF to Wave converter is part of PrimeConnect's complete suite of free financial file conversion and accounting utility tools:

• CSV to IIF Converter — Convert bank CSV files to QuickBooks Desktop IIF format.
• CSV to QBO Converter — Convert bank CSV files to QBO Web Connect format.
• QBO to IIF Converter — Convert QBO/OFX files to QuickBooks Desktop IIF format.
• IIF to QBO Converter — Upgrade legacy IIF files to QBO/OFX format.
• PDF to QBO Converter — Convert PDF bank statements to QBO, CSV, or IIF.
• OFX to QBO Converter — Convert OFX bank statements to QuickBooks QBO format.
• QFX to QBO Converter — Convert Quicken QFX files to QuickBooks QBO format.
• QBO to CSV Converter — Export QBO transaction files to CSV spreadsheets.
• OFX to CSV Converter — Convert OFX bank files to CSV for Excel and Google Sheets.
• OFX to IIF Converter — Convert OFX files to QuickBooks Desktop IIF format.
• CSV to OFX Converter — Transform bank CSV exports into standard OFX format.
• QIF to QBO Converter — Upgrade legacy Quicken QIF files to QBO format.
• QBO to PDF Converter — Generate professional PDF statements from QBO files.
• MT940 to QBO Converter — Convert SWIFT MT940 bank statements to QBO format.
• QIF to CSV Converter — Convert Quicken QIF files to CSV spreadsheets.
• QIF to IIF Converter — Convert QIF files to QuickBooks Desktop IIF format.
• IIF to CSV Converter — Export IIF files to CSV for spreadsheet editing.
• QBO to OFX Converter — Convert QBO files to standard OFX format.
• MT940 to CSV Converter — Convert SWIFT MT940 statements to CSV spreadsheets.
• XLSX to QBO Converter — Convert Excel spreadsheets to QBO Web Connect format.
• CAMT.053 to QBO Converter — Convert ISO 20022 XML bank statements to QBO format.
• Stripe to QuickBooks Converter — Convert Stripe payment exports to QuickBooks format.
• PayPal to QuickBooks Converter — Convert PayPal activity exports to QuickBooks format.
• Square to QuickBooks Converter — Convert Square POS exports to QuickBooks format.
• Amazon to QuickBooks Converter — Convert Amazon Seller reports to QuickBooks format.
• Shopify to QuickBooks Converter — Convert Shopify payout exports to QuickBooks format.
• Etsy to QuickBooks Converter — Convert Etsy seller statements to QuickBooks format.
• IIF Viewer & Validator — Preview and validate IIF files before QuickBooks import.
• Chart of Accounts Generator — Generate industry-specific chart of accounts.
• Bank CSV Cleaner — Clean messy bank CSV exports for QuickBooks import.
• Import Troubleshooter — Diagnose and fix QuickBooks import errors.
• QBO File Viewer & Validator — Preview and inspect QBO files before importing.
• OFX File Viewer & Validator — Preview and inspect OFX bank statement files.
• Duplicate Transaction Detector — Find and remove duplicate transactions in your files.
• Financial File Format Detector — Identify unknown financial file formats automatically.
• QBO to Xero Converter — Convert QBO files to Xero-compatible CSV.
• OFX to Xero Converter — Convert OFX bank files to Xero-compatible CSV.
• IIF to Xero Converter — Convert IIF files to Xero-compatible CSV.
• CSV to Xero Converter — Reformat bank CSV for Xero import.
• QBO to Wave Converter — Convert QBO files to Wave CSV format.
• OFX to Wave Converter — Convert OFX bank files to Wave CSV format.
• CSV to Wave Converter — Reformat bank CSV for Wave import.
• QBO to FreshBooks Converter — Convert QBO files to FreshBooks-compatible CSV.
• OFX to FreshBooks Converter — Convert OFX bank files to FreshBooks CSV.
• IIF to FreshBooks Converter — Convert IIF files to FreshBooks CSV.
• CSV to FreshBooks Converter — Reformat bank CSV for FreshBooks import.
• QBO to Sage Converter — Convert QBO files to Sage-compatible CSV.
• OFX to Sage Converter — Convert OFX bank files to Sage CSV.
• IIF to Sage Converter — Convert IIF files to Sage CSV.
• CSV to Sage Converter — Reformat bank CSV for Sage import.