QIF to QBO: Getting QIF Data Into QuickBooks

Quick Answer: QuickBooks does not import QIF files. Desktop reads only .QBO (Web Connect) for bank transactions, and QuickBooks Online's upload takes CSV, TXT, QBO or OFX. To use QIF data you either convert it to .QBO with a converter, convert it to CSV for QuickBooks Online, or skip the QIF and build a new file from the original bank statement or a fresh bank download.

A QIF file is a Quicken-era text format, and QuickBooks has never treated it as a bank import format. When you try to open one, QuickBooks either refuses the file or offers nothing to open it with. The workable routes all involve turning the data into something QuickBooks accepts, and the right one depends on where the QIF came from and how much you trust it.

Why won't QuickBooks open a QIF file?

Because neither edition of QuickBooks has a QIF importer for bank transactions:

• QuickBooks Desktop. An Intuit team member put it plainly on the company's support community: the option to import Quicken financial data files such as QIF into QuickBooks Desktop is unavailable, and users are pointed to third-party apps instead. Intuit's Web Connect help adds that .qbo is the only file type Web Connect can read, which rules out Quicken's QFX and QIF files.
• QuickBooks Online. The bank upload screen lists .csv, .txt, .qbo and .ofx in Intuit's manual upload article. QIF is not among them.

QIF also has a history of being pushed aside within Intuit's own products. According to the Wikipedia summary of the format, Quicken itself dropped QIF import for major account types in its 2006 version in favor of QFX.

What is lost in a QIF file?

The reason QIF does not convert perfectly is what it never contained. A QIF bank file is a list of records like this:

!Type:Bank
D03/04/2026
T-84.17
POffice Depot
LOffice Supplies
^
D03/05/2026
T2500.00
PHarper LLC
^

Each record has a date (D), amount (T), payee (P), and optionally a category (L), check number (N), memo (M) and cleared flag (C). Compare that with what a .QBO file carries:

Three practical consequences follow. A converter has to supply the bank and account identity that QuickBooks uses to link the file to an account, usually by asking you or by using a placeholder. It has to invent transaction IDs, so importing two overlapping QIF conversions can produce duplicates that a bank's own QBO would have caught. And it has to guess the date order, so a file from a non-US Quicken user can turn 03/04 into the wrong month.

The categories in the QIF are lost in a QBO conversion, since QBO has no field for them. If those categories matter, a CSV conversion for QuickBooks Online can keep them as a memo or description for you to categorize from.

How does a QIF to QBO converter work?

A QIF-to-QBO converter reads each QIF record and writes it as an OFX-style transaction inside a QBO wrapper, adding the bank identifier, account number, transaction IDs and date range. Paid converters for desktop or online use are common, and the Intuit thread above mentions converters from a vendor that offers QIF to OFX, QFX and QBO as well as QIF to IIF.

Whatever converter you use, check:

• Date order. Confirm a few converted dates against the source before importing.
• Account type. A credit card QIF should become a credit card QBO, or charges will look like deposits.
• Bank identity. QuickBooks Desktop needs a bank identifier it recognizes in the file. If the converter lets you choose the bank, pick the real one.
• Sign convention. QIF writes payments as negative amounts; the QBO should keep that.
• Duplicates. Import a date range that does not overlap anything already in QuickBooks.

Before you import any .QBO file you did not get from your bank, open it in a QBO file checker to confirm it is well formed and has the account details and transactions you expect.

Free QIF to QBO options

Free routes exist, with more manual work:

1. Open the QIF in a text editor or a spreadsheet tool that understands QIF, and turn it into a three-column CSV (date, description, amount).
2. In QuickBooks Online, upload that CSV through the bank upload screen. No QBO is needed.
3. In QuickBooks Desktop, there is no free CSV route for bank transactions; you would need a .QBO file, or Batch Enter Transactions if you have the Accountant or Enterprise edition.

Should you go back to the original statement instead?

Often, yes. A QIF is usually a second-hand copy: exported from Quicken, from an old personal finance app, or from a bank's legacy download option. Each step away from the bank adds risk of missing transactions or edited amounts. If you still have access to the source, these give a better file:

• A fresh bank download. Many banks still offer QuickBooks (.QBO) downloads for recent months. A bank-issued QBO carries the real account details and transaction IDs.
• The bank's CSV. For QuickBooks Online, a bank CSV is cleaner than a converted QIF.
• The PDF statements. For older months the bank no longer offers as downloads, the monthly statements are the authoritative record. A statement converter reads them directly. QuickBankConvert, for instance, takes the statement PDF and writes a QBO file on the Plus plan and above (see PDF to QBO), and shows the opening and closing balance it read above the preview, so you can check the transactions against the statement before importing.

Use the QIF when it is all you have, such as a Quicken file from a closed account or a client's old personal records. Even then, check its totals against at least one statement before trusting it.

Where do QIF files come from today?

Knowing the source tells you how far to trust the file:

• Exported from Quicken. Quicken can still write QIF, but Quicken for Windows itself now accepts QIF imports only for certain account types (asset, liability and cash accounts, per Quicken's import overview). An export from a long-used Quicken file may include edited or deleted transactions that never matched the bank.
• Downloaded from a bank's legacy option. Some banks still list QIF next to QFX and QBO. If the same screen offers QBO, choose that instead.
• Produced by another app. Personal finance and budgeting apps sometimes export QIF. Their payee names may already be cleaned up, which helps, but their categories will not match your chart of accounts.

QIF to QBO, QFX to QBO and QIF to IIF compared

The QFX case is close to a rename with header edits and is covered in the QFX to QBO conversion guide. For the structure of QIF itself, including other account types, see the QIF format guide.

Related guides

• Moving a QFX file into QuickBooks
• Inside the QIF format
• Check a .qbo file before importing
• Desktop's Web Connect import, step by step