Bank statement PDF to QIF

Importing the QIF into your tools

• Quicken

  File → File Import → QIF file → choose the account to import into. Review payees on first import; Quicken remembers your renaming rules afterwards.

• YNAB

  Account → Import — YNAB accepts QIF directly; match the account, then approve the imported transactions.

• GnuCash

  File → Import → Import QIF → follow the assistant; map the QIF account to your GnuCash account when prompted.

Worth knowing: QIF has no currency field and dates are locale-ambiguous in some old importers — if your tool supports OFX, that's the more robust choice; QIF remains the format of choice for older Quicken versions and GnuCash workflows.

When you need a converter (and when you don't)

If your online banking offers a CSV, Excel or OFX export for the period you need, use it — a native export is written by the bank and always beats a conversion. The converter earns its keep in the cases banks don't cover: months that are only available as PDF, closed accounts where only downloaded statements remain, statements forwarded by a client or family member, and scanned paper statements.

Accountants and bookkeepers hit this constantly during year-end and client onboarding: a shoebox of PDFs that need to become one clean ledger. Converting them one by one by copy-paste typically costs 15–30 minutes per statement and introduces silent errors; a purpose-built converter does the batch in minutes with amounts validated against the document.

What makes bank PDFs hard to convert

A PDF doesn't contain a table — it contains instructions to draw text at coordinates. The rows you see are a visual arrangement that has to be reconstructed, and every bank arranges differently: multi-line descriptions, transactions that span page breaks, running-balance columns that appear only on some pages, and date formats that flip between regions.

Generic OCR makes it worse on scanned statements: a misread character in a description is cosmetic, but a misread digit in an amount silently corrupts your books. That's why this converter re-validates every date and amount after extraction, and shows totals you can reconcile against the statement's own summary line.

What you get that a plain converter can't give you

Conversion is the commodity half of the job. The half that saves real time is identification: SQ *BLUE BTTL 0412 becomes Blue Bottle Coffee with a category and a confidence level, PAYPAL *ODDNAME resolves to the actual seller, and the export you download is already readable. Subscriptions, recurring charges and bank fees are detected in the same pass, so the output is bookkeeping-ready rather than merely machine-readable.

Converting statements for accountants, mortgages and visas

Most conversions trace back to one of three deadlines. Bookkeepers and accountants convert a year of client PDFs into one ledger at tax time. Mortgage and loan applicants are asked for three to six months of statements that a broker wants as a spreadsheet, not a stack of PDFs. And visa or immigration cases often need statements as data a caseworker can total. In all three, what matters isn't just getting a CSV out — it's that the numbers reconcile, because someone is going to add them up and check.

That's the practical difference from a free online PDF-to-CSV tool: the output is validated against the statement's own totals and every merchant is named, so the person on the other end trusts it on the first pass instead of sending it back.

Frequently asked questions