How to Convert a Scanned Bank Statement to Excel or CSV

Why are scans and photos harder to convert than digital PDFs?

A digital PDF downloaded from online banking contains actual text: every character and its position on the page is stored in the file. Conversion is a matter of reading structured data that is already there. A scan or phone photo contains none of that — it is only a picture, and every digit, date, and description has to be recognised from pixels.

That recognition step introduces failure modes that native PDFs never have. Skew and perspective distortion make table rows drift, so an amount can end up attributed to the wrong transaction or the wrong column. Uneven lighting puts shadows across figures or glare on glossy paper, hiding parts of characters. Low resolution blurs the difference between a 6, an 8, and a 0, and can make decimal points and thousands separators vanish entirely. Physical artefacts — bank stamps, handwritten notes, highlighter, hole punches, fold creases — sit on top of the very text that needs to be read. Photocopies of photocopies compound all of this.

The uncomfortable part is that a misread digit usually looks plausible. A description with a garbled letter is obvious; £1,840.00 read as £1,340.00 is not. That is why, for scanned statements, verification is not a nice-to-have — it is the core of the workflow, and it is worth choosing a scanned statement converter that checks its own output rather than one that simply hands you a table.

How do you photograph a bank statement so it converts well?

Most conversion failures are capture failures. A minute of care with the phone camera saves far more time than fixing misread rows later. The rules are simple:

• Lay the page flat on a dark, contrasting surface. Press out fold creases with your hand or a book for a few seconds first — a page curling at the edges distorts the columns nearest the fold.
• Get all four corners in frame. Cropped edges are a leading cause of missing transactions, because the first or last rows of the table are simply not in the image.
• Hold the phone parallel to the page, directly above it. Shooting at an angle creates perspective distortion that makes columns converge, which is exactly what row-and-column recognition struggles with.
• Use even, indirect light. Daylight near a window works well. Avoid flash on glossy paper (glare wipes out whole regions) and watch that your own shadow is not falling across the figures.
• One page per shot. Do not photograph a two-page spread in a single frame — resolution per character halves and the centre fold distorts both pages.
• Fill the frame and check legibility. Zoom into the smallest printed digits on your photo. If you cannot read them clearly, no software can either. Retake rather than hope.

The same logic applies to flatbed scanners and scanner apps: scan flat, scan straight, and use a reasonable resolution — 300 DPI is the common-sense standard for documents with small print. A clean, straight scan at sensible settings removes most of the failure modes that make images harder to read than native PDFs.

How do you verify the numbers from a scanned statement?

Proofreading every row against the image is slow and unreliable — after fifty rows your eyes glaze over. The efficient check is arithmetic: the opening balance, plus every credit, minus every debit, must equal the closing balance to the cent. A single misread amount breaks that chain, so a statement that reconciles end-to-end gives you strong evidence that the transaction amounts were read correctly.

BankStatementWise turns scans into editable transaction rows with automatic checks and detected issues highlighted. Understand your result, then choose the export that fits your work.

Open the result alongside your source image and check the highlighted issues, account and period before using the data. Clear merchant descriptions matter too: they help you categorize spending and find a transaction later.

How should you handle multi-page scans and photos?

Photograph or scan pages one at a time, in order, and keep them in a single file if your scanner app can produce a multi-page PDF — most can. Order matters more for scans than you might expect: the running balance continues from page to page, and 'balance carried forward' lines are part of the arithmetic chain, so shuffled pages read like a broken statement.

Keep every page of the statement in the upload, including the opening and closing summaries. After conversion, confirm the expected accounts and periods are present. Detected accounts remain separate in the result.

Upload your multi-page scan as one PDF and follow progress on screen. Larger packets take longer than a short statement, so keep each upload within the page allowance shown in your workspace.

When is a scan too degraded to convert?

There is a floor below which no tool reads reliably, and the honest test is your own eyes: zoom into the image, and if you cannot confidently distinguish the digits yourself, automated recognition will not do better. Common lost causes include thermal-paper printouts that have faded to grey, fax copies several generations removed from the original, heavy highlighter directly over amount columns, and photos so blurred that decimal points have disappeared.

Before giving up, work up the quality ladder. If you still have the paper original, re-photograph it with the technique above — most 'bad scans' are just bad captures of good paper. If the statement came from a bank, log in to online banking and download the digital PDF instead; most banks keep several years of statements available, and a native PDF sidesteps every problem in this guide. Failing that, rescan at higher resolution on a flatbed.

Use the free preview to see how your scan converts: the first 3 pages can be converted and downloaded without an account. If a page is unreadable, a fresh scan or the bank’s original PDF gives you a better starting point. You upload the document you have, without sharing a bank login.

What do you get once the scan converts?

The output is the same as for any statement: a clean transaction table with dates, descriptions, amounts, and the running balance wherever the statement carries one. Amounts and balances export as real numeric cells, so SUM checks and pivot tables work immediately — no stripping of currency symbols or retyping. You can download the result as Excel, CSV, JSON, or OFX — the format QuickBooks, Xero and most bookkeeping tools import, written whenever the statement states a currency, a date and a closing balance; CSV covers ordinary spreadsheet work.

If the scanned PDF is password-protected, the password is used only to open the file and is never stored. And if you create a free account, your conversions stay in a workspace so you can re-export in a different format later without re-uploading the scan.