Bank statement to QIF
Upload a PDF statement (or a scan) and download a QIF file that GnuCash, Moneydance, Banktivity, Quicken and other QIF-reading tools can import. One entry per transaction, in the order the statement prints them, with dates as MM/DD/YYYY.
Upload a file
What the QIF file contains
- One entry per transaction, in statement order
- Date, payee, and amount in the fields QIF readers expect
- No category invented for you — the file imports cleanly and you set categories in Quicken
- A file you import directly, not a spreadsheet to tidy first
What the QIF file looks like
QIF is line-based: !Type:Bank opens the account, then D is the date, P the payee, T the amount, and ^ closes each transaction. There is no currency or account number, which is why Quicken asks which account to load it into.
!Type:Bank
D03/02/2026
PDirect Debit 4471 Acme Insurance
T-120.00
^
D03/04/2026
PCard Payment Corner Grocer
T-38.40
^
D03/06/2026
PTransfer Received J Smith
T500.00
^How to convert
Upload your statement
Drop in the PDF you downloaded from your bank, or a scan of a paper statement.
Choose QIF
Leave the output format on QIF — it is preselected on this page.
Import the file
Bring the .qif in through your finance app’s QIF import.
Statements it handles
Layouts differ from bank to bank, so nothing is matched against a fixed template. An unusual statement still produces a table you can check before exporting — which is what makes it usable for bookkeepers and accountants who receive statements from every client.
PDF statements and CSV exports
A statement downloaded from your bank, or the CSV your bank lets you export. Both arrive as the same clean table.
Multi-page statements, read as one table
A statement that runs over several pages — or several statements uploaded together — is read as one continuous table, not one file per page.
Amounts and dates kept as your bank prints them
Debit and credit signs, decimal places and date formats are left as printed, so the numbers still reconcile against the statement.
Scanned, image-only PDFs, read with OCR
A statement with no text layer is read with OCR and may need a quick review — the one case where a row can come out wrong.
- CSV
- Scan
Rows are read by what they are — a date, a description, an amount — not by where they sit on the page, so a wrapped description stays with its transaction and a closing balance never becomes one. Why OCR mangles bank statements
Frequently asked questions
How do I convert a bank statement to QIF?
Upload the PDF from your bank (or a scan) above, keep QIF as the output format, and download the .qif file. No account and nothing to install.
What is a QIF file?
QIF (Quicken Interchange Format) is a plain-text format for moving transactions between finance programs. It stores dates, payees, and amounts as tagged lines.
Can I convert a PDF bank statement to QIF?
Yes. A PDF statement is the most common input; upload it, pick QIF, and download the file.
Does the file include categories?
No. Categories are guessed wrong more often than not, and a wrong category is harder to fix than an empty one, so they are left for you to set in Quicken.
Can I import the QIF into a Quicken checking or credit card account?
Not in Quicken for Windows: it imports QIF into cash, asset and liability accounts only. For checking, savings and credit card accounts use Quicken’s CSV import — choose Quicken in the format menu, see bank statement to Quicken.
Is my statement kept after conversion?
No. The file is deleted when the conversion finishes; only the converted copy stays at your private link.
Do I need an account?
No. The converter works without signing up.