How to convert a scanned bank statement to Excel or CSV
Save the scan or photos as one PDF, upload it to a converter that reads scanned pages with OCR, and download Excel or CSV. Clean scans give the best results, so scan flat, at 300 dpi, in even light. Always check the result against the paper statement, because OCR can misread digits, decimal points and minus signs.
Updated
Scanned vs digital PDF: why it matters
A digital PDF from online banking contains real text. A scanned or photographed statement is only a picture of text, so software has to read it with OCR (optical character recognition) first.
| Digital PDF | Scanned PDF or photo | |
|---|---|---|
| Where it comes from | Downloaded from online banking or emailed e-statement | Paper statement scanned, photographed or faxed |
| Can you select text? | Yes | No, the page selects as one image |
| How it’s read | Text is extracted directly | OCR reads the image |
| What can go wrong | Layout quirks | Misread digits, dropped decimals, skewed columns |
| Check needed | Quick check of totals | Row-by-row balance check |
Before you scan anything, check whether you can download the statement. Most banks keep PDF statements online for several years under a section like “Statements” or “Documents”. A downloaded PDF beats the best scan.
Scans make sense for statements older than the online archive, closed accounts, paper statements from a client, or documents from a bank branch.
Step 1: Scan or photograph the statement cleanly
OCR quality depends mostly on the image. Five minutes spent on a clean scan saves far more time fixing numbers later.
With a flatbed scanner or office copier:
- Set resolution to 300 dpi (400 dpi for tiny print).
- Choose grayscale. Color adds file size without helping, and pure black-and-white can break thin digits.
- Save as PDF, with all pages in one file.
- Place pages straight against the glass edge.
With a phone:
- Use a document scanner rather than the normal camera. On iPhone, the Notes app has Scan Documents. On Android, the Google Drive app has a Scan option.
- Lay the page flat on a dark, plain surface so the edges are easy to detect.
- Use even daylight or overhead light. Avoid the flash, which leaves a glare spot.
- Hold the phone directly above the page, not at an angle.
- Scan every page into one document and save it as a PDF.
Avoid these, they cause most OCR errors:
- Shadows from your hand or phone across the table
- Curled pages or a fold through a column of numbers
- Cropped edges that cut off the amount or balance column
- Highlighter, pen ticks or staples over figures
- A photocopy of a photocopy, or a fax
Step 2: Turn photos into one PDF
BankConv accepts PDF files only, up to 30 MB each. If you have JPG, PNG or HEIC photos, combine them into a PDF first.
- iPhone: select the photos in Photos, tap Share → Print, then use Share again from the print preview to save a PDF. Or use the Files app’s Create PDF.
- Android: scanning with the Google Drive app already saves a PDF.
- Windows: select the images, choose Print, then pick Microsoft Print to PDF.
- Mac: open the images in Preview, put them in page order, then File → Export as PDF.
Keep pages in order and the right way up. One statement per PDF makes checking simpler. If the file is over 30 MB, scan again at 300 dpi in grayscale; that usually brings it well under.
Step 3: Convert the scan with OCR
BankConv reads scanned PDFs with OCR automatically. You don’t need to run OCR yourself first.
- Upload the PDF to bank statement to Excel or bank statement to CSV. Up to 10 files per batch.
- Look at the extracted rows on screen next to the paper statement.
- Download Excel, CSV or Google Sheets. Downloading needs a free account.
The first 5 pages convert free, so you can test a scan’s quality before you convert a whole year. See pricing for larger jobs.
Generic chatbots can also read a statement photo, but they may skip or invent rows on long statements. See BankConv vs ChatGPT for the differences.
Step 4: Check the numbers
OCR errors are rarely random. They follow patterns, so you know what to look for.
| Misread | Example | How to spot it |
|---|---|---|
| 8 and 3, 6 and 5 | 1,836.20 read as 1,336.20 | Running balance breaks on that row |
| 1 and 7 | 71.00 read as 11.00 | Running balance breaks |
| Decimal point dropped | 45.99 read as 4599 | Amount is far larger than its neighbors |
| Minus sign or DR missed | -120.00 read as 120.00 | Balance moves the wrong way |
| Comma read as decimal | 1,250.00 read as 1.25 | Tiny amount on a large payment |
| Row merged with the next | Two descriptions in one cell | Row count lower than the statement |
The running-balance check. This one formula finds almost every misread. In Excel, with Amount in column C and Balance in column D, put this in E3 and fill down:
=ROUND(D2+C3-D3, 2)Every row should show 0. Any other number points to a misread on that row or the row above. If your file has separate columns, with Debit in D, Credit in E and Balance in F, use =ROUND(F2+E3-D3-F3, 2) instead.
Then confirm two totals:
- The number of rows matches the transactions on the statement.
- Opening balance plus the sum of amounts equals the closing balance printed on the last page.
Fix any flagged rows by reading the paper copy. Then the file is ready to use or import.
Tips for large scanning jobs
Bookkeepers catching up a year of paper statements can save time by batching.
- Scan one statement per PDF and name it by account and month:
checking-2024-03.pdf. - Do a test page first to check lighting and resolution before scanning a whole box.
- Keep the paper originals until the converted figures have been checked and reconciled.
- Uploaded files and converted outputs are deleted automatically after 24 hours. See security for details.