Bank statements

Scanned bank statement to Excel in Australia: what works, what fails

Why free tools choke on a scanned or photographed bank statement, what to try instead, and how to check every figure in A$ before it reaches your spreadsheet.

Editorial illustration for Scanned bank statement to Excel in Australia: what works, what fails

A scanned bank statement is a picture of numbers, not numbers, so free converters either refuse it or hand back columns full of small mistakes. The reliable fix is to avoid the scan altogether and get a digital copy of the statement; if you truly only have paper, you can still end up with a trustworthy sheet by checking every line against the printed balances.

How can I tell if my statement is a picture or real text?

Open the PDF and try to drag-select a single amount with your cursor. If the amount highlights and you can paste it into a notepad, the file contains real text and almost any converter or a plain copy and paste into Excel will do. If nothing highlights, or the whole page highlights as one block, you are looking at an image, however sharp it appears. Photos taken on a phone and pages run through an office scanner are always images.

Image files need optical character recognition, which guesses each character from its shape. Free versions guess well on clean print and badly on faint ink, creased paper, shadows from a phone camera and the small grey text banks often use for running balances.

What to try before you convert a scan

  1. Log in to your own online banking and look for a way to download statements as PDF or CSV for the months you need. Describe what you find from your own screen; menus differ from bank to bank.
  2. If only older months are missing, ask the bank through its usual help channel for copies of those statements. Say the exact months and the account nickname you use.
  3. If the paper copy is all you have, scan at a high resolution on a flat bed, or photograph it in even light with the page filling the frame and the phone held square above the paper.
  4. Run the scan through a character recognition tool, then paste the result into a blank sheet, never over your main one.

The balance check that catches every misread digit

Whatever tool you use, a statement carries its own proof. The opening balance plus everything that came in, minus everything that went out, must equal the closing balance. A single misread digit breaks that sum, which is why it is the best test you have.

Say a month starts at A$2,450.00 and the sheet shows these rows:

LineAmount in A$Direction
Pay from employer3,200.00In
Supermarket186.40Out
Rent1,450.00Out
Phone plan65.00Out
Fuel92.35Out

Money out adds up to 186.40 + 1,450.00 + 65.00 + 92.35 = A$1,793.75. So the closing balance should be 2,450.00 + 3,200.00 - 1,793.75 = A$3,856.25. If the printed closing balance reads A$3,856.25, every row is probably right. Now imagine the recognition tool read the supermarket line as 786.40 instead of 186.40. Your total out becomes A$2,393.75 and your closing figure A$3,256.25, exactly A$600 short, and the gap points straight at a digit that was misread as a 7. Gaps that are round numbers usually mean one wrong digit; gaps that are odd amounts usually mean a missing or duplicated row.

Why do free converters mangle columns?

  • Statement tables use thin or invisible gridlines, so the tool cannot tell where one column ends and the next begins.
  • Dates, descriptions and amounts sit in one long text line, so everything lands in a single cell.
  • Minus signs, brackets and the letters CR or DR beside amounts get dropped or turned into a different character.
  • A thousands comma gets read as a full stop, which turns 1,450.00 into something your sheet reads as text.
  • Multi-line descriptions are split into extra rows with no date or amount.

None of this means the tool is broken. Statements are laid out for human eyes, and pictures remove the structure that software relies on.

What should I do once the rows are clean?

Add a column for the account nickname and a column for the month, then store one sheet per account per year instead of one giant sheet. Keep the original scan or PDF in a folder named the same way, such as 2025-03 Everyday account, so any figure can be traced back to its source in a minute.

SpendixAI is built around India and INR, so it is not aimed at Australian banks. Its approach is still worth borrowing: choose the account first, import one statement at a time, and review the rows before anything is saved.

Quick checklist for a scanned statement

  • Is the PDF selectable text? If yes, skip the recognition step.
  • Is a digital copy obtainable from your bank? If yes, use it.
  • Does opening balance plus money in, minus money out, equal the printed closing balance for each month?
  • Are the originals filed so each row can be traced back?
  • Have you kept the recognition output in its own sheet, separate from your clean one?
SPENDIXAI JOURNAL

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

Explore your reports