QIF File, What It Is and Which Apps Still Read It

QIF dates from the early era of desktop money management, when banks mailed paper statements and online banking was rare. Users needed a way to load transactions from bank disks, other programs and early download services, and QIF filled that role.

In the mid 2000s Quicken moved toward OFX based downloads, which arrive as QFX files and Web Connect sessions. Those formats carry bank and account identifiers, which allows matching against an existing account and better duplicate detection. QIF has none of that, so Quicken narrowed QIF import for bank and credit card accounts and kept it mainly for certain account types and for transferring data between Quicken files.

Banks followed the same path. Many removed the QIF option from their download menus and kept CSV, QFX or QBO instead. That is why bookkeepers who need a QIF file today often have to create one from a CSV or a PDF statement rather than download it.

Every QIF file starts with the Type header line, which tells the importing program what kind of account the records belong to. Bank accounts, cash accounts, credit cards, investment accounts, other assets and other liabilities each have their own type value. After the header come the transactions, and each one ends with a line containing only a caret character.

Here is what a short bank file looks like.

!Type:Bank
D10/03/2026
T-45.20
PCoffee Supply Co
MOffice supplies for October
N1042
LOffice Expenses
^
D10/05/2026
T2,500.00
PNorthside Dental
MInvoice 3318 payment
LSales
^

The two records above describe one payment and one deposit. Notice that there is no column header and no balance line. The format only lists transactions, and the importing program adds them to whatever account you choose.

• D is the date of the transaction.
• T is the amount, negative for money going out and positive for money coming in.
• P is the payee, the name of the person or business on the other side.
• M is the memo, a free text note such as an invoice number or description.
• N is the number field, used for check numbers or reference codes.
• L is the category, or a transfer account written inside square brackets.
• C marks the cleared status, for example an asterisk for cleared or an X for reconciled.
• The caret line closes the record so the next transaction can begin.

Split transactions use extra letters for each portion of the amount, and investment records use their own set of letters for security names, prices and quantities. For ordinary bank and card statements, the six letters D, T, P, M, N and L cover nearly everything.

QIF has no single strict date format. Files in the US usually use month first, such as 10/03/2026 or 10/03/26. Quicken also writes an apostrophe before a two digit year for dates after 1999, such as 10/3'26, and many apps accept that style. Files produced outside the US often use day first.

The risk is obvious once you see it. The date 03/10/2026 means March 10 in one convention and October 3 in the other. An importing program cannot tell the difference, so a whole statement can land in the wrong month without any error message.

Before importing, check a date where the day is above twelve. If 10/25/2026 imports correctly, the file is month first. If the app rejects it or shows a strange date, the app expects the other order and you should regenerate the file with matching settings.

Amounts carry a similar trap. A file written with a comma as the decimal separator will be misread by an app that expects a period, and thousands separators can confuse some importers. Keeping amounts to plain digits with a period decimal is the safest choice for US software.

Support changes between versions, so check the import menu of the release you use. As a general picture, these tools continue to import QIF.

• Quicken accepts QIF for selected account types and for moving data between Quicken files, while bank and card downloads go through QFX and Web Connect.
• Xero accepts QIF as one of its bank statement import formats, alongside OFX and CSV.
• GnuCash, the open source accounting program, imports QIF with an assistant that maps accounts and categories.
• Moneydance, KMyMoney and HomeBank import QIF for personal and household bookkeeping.
• Older installs of Microsoft Money and many niche budgeting apps still list QIF as an import option.

QuickBooks is the main exception for bookkeepers. QuickBooks Desktop expects QBO Web Connect files for bank transactions, and QuickBooks Online works best with QBO or CSV uploads. If the books are in QuickBooks, a QIF file is usually the wrong choice.

QIF is plain text with one letter per line. It is easy to read and edit, but it does not identify the bank or the account, and it gives the importing app nothing to detect duplicates with.

OFX, Open Financial Exchange, is a structured format with tags for the bank, the account, the statement period, the ending balance and a unique ID for every transaction. Those IDs let apps skip transactions they have already imported.

QBO is the QuickBooks flavor of OFX. It adds an Intuit bank identifier so QuickBooks Desktop and QuickBooks Online treat the file like a Web Connect download. QFX is the matching flavor for Quicken.

A simple rule works for most cases. Use QBO for QuickBooks, OFX for apps that support it, and QIF when the destination asks for QIF or when you need a file you can inspect and fix by hand.

When the bank no longer offers QIF, or the period you need exists only as a PDF, you can build the file from the statement.

• Step 1. Collect the statement PDFs, scans or photos for every period you need.
• Step 2. Convert each statement and review the extracted rows, paying attention to dates, signs and payees.
• Step 3. Confirm that the rows reconcile to the opening and closing balance printed on the statement.
• Step 4. Export as QIF, choosing the account type and the date order your destination app expects.
• Step 5. Import into a test account first, then check one date with a day above twelve and the final balance.

Our pdf to qif converter follows exactly these steps and writes valid QIF records with the Type header line, D, T, P, M, N and L fields. If the destination app supports OFX, the pdf to ofx converter produces a file with transaction IDs for duplicate detection.