Sample QIF File
Downloadable Quicken Interchange Format (.qif) samples — a bank statement and a credit-card statement carrying the same 20 categorized transactions, with a parsed CSV preview and field schema.
Personal Finance QIF Text format
sample-bank-statement.qif · sample-credit-card.qif
Data Preview
20 rows × 6 columns
| 1 | Date | Amount | Payee | Memo | Category | Check Number |
| 2 | 2025-01-02 | 3850.00 | Direct Deposit - Payroll | Income | ||
| 3 | 2025-01-03 | -87.32 | Whole Foods Market | Groceries | ||
| 4 | 2025-01-04 | -52.18 | Shell Gas Station | Transportation | ||
| 5 | 2025-01-05 | -15.99 | Netflix Subscription | Entertainment | ||
| 6 | 2025-01-06 | -500.00 | Transfer to Savings | Savings | ||
| 7 | 2025-01-07 | -6.45 | Starbucks | Dining | ||
| 8 | 2025-01-08 | -128.50 | Electric Company | Monthly electric bill | Utilities | |
| 9 | 2025-01-09 | -1750.00 | Oakwood Property Management | January rent | Housing | 1042 |
| 10 | 2025-01-10 | -43.97 | Amazon.com | Shopping | ||
| 11 | 2025-01-11 | -62.84 | Trader Joe's | Groceries | ||
| 12 | 2025-01-12 | -18.50 | Uber Ride | Transportation | ||
| 13 | 2025-01-13 | -85.00 | AT&T Wireless | Monthly phone bill | Utilities | |
| 14 | 2025-01-14 | -12.95 | Chipotle | Dining | ||
| 15 | 2025-01-15 | 750.00 | Freelance Payment | Invoice #204 | Income | |
| 16 | 2025-01-16 | 3850.00 | Direct Deposit - Payroll | Income | ||
| 17 | 2025-01-17 | -94.17 | Whole Foods Market | Groceries | ||
| 18 | 2025-01-18 | -29.99 | Planet Fitness | Health | ||
| 19 | 2025-01-19 | -156.33 | Home Depot | Home | ||
| 20 | 2025-01-20 | -220.00 | Insurance Premium | Insurance | ||
| 21 | 2025-01-30 | 35.00 | Venmo Refund | Refund from friend | Refund |
Raw File Contents
Download Bank Statement (.qif)
sample-bank-statement.qif
!Type:Bank D01/02/2025 T3850.00 PDirect Deposit - Payroll LIncome ^ D01/03/2025 T-87.32 PWhole Foods Market LGroceries ^ D01/04/2025 T-52.18 PShell Gas Station LTransportation ^ D01/05/2025 T-15.99 PNetflix Subscription LEntertainment ^ D01/06/2025 T-500.00 PTransfer to Savings LSavings ^ D01/07/2025 T-6.45 PStarbucks LDining ^ D01/08/2025 T-128.50 PElectric Company MMonthly electric bill LUtilities ^ D01/09/2025 T-1750.00 POakwood Property Management MJanuary rent LHousing N1042 ^ D01/10/2025 T-43.97 PAmazon.com LShopping ^ D01/11/2025 T-62.84 PTrader Joe's LGroceries ^ D01/12/2025 T-18.50 PUber Ride LTransportation ^ D01/13/2025 T-85.00 PAT&T Wireless MMonthly phone bill LUtilities ^ D01/14/2025 T-12.95 PChipotle LDining ^ D01/15/2025 T750.00 PFreelance Payment MInvoice #204 LIncome ^ D01/16/2025 T3850.00 PDirect Deposit - Payroll LIncome ^ D01/17/2025 T-94.17 PWhole Foods Market LGroceries ^ D01/18/2025 T-29.99 PPlanet Fitness LHealth ^ D01/19/2025 T-156.33 PHome Depot LHome ^ D01/20/2025 T-220.00 PInsurance Premium LInsurance ^ D01/30/2025 T35.00 PVenmo Refund MRefund from friend LRefund ^
Download Credit Card (.qif)
sample-credit-card.qif
!Type:CCard D01/02/2025 T3850.00 PDirect Deposit - Payroll LIncome ^ D01/03/2025 T-87.32 PWhole Foods Market LGroceries ^ D01/04/2025 T-52.18 PShell Gas Station LTransportation ^ D01/05/2025 T-15.99 PNetflix Subscription LEntertainment ^ D01/06/2025 T-500.00 PTransfer to Savings LSavings ^ D01/07/2025 T-6.45 PStarbucks LDining ^ D01/08/2025 T-128.50 PElectric Company MMonthly electric bill LUtilities ^ D01/09/2025 T-1750.00 POakwood Property Management MJanuary rent LHousing N1042 ^ D01/10/2025 T-43.97 PAmazon.com LShopping ^ D01/11/2025 T-62.84 PTrader Joe's LGroceries ^ D01/12/2025 T-18.50 PUber Ride LTransportation ^ D01/13/2025 T-85.00 PAT&T Wireless MMonthly phone bill LUtilities ^ D01/14/2025 T-12.95 PChipotle LDining ^ D01/15/2025 T750.00 PFreelance Payment MInvoice #204 LIncome ^ D01/16/2025 T3850.00 PDirect Deposit - Payroll LIncome ^ D01/17/2025 T-94.17 PWhole Foods Market LGroceries ^ D01/18/2025 T-29.99 PPlanet Fitness LHealth ^ D01/19/2025 T-156.33 PHome Depot LHome ^ D01/20/2025 T-220.00 PInsurance Premium LInsurance ^ D01/30/2025 T35.00 PVenmo Refund MRefund from friend LRefund ^
Schema
| Field | Type | Description |
|---|---|---|
| Date | date | Transaction date from the D field (MM/DD/YYYY in these samples — QIF date formats vary by locale) |
| Amount | number | Signed amount from the T field — positive for deposits, negative for payments |
| Payee | string | Payee or merchant name from the P field |
| Memo | string | Optional free-text note from the M field (blank on most rows) |
| Category | string | Spending category from the L field (Income, Groceries, Dining, etc.) — a QIF feature the OFX family lacks |
| Check Number | string | Check or reference number from the N field, present only on check transactions |
About the QIF Format
Quicken Interchange Format (QIF) is the oldest format in this cluster — a plain-text, line-oriented layout that predates OFX entirely. No markup, no header block: every line is a single-letter field code followed immediately by its value.
File structure
A QIF file starts with a type declaration — !Type:Bank for the bank variant, !Type:CCard for the credit-card variant — then a flat run of records. Each record is a group of field lines terminated by ^ on its own line:
D01/03/2025
T-87.32
PWhole Foods Market
LGroceries
^The field codes used in these samples:
D— date (MM/DD/YYYYhere; QIF never standardized date format)T— signed amount (deposits positive, payments negative)P— payeeM— memo (optional)L— category, QIF’s distinctive feature — OFX statements carry no category dataN— check or reference number (optional)^— end of record
Parsing notes
Parsing is nearly trivial — split on ^, then dispatch on each line’s first character — but two quirks bite real-world code. First, dates are locale-ambiguous: 01/03/2025 is January 3 in US files and March 1 in European ones, and some exporters write D1/ 3'25. Second, there is no FITID-style unique ID, so re-importing an overlapping QIF file duplicates transactions; de-duplication is the importer’s problem. QIF to CSV handles the parsing in the browser, and CSV to QIF writes this exact layout back out.
Both variants contain the same 20-transaction set as the OFX, QBO, and QFX samples — compare them to see what each format keeps and drops.
FAQ
4 questionsWill this sample file import into Quicken or QuickBooks?
Modern QuickBooks no longer imports QIF at all, and current Quicken versions restrict it to certain account types — their preferred path is Web Connect (QFX/QBO), which they validate against Intuit's registered-bank list and may reject with an OL-221/OL-222-class error even for structurally valid files. This sample is well-formed QIF that standard parsers and apps like GnuCash accept; for Intuit-bound workflows, convert it with QIF to QBO or QIF to QFX below.
How is QIF different from OFX?
QIF is a line-oriented text format from the pre-OFX era — one field per line, keyed by a leading letter code, no XML/SGML markup. Unlike OFX it has no FITID, so importers cannot reliably de-duplicate transactions, and its dates are locale-ambiguous. It does carry spending categories (the L field), which OFX statements lack.
Is anything uploaded when I download or convert this file?
No. The downloads are static files served straight from the site — nothing you do here is uploaded or processed on a server. The CSV Tools converters linked below also run entirely in your browser.
Which apps still read QIF files?
GnuCash, Moneydance, Banktivity, HomeBank, and most open-source finance tools import QIF happily, and nearly every legacy finance app can export it — which is why it survives as a lowest-common-denominator interchange format decades after Intuit deprecated it.