How-to
How to convert a bank statement PDF to Excel
Banks hand you a PDF. Your accountant, your tax software and your spreadsheet want rows. Here's how to get from one to the other without retyping anything, and without trusting numbers nobody has checked.
Updated · 3 min read
Why copy-paste and generic PDF converters fail
A bank statement looks like a table, but inside the PDF it's just words placed at coordinates. Copy-paste and general "PDF to Excel" tools guess where the columns are, and statements are where those guesses break:
- Wrapped descriptions become extra rows. "CARD PURCHASE TESCO STORES" on one line and "1234 LONDON" on the next turn into two transactions, one with no amount.
- Page headers repeat in the middle of your data. Every page reprints "Date · Description · Paid out · Paid in · Balance", and a naive converter imports each one as a row.
- Dates printed once per day go missing. Many banks print the date on the first transaction of the day only. The rest arrive blank.
- Money in and money out get mixed up. A converter that misreads which column a number sits in flips the sign, and the totals still look plausible.
- A transaction disappears at a page break. Nothing warns you; the closing balance just stops matching.
Converting a statement with Signavos, step by step
- Download the statement from your online banking as a PDF. The original download works best: it has a real text layer, so nothing has to be guessed from pixels.
- Sign in to Signavos and open Statements in the dashboard.
- Upload one or more PDFs. If the file is password-protected, enter the password when asked. It is used once to open the file and never stored.
- Check the free preview: the first rows of the table, plus a balance result for every page (✅ ties out or ⚠️ doesn't).
- Convert with credits and download Excel (XLSX) or CSV, or QBO/OFX for QuickBooks and Xero.
Uploaded statements and the files made from them are deleted automatically after 24 hours.
What the spreadsheet looks like
One row per transaction, the same columns for every bank, so a formula you write once works on every statement:
| Column | What it holds |
|---|---|
| Date | ISO date (2026-03-14). Year-less dates like "14 Mar" get the year from the statement period. |
| Description | The full text, with wrapped lines joined back into one cell |
| Debit / Credit | Money out and money in, as positive numbers |
| Amount | One signed number: negative = money out |
| Balance | The running balance printed on the statement |
| Page | Which page of the PDF the row came from, so you can check any line against the original |
The part that matters: does it add up?
Any tool, including a chatbot, can produce rows. The question is whether the rows are right. Every Signavos conversion is checked against the statement's own numbers: opening balance, plus every transaction, must equal each running balance the bank printed, and the closing balance.
Rows that don't tie out are marked red, never passed silently. How the check works and what to do when a page fails is covered in How to check a bank statement conversion is accurate.
Scanned and photographed statements
A scan has no text layer, only an image of text, so it has to be read with OCR. Signavos does that on its own servers; no third-party OCR service sees your file. OCR misreads characters (0 and O, 1 and I) more often than a text PDF does, which is exactly what the balance check catches. If you can get the original PDF from your bank's website, use that instead.
Frequently asked questions
- Can I convert several statements into one spreadsheet?
- Yes. Upload a batch, for example twelve monthly statements, and download them merged into one sheet, in date order, with the page and source file on every row.
- Does it work with password-protected PDFs?
- Yes. Enter the password when prompted. It is used only to open the file for that conversion and is never stored.
- Which banks are supported?
- Signavos reads the statement's table layout rather than relying on a fixed template per bank, so it works with most banks that issue text-based PDF statements. The balance check tells you, page by page, whether a particular statement was read correctly.
- Do I need a subscription?
- No. Conversions are paid with the same pay-as-you-go credits as signatures. The preview is free, and you are not charged for pages that fail the balance check. Your first conversion on a new account is free.
Send your next document without a subscription.
Upload a PDF, place the fields, send. Your recipient signs without an account and you pay per signature — nothing renews.
Start paying per signature