What the Excel file looks like
Every transaction becomes one row. Dates are real Excel dates (sortable, filterable), amounts are real numbers, not text, so SUM and pivot tables work immediately. Withdrawals and deposits are in separate columns, and the running balance is kept when the statement prints one.
- Transactions sheet: Date · Description · Money out · Money in · Amount (signed) · Balance · Page
- Summary sheet: bank, account (last 4 digits), period, opening and closing balance, totals in and out, balance-check result
- Multi-line descriptions are joined into one cell; page headers, footers and 'balance brought forward' lines are dropped
Why the balance check matters
Copy-pasting from a PDF or using a generic PDF-to-Excel tool usually breaks columns or drops rows, and you only notice when the books don't reconcile. We add up every converted row and compare it with the statement's opening and closing balance. When they match you see a green BALANCED stamp. When they don't, we show the exact difference and highlight the rows where the running balance stops adding up, so you can fix one cell instead of re-checking 300.
Many statements at once
Drop a year of monthly statements together. Each file converts in parallel and you can download them merged into a single sheet (sorted by date, with the source file in a column) or as one sheet per statement.