QuickBooks Online doesn't accept IIF files directly anymore

If you're trying to move data from QuickBooks Desktop into QuickBooks Online, you cannot upload an IIF file (Interchange File Format) directly. QuickBooks Online stopped supporting IIF imports years ago. Instead, you'll need to convert the file to CSV format first, or use Intuit's official migration tool if you're switching from Desktop to Online.

The path you take depends on what data you're moving and whether you're migrating your entire company file or just importing transactions. A full migration uses different steps than importing a single list of customers or vendors.

Key Takeaways

  • QuickBooks Online does not accept IIF files; you must convert to CSV format or use the official migration tool.
  • If you own QuickBooks Desktop, Intuit's Migration Assistant is the fastest way to move your entire company file to Online.
  • For partial imports (customers, vendors, or items only), convert your IIF file to CSV using a third-party converter, then upload through QuickBooks Online's import feature.
  • CSV imports work best for lists; transaction history usually requires the full migration tool to preserve account balances and dates correctly.

Using Intuit's Migration Assistant for a complete switch

If you own QuickBooks Desktop and want to move your entire company file to Online, Intuit's Migration Assistant is the official tool. It converts your Desktop file automatically and handles all your accounts, transactions, customers, vendors, and items in one process. You read the Migration Assistant from Intuit's website, run it on the computer where your Desktop file lives, and it guides you through connecting to your Online account.

The Migration Assistant preserves your account structure, opening balances, and transaction history. It typically takes 30 minutes to a few hours depending on how much data you have. After migration completes, you review the results in QuickBooks Online to make sure everything moved correctly, then you can stop using Desktop.

This is the only method that reliably moves your entire chart of accounts and all historical transactions without data loss. If you're doing a partial import instead — just bringing in a customer list, for example — skip to the CSV conversion method below.

Converting an IIF file to CSV format

To import data from an IIF file into QuickBooks Online, you first convert it to CSV (comma-separated values). You cannot do this inside QuickBooks itself; you need a third-party converter. Search for "IIF to CSV converter" and you'll find several free and paid options. Common choices include CloudConvert, Zamzar, and specialized accounting converters.

read your IIF file from QuickBooks Desktop by going to File > Utilities > Export, then select the data type you want (customers, vendors, items, or transactions). Save it as an IIF file. Upload that IIF file to your chosen converter, select CSV as the output format, and read the converted file to your computer.

Open the CSV file in a spreadsheet program like Excel or Google Sheets to check that the data looks correct — column headers should match what QuickBooks expects, and rows should contain your actual data without strange characters or broken formatting. If something looks wrong, try a different converter.

Importing CSV data into QuickBooks Online

Once you have a CSV file, log into QuickBooks Online and go to Settings (the gear icon in the top left). Select Import Data, then choose the data type you're importing: Customers, Vendors, Items, or Transactions. Click Select File, choose your CSV, and QuickBooks will preview the data and ask you to map columns.

Column mapping means telling QuickBooks which column in your CSV matches which field in QuickBooks. For example, your CSV might have a column called "Company Name" that needs to map to QuickBooks' "Customer Name" field. The import tool usually suggests matches automatically, but review them carefully before proceeding.

Click Import and QuickBooks will process the file. You'll see a summary showing how many records imported successfully and whether any had errors. Check your data in QuickBooks afterward — spot-check a few customers or items to confirm everything came through correctly.

Why transactions need special handling

Importing transactions (invoices, bills, checks, deposits) from CSV is more complicated than importing lists because QuickBooks Online needs to match transactions to the correct accounts and maintain your account balances. A CSV import of transactions can create duplicate entries or post to the wrong accounts if the file isn't formatted exactly right.

For this reason, the Migration Assistant is strongly recommended if you have transaction history to move. If you must import transactions via CSV, create a test file with just a few transactions first, import it, and verify the results before importing your full transaction history. You may need to contact QuickBooks support or a bookkeeper to fix any balance discrepancies afterward.

Troubleshooting common import errors

If your CSV import fails or shows errors, the most common causes are incorrect column headers, special characters (like apostrophes or commas) in the data, or duplicate entries that QuickBooks detects. Check that your CSV file uses the exact column names QuickBooks expects — these vary by data type, so read a sample CSV from QuickBooks first to see the correct format.

If your data contains special characters, open the CSV in Excel, select all cells, and use Find & Replace to remove or escape problem characters. Save the file as CSV again and try importing. If QuickBooks reports duplicates, it means records with the same name already exist in your Online file — either delete the duplicates from your CSV or merge them manually in QuickBooks after import.

For persistent problems, QuickBooks Online's support chat can walk you through the import process, or you can hire a QuickBooks-certified bookkeeper to handle the migration for you.

When to use a professional migration service

If your company file is large, contains complex transactions, or you're uncomfortable with the technical steps, professional migration services exist. Some accountants and bookkeepers specialize in moving data from Desktop to Online and can handle the entire process, including fixing any data issues that arise. This costs money but saves time and reduces the risk of errors.

Intuit also offers migration support through their ProAdvisor network — certified accountants who can information with the switch. If you're already working with a bookkeeper or accountant, ask whether they offer migration help.

Frequently Asked Questions

Can I import an IIF file directly into QuickBooks Online without converting it?

No. QuickBooks Online does not support IIF file uploads. You must convert the IIF file to CSV format using a third-party converter, or use Intuit's Migration Assistant if you're moving your entire Desktop company file.

What's the difference between using Migration Assistant and importing a CSV file?

Migration Assistant moves your entire QuickBooks Desktop file to Online in one process, preserving all accounts, transactions, and balances. CSV import works only for specific data types (customers, vendors, items) and is better for partial imports. Migration Assistant is more reliable for complete company transfers.

Will importing transactions from CSV mess up my account balances?

It can, because CSV import doesn't always match transactions to accounts correctly. Use Migration Assistant instead if you have transaction history to move. If you must use CSV, test with a small batch first and verify balances afterward.

How long does it take to import data into QuickBooks Online?

CSV imports usually complete within minutes. Migration Assistant typically takes 30 minutes to a few hours depending on your file size. After import, allow extra time to review and fix any errors.

What if my converter creates a CSV file that QuickBooks won't accept?

Try a different converter — some handle IIF files better than others. You can also read a sample CSV from QuickBooks Online to see the exact format it expects, then manually edit your converted file to match that format in Excel before uploading.