Convert a scanned bank statement PDF to Excel (OCR, checked to the balance)
A scanned bank statement is a picture of the pages: there's no text in the PDF to copy, search or import, so Excel, QuickBooks Desktop and most converters get nothing out of it. Utilly reads scanned statement PDFs with OCR (text recognition), then checks the rows against the statement's beginning and ending balance before you download Excel, CSV, QuickBooks or Xero files. Below: how to tell whether your PDF is a scan, when to download a fresh copy instead, how the balance check catches OCR mistakes, and how to make a scan that reads cleanly.
Short answer: if you can get the statement again from online banking, download it. That PDF has a text layer and converts exactly. If the scan is all you have (a paper statement, a closed account, a client's shoebox), upload the scanned PDF to the bank statement converter. It's read with OCR, the rows are added up against the beginning and ending balance, and the free preview tells you Balanced ✓ or exactly how far off it is before you pay. Scans of up to 10 pages work, in English, as PDF files.
Watch a scanned statement get read and balanced
Open a fictional business checking statement scanned as images, tilted slightly, with scanner specks and no text layer. OCR reads all 31 rows and they tie to the beginning balance of 12,418.36 and the ending balance of 13,440.52. Every download is unlocked for the sample.
1. Is your PDF a scan?
Two quick tests in any PDF viewer:
- Select text. Drag across a transaction description. If the words highlight one by one, the PDF has a text layer. If a box appears around the whole page (or nothing happens), it's an image.
- Search. Press Ctrl+F (Cmd+F on a Mac) and search for an amount you can see, such as the ending balance. No match on a number that's plainly on the page means a scan.
Statements downloaded from a bank's website or app are almost always text PDFs. Scans come from a scanner or copier, a phone's document scanner, a fax, or a statement printed and then scanned back in. Some PDFs mix both: a scanner that adds its own OCR text layer. Those usually read as text PDFs, with whatever mistakes the scanner's OCR made, and the balance check catches those the same way.
2. Try a downloaded copy first
OCR is good, but reading text that's already in the file is exact. Before converting a scan, check whether the same month is still in online banking under Statements or Documents. Banks keep a different number of months online, and many will send older statements on request. Our bank pages list how far back each one goes, for example Bank of America, Wells Fargo and Capital One.
Scans make sense when the account is closed, the months are older than what's online, the client only kept paper, or the statement came to you as a scan and getting a new copy would take days.
3. Convert a scanned statement to Excel
- Upload the scanned PDF on the bank statement to Excel page (or any bank page: they all use the same converter). There's nothing to switch on: a PDF with no text layer goes to OCR automatically, and the page is read in memory on our server. The PDF isn't stored, isn't sent to another service, and the results are deleted after an hour.
- Read the result line. The preview says Read from a scan and then either Balanced ✓ (beginning balance plus every row equals the ending balance) or Off by an exact amount.
- Skim the descriptions. A balanced scan has every amount right, but OCR can still swap a letter in a payee name or a digit in a check number, which doesn't touch the total. A quick read against the scan fixes those.
- Download. One credit unlocks CSV and Excel, QuickBooks .QBO and QuickBooks Online CSV, Desktop .IIF, Quicken .QIF, OFX, Wave, FreshBooks and Xero files for that statement. Credit card statements work the same way, checked against the previous and new balance.
4. How the balance check catches OCR mistakes
Every OCR tool misreads sometimes, and a wrong digit in an amount is the mistake that matters for bookkeeping. On a statement, the beginning balance, the rows and the ending balance have to add up, so a misread amount or a skipped row shows as a difference you can see before importing. These are the usual scan mistakes and how they show up:
| What OCR gets wrong | Example | What you see |
|---|---|---|
| Look-alike digits | 132.47 read as 432.47; 3 and 8, 1 and 7, 5 and 6 | Off by the difference (300.00 here). Find the row whose amount doesn't match the scan |
| Letters for digits | 1,O45.2O or l,045.20 | Nothing: Utilly turns O, o and l back into digits inside amounts |
| A decimal comma | 1,234,56 | Nothing: read as 1,234.56 |
| Scanner specks | A dot or dash next to an amount | Nothing: lone specks are dropped, so a dash after an amount isn't taken as a minus sign |
| A blurred date | 09/17 read as O97 | The row can drop out, so the statement is off by that row's amount. Utilly reads the page a second way when the first read doesn't balance, and keeps the read that ties out |
| A wrong letter in a description | XXXX9921 read as XXXxX9921 | Balanced ✓, because the totals are right. Skim descriptions and check numbers before you import |
When a scan comes out off, the running balance column helps: Utilly flags any spot where the balance jumps by more than the listed amount, which points at the misread row. For the step-by-step version of that hunt, see how to find bank reconciliation discrepancies.
5. Making a scan that reads cleanly
| Setting | Use | Why |
|---|---|---|
| Resolution | 300 dpi | Small statement print gets blurry below 200 dpi; above 300 adds file size, not accuracy |
| Colour | Black and white or grayscale | Colour backgrounds and shaded rows lower the contrast between digits and paper |
| Pages | Flat and straight, one statement per file, 10 pages at most | A curled or skewed page bends the rows; one statement per file keeps one beginning and ending balance per check |
| File type | Phone photos (JPG, PNG, HEIC) aren't read as statements. A phone's document scanner, such as the one in iPhone Notes or Google Drive, saves a PDF | |
| Faxed or copied pages | Rescan the original if you have it | Each copy loses detail, and fax resolution is low enough to confuse digits |
6. Other ways, and where they stop
- Excel's Get Data → From PDF reads the PDF's text, so a scan gives it nothing to read. It works well on downloaded statements: see the DIY section of bank statement PDF to Excel.
- QuickBooks Online's own statement upload also reads scans and is free inside QuickBooks Online. You review the extracted lines there. See how to upload a PDF bank statement to QuickBooks Online, including the scan mistakes to look for.
- QuickBooks Desktop, Xero's CSV import, Wave and FreshBooks don't read PDFs at all. They need a file: the .QBO, .IIF, Xero CSV, Wave or FreshBooks CSV that the converter writes.
- Typing it in. For a one-page statement with a handful of rows, the free bank statement Excel template has a blank statement sheet to type into, next to a filled-in example.
7. What Utilly doesn't read
Handwriting, photos that aren't saved as PDF, statements in languages other than English, and scans over 10 pages (split those into one statement per file). A very faint, dark or rotated scan may come back with no rows, or off by a lot; that's the signal to rescan or get a downloaded copy. The bank reconciliation checker reads scanned bank statements the same way, so you can compare a scanned statement with your QuickBooks or Xero export directly.
Convert your own scanned statement
Upload the scanned PDF: the free preview shows the balance check and the first 5 rows with no sign-up. $9 unlocks 5 statements in every format, with no subscription. Files are read in memory and never stored.
FAQ
Can you convert a scanned bank statement to Excel?
Yes. Upload the scanned PDF to Utilly's bank statement converter: a PDF with no text layer is read with OCR automatically, then the rows are checked against the statement's beginning and ending balance. The free preview shows Balanced or exactly how far off it is, and one credit unlocks Excel, CSV, QuickBooks and Xero files.
How do I know if my bank statement PDF is a scan?
Try to select a description or search for an amount you can see with Ctrl+F. If no words highlight and the search finds nothing, the PDF is an image of the pages, which is a scan. Statements downloaded from online banking are almost always text PDFs.
How accurate is OCR on bank statements?
On a clean 300 dpi scan, most amounts read correctly, but look-alike digits such as 3 and 8 or 1 and 7 can be swapped on faint or blurred pages. That's why Utilly adds the rows up against the beginning and ending balance: a misread amount or a missing row shows as a difference before you import, instead of ending up in your books.
Can I convert a photo of a bank statement?
Not as a JPG or PNG. Save it as a PDF first, for example with the document scanner in iPhone Notes or Google Drive, which keeps the page flat and straight. Then upload the PDF.
Is my scanned statement stored or shared?
No. The PDF is read in memory on Utilly's server with open-source OCR, never written to disk and not sent to any other service. The extracted rows are deleted after an hour.
What if the scan doesn't balance?
Look at the rows next to the scan, starting where the running balance jumps by more than the listed amount: that's usually the misread row. If it's far off, rescan at 300 dpi in black and white, or download the statement again from online banking, which converts exactly.
Related guides
- How to get a bank statement PDF into Google Sheets (checked to the balance)
- How to upload a PDF bank statement to QuickBooks Online (and check nothing was missed)
- Free sample bank statement PDF (fictional, with known totals)
- Catch-up bookkeeping: getting 12 months of bank statements into QuickBooks or Xero and reconciled
- How to find a bank reconciliation discrepancy: 7 causes and a 15-minute method
- Free sample bank statement in Excel (with a blank template)
Related tools
- Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
- Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.
