How to convert a scanned bank statement to Excel
A statement downloaded from online banking is usually a "digital" PDF: the text is inside the file and a converter can read it directly. A statement that was printed and scanned, or photographed with a phone, is only a picture of text. To get it into Excel, something has to read the picture first – that is OCR (optical character recognition) – and OCR makes mistakes you need to catch.
Is your PDF scanned or digital?
Open it and try to select a word with the mouse. If the text highlights and you can copy it, it is digital. If the whole page is selected as one image, or nothing happens, it is scanned. Many PDF converters only handle digital PDFs and return an empty sheet or an error for scans.
Getting a scan or photo that reads well
- Flat and straight. Lay the page flat; folds and curled edges bend the lines of the table, and the reader loses track of which amount belongs to which row.
- The whole table in the frame, including the balance column on the right – it is what lets you check the result.
- Sharp and evenly lit. No shadow from your phone across the page, no flash glare. If you can't read the small print easily on screen, OCR can't either.
- Scanner settings: 300 dpi is plenty. Black-and-white is fine unless the statement uses coloured shading behind rows.
- One page per photo, taken from straight above.
The mistakes OCR makes on statements
OCR is good at words and less reliable on exactly the things that matter in a bank statement:
- Similar digits: 3 and 8, 1 and 7, 5 and 6, 0 and 8.
- A lost decimal point or comma – 1,250.00 read as 125000.
- A minus sign or "DR" marker missed, turning a payment into a deposit.
- A faint line skipped entirely, especially at the top or bottom of a page.
Reading the result back by eye rarely catches these. The reliable way is to use the balances printed on the statement: opening balance plus every transaction must equal the closing balance, and each running balance should match the one you calculate. A single wrong digit breaks the sum, and the running balance shows you which line. Here is how to run those checks in Excel.
Converting scans with BalancedProof
Drop the scanned PDFs or the photos (JPG or PNG) on the converter – you can mix them with digital PDFs. Scanned pages are read with OCR on our own server, and the images never leave it. If the statement's format is new to us, only a masked outline of the table (every letter shown as "x", every digit as "9") is sent to an AI service to learn the layout – see our privacy policy. Every row is then checked against the printed balances. Where a balance doesn't match, or a line couldn't be read clearly, the row is flagged: click it to see that line cut from the original image next to what was read, with a correction worked out from the balances. Download as Excel, CSV, or an import file for QuickBooks, Xero, Sage or Wave.
A photo counts as one page. It is free for 5 pages a day without signing up, and your files are deleted automatically after 2 hours.