Convert a bank statement to Excel, with the math checked.
Drop a PDF and export a formatted .xlsx workbook. Every transaction is reconciled against the statement's printed balances first, so you're not just trusting an OCR guess.
Reconciled, not just guessed
Balance chain, opening/closing totals, and date sanity are checked automatically — and we say so plainly when a statement can't support a check.
See where every number came from
Click a row and the source PDF page renders beside it with the exact text highlighted.
QBO, OFX, QFX, CSV, Excel — free
Export straight into QuickBooks or Xero format. No per-page pricing, no subscription.
What's in the .xlsx file
A real Excel workbook, not a renamed CSV — Date, Description, Amount, and Balance columns with actual cell types: dates as Excel date cells (yyyy-mm-dd), amounts and balances as numbers formatted to two decimals, description as text. That distinction matters — a CSV re-opened in Excel often turns dates and negative amounts into text strings thatSUM() silently ignores. This export is typed correctly from the start, so pivot tables and sum formulas work immediately — no "convert to number" cleanup pass first.
Column widths and formatting
Columns are pre-sized (Date 12, Description 45, Amount and Balance 14 characters) so the sheet is readable without manually dragging column borders, and the header row is bold. It's a plain, unstyled workbook beyond that — no colors, no merged cells, no macros — because a spreadsheet you're about to build formulas on top of is easier to work with than one fighting a template.
Building a pivot table or budget from the export
Because Amount is signed (negative for debits, positive for credits) rather than split into separate debit and credit columns, a single SUMon that column gives net change for the period — and it's already reconciled against the statement's printed closing balance, so a pivot table built on top of it starts from numbers that are known to add up correctly, not just extracted.
Excel, CSV, or QBO?
Excel is the right choice when you're going to analyze the data yourself — sort, filter, chart, pivot. If you're feeding the file straight into accounting software instead, CSVor QBO usually fit better: QBO in particular carries a bank ID and per-transaction IDs that QuickBooks uses for duplicate detection, which a spreadsheet format can't express.