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.
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?
Is a transaction report the same as a statement?
Any bank, any country