Export format
Bank statement to QIF converter
Quicken Interchange Format, the plain-text format read by Quicken, QuickBooks Desktop (via import), Moneydance, YNAB and many older tools. Any bank, digital or scanned PDF, with the running balance reconciled before you import anything.
What's in the QIF file
- !Type:Bank list with D (date, MM/DD/YYYY), T (signed amount) and P (payee/description) per transaction.
- Read by Quicken (older versions and via conversion), Moneydance, YNAB, GnuCash, KMyMoney, Microsoft Money and many bank portals.
- No transaction IDs in the QIF standard — import each statement once.
Other formats: Excel · CSV · QuickBooks · Xero · QBO · OFX · QFX
The extracted data
| A · Date | B · Description | C · Debit | D · Credit | E · Balance | |
|---|---|---|---|---|---|
| 1 | 2026-08-02 | CARD PURCHASE 08/01 STARBUCKS #2231 NEW YORK NY | 6.85 | 4,805.55 | |
| 2 | 2026-08-03 | ACH DEBIT CON EDISON UTILITY PAYMENT | 142.19 | 4,663.36 | |
| 3 | 2026-08-04 | ZELLE PAYMENT FROM J. MARTINEZ | 350.00 | 5,013.36 | |
| 4 | 2026-08-08 | DIRECT DEPOSIT ACME CORP PAYROLL | 3,240.00 | 7,664.94 | |
| 5 | 2026-08-12 | CHECK #1042Verify — read from image | 130.00 | 7,534.94 |
QIF questions
Which programs read QIF?
Quicken (older versions natively, newer via conversion), QuickBooks Desktop through third-party import, Moneydance, YNAB, GnuCash, KMyMoney, Microsoft Money and many others.
What date format does the QIF use?
MM/DD/YYYY, which Quicken and QuickBooks expect by default. Amounts are signed: negative for money out.
Should I choose QIF or QBO/OFX?
If your software accepts OFX or QBO, use those — they carry transaction IDs and the closing balance. QIF is for tools that only read QIF.