How to Convert a Scanned Bank Statement to Excel

Scanned and photographed statements need OCR, which brings real accuracy risks. How to get the best result — and how to check it before you rely on it.

If your statement is a scan, a photo, or a PDF that someone printed and re-scanned, there is no text inside the file — only an image of text. Getting data out means OCR, and OCR on financial documents deserves more caution than it usually gets.

First, check whether you actually need OCR

Open the PDF and try to select a word with your cursor. If individual words highlight, the file has a text layer and you should not be using OCR — you'd be replacing perfect data with a guess. If your cursor draws a rectangle instead, it's an image, and OCR is the only route.

Why OCR errors are dangerous specifically in financial data

OCR confuses characters that look alike: 8 and 3, 5 and 6, 1 and 7, 0 and O. In ordinary prose you'd spot the mistake from context. In a column of amounts there is no context — 1,832.00 and 1,632.00 are equally plausible, and nothing about the wrong one looks wrong.

Getting the best possible scan

Scan at 300 DPI or higher Below 300 DPI, character shapes degrade enough that digit confusion rises sharply. 300 is the practical floor for financial documents.
Scan straight Even a few degrees of skew hurts accuracy, and can cause columns to be misassigned. Use the document feeder rather than holding the page.
Use greyscale, not black-and-white Pure bitonal scanning destroys thin strokes. Greyscale preserves the detail OCR needs.
Photograph flat and evenly lit if you must use a phone Shadows and page curl are the two biggest causes of failure on phone photos.

After conversion, check these specifically

Does the balance chain hold from opening to closing balance?
Do the debit and credit totals match the printed summary?
Spot-check five amounts against the original image, especially any with 8, 3, 5 or 6
Check the dates — a misread year silently reorders everything

If the totals tie out, digit-level OCR errors are very unlikely to have survived: a misread digit almost always breaks the arithmetic.

Frequently asked questions

What accuracy should I expect from a scan?

A clean 300 DPI scan converts well. A phone photo of a crumpled page does not. The verification result tells you which situation you're in rather than leaving you to guess.

Can I get the original PDF instead?

If the account is still open, download the e-statement from online banking. A native PDF is always better input than any scan.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.