PDF Bank Statement to Excel
Turn any digital bank statement PDF into a clean, import-ready Excel (.xlsx) workbook — debits, credits and balances in proper columns. Free, no sign-up, and your file is never uploaded.
Output columns: Date · Description · Money Out · Money In · Balance — ready for Excel, Google Sheets, QuickBooks or Xero import.
From PDF statement to Excel in three steps
Re-typing a bank statement into Excel is slow and error-prone, and most online converters ask you to upload sensitive financial documents to a server. This tool takes a different approach: it opens the PDF locally in your browser, reads the embedded text layer with pdf.js, and reconstructs the statement table from the on-page coordinates of every character cluster. Rows are grouped by vertical position, a transaction is any row that starts with a date and carries an amount, and the result lands in a tidy table you can download as a native .xlsx workbook — or as CSV, or copied straight to your clipboard.
The column layout is detected, not assumed. If your statement prints separate debit and credit columns, the converter spots the two consistent horizontal positions and splits them into Money Out and Money In; a third column becomes the running Balance. Single signed-amount layouts (common with challenger banks and card statements) are converted with negative values mapped to money out. Repeated page headers, footers and page numbers are stripped automatically, so the Excel sheet contains nothing but transactions.
Amounts are written to the workbook as true numbers, not text, so totals, pivots and SUMIF formulas work the moment the file opens. If you import bank data into QuickBooks, Xero or another bookkeeping package, the flat Date–Description–Out–In layout maps cleanly onto their bank-feed columns — no merged cells, no page breaks, no cleanup pass.
Built for accounting imports
| Feature | Why it matters for Excel / bookkeeping |
|---|---|
| Numeric amount cells | Formulas, sorting and pivot tables work immediately — no "text to columns" fix-up |
| Separate Money Out / Money In columns | Matches the debit/credit mapping in QuickBooks and Xero bank imports |
| Running balance preserved | Lets you reconcile the sheet against the statement's closing balance in seconds |
| Headers/footers removed | No stray repeated rows to delete before importing |
Frequently asked questions
How do I convert a PDF bank statement to Excel?
Drop your statement PDF onto the upload zone above and click "Download Excel (.xlsx)". The tool reads the text layer of the PDF in your browser, detects dates, descriptions and amount columns, and produces a ready-to-open workbook — no upload or sign-up.
Is the Excel output ready for QuickBooks or Xero import?
Yes. The .xlsx is a clean flat table — Date, Description, Money Out, Money In, Balance — with real numeric cells. Map Money Out/Money In to the debit/credit fields during bank-feed import, or combine them into one signed column in Excel if your software expects that.
Are my statements uploaded to a server?
No. All parsing happens locally in your browser with JavaScript (pdf.js). Your file never leaves your device, which makes the tool suitable for confidential financial documents.
Does it work with multi-page statements?
Yes — every page is processed in order and concatenated into a single sheet. Repeated page headers, footers and page numbers are removed, and opening/closing balance lines become a note rather than polluting your totals.
My statement is a scan — why did nothing convert?
Scanned PDFs are images without a text layer, so there is no text to extract; the converter detects this and shows a notice. Re-download the digital e-statement from your bank's portal or app — that PDF converts cleanly to Excel.