All articles

QIF to IIF for QuickBooks Desktop, and Why QBO Is the Safer Import

• 6 min read • QIFQBO Team
.qif → .qbo
No file handy?

No account needed for your first 3 conversions. We never store your bank login.

To convert QIF to IIF for QuickBooks Desktop you need a tool or a hand built tab delimited file, and then you import it through File, Utilities, Import, IIF Files. It works, but IIF posts transactions straight into your books with no review step, and one wrong account name or a missing header makes the file fail or pollute the ledger. Converting the QIF to a .qbo Web Connect file instead lands transactions in the bank feed for approval, which is why most bookkeepers choose QBO.

IIF is Intuit Interchange Format, a tab separated text file that QuickBooks Desktop reads for lists and transactions. It predates bank feeds. People search for a QIF to IIF conversion because it was the old advice when moving Quicken data into QuickBooks, and plenty of forum threads still repeat it. This article compares the two routes on the things that decide whether an import goes cleanly: review, duplicates, accounts and recovery. It assumes QuickBooks Desktop. QuickBooks Online does not import IIF at all.

What does an IIF import actually do?

An IIF import writes transactions directly into the company file. Each transaction is a block of lines starting with TRNS and SPL rows, and every line must name an account that already exists exactly as QuickBooks spells it. Intuit describes the format and its limits in its QuickBooks support articles on IIF files. There is no preview and no matching against existing entries, so an import you regret has to be undone by hand or from a backup.

Can QuickBooks import a QIF file directly?

No. Current QuickBooks Desktop and QuickBooks Online reject QIF files. The Quicken conversion path Intuit once offered is gone for current versions. A QIF has to become either an IIF or a QBO before QuickBooks will read it, and the two outcomes behave very differently, which is the whole point of the table below.

IIF importQBO (Web Connect) import
How to start in DesktopFile, Utilities, Import, IIF FilesFile, Utilities, Import, Web Connect Files
Review before postingNone, writes straight to the registerYes, items wait in the bank feed to accept
Duplicate protectionNone, running it twice doubles the entriesYes, repeated transactions are flagged
Account namesMust match the chart of accounts exactlyYou choose the account at upload, categorize later
Works in QuickBooks OnlineNoYes
Recovery from a bad fileRestore the company file backupDelete or exclude the downloaded items
Best forImporting lists, opening balances, custom journal entriesYears of bank and card transactions

When is IIF still the right choice?

IIF is right when the thing you are importing is not a bank transaction. Customer and vendor lists, a chart of accounts and opening journal entries all go in through IIF, because a bank file cannot carry them. If you are moving a whole Quicken Home and Business file, you may use IIF for the structure and QBO for the transaction history. Our Quicken Home and Business to QuickBooks page lays out that split.

For ordinary transaction history, IIF has no advantage. It is also the riskier choice with transfers, because a transfer between two Quicken accounts becomes two IIF lines that must offset exactly, and a mismatch leaves the books out of balance by the difference.

How do you convert QIF to QBO instead?

Export the account from Quicken Classic as QIF, drop the file into the converter at the top of the site, and download the .qbo. Then in QuickBooks Desktop choose File, Utilities, Import, Web Connect Files, select the .qbo, pick the account it belongs to and accept the transactions in the bank feed. The converter balances transfers and splits when it writes the file, which is the step that causes most failed imports. The QIF to QuickBooks Desktop page has the same steps with screenshots of each dialog.

A worked example with illustrative numbers. Say a consultant exports one checking account from Quicken with 3,412 transactions across five years and a four way split on a quarterly tax payment. As QBO, the whole file uploads once, QuickBooks flags nothing as a duplicate on the first pass, and the split totals match the register to the cent. As a hand built IIF, the same file would need every category spelled to match the chart of accounts and the split written as four SPL rows that net to the transaction amount, and the user would have no way to see a problem before posting.

What goes wrong with IIF imports

  • Header errors. The file needs TRNS, SPL and ENDTRNS header rows (each marked as a header) with the right columns. A missing header gives an unspecific import error.
  • Unknown accounts. A category in the QIF that is not in QuickBooks either fails the import or creates an unwanted account, depending on the entry.
  • Date format. A day month swap changes the period a transaction lands in. See our note on QIF date formats in QuickBooks.
  • Double posting. Importing the same file twice doubles income and expense, and nothing warns you.

Whichever route you take, make a company file backup first. In Desktop that is File, Back Up Company, Create Local Backup. It is the only dependable undo for an IIF import.

Is QIF to IIF conversion free?

Some utilities do the conversion for a one off fee or subscription, and a spreadsheet and patience can do it for nothing, but the cost that matters is the cleanup time when a file posts wrong. Our converter writes QBO, not IIF, because the review step in the bank feed removes the biggest risk. If a QBO import does fail, the guide to the Web Connect import error covers the usual causes.

One more thought for teams. If you onboard bookkeepers or students on these import steps, a short quiz on QuickBooks account matching, built in a tool such as Assessing, catches the IIF mistakes before they reach a client file.

Which should you use?

Use QBO for transactions and IIF only for lists or opening entries. If you are on QuickBooks Online, QBO is your only option and the QIF to QuickBooks Online page applies. If you are choosing between them for a client file, convert one account to QBO first, import it into a test company and check the register totals before you do the rest.

Convert your QIF to QBO now

Upload your Quicken QIF file and download a QuickBooks ready QBO file in seconds.

Start converting