Convert IIF Files to Xero Format Instantly

Migrating from QuickBooks Desktop to Xero

QuickBooks Desktop has been a cornerstone of small business accounting for decades, but as businesses increasingly need cloud-based access, multi-user collaboration, and anywhere-anytime availability, many are making the switch to Xero. The challenge with QuickBooks Desktop migrations is that the primary export format — IIF (Intuit Interchange Format) — is a proprietary tab-delimited text format that Xero cannot read. Without a conversion tool, you're faced with the prospect of manually re-entering years of transaction history into Xero, which can take weeks for a business with active accounts. This free IIF to Xero converter solves that problem by parsing your IIF transaction files and transforming them into the exact CSV format Xero needs for bank statement imports, preserving transaction dates, amounts, descriptions, and reference data throughout the conversion.

Understanding the IIF File Format

IIF (Intuit Interchange Format) is a tab-delimited text format created by Intuit for importing and exporting data in QuickBooks Desktop. Unlike modern XML or JSON formats, IIF uses a structured but quirky format with specific keywords:

• Header rows start with ! and define column names for each data type (e.g., !TRNS defines transaction columns, !SPL defines split-line columns, !ACCNT defines account columns).
• TRNS rows contain the main transaction data: date, account, amount, payee name, memo, transaction type, and document number. Each TRNS row represents one side of a double-entry journal entry.
• SPL rows contain the offsetting split entries. In double-entry bookkeeping, every TRNS must be balanced by one or more SPL rows that total to zero.
• ENDTRNS marks the end of each transaction block. The pattern is always TRNS → SPL(s) → ENDTRNS.

To export IIF files from QuickBooks Desktop, go to File → Utilities → Export → Lists to IIF Files or use the “Export Transactions” option. The resulting .iif file can be uploaded directly to this converter.

What Data Transfers from IIF to Xero

Understanding what transfers and what needs to be set up manually in Xero is crucial for planning your migration:

• What transfers: Transaction dates, amounts with correct debit/credit signs, payee names, memo/description text, check numbers and document references, and transaction types (checks, deposits, transfers). The converter maps TRNS-level data directly to Xero's Date, Amount, Payee, Description, and Reference CSV columns.
• What doesn't transfer: Chart of accounts structure, account categories, class tracking, job costing data, vendor/customer records, invoice and bill data, inventory items, sales tax rates, memorized transactions, and reconciliation history. These are QuickBooks Desktop-specific features that need to be configured manually in Xero after the bank transaction import.

Important: IIF files may contain double-entry journal entries (TRNS + SPL pairs). The converter extracts the TRNS rows, which represent the bank-side of each transaction. The SPL (split) rows containing the offsetting account entries are not needed for Xero's bank statement import, since Xero handles categorization through its own reconciliation workflow.

Setting Up Xero After IIF Migration

After importing your converted IIF data into Xero, follow these steps to complete your migration and get the most out of Xero's features:

1. Set up your chart of accounts — Xero comes with a default chart of accounts, but you should customize it to match your QuickBooks Desktop account structure. Go to Accounting → Chart of Accounts to add, rename, or reorganize accounts.
2. Create bank rules — Xero's bank rules automatically categorize recurring transactions. For each common payee (rent, utilities, subscriptions), create a rule that assigns the correct account. This replaces QuickBooks' memorized transaction feature.
3. Reconcile imported transactions — The imported bank transactions will appear in your bank account's “Bank Statements” tab. Work through them one by one, matching or creating new transactions. Xero's AI-powered suggestions improve as you reconcile more transactions.
4. Set up tax rates — If you tracked sales tax in QuickBooks Desktop, configure equivalent tax rates in Xero under Settings → General Settings → Tax Rates.
5. Import contacts — Export your vendor and customer lists from QuickBooks Desktop (Vendor List, Customer List) and import them into Xero via the Contacts → Import feature.

IIF vs Other QuickBooks Export Formats

QuickBooks Desktop offers several export options. Here's how they compare for Xero migration purposes:

• IIF — Best for exporting transaction lists with double-entry detail. Supports bulk export of all transactions within a date range. This is the most common format for QuickBooks Desktop to Xero migrations.
• QBO (Web Connect) — Used by QuickBooks Desktop's bank feed feature. Contains bank-side transaction data only (no journal entries or account mappings). Simpler format but may not include all transaction types.
• Excel/CSV report export — QuickBooks Desktop can export reports as Excel files, but these have inconsistent column structures and formatting that makes them unreliable for automated conversion.

For most QuickBooks Desktop to Xero migrations, IIF is the recommended format because it captures the broadest range of transaction data. If your IIF export is very large (over 1,000 transactions), consider splitting by date range, as Xero recommends a maximum of 1,000 lines per CSV import.

Related Free Accounting Tools

The IIF to Xero converter is part of our complete suite of free financial file conversion tools. Whether you need to convert between formats, import marketplace data, or migrate to another accounting platform, we have a dedicated tool for every workflow:

• 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 statement files 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 European bank statements to QBO.
• QIF to CSV Converter — Convert Quicken QIF files to CSV spreadsheet format.
• QIF to IIF Converter — Convert Quicken QIF files to QuickBooks IIF format.
• IIF to CSV Converter — Export QuickBooks IIF files to CSV spreadsheets.
• QBO to OFX Converter — Convert QuickBooks QBO files to standard OFX format.
• MT940 to CSV Converter — Convert SWIFT MT940 bank statements to CSV format.
• XLSX to QBO Converter — Convert Excel XLSX files to QuickBooks QBO format.
• CAMT.053 to QBO Converter — Convert ISO 20022 CAMT.053 bank statements to QBO.
• 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 Shop Manager CSV exports to QuickBooks format.
• IIF Viewer — Preview and validate IIF files before QuickBooks import.
• Chart of Accounts Generator — Generate industry-specific chart of accounts for QuickBooks.
• Bank CSV Cleaner — Clean messy bank CSV exports for QuickBooks import.
• Import Troubleshooter — Diagnose and fix QuickBooks import errors.
• QBO Viewer — Preview and inspect QBO Web Connect files before import.
• OFX Viewer — Preview and inspect OFX bank statement files.
• Duplicate Detector — Find and remove duplicate transactions before import.
• File Format Detector — Identify unknown financial file formats automatically.
• QBO to Xero Converter — Convert QuickBooks QBO files to Xero CSV format.
• OFX to Xero Converter — Convert OFX bank statement files to Xero CSV format.
• CSV to Xero Converter — Reformat any bank CSV for Xero's import requirements.
• QBO to Wave Converter — Convert QBO files to Wave-compatible CSV format.
• OFX to Wave Converter — Convert OFX bank files to Wave CSV format.
• IIF to Wave Converter — Convert IIF files to Wave-compatible CSV format.
• CSV to Wave Converter — Reformat bank CSV for Wave's import requirements.
• QBO to FreshBooks Converter — Convert QBO files to FreshBooks CSV format.
• OFX to FreshBooks Converter — Convert OFX bank files to FreshBooks CSV format.
• IIF to FreshBooks Converter — Convert IIF files to FreshBooks CSV format.
• CSV to FreshBooks Converter — Reformat bank CSV for FreshBooks import.
• QBO to Sage Converter — Convert QBO files to Sage-compatible CSV format.
• OFX to Sage Converter — Convert OFX bank files to Sage CSV format.
• IIF to Sage Converter — Convert IIF files to Sage-compatible CSV format.
• CSV to Sage Converter — Reformat bank CSV for Sage's import requirements.