Free converter
Bank statement converter for GnuCash
Get statements into GnuCash's double-entry world without fighting the importer.
Choose a statement file (PDF, OFX/QFX, CSV, XLSX, TXT — up to 5 MB)
Why GnuCash users end up here
GnuCash imports QIF, OFX and CSV, and its QIF importer is genuinely good — a guided assistant that maps QIF categories and accounts onto your GnuCash account tree. The pain is never the import mechanics; it's the input file: bank CSVs vary wildly, PDFs need converting, and raw descriptors make the payee-matching step miserable. A well-formed QIF with real merchant names lets GnuCash's Bayesian matching learn where transactions belong — which is the difference between categorising a statement in minutes and in an evening.
Importing into GnuCash, step by step
- Convert your statement above and download the QIF (OFX works too and carries transaction IDs for deduplication).
- In GnuCash: File → Import → Import QIF, then follow the assistant.
- Map the QIF account to the matching GnuCash account when prompted (first import only — it remembers).
- In the duplicate-check step, confirm any matches against transactions you entered manually.
- Run the generic transaction matcher's suggestions; with identified merchant payees, its guesses get good fast.
The gotchas GnuCash users actually hit
QIF vs OFX in GnuCash
QIF is simpler and fine for one-off imports. OFX carries unique transaction IDs, so repeated/overlapping imports dedupe automatically — prefer it if you import the same account regularly.
Import into the right side of the tree
GnuCash is double-entry: statement lines are one leg of each transaction. Import into the bank's asset account and let the matcher assign the expense legs — don't import into an expense account.
Encoding on older QIF importers
Non-ASCII characters in payees occasionally garble in old GnuCash builds. Our exports are UTF-8; if you see mangled characters, update GnuCash rather than editing the file.
Free converter
Convert your statement — and understand it too
A free account converts a statement page every day to CSV, Excel, QIF or OFX — with every transaction matched to a real merchant name, not a cryptic descriptor. No card required; files deleted after 24 hours.
No bank logins · card numbers redacted before storage · everything deleted after 24 hours
Frequently asked questions
Which format does GnuCash import best?
QIF for simplicity, OFX for repeat imports (its transaction IDs enable automatic deduplication). GnuCash reads both first-class; we export both from the same statement.
Can GnuCash read a PDF bank statement?
No — convert it first. Structured exports are parsed exactly; PDFs go through layout detection with AI fallback, and every date and amount is re-validated before the QIF/OFX is written.
Why do my imported payees matter so much in GnuCash?
GnuCash's transaction matcher learns account assignments per payee. Clean merchant names mean the second statement you import practically categorises itself.