How to Convert a Scanned PDF Bank Statement to Excel (OCR)

Some bank statements aren’t real digital PDFs: they’re pictures of pages — scanned, photographed or printed to PDF from an image. Excel and most converters can’t read them, because there is no text inside, only pixels. Text recognition (OCR) turns those pixels back into text. This guide shows how to do that and, just as important, how to check the result.

Is your PDF scanned?

Open it and try to select a word with the mouse. If you can highlight individual words, it’s a digital PDF: use the PDF bank statement converter or PDF table to Excel directly — no OCR needed, and the numbers will be exact. If clicking selects the whole page as one image, or nothing at all, it’s scanned.

Before using OCR, check whether your bank can give you the same period as a CSV, Excel or digital PDF download. Most online banking keeps 12 months or more, and some banks will email older digital statements on request. That is always more accurate than OCR.

Converting it with OCR

1. Open PDF table to Excel and drop the statement on it.
2. The tool sees there is no text and offers Read it with text recognition (OCR). OCR runs in your browser — the statement is not uploaded. The first time, it downloads about 7 MB; each page then takes a few seconds.
3. Check the table it finds: the columns, their names and types, and the date order.
4. Download Excel. The file has your table plus a Checks sheet with column totals and a running-balance check.

Check every number with the running balance

OCR can misread characters: a 5 for a 6, a comma for a full stop, a missing minus sign. On a bank statement you have a built-in way to catch them, because each balance should equal the previous balance plus money in, minus money out.

The Checks sheet does this for you when the table has a Balance column and Debit and Credit (or Amount) columns. It reports how many balances follow from the amounts, lists any row where they don’t — with the balance it expected — and highlights that cell. A single misread number usually shows up as one or two rows that don’t follow; correct the value from the PDF and the rest falls into place.

Also compare the totals on the Checks sheet with the statement’s own summary of money in and money out. If the statement’s summary disagrees with the running balances, trust the balances: summaries sometimes leave out fees or interest.

Getting a better scan

• Scan at 300 dpi in black and white or greyscale. Lower resolutions lose the shapes of small digits.
• Keep pages straight. A skewed page makes columns harder to find. Most scanner apps have an auto-straighten option.
• Avoid phone photos at an angle, shadows and folds across the table.
• One statement per file. Use Split PDF to remove cover letters and marketing pages before converting.

Limits of OCR

OCR reads typed text; it doesn’t read handwriting reliably. Very faint scans, coloured backgrounds and stamps across the table reduce accuracy. The tool reads up to 30 pages, in English. For long or poor-quality statements, ask the bank for a digital copy.

Next steps

Once the transactions are in Excel, you can combine the debit and credit columns, merge several months into one file, or convert it for QuickBooks or Xero.