Import IIF File into QuickBooks Online: IIF Importer Options and the QBO Alternative

Almost everyone who searches for this has already tried it, found no menu item anywhere in QuickBooks Online, and assumed they were looking in the wrong place. They were not.

Quick answer

QuickBooks Online cannot import IIF files. IIF is a QuickBooks Desktop format, and Intuit never carried it over to the cloud product, so there is no screen, menu or setting that will accept one. You have three real options: convert the IIF to a spreadsheet and import that, install a third party app from the QuickBooks App Store that reads IIF on your behalf, or skip the IIF entirely and rebuild the bank history from the original statements as a .qbo file, which QuickBooks Online does accept natively.

Native .qbo output No column mapping Scanned PDFs included

Last updated August 2026

Make a file QuickBooks Online will take

Upload a PDF bank or credit card statement and download a .qbo file that uploads without mapping.

No credit card required to try your first statement.

Desktop only

Where IIF actually works

.qbo

The format QBO takes natively

1,000

Lines per bank upload in QBO

3 routes

And one of them is usually wrong

Why QuickBooks Online will not take an IIF file

IIF stands for Intuit Interchange Format. It is a tab delimited text format built for QuickBooks Desktop, and it writes directly into the Desktop company file at a fairly low level: account lists, customers, vendors, and transactions expressed as TRNS and SPL rows that have to balance to zero. In Desktop you import one through File, then Utilities, then Import, then IIF Files.

QuickBooks Online is a different product on a different database, reached only through a published API. There is no equivalent low level write path, and Intuit did not build an IIF reader for it. That is why the answer has stayed the same for years in Intuit's own community threads: the format is not supported, and renaming or reformatting the file does not change that. Anything that does get IIF data into QuickBooks Online is either converting it to something else first, or is an app posting the records through the API on your behalf.

That distinction matters more than it sounds, because it decides which of the routes below will actually work for what you are holding. An IIF full of invoices and bills is a different problem from an IIF full of bank transactions, and the second one has a much cleaner answer.

What QuickBooks Online actually accepts

Two separate import paths exist and they take different formats. Bank and credit card history goes in through the banking upload. Lists and some transaction types go in through the spreadsheet importers under Settings.

Format	Accepted by QBO	Which path	Column mapping	Duplicate detection
IIF	No	None. Desktop only	Not applicable	Not applicable
QBO (Web Connect)	Yes	Bank upload	None needed	Yes, per transaction ID
QFX / OFX	Yes	Bank upload	None needed	Yes, per transaction ID
CSV	Yes	Bank upload	Yes, every time	Weaker, matched on values
XLS / XLSX, Google Sheets	Yes	List and invoice importers	Yes	No
PDF statement	No	Convert it first	Depends on output	Depends on output

The banking upload is capped at 1,000 transaction lines per file, so long periods have to be split whichever format you choose.

Three routes that work, and who each one suits

Route	What you actually do	Handles splits and lists	Best for
Convert IIF to a spreadsheet	Open the .iif in Excel or Sheets, restructure the rows into the columns QuickBooks Online expects, save as CSV or XLSX, then import.	Only after manual rework	Small files, simple lists, one off jobs
Third party importer app	Connect an app from the QuickBooks App Store that reads IIF and posts through the API. SaasAnt Transactions and Aaatex IIFImporter are the two most often named in Intuit's own community threads.	Yes, this is their whole purpose	Invoices, bills, journal entries, recurring migrations
Rebuild from the statements as .qbo	Ignore the IIF, take the PDF statements for the same periods, convert them to .qbo files and upload those under Transactions.	Bank and card transactions only	Bank history, cleanups, catch up bookkeeping

Pick by what is inside the file, not by which route sounds easiest. If the IIF holds your customer list or a year of invoices, an importer app is the only sensible answer. If it holds bank and credit card transactions, which is the most common case by a wide margin, the third route is faster and produces a cleaner result than either of the others.

The catch nobody mentions about converting IIF to CSV

Plenty of pages will tell you an IIF file opens in Excel, which is true, and then stop there as if the job is done. It is not. An IIF does not hold a tidy grid of dates, descriptions and amounts. It holds a header block, then TRNS rows for each transaction, then one or more SPL rows underneath each one for the split lines, and the whole set has to net to zero. Open that in a spreadsheet and you get a stack of rows in several different shapes stacked on top of each other.

QuickBooks Online's banking upload wants something much simpler: a date column, a description column, and either one amount column or separate debit and credit columns. Getting from one to the other means deleting the header rows, deciding what to do with every split line, flattening the rest, and reformatting the dates. On a few dozen transactions that is an annoying afternoon. On two years of history it is where people quietly give up, or worse, push a half correct file through and spend longer unpicking it than the import saved.

There is also what you lose. A CSV import has no transaction identifiers, so QuickBooks cannot tell a genuine second coffee shop charge from a duplicate of the first, and you have to map the columns again for every single file. A .qbo carries the account details and a unique ID on every transaction, so the upload routes itself and QuickBooks suppresses anything it has already seen. For bank history that difference is worth more than the time saved on the conversion.

Rebuilding the history as a file QuickBooks Online accepts

One account, one period

Gather the PDF statements covering the same range as the IIF. Keep them one account per file, because a .qbo describes exactly one account and a combined PDF cannot be routed cleanly.

Upload and read it back

Upload the statement and check every extracted date, description and amount on screen before a file is written. Misread lines get corrected here, not after they have posted into the books.

Tie out the closing balance

Compare the converted total against the closing balance printed on the statement. A skipped continuation page shows up here as a mismatch, which is far cheaper than finding it during a reconciliation.

Upload the .qbo in QBO

Go to Transactions, then Bank transactions, open the Link account dropdown, choose Upload from file, pick the .qbo and select the matching account. Import the oldest period first and work forward.

IIF and QBO side by side

	IIF	QBO (Web Connect)
Works in QuickBooks Online	No	Yes
Works in QuickBooks Desktop	Yes	Yes
Underlying format	Tab delimited Intuit text format	Intuit's branded variant of OFX
Can carry lists and invoices	Yes	No, bank transactions only
Per transaction unique ID	No	Yes
Posts to a review queue first	No, it writes straight in	Yes
Easy to undo a bad import	No, restore from backup	Yes, exclude from the queue

The review queue difference is the one people underrate. An IIF import in Desktop lands in the register immediately, which is why Intuit's own guidance is to back up the company file first.

Who ends up here

Firms moving a client off Desktop

The old workflow exported an IIF every month and it stopped working the day the client moved to QuickBooks Online. The bank side of that history converts cleanly from statements; the lists need an importer app.

Bookkeepers inheriting a mess

You have been handed a folder of IIF exports and a QuickBooks Online file with gaps in it. Rebuilding from the statements gives you something you can reconcile against, which an IIF never did.

Anyone told to just use Excel

The advice is technically correct and practically painful once splits are involved. If the file is bank data, going back to the source statement skips the reformatting entirely.

Questions people ask about importing IIF files into QuickBooks Online

Can you import an IIF file into QuickBooks Online?

No. IIF is a QuickBooks Desktop format and QuickBooks Online has no import path for it, so there is no menu item to find. To get the data in you either convert it to a spreadsheet, use a third party app from the QuickBooks App Store that reads IIF and posts through the API, or rebuild bank history from the statements as a .qbo file.

Why does QuickBooks Online not support IIF files?

IIF writes at a low level into a Desktop company file sitting on your own machine. QuickBooks Online is a different product on a hosted database that can only be written to through its published API, so the mechanism IIF relies on does not exist there. Intuit built the cloud importers around spreadsheets and bank file formats instead.

How do I convert an IIF file to CSV?

Open the .iif in Excel or Google Sheets, which reads it as tab delimited text. Then delete the header rows, flatten the TRNS and SPL rows into one row per transaction, reformat the dates, and save as CSV. The opening is trivial; the restructuring is the part that takes the time, and it grows quickly with the number of split transactions.

What file formats can QuickBooks Online import?

For bank and credit card history, QuickBooks Online accepts CSV, QBO, QFX and OFX through the banking upload, capped at 1,000 transaction lines per file. For lists and certain transaction types it accepts CSV, XLS, XLSX and Google Sheets through the importers under Settings. IIF appears in neither path.

Is there an IIF importer for QuickBooks Online?

Yes, as third party apps rather than an Intuit feature. SaasAnt Transactions and Aaatex IIFImporter are the two named most often in Intuit's community threads. They read the IIF and create the records through the QuickBooks Online API, so what you get is app created transactions rather than a true IIF import.

Can I import IIF files into QuickBooks Desktop?

Yes, that is the format's home. Go to File, then Utilities, then Import, then IIF Files, and choose the file. Back up the company file first, because an IIF import writes straight into the register with no review queue and no simple undo if the file turns out to be wrong.

Should I use IIF or QBO to import bank transactions?

Use QBO for bank and credit card transactions in either product. It carries a unique ID per transaction so QuickBooks can suppress duplicates, it identifies the account so nothing needs mapping, and it lands in a review queue you can exclude from. IIF only makes sense in Desktop for records QBO cannot express, such as lists and invoices.

Can I rename an IIF file to CSV or QBO?

No. The extension is not the format. Renaming an IIF to .csv gives you a comma separated file with tab separated contents in the wrong shape, and renaming it to .qbo produces a file with none of the OFX structure QuickBooks validates before reading. Both fail, and the .qbo attempt returns an invalid file error.

How do I move Desktop transactions to QuickBooks Online?

For a whole company file, Intuit's own migration tool moves the file across and no IIF is involved. IIF only comes up when someone is moving a subset by hand. For bank and card history specifically, converting the statements to .qbo is usually faster than trying to reshape an export.

Can QuickBooks Online read a PDF bank statement?

No. You can attach a PDF to a transaction as a document, but QuickBooks Online will not read transactions out of it. The statement has to be converted into one of the accepted formats first, and .qbo is the one that imports without column mapping and with duplicate detection intact.

Skip the reformatting and start from the statement

Upload one PDF, check the transactions against the closing balance, and download a .qbo that QuickBooks Online accepts without any column mapping.

Convert a statement now