Bank statements

Scanned bank statement to Excel: first check whether the text is selectable (US)

Free converters fail on images of statements. Learn the select-text test, how to get a proper digital copy and when typing the rows yourself is quicker.

Editorial illustration for Scanned bank statement to Excel: first check whether the text is selectable (US)

Before you try any converter, test whether your statement is a real document or a picture of one. If you can select and copy the words with your cursor, the file already holds text and converts easily. If you cannot, it is an image, and free tools will give you garbled output.

The ten-second test

  1. Open the file in a PDF viewer.
  2. Try to highlight one line of transactions with your cursor.
  3. Copy it and paste it into a blank sheet.
  4. If the date, description and amount paste as readable text, the PDF is text-based.
  5. If nothing highlights, or the paste is blank, you have a scan.

A scan is a photograph of paper, so the computer sees pixels, not letters. A tool that tries to guess the letters makes mistakes, especially with small print, faint ink and tight columns.

Why do free converters struggle?

  • They read each page as one block, so the columns merge into a single stream of text.
  • They confuse similar characters, such as 5 and 6, 1 and 7, or a decimal point and a speck of dust.
  • They drop minus signs and parentheses, which turns a debit into a credit.
  • They split a long description over two rows, leaving amounts attached to the wrong line.

Get a clean copy first

Before spending an evening cleaning a scan, ask whether a digital copy exists. Your bank may offer statements for download as PDF, or as CSV, in its online banking, and a request to the branch or support may produce one. A digital file is nearly always better than any scan, so exhaust that route first. Never hand your online banking login to anyone; if a helper needs the statement, send them the file.

When is typing quicker than converting?

Say a scanned statement has 58 transaction rows over three pages. Converting might leave you checking each of 58 rows against the page anyway. Typing date, description and amount for 58 rows into a sheet means three columns by 58, and each entry is checked as you go. For a short statement, typing can be the more accurate choice.

Statement typeBest routeWatch out for
Text-based PDFCopy into a sheet or import the fileColumns merging
Scan, under about 60 rowsType it, or convert and check every rowDropped minus signs
Scan, a long historyAsk the bank for a digital copyWasted hours on poor OCR
Phone photo of paperRetake it flat and well lit, then checkSkewed lines and shadows

If you have a large pile of old scans, triage them. Decide which periods you really need, for example the last twelve months, and work backwards only as far as necessary. Older months can stay as filed images with a note in your coverage list, so you know they exist without having to convert them.

For anything you convert, record the date you did it and how you checked it, even in one line. A sheet that says 'checked against printed closing balance, matched' is far more trustworthy than one that has no note at all.

What should I do with the result?

Keep the original image next to the sheet, with the file name of the month, so you can recheck a row. Once the data is clean, save it as a CSV so it can go into your records or tracker without more editing. A tool or workflow that insists you retype every row each time is not worth the effort, so aim to get digital statements from the start.

This article gives a method only. If you need statements for a formal purpose, such as a loan application, ask the institution which format it accepts.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports