Convert OFX Files to
QuickBooks Desktop IIF

Understanding the OFX Format

OFX (Open Financial Exchange) is a standardized data format used by banks, credit unions, and financial institutions to deliver electronic bank statements and transaction data. Originally developed in the late 1990s as a collaboration between Microsoft, Intuit, and CheckFree, OFX has become the dominant format for downloading transaction data from online banking portals. Most banks offer OFX downloads under names like “Download Transactions,” “Export to Quicken/QuickBooks,” or simply “OFX format.”

An OFX file is structured using SGML-like tags (similar to XML) that wrap individual transaction records. Each transaction sits inside a <STMTTRN> block and includes fields like<TRNTYPE> (debit or credit), <DTPOSTED> (date in YYYYMMDD format),<TRNAMT> (amount), <NAME> (payee name), and<MEMO> (transaction memo). The file also contains account identification data including the bank routing number (<BANKID>), account number (<ACCTID>), and account type (<ACCTTYPE>).

Understanding the IIF Format

IIF (Intuit Interchange Format) is a tab-delimited text format created by Intuit specifically for importing and exporting data in QuickBooks Desktop. Unlike QBO (Web Connect) files that are designed for bank feed imports, IIF files support a much broader range of data types including general journal entries, invoices, bills, customers, vendors, items, and chart of accounts. This makes IIF the most flexible import format available for QuickBooks Desktop.

The IIF file structure uses a header section and a data section. Headers begin with an exclamation mark (!) and define the column layout. For transaction imports, the key headers are!TRNS (main transaction line), !SPL (split/offset line), and!ENDTRNS (end marker). Each transaction consists of at least one TRNS line, one SPL line, and one ENDTRNS marker. The TRNS line represents the main account entry (e.g., your bank account), while the SPL line represents the offsetting entry (e.g., an expense or income account). This double-entry structure ensures that every transaction balances to zero, which is fundamental to proper accounting.

Why Convert OFX to IIF?

While QuickBooks Desktop can import OFX files directly through its Web Connect feature, there are several compelling reasons to convert OFX to IIF instead:

• Account mapping control — OFX Web Connect imports require you to manually assign transactions to accounts after import. IIF files include the account assignments directly, so transactions are pre-categorized when they arrive in QuickBooks.
• Double-entry journal entries — IIF creates proper double-entry journal entries with both a TRNS and SPL line for each transaction. This ensures every import maintains balanced books and creates a clean audit trail.
• Batch processing — IIF files can contain hundreds or thousands of transactions in a single import, and each transaction is pre-mapped to the correct accounts. This eliminates the transaction-by-transaction review that Web Connect imports require.
• Custom expense categorization — By specifying the expense account in the conversion, you can route all imported transactions to a specific account. This is particularly useful for dedicated-purpose accounts like payroll, credit cards, or petty cash.
• Older QuickBooks compatibility — Some older QuickBooks Desktop versions have limited or buggy OFX import support. IIF import has been a stable feature since the earliest versions of QuickBooks and works consistently across all Desktop editions.

QuickBooks Desktop IIF Import Workflow

After converting your OFX file to IIF, follow these steps to import into QuickBooks Desktop:

1. Back up your company file — Before any import, create a backup via File → Back Up Company → Create Local Backup. IIF imports cannot be easily undone, so a backup is essential.
2. Open QuickBooks Desktop and navigate to File → Utilities →Import → IIF Files.
3. Browse to the downloaded .iif file and click Open.
4. QuickBooks will display a confirmation dialog showing how many transactions were imported. ClickOK to proceed.
5. Open the bank account register (Banking → Use Register → select the account) to verify that transactions imported correctly with the right dates, amounts, and memo fields.
6. If any account names in the IIF file don't match your chart of accounts, QuickBooks will automatically create new accounts. Review your chart of accounts after import and merge any duplicates.

Account Mapping Best Practices

Proper account mapping is the key to a clean IIF import. Here are recommended practices:

• Match account names exactly — The bank account name in the converter must match your QuickBooks chart of accounts exactly, including capitalization and spacing. For example, if your QuickBooks account is named “Business Checking,” enter exactly that — not “business checking” or “Checking Account.”
• Use a catch-all expense account — Set the expense account to “Uncategorized Expense” or “Ask My Accountant” as a default. This ensures all transactions import successfully, and you can recategorize them later in QuickBooks using the Reclassify Transactions feature.
• Verify account types — The bank account should be a “Bank” type account in QuickBooks. The expense account should be an “Expense” type. Using incorrect account types can cause reconciliation issues.
• Credit card accounts — For credit card OFX files, use the credit card account name (e.g., “Visa Credit Card”) as the bank account. The expense account works the same way — charges get routed to the expense account, and payments get routed to Income.

Common IIF Import Issues and Solutions

While IIF import is generally reliable, these are the most common issues users encounter:

• “Can't find account” warnings — QuickBooks will auto-create any account names it doesn't recognize. After import, check your chart of accounts for newly created accounts and merge them with existing ones if needed (Edit → Merge).
• Duplicate transactions — If you import the same OFX file twice (converted to IIF), QuickBooks will create duplicate entries. Always verify whether transactions have already been imported before running another import for the same date range.
• Date range conflicts — If imported transactions overlap with existing bank reconciliations, you may see discrepancies in your reconciliation reports. Import only date ranges that haven't been reconciled yet.
• Special characters in memos — Tab characters, line breaks, and double quotes in transaction memos can corrupt the IIF file structure. Our converter automatically sanitizes these characters during conversion.
• Large file imports — QuickBooks Desktop can handle IIF files with thousands of transactions, but very large imports (10,000+ entries) may take several minutes. Consider splitting large date ranges into monthly files for faster processing.

Related Free Accounting Tools

The OFX to IIF Converter is part of our complete suite of free QuickBooks conversion 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 statement files to QBO Web Connect 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.
• 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.
• Stripe to QuickBooks Converter — Convert Stripe payment exports to QuickBooks CSV.
• PayPal to QuickBooks Converter — Convert PayPal activity exports to QuickBooks CSV.
• Square to QuickBooks Converter — Convert Square POS exports to QuickBooks CSV.
• Amazon to QuickBooks Converter — Convert Amazon Seller reports to QuickBooks CSV.
• Shopify to QuickBooks Converter — Convert Shopify payout exports to QuickBooks CSV.
• IIF Viewer — 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.
• QIF to CSV Converter — Convert legacy Quicken QIF files to clean CSV spreadsheets for analysis.
• QIF to IIF Converter — Convert Quicken QIF files directly to QuickBooks Desktop IIF format.
• IIF to CSV Converter — Export QuickBooks Desktop IIF files to CSV for spreadsheet analysis.
• QBO to OFX Converter — Convert QuickBooks QBO files to standard OFX format for other financial software.
• MT940 to CSV Converter — Convert SWIFT MT940 European bank statements to CSV spreadsheets.
• QBO File Viewer — Preview and inspect QBO Web Connect files before importing into QuickBooks.
• OFX File Viewer — Preview and inspect OFX bank statement files in a readable format.
• XLSX to QBO Converter — Convert Excel spreadsheets directly to QuickBooks Web Connect QBO format.
• Etsy to QuickBooks Converter — Convert Etsy shop payment exports into QuickBooks-compatible format.
• Duplicate Transaction Detector — Scan QuickBooks files to find and flag duplicate transactions before import.
• Import Troubleshooter — Diagnose and fix common QuickBooks file import errors automatically.
• File Format Detector — Identify unknown financial file formats and get conversion recommendations.
• CAMT.053 to QBO Converter — Convert ISO 20022 CAMT.053 bank statements to QuickBooks QBO format.