Convert Excel Files to
QuickBooks IIF

Why Convert Excel Spreadsheets to IIF for QuickBooks Desktop

Excel spreadsheets are among the most common formats for financial data. Whether you receive bank transaction exports as XLSX files, maintain your own accounting ledger in Excel, or download payment reports from third-party services, there is a good chance your data lives in a spreadsheet. While QuickBooks Desktop can import several financial formats, Excel is not one of them. The IIF (Intuit Interchange Format) is QuickBooks Desktop's native import format, designed specifically for bulk data loading with full double-entry bookkeeping support. The XLSX to IIF Converter bridges that gap, transforming any Excel spreadsheet into a properly balanced IIF file with TRNS/SPL journal entries.

IIF vs. QBO: Choosing the Right Output Format

When converting Excel files for QuickBooks, you have two main output options:

• QBO (Web Connect) — Imports transactions as bank feeds into QuickBooks' bank register. Transactions appear in the “For Review” tab and must be manually categorized. Works with both QuickBooks Online and Desktop. Best for simple bank statement imports where you want to categorize later.
• IIF (Intuit Interchange Format) — Imports transactions as fully balanced journal entries with TRNS (main entry) and SPL (offsetting split) pairs. Each transaction is already categorized to the correct income or expense account. Works only with QuickBooks Desktop. Best for accountants and bookkeepers who need proper double-entry records.

Choose IIF if you're using QuickBooks Desktop and want transactions pre-categorized with proper journal entries. Choose QBO if you're using QuickBooks Online or prefer to categorize transactions manually through the bank feed workflow.

How the XLSX to IIF Converter Works

The converter uses a five-step process to transform your Excel spreadsheet into a QuickBooks Desktop-compatible IIF file:

1. Parse the Excel file — The converter reads your XLSX or XLS file using the SheetJS library, extracting all sheets, column headers, and data rows. If your workbook has multiple sheets, you can select which one contains the transactions you want to convert.
2. Map columns to transaction fields — The converter auto-detects which columns contain dates, descriptions, and amounts based on common header naming patterns. You can manually adjust these mappings. The tool supports separate Credit and Debit columns, optional Check Number fields, and Memo columns.
3. Configure IIF settings — Set your QuickBooks bank account name and customize offset account mappings. Income transactions are offset to a configurable income account; expense transactions to a configurable expense account. Default mappings follow standard QuickBooks chart of accounts conventions.
4. Preview transactions — Review the converted transactions in a table showing date, description, amount, category (income/expense), and type. Verify everything looks correct before generating the IIF file.
5. Generate and download IIF — The converter produces a properly formatted IIF file with tab-separated TRNS/SPL pairs, the required header rows (!TRNS, !SPL, !ENDTRNS), and balanced journal entries that QuickBooks Desktop can import directly.

Understanding the IIF (Intuit Interchange Format)

IIF is a tab-separated text format created by Intuit for bulk data import into QuickBooks Desktop. Each IIF file contains header rows that define the data structure (prefixed with !) and data rows that contain the actual transaction data. The key elements of an IIF transaction file are:

• !TRNS row — Defines the columns for the main transaction entry: TRNSID, TRNSTYPE, DATE, ACCNT (account name), AMOUNT, and NAME (description).
• !SPL row — Defines the columns for the split (offsetting) entry: SPLID, TRNSTYPE, DATE, ACCNT (offset account), AMOUNT (negated), and NAME.
• !ENDTRNS row — Marks the end of the header block.
• TRNS data rows — Each transaction starts with a TRNS line posting the amount to your bank account.
• SPL data rows — Immediately after each TRNS line, a SPL line posts the opposite amount to the offset account, creating a balanced entry.
• ENDTRNS rows — Each TRNS/SPL pair is terminated with an ENDTRNS marker.

The double-entry structure ensures that every import maintains the fundamental accounting equation: Assets = Liabilities + Equity. Every debit has a corresponding credit, and your trial balance remains in balance after import.

Column Mapping for Excel to IIF Conversion

Column mapping is the critical step that tells the converter which spreadsheet columns correspond to which transaction fields. The three required fields are:

• Date — The transaction date column. The converter handles multiple date formats including MM/DD/YYYY, YYYY-MM-DD, DD/MM/YYYY, and text-based formats. Dates are output in MM/DD/YYYY format as required by QuickBooks Desktop.
• Description — The transaction description, payee name, or memo column. This becomes the NAME field in the IIF output.
• Amount — A single column with positive values for credits (deposits) and negative values for debits (withdrawals). The converter also supports separate Credit and Debit columns — map both and the net amount is calculated.

Importing IIF Files into QuickBooks Desktop

After converting your Excel spreadsheet to IIF format, follow these steps to import into QuickBooks Desktop (Pro, Premier, or Enterprise):

1. Open QuickBooks Desktop and go to File → Utilities → Import → IIF Files.
2. Browse to and select your converted .iif file.
3. QuickBooks will validate the file format and display a confirmation dialog.
4. Click OK to import. Transactions will be created as journal entries in the specified accounts.
5. Open the bank register for your imported account to verify that all transactions appear correctly with proper dates, descriptions, and amounts.

Important: Before importing, ensure that the account names used in the IIF file (both the bank account and offset accounts) exist in your QuickBooks chart of accounts. If they don't exist, QuickBooks will create them automatically, which may not match your preferred account structure.

Preparing Your Excel Spreadsheet for Conversion

For the smoothest conversion experience, follow these best practices:

• Use the first row for headers — Column headers help the auto-detect feature map your columns correctly. Use clear names like “Date”, “Description”, and “Amount”.
• Keep dates consistent — Use the same date format throughout the spreadsheet. Mixing formats can cause parsing errors.
• Use plain numbers for amounts — While the converter handles currency symbols and commas, plain numbers (e.g., -150.00) are parsed most reliably.
• Remove summary rows — Total rows, subtotal rows, and blank separator rows can cause parse errors. Remove them before uploading.

Related Free Accounting Tools

The XLSX to IIF Converter is part of PrimeConnect's complete suite of free QuickBooks conversion and utility tools:

• XLSX to QBO Converter — Convert Excel spreadsheets to QBO Web Connect format for QuickBooks Online.
• 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 IIF Converter — Convert OFX files to QuickBooks Desktop IIF format.
• MT940 to IIF Converter — Convert SWIFT MT940 European bank statements to IIF.
• CAMT.053 to IIF Converter — Convert ISO 20022 CAMT.053 statements to IIF.
• MT940 to QBO Converter — Convert SWIFT MT940 statements to QBO format.
• CAMT.053 to QBO Converter — Convert ISO 20022 CAMT.053 statements to QBO.
• IIF Viewer — Preview and validate IIF files before QuickBooks import.
• QBO Viewer — Preview and inspect QBO files before importing.
• OFX Viewer — Preview and inspect OFX bank statement files.
• Bank CSV Cleaner — Clean messy bank CSV exports for better imports.
• Chart of Accounts Generator — Generate industry-specific chart of accounts.
• Duplicate Detector — Find and remove duplicate transactions in financial files.
• Import Troubleshooter — Diagnose and fix QuickBooks import errors.
• File Format Detector — Identify unknown financial file formats automatically.
• 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.
• Etsy to QuickBooks Converter — Convert Etsy shop exports to QuickBooks CSV.