Glossary
What Is a QIF File?
A QIF file is a plain-text export of financial transactions, written in the Quicken Interchange Format that Intuit created for Quicken in the desktop era. Each line of the file carries a single value, and the first character of the line says what that value means. QIF is the ancestor of the whole Quicken and QuickBooks file family, and it is also the only member of it that Intuit stopped developing, so a QIF file you meet today is almost always an old file rather than a fresh export.
TL;DRQIF is a plain-text Quicken export where a single letter labels each field and a caret closes each record. It is no longer developed, so a QIF archive is usually converted to QBO, CSV or PDF before it can be used.
0
fields in a QIF record for the currency of an amount, and no identifier that lets the receiving program match an imported transaction against what is already in the account
One Letter per Field
A QIF record is a short stack of lines, each one a letter followed by its value. D holds the date, T the amount, P the payee, M the memo, and L the category or the transfer account. A line containing nothing but a caret closes the record, and the next transaction starts underneath it. Above the records sits a header line such as !Type:Bank or !Type:CCard that declares the kind of account the block belongs to, which is how one file can carry several accounts one after another.
A transaction divided between several categories is written as extra lines attached to the same record, one group of lines per part. Those parts belong to the transaction above them and are not transactions in their own right; adding them up alongside the parent record is the usual way a QIF archive ends up showing twice the money it holds.
Why a QIF Date Can Mean Two Things
The format says which line holds the date. It does not say how the date is written. Leading zeros on the month and the day may be dropped, the year may be four digits or two, and a short apostrophe form of the year is legal as well. Nothing inside the file states whether the first number is the month or the day, so 03/04/2026 is the fourth of March to one writer and the third of April to another, and both are valid QIF. Whoever reads the file has to know the convention of the program that wrote it, or work it out from days above twelve elsewhere in the same file.
QIF is expected to be plain ANSI text. A file saved as UTF-8 is not processed correctly on import, and accented or non-Latin payee names are where that shows up first. Nothing in the name or the extension distinguishes the two, so an encoding change made by a text editor on save is invisible until the import goes wrong.
Why Intuit Moved On
QIF was built for one program on one desktop, and two structural gaps kept it there. An imported transaction carries no identifier that the receiving program can match against the account, so reconciling an import against existing records was never reliable. An amount carries no currency at all. The replacement was the OFX family of formats, and its variants QFX and QBO are what Intuit ships today. Quicken narrowed QIF import step by step: from Quicken 2006 checking, savings and credit card accounts stopped taking it, and QIF import is now offered only for asset, liability and cash accounts. QuickBooks does not read QIF at all.
Before converting an archive, look at the header lines. They tell you how many accounts the file actually holds, and a conversion that ignores them merges records that were meant to stay in separate accounts.
Where QIF Files Still Turn Up
Old Quicken installations, discontinued personal finance programs and long-kept bookkeeping archives are the usual sources: a period that has to be retained for years often survives only as a QIF export, because the online statements behind it have long since rolled off. Getting that data into something current means converting it, either into QBO for QuickBooks, into CSV for a spreadsheet, or into PDF for a document you can hand to someone.
Related Guides
Related Terms