Convert a Bendigo Bank statement to checked Excel

Bendigo Bank runs a community-branch model that ties a lot of small towns and their businesses to the bank, so its statements often belong to a sole trader, a club or a local enterprise squaring up the books. Whoever's reconciling, the job is the same: a PDF has to become rows before you can sort, total and import it.

What a Bendigo statement looks like

A Bendigo transaction account statement uses these columns:

The Description tells you what each line was — a card purchase, a bill, a transfer, a fee — and on a longer entry it spills onto a second line. Left to a copy-paste, that second line becomes a phantom row and the debit and credit figures shift out of place. The converter pulls each description back onto its own transaction, so a Bendigo month arrives whole and in order.

It's worth knowing Bendigo owns the app-only bank Up; if you hold both, each produces its own statement, and the converter keeps them separate rather than merging the balances.

A community bank's paperwork

Bendigo's community-branch model means a large share of its accounts belong to local outfits — a sporting club, a co-op, a family business, a not-for-profit. Those are exactly the accounts where someone volunteers to do the books, often without an accounting background, and where a year of statements has to be made sense of at once. Turning each statement into rows is what lets a treasurer total the year, group the spending, and hand a committee or an accountant something clear — rather than reading forty pages of PDF line by line.

Where to download your Bendigo statement

1. Bendigo e-banking: log in at bendigobank.com.au, choose the account, open Statements, select the period and download the PDF.
2. Bendigo Bank app: tap the account, go to Statements, pick a statement and save the PDF.

A statement downloaded from e-banking is a digital PDF with selectable text, so the conversion is exact. If you only have a scan or a photo of a mailed statement, the converter reads it with OCR — that just takes a little longer.

Getting the numbers where you need them

• Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total and filter.
• Xero or MYOB — an import-ready bank file so the lines arrive as statement entries to reconcile.
• QuickBooks, Zoho and others — the same data in each one's format.

The figures are reconciled before download: opening balance, plus credits, minus debits, must reach the closing balance. For a treasurer or a sole trader working without an accounting team, that automatic check is the safety net — it flags a line that slipped rather than letting it quietly break the year's totals.

Common snags with Bendigo statements

• Second-line descriptions. A payee that overflows onto the next line is joined back to its transaction.
• Club and community accounts. Treasurer accounts convert the same way, so a year totals in minutes rather than an evening.
• Up accounts stay separate. If you also bank with Bendigo-owned Up, each statement keeps its own balance.