If your bank only gives you PDF statements (common for older months, closed accounts, or smaller banks), getting that data into a spreadsheet or accounting tool is surprisingly painful. Here are the options, roughly from cheapest to most automated, plus the gotchas that trip people up.
Option 1: Check for a hidden CSV/OFX export first
Before converting anything, look in your online banking for "Download transactions", "Export", "OFX", "QFX" or "QBO". Many banks offer it but only for the last 90 days to 2 years. If it exists, use it: it's exact.
Option 2: Copy-paste or Excel's "Get Data from PDF"
For a statement or two, Excel's Data → Get Data → From File → From PDF can pull tables out of digital PDFs. It works well on clean layouts and badly on statements where descriptions wrap onto two lines or where each page repeats headers.
Option 3: Script it with a PDF table library
If you're comfortable with Python, libraries like pdfplumber or camelot can extract tables from digital PDFs:
import pdfplumber, csv with pdfplumber.open("statement.pdf") as pdf, open("out.csv", "w", newline="") as f: w = csv.writer(f) for page in pdf.pages: for table in page.extract_tables(): for row in table: w.writerow(row) Expect to spend time on cleanup: merged description lines, page headers in the middle of your data, debit/credit columns vs. signed amounts, and dates without a year.
Scanned statements (images) need OCR first, which adds another layer of errors.
Option 4: A dedicated converter
Tools built for bank statements handle the multi-line descriptions, running balances and per-bank layouts for you. Whatever you choose, check:
- Privacy: how long are files kept, and are they used for training?
- Accuracy: does the closing balance reconcile? Always check opening balance + transactions = closing balance.
- Preview before paying, so you can see your own statement converted.
Importing the CSV
- QuickBooks Online: Banking → Upload transactions accepts CSV with 3 or 4 columns (Date, Description, Amount or Debit/Credit).
- Xero: Bank account → Import a statement, CSV with Date, Amount, Payee/Description.
- hledger / beancount: write a CSV rules/importer once per bank and reuse it.
Disclosure: I'm part of the team behind Bank Statements CSV, a converter for digital and scanned PDF bank statements. It shows a free preview before you pay, needs no sign-up to start, deletes files within 24 hours, and pricing is per conversion from $1. If your bank has a CSV export, though, use that first.
Which banks have given you the worst PDF layouts? Curious what edge cases people run into.

