Bank statements

Photographed a paper statement? How to get usable rows from the image (UK)

A phone photo of a printed bank statement can be turned into rows, if the photo is good and you verify the numbers. Practical steps and checks in pounds.

Editorial illustration for Photographed a paper statement? How to get usable rows from the image (UK)

A paper statement photographed on your phone can give you usable rows, but only if the photo is flat, sharp and evenly lit, and only if you verify the result against the printed balances. Poor photos are the main reason conversion goes wrong.

Take the photo properly

  • Lay the page flat on a plain, dark surface. A curved page bends the lines of text.
  • Use daylight or an even lamp. Avoid a shadow from your phone or hand falling across the page.
  • Hold the phone parallel to the page, directly above it, so the columns stay straight.
  • Photograph one page at a time and fill the frame without cutting off the edges.
  • Check you can read the smallest numbers when you zoom in. If you cannot, the software will not either.

Where do conversions go wrong?

Even a good photo can produce errors. The most frequent are a lost minus sign, a 1 read as a 7, a comma read as a full stop, and two lines merged into one. The costly ones are the amounts, because a wrong figure moves your balance.

Check each page with a running balance

Most printed statements show a balance after each line. Use that. Type the converted rows into a sheet with columns for date, amount and your own running balance. Say a page starts at £1,418.60 and the first four lines read -£32.15, -£9.99, +£850.00 and -£120.00.

LineAmountExpected balancePrinted balance
1-£32.15£1,386.45£1,386.45
2-£9.99£1,376.46£1,376.46
3+£850.00£2,226.46£2,226.46
4-£120.00£2,106.46£2,106.46

If a row's expected balance differs from the printed one, that row, or the one just before it, was misread. Compare it with the original image.

Can I automate the balance check?

Yes. With amounts in column C starting at row 2 and your opening balance in F1, put =F1+C2 in D2, and =D2+C3 in D3, copying down. In column E, type the printed balance, and in column F put =ROUND(D2-E2,2) to see any difference. A non-zero value marks the line to inspect.

Which rows deserve the most care?

  1. Large amounts, because a slip costs the most.
  2. Credits and refunds, which are the rows that lose their signs.
  3. Rows near the page break, where lines get split.
  4. Any amount ending in 0, 5 or 6, which are easily mistaken for each other.

Some phones have a built-in document scanner that straightens and sharpens a page automatically. If yours does, use it instead of the ordinary camera, because it corrects the angle and the contrast for you. The result is still an image, so the same checks apply, but there are usually fewer misread characters to fix.

Resist the urge to improve a poor photo by heavy editing. Brightening and sharpening can create false characters that look convincing and are wrong. Retaking the picture is almost always the better choice.

If you only need a handful of rows, for example to evidence a single payment, you may not need to convert anything: crop the relevant lines from the photo, keep it with a note of the date and amount, and move on.

What should I keep?

Keep the photograph of each page in a folder named by month, next to the finished sheet. If a figure is queried later, you can go back to the original. Do not share the images publicly, because statements hold personal details, and do not send them to anyone you do not trust. Banks differ in how long they provide older statements, so check your own accounts for what is available.

SPENDIXAI JOURNAL

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

Explore your reports