How to Import an IIF File Into QuickBooks Online

If you've searched for a way to import an IIF file into QuickBooks Online, here's the short answer: you can't — at least not directly. QuickBooks Online does not natively support IIF (Intuit Interchange Format) file imports. That's not a bug or a missing feature you overlooked. It's a deliberate architectural difference between two distinct Intuit products, and understanding why that gap exists will save you a lot of troubleshooting time.

What Is an IIF File, and Where Does It Come From?

An IIF file is a proprietary Intuit format originally designed for QuickBooks Desktop (the locally installed Windows version). It's a tab-delimited text file that QuickBooks Desktop uses to import and export lists and transactions — things like chart of accounts, customers, vendors, journal entries, and items.

IIF files were built for a file-based, locally managed accounting environment. QuickBooks Desktop reads and writes them as part of its data architecture. They're common when migrating data between Desktop company files, working with third-party Desktop add-ons, or receiving exported data from a business still running the Desktop version.

Why QuickBooks Online Doesn't Accept IIF Files

QuickBooks Online is a cloud-based platform with a completely different data structure. Instead of reading flat files like IIF, QBO communicates through:

• REST APIs for developer integrations
• CSV imports for lists and transactions
• Native bank feeds for transaction syncing
• Third-party migration tools for bulk data transfer

The IIF format was never built into QBO's import pipeline. Intuit designed QBO from the ground up as a separate product, not simply a web version of Desktop. That means the file formats, data models, and import methods don't overlap cleanly.

What You Can Do Instead 🔄

You have a few realistic paths depending on what data is inside the IIF file and what you're trying to accomplish in QBO.

Option 1: Convert the IIF to CSV First

Most of what an IIF file contains — accounts, transactions, customer lists — can be reformatted as a CSV file, which QBO does support for imports.

The process generally looks like this:

1. Open the IIF file in a spreadsheet application (Excel, Google Sheets) — it's tab-delimited, so it will open with proper column separation
2. Identify the data type (transactions, chart of accounts, vendor list, etc.)
3. Reformat the columns to match QBO's CSV import template for that data type
4. Import the cleaned CSV into QBO via the appropriate section (Banking, Chart of Accounts, Customers, etc.)

This approach works but requires manual cleanup. IIF files often contain multiple record types in one file (flagged by headers like !TRNS, !SPL, !ENDTRNS), so you may need to separate them before converting.

Option 2: Use a Third-Party Conversion Tool

Several third-party tools are built specifically to handle IIF-to-QBO conversions. These tools parse the IIF structure and output a format QBO can accept — typically CSV or direct API import.

When evaluating third-party tools, check whether they handle the specific record types in your IIF file — not all tools support every transaction type equally.

Option 3: Re-enter Data Manually

For small amounts of data — a handful of journal entries or a short vendor list — manual entry directly into QBO is often faster than wrestling with file conversion. QBO's interface for entering journal entries, creating accounts, and adding contacts is straightforward.

Option 4: Use Intuit's Desktop-to-Online Migration Path

If the IIF file is part of a larger QuickBooks Desktop-to-Online migration, Intuit offers a built-in migration tool that transfers your company file more completely than any IIF-based workaround. This path handles chart of accounts, open balances, customer and vendor records, and some transaction history — without needing to manually process IIF files at all.

What Data Types Are Commonly in IIF Files

Understanding what's actually in the file helps you pick the right import path in QBO:

• Chart of Accounts → Import via QBO's Chart of Accounts CSV import
• Journal Entries → Import via QBO's Journal Entry import (CSV format)
• Customer/Vendor Lists → Import via QBO's customer or vendor import (CSV)
• Items/Products → Import via QBO's Products and Services import
• Payroll transactions → Generally not importable; requires manual entry or payroll service setup

The Variable That Changes Everything

How straightforward this process is depends heavily on a few factors specific to your situation: the size and complexity of the IIF file, whether it contains one record type or many, how much data cleaning you're willing to do, and whether this is a one-time import or part of an ongoing workflow.

A single IIF file with 20 journal entries is a very different problem than a multi-year export of transactions, payroll records, and inventory items from a busy Desktop company file. 🗂️

The technical steps above apply broadly, but which path makes the most sense — manual conversion, a third-party tool, or Intuit's migration service — depends on what's actually inside your file and what you're trying to accomplish on the QBO side of things.