# Import QIF File into Quicken: Limits to Know

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: Quicken and other software
- Canonical: https://simplebankconvert.com/blog/import-qif-file-into-quicken

> How to import a QIF file into Quicken, which account types still accept QIF and why bank and card accounts may refuse it in newer versions.
To import a QIF file into Quicken, back up your data, then open File, File Import and choose the QIF option. Whether it goes in depends on the account type and your release. Asset, liability and cash accounts take QIF. Checking, savings and credit card accounts may refuse it, so those usually need a QFX file instead.

## Which Quicken accounts take a QIF file import?

Quicken accounts that take a QIF file import reliably are asset, liability and cash accounts, including house and vehicle accounts. [Quicken's guide to importing data into Quicken for Windows](https://www.quicken.com/support/how-do-i-import-data-quicken-windows) names those, and says Business and Personal editions also accept QIF into payables and invoice accounts.

The same guide says QIF import is not available for checking, savings or credit card accounts, nor for 401(k) and brokerage accounts. A second Quicken article, [on why a QIF file may not import into a bank account](https://info.quicken.com/win/why-can-t-i-import-data-from-a-qif-file-into-a-ban), says the opposite for newer releases: that any account type can now be imported using QIF, where older versions could not.

So the two official pages disagree, and the honest answer is that it depends on your release. Treat the stricter rule as the safe assumption. If your copy offers your checking account as a QIF target, it is one of the newer releases, and the import may work. If it does not, the stricter rule applies to you.

## Reading the QIF type line before you import

A QIF type line is the first line of the file, and it tells Quicken what kind of account the transactions belong to. Quicken's QIF article notes that each file begins with a header naming the account type. Open the file in a plain text editor and read that line before you pick a target account.

### Checklist of type lines

The type lines below are the common ones. Match the file to a Quicken account of the same kind.

- `!Type:Bank` means checking or savings lines. These are the ones most likely to be refused.
- `!Type:CCard` means credit card lines, which face the same limit.
- `!Type:Cash` means a cash account, which accepts QIF.
- `!Type:Oth A` means an other asset account, such as a house or vehicle.
- `!Type:Oth L` means an other liability account, such as a loan.
- `!Type:Invst` means investment lines, which go to an investment account.

If a file has no type line at all, it is probably damaged or was produced by a tool that left it out. Add the line by hand only if you know which kind of account the data came from.

## Why does a checking account refuse a QIF file in Quicken?

A checking account refuses a QIF file in Quicken because, in many releases, QIF import is switched off for bank and card accounts. Quicken expects bank downloads through Web Connect instead, which uses QFX files with a bank identifier and a unique ID on every transaction. QIF carries neither, so Quicken cannot match its lines against what is already there.

You have three ways forward when that happens:

1. **Update Quicken.** If your release is older, the newer behaviour described in Quicken's QIF article may let the import through.
2. **Use a different file.** Ask the bank for its Quicken download, which is a QFX file, and import that through Web Connect.
3. **Convert the QIF.** A converter can rebuild the transactions as a QFX file, at the cost of having to supply the bank details QIF lacks. Quicken says it does not support QFX files made by conversion software, so a converted file may fail and Quicken support will not help with it.

Whichever route you take, try it in a copy of your data first. A file that goes in cleanly on the copy can then be imported into the real account with a known result.

## Back up Quicken before a QIF import, because QIF has no IDs

Back up Quicken before every QIF import. A QIF file has no transaction IDs, so Quicken cannot tell that a line is already in your register. A file imported twice, or two files whose dates overlap, will leave you with doubled lines and a wrong balance, and undoing that by hand is slow.

The backup takes a minute and is the only clean undo. After the import, check two figures: the number of new lines, compared with the file, and the account balance, compared with the last statement the file covers. If either is off, restore the backup and fix the file rather than deleting lines one by one.

QIF also drops some detail on the way in. Look at categories after the import too. A category name in the file that does not match one in Quicken can arrive as a new, slightly different category, which splits your reports in two.

## When a QIF file belongs in software other than Quicken

A QIF file belongs elsewhere when you are leaving Quicken, not returning to it. Many people find an old QIF export while moving to a small business tool, and the question then is whether the new program reads QIF at all, and how much history is worth bringing.

Wave is a common destination for freelancers. Which files it takes, and how a statement gets in, are covered in [importing a bank statement into Wave](/blog/import-bank-statement-into-wave). And if you end up rebuilding the QIF data as a spreadsheet, [the Wave CSV import format](/blog/wave-csv-import-format) lists the columns it expects.

Before converting years of QIF files, decide how far back you really need to go. Opening balances plus the current year is often enough, and [how much bank history to move to new software](/blog/how-much-bank-history-to-move-to-new-software) helps you pick a cut-off. When your only record of a month is a PDF statement, [SimpleBankConvert](/) is being built to turn it into a file for QuickBooks or Xero, which skips QIF entirely for those two programs.
