QuickBooks Online doesn't accept IIF files directly
IIF (Interchange File Format) files are not compatible with QuickBooks Online. If you have an IIF file from QuickBooks Desktop, you cannot import it straight into the online version. QuickBooks Online uses a different data structure, so you'll need to convert your data first or use QuickBooks Desktop's migration tools if you're switching from Desktop to Online.
The most reliable path depends on whether you're moving from QuickBooks Desktop to Online, or whether you simply have an IIF file you need to work with. Each situation has a different solution, and choosing the wrong one wastes time.
Key Takeaways
- IIF files from QuickBooks Desktop cannot be imported directly into QuickBooks Online because the two products use incompatible file formats.
- If you're migrating from Desktop to Online, use the official QuickBooks migration tool or contact QuickBooks support for a data transfer.
- If you have an IIF file you need to use in Desktop, open it in QuickBooks Desktop using File > Utilities > Import > IIF Files.
- Converting an IIF file to a format QuickBooks Online accepts requires either exporting from Desktop as a different file type or using third-party conversion software.
If you're moving from QuickBooks Desktop to Online
QuickBooks offers an official migration path for Desktop users switching to Online. This is the safest method because it preserves your data structure and avoids compatibility problems. Go to the QuickBooks Desktop Help menu, select "Migrate to QuickBooks Online," and follow the prompts. The tool will guide you through backing up your company file and uploading it to Intuit's servers for conversion.
The migration process typically takes a few hours to a few days depending on the size of your company file. You'll receive an email when your data is ready in QuickBooks Online. This method handles all the format conversion automatically, so you don't need to touch IIF files at all.
If the migration tool doesn't work or you run into errors, contact QuickBooks support directly. They can sometimes perform the migration manually, though this may take longer.
If you need to open an IIF file in QuickBooks Desktop
If you have an IIF file and you're working in QuickBooks Desktop (not Online), you can import it directly. Open QuickBooks Desktop and go to File > Utilities > Import > IIF Files. Navigate to your IIF file, select it, and click Open. QuickBooks will process the file and add the data to your company file.
Before importing, make sure you're in the correct company file. Importing adds data to whatever file is currently open, and you cannot undo an import. If you're unsure, create a backup of your company file first by going to File > Create Copy.
The import process usually completes within seconds for small files. Larger IIF files may take a minute or two. Once complete, review the imported data to confirm everything came through correctly, especially customer names, invoice numbers, and account balances.
Converting an IIF file to work with QuickBooks Online
If you cannot use the official migration tool and need to get data from an IIF file into QuickBooks Online, you'll need to convert the file first. The most straightforward approach is to import the IIF file into QuickBooks Desktop, then export the data in a format QuickBooks Online recognizes, such as a CSV file or Excel spreadsheet.
To do this, import the IIF file into Desktop using the steps above. Then go to File > Utilities > Export > to IIF or another format. Save the file as a CSV or Excel file if that option appears. You can then attempt to import this converted file into QuickBooks Online through the Import Data feature in Online's settings.
QuickBooks Online's import tool is limited and only accepts specific file types for specific data categories (customers, vendors, items, and chart of accounts). Not all data from your IIF file will import this way. Transactions, invoices, and detailed history usually require the full migration tool or manual entry.
What data actually transfers when you import
Understanding what does and doesn't transfer prevents frustration later. If you're using the official Desktop-to-Online migration, nearly everything transfers: your chart of accounts, customers, vendors, items, and transaction history. The migration tool is designed to move a complete company file.
If you're converting an IIF file to CSV or Excel and importing into Online manually, only basic lists transfer: customer names and contact info, vendor names, item descriptions, and account names. Transactions, invoices, bills, and payment history do not import this way and must be re-entered or handled through the full migration process.
This is why the official migration tool is strongly preferred. It handles the complexity automatically and preserves data integrity. Manual conversion and import should only be your approach if the migration tool is truly unavailable to you.
Common problems and what to do
The most common error is trying to import an IIF file directly into QuickBooks Online, which simply won't work. If you see an error message saying the file format is not supported, you've hit this wall. The solution is to use the Desktop-to-Online migration tool or convert the file through Desktop first.
Another frequent issue is importing an IIF file into the wrong company file in Desktop. Once imported, the data is mixed with your existing records and cannot be easily separated. Always verify you're in the correct company file before importing, and always back up first.
If the migration tool fails or gets stuck, check your internet connection and try again. If it continues to fail, take a screenshot of the error message and contact QuickBooks support. They have tools to diagnose what's blocking the migration and can often resolve it remotely.
Frequently Asked Questions
Can I import an IIF file directly into QuickBooks Online?
No. QuickBooks Online does not accept IIF files. You must either use the official Desktop-to-Online migration tool if you're switching products, or convert the IIF file through QuickBooks Desktop first. There is no direct import path from IIF to Online.
What if I don't have QuickBooks Desktop anymore?
Contact QuickBooks support and explain your situation. They may be able to help you migrate the data or convert the IIF file. If you have an older version of Desktop available, you could install it temporarily to import the IIF file and then migrate to Online. Some third-party accountants also offer IIF conversion services, though these typically cost money.
Will my transaction history transfer when I migrate?
Yes, if you use the official QuickBooks Desktop-to-Online migration tool. Your complete transaction history, invoices, bills, and payments all transfer. If you're converting an IIF file manually through CSV or Excel import, only customer and vendor lists transfer—transactions do not.
How long does the migration from Desktop to Online take?
The upload process usually takes a few hours, but the full conversion on QuickBooks' servers can take up to a few days. You'll receive an email notification when your data is ready in Online. During this time, you can continue working in Desktop, but you should not make major changes to your company file.
Can I undo an IIF import if I imported it to the wrong file?
No. Imports cannot be undone. This is why backing up your company file before importing is essential. If you imported to the wrong file, restore from your backup and import to the correct file instead.