Australian bank statements into Excel and Xero

Australian banks are good with exports for recent months: CommBank, Westpac, ANZ and Bendigo Bank all download transactions. The trouble starts with older financial years, closed accounts and statements a client sends instead of a login. Those are PDFs, with debits and credits in separate columns and sometimes six months on one statement. Pick your bank, or upload one.

Currency
Australian dollars (AUD)
Date order
Day first, DD/MM/YYYY or '03 Feb'
Money columns
Debit, credit, balance
Common imports
Xero, MYOB, QuickBooks Online

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.

Banks

Australian banks and what their statements do

Big four 4

  • CommBank

    NetBank files statements by financial year and now exports transactions as CSV only, without OFX or QIF.

  • Westpac

    Exports and reports offer CSV, QBO, QIF and OFX; closed accounts keep seven years of statements.

  • ANZ

    The transaction download stops at two years, and online statements are scanned copies of paper ones.

  • NAB

    Most accounts get a statement every six months, and up to 25 download at once.

Challenger and regional banks 6

  • Macquarie Bank

    Downloads include only the rows visible on screen; statement history runs 2 to 10 years by account.

  • St.George Bank

    Personal Internet Banking gives eStatements and a 'Transaction listing' PDF, but no CSV.

  • Suncorp Bank

    eStatements reach back to 1 July 2013; ANZ acquired the bank in July 2024.

  • Bendigo Bank

    Downloads cover 18 months, while statements for open accounts go back seven years.

  • BOQ

    Two platforms, myBOQ and Classic, and interim statements that overlap the next regular one.

  • ING Australia

    Interim statements cover the days since your last one, so they overlap the next statement.

Statement layout

What Australian statements look like

Debits, credits and day-first dates

Most statements print debits and credits in separate columns beside a running balance, and dates day first, often as '03 Feb' with the year left to the statement period. Each row comes out with one signed amount, and the year is filled in across 31 December.

Long statements and look-alike reports

NAB sends most accounts a statement every six months, so one PDF can hold hundreds of lines. Transaction reports, listings and interim statements cover days the regular statements cover too; upload them together and the overlap is flagged.

Financial years, not calendar years

Books and tax returns run from 1 July to 30 June. CommBank groups statements by financial year; elsewhere, collect every statement that touches July to June and let the period check confirm the run is complete.

Output and review

What you get, and the checks behind it

Each statement turns into rows of date, description, signed amount and balance, as Excel, CSV or JSON, or as a CSV laid out for Xero or QuickBooks. The rows are added from the opening balance and have to reach the closing one. In your account, statements for the same account are compared by period, so a gap, an overlap or a duplicate shows up before export.

Benchmark vs free tools

Xero, MYOB and QuickBooks

  • Xero

    Import the Xero CSV through manual statement import. Xero can't read a PDF, and it keeps your column mapping after the first file.

    Step-by-step import guide
  • MYOB

    MYOB's statement import takes QIF or OFX, not CSV. Use your bank's own QIF or OFX download where it reaches, and reconcile older periods against the converted rows.

  • QuickBooks Online

    QuickBooks Online in Australia takes a three-column Date, Description and Amount CSV, which is how the QuickBooks CSV is built.

    Step-by-step import guide

FAQ

Questions about Australian bank statements

Why convert when my bank already exports CSV?
Exports only reach so far: two years at ANZ and NAB, 18 months at Bendigo Bank. Statements go back further, closed accounts included at Westpac, and carry the opening and closing balances a reconciliation starts from.
Is a transaction report the same as a statement?
No. NAB's recent-transactions PDF, ANZ's Transaction Report and St.George's Transaction listing are reports. They convert the same way, but lenders and auditors usually want the statement.

Any bank, any country

Bank statement converter