DEV Community

Petrovich
Petrovich

Posted on

How to import old PDF bank statements into YNAB, Actual Budget or GnuCash (without uploading them anywhere)

Budgeting apps are great at importing new transactions: you link the bank and they flow in. The pain is the past. You start YNAB in July and want January–June. You switch apps and the old history is gone. Your bank only keeps 90 days of CSV export, but gives you years of PDF statements.

YNAB, Actual Budget, GnuCash and Quicken all import CSV, OFX or QIF. None of them read PDFs. Here are the options, from free-and-manual to automated.

Option 1: Ask the bank for CSV/OFX (free, often impossible)

Look for "Export", "Download transactions" or "Quicken/QFX" in online banking. Many banks limit this to the last 90–180 days, which is why most people end up with PDFs.

Option 2: Copy-paste into a spreadsheet (free, painful)

Select the table in the PDF, paste into Excel/Sheets, fix the broken columns, then save as CSV with the columns your app expects. For YNAB:

Date,Payee,Memo,Outflow,Inflow
2026-03-01,Grocery Mart,,54.20,
2026-03-02,Payroll ACME,,,2540.00
Enter fullscreen mode Exit fullscreen mode

Plain numbers (no currency symbols or thousands separators), one date format, and a real payee name so auto-categorisation works.

The catch: a 3-page statement is ~60 rows, and PDF text often comes out with wrapped descriptions, merged columns and debits/credits in the wrong place. One missed row and your balance is off forever.

Option 3: Python + pdfplumber (free, for developers)

import pdfplumber
with pdfplumber.open("statement.pdf") as pdf:
    rows = [r for p in pdf.pages for r in (p.extract_table() or [])]
Enter fullscreen mode Exit fullscreen mode

Fine for one bank's layout; each bank needs its own tweaks (date formats, Cr/Dr markers, (45.00) negatives, Indian 1,23,456.78 grouping, multi-line descriptions).

The trick that makes any method trustworthy: reconcile against the balances

Whatever you use, check the result against the statement itself:

opening balance + sum(all transactions) == closing balance
Enter fullscreen mode Exit fullscreen mode

and, if there is a running balance column, previous balance + amount == this row's balance, for every row. If both hold, you didn't drop or misread a single transaction. If one row fails, you know exactly where to look.

Option 4: A tool that does all of the above in the browser

Disclosure: I built this one. Backfill converts a PDF statement to YNAB CSV, OFX (Actual, GnuCash, Xero), QIF (Quicken) or plain CSV, and runs the reconciliation above automatically: green if it matches to the cent, red rows if not.

It runs entirely client-side (pdf.js), so the statement never leaves your machine; load the page, turn off Wi-Fi and it still works. Preview and reconciliation are free; full exports are a small one-time payment. It doesn't handle scanned statements yet.

Importing the file

  • YNAB: account → Import → pick the CSV → confirm the date format. Rows arrive unapproved, so nothing hits your budget silently.
  • Actual Budget: account → Import → OFX/QIF/CSV. OFX keeps stable IDs, so re-importing won't duplicate.
  • GnuCash: File → Import → Import OFX/QFX.
  • Quicken: File → File Import → QIF.

If your bank's layout breaks any of these approaches, post the (anonymised) column headers in the comments and I'll take a look.

Top comments (0)