Convert a St.George statement to checked Excel

What "reconciled" actually means here

A St.George statement carries its own proof inside the Balance column. The opening figure, adjusted by every debit and credit, has to arrive exactly at the closing balance printed on the final line. Export Bank Statement walks that arithmetic line by line. If the numbers land where they should, you get a green confirmation and you can trust the file. If they don't — say a $612.50 BPAY payment came through as $61.25, or a transaction dropped out where page four meets page five — the statement is flagged before you do anything with it.

"PDF in, spreadsheet out" is the easy part. Knowing the spreadsheet is *complete* is the harder part, and it's the check a meticulous bookkeeper runs by eye at the foot of every page. Running it automatically across a nineteen-page statement, including the lines deep in the middle where attention drifts, is the reason this tool exists.

The St.George statement layout

St.George issues statements in Australian dollars, and the transaction table reads left to right: Date | Description | Debit | Credit | Balance. The Description carries the narrative — a Visa Debit purchase, a periodical payment, a Pay Anyone transfer, a BPAY biller reference, a salary credit. Money out lands in Debit, money in lands in Credit, and the Balance on the right shows where the account stood after each movement. Splitting debits and credits into two columns is a small mercy once the data is in a spreadsheet, because you can total or filter one side without dragging the other across.

Two St.George details are worth singling out, because both can trip a careless converter.

• Dates run DD/MM/YYYY. That's the Australian convention, and it isn't cosmetic. A tool that assumes American MM/DD order will reorder every date up to the twelfth of the month, turning 07/04/2025 from the 7th of April into the 4th of July. Export Bank Statement keeps the day-first order untouched.
• The account is keyed by a six-digit BSB and a separate account number. St.George BSBs sit in the 112 range — a legacy of the bank becoming part of the Westpac Group in 2008. Those loose runs of digits are exactly the kind of thing a blunt extractor mistakes for a transaction amount, so the converter holds the BSB and account number as reference text and never treats them as money.

Convert a St.George statement to Excel: the steps

1. Get the PDF from St.George. Sign in to St.George Internet Banking or the St.George App, open eStatements, choose the account and the statement period, and download the PDF.
2. Drop it onto the converter. Upload the file at /convert. Complete Freedom, a savings account, a business transaction account — one page or eighty — it's the same upload either way.
3. Extraction and reconciliation run together. The tool reads Date, Description, Debit, Credit and Balance on every line, then checks the running balance from the opening figure through to the close.
4. Download what suits the job. Take the .xlsx for Excel or Google Sheets, or the CSV if the data is bound for Xero, QuickBooks or Zoho Books.

A single month generally finishes well under a minute — reading the four steps takes longer than running them.

When the PDF is a scan or a phone photo

Pull a statement straight from St.George Internet Banking or the app and you'll usually get a proper text-based PDF, where the figures read cleanly on the first pass. Older paperwork is the exception. A statement scanned at a branch, or a page snapped on a phone, is just an image — there's no selectable text under it for any tool to read. OCR is what bridges that gap, lifting the AUD amounts and dates off the picture so the page can be reconciled like any other.

Those image copies turn up more than people expect: a few years of statements gathered for a home-loan application, a printed "proof of balance" that's since been rescanned, the accountant chasing a paper trail at tax time. However the file arrives, it goes through the same balance check once it's read.

Skip the retype

Highlighting a St.George statement inside the PDF and pasting it into Excel holds up for about ten seconds. Then a date and an amount jam into a single cell, a long Pay Anyone narrative spills onto the row beneath, and the Debit and Credit columns shear apart by a few cents. So you start fixing it by hand, and hand-keying is precisely where the quiet errors creep in — $1,280 typed as $1,820 looks perfectly fine on screen, and there's nothing to catch it. Retyping a 70-line Complete Freedom account can eat most of an hour and still leave you unsure it balances. The converted version is checked for you, and one glance at the confirmation tells you whether it ties out.

Sending a St.George statement to Xero, QuickBooks or Zoho Books

For accounting software, choose the CSV over the .xlsx. Export Bank Statement writes it in the native bank-import layout Xero, QuickBooks and Zoho Books expect (the Xero and QuickBooks files come with the paid plans; the Zoho Books CSV is free), so Date, Debit, Credit and the description map straight in without you reshaping columns. Most Australian bookkeepers reconcile in Xero, and the route is simple: convert the St.George PDF, then upload the CSV under that account's bank statement import. There's a step-by-step in importing PDF bank statements into Xero, and the Xero integration page covers the read-only connection.

Worth being straight about one thing. This is a file import, not a live bank feed. Export Bank Statement doesn't push transactions into Xero through a certified bank-feed API — you convert, then import the CSV, and it lands as reconcilable statement lines. When you're working from PDFs after the fact, that's the better path anyway, because you already know the file balances before it touches your ledger.

There's a built-in analyser too, if you want more than a grid of rows: cash flow, income verification, spending categories, recurring-payment detection and a statement health check. Files are processed and then deleted straight away, and never used to train AI.