Convert Australian bank statements.
Xero and MYOB files from the PDF.
Australian statements are generally one clean table with a balance on every row, which makes them the easiest to check. What trips people up is the six-monthly cycle at some banks, the DR and CR markers instead of minus signs, and app banks that export a CSV with three amount columns. Xero and MYOB dominate here, and both import the CSV formats produced below; these pages describe each bank's statement and export.
Drop a Australian bank statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Australian dates and AUD amounts are read from the statement itself; there is no country setting.
Last updated
Australian banks with their own page
How Australian statements are laid out
Dates are day first, DD/MM/YYYY or day and short month, with the year on the row or in the header. Amounts use a point for decimals and a comma for thousands, in Debit and Credit (or Withdrawals and Deposits) columns, and an overdrawn or credit-card balance is marked DR or CR after the figure at CommBank and others rather than with a minus. Transaction and savings account statements are monthly at most banks but six-monthly at Macquarie and quarterly at Up, so a single PDF can hold twenty pages. BPAY, PayID and Osko descriptions carry reference numbers that wrap onto a second line.
What to know before converting Australian statements
- DR and CR balance markers are read as signs, so an overdrawn month reconciles instead of failing on a positive number that should be negative.
- App exports (Westpac, Up) often list newest first; rows are put into date order and the balance check says so.
- Up's CSV has Subtotal, Fee, Round Up and Total (AUD) columns; only Total (AUD) moves the balance.
- Offset accounts attached to a home loan are statemented with the loan at some banks; convert the offset pages on their own.
- ANZ New Zealand statements follow the same layout in NZD; the currency is taken from the statement.
Who asks for Australian statements, and in what form
The ATO expects BAS and income tax figures to be supported by bank records for five years, and sole traders without software rebuild the year from statements at tax time. Lenders assessing a home loan ask for three months of statements for every account, and self-managed super fund auditors want the fund's bank statements for the whole financial year.
Importing Australian statements into Xero or MYOB
Australian bookkeepers usually import into Xero, MYOB, QuickBooks Online, Excel.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
Australia and New Zealand questions
How do I get the converted statement into MYOB?
MYOB Business imports bank transactions from a CSV, OFX, QIF or QFX file through the bank feeds screen. Use the plain CSV download and map Date, Description and Amount (or the Money Out and Money In pair) when MYOB asks. AccountRight imports the same file through Banking, Bank Feeds, Import Statement.
My six-monthly Macquarie statement is twenty pages. Is that one upload?
Yes, up to 60 pages per file. It comes back as one table with the opening balance at the start of the period and the closing balance at the end, and the running balance on every row is checked in between. Filter the Excel by month afterwards if you post monthly.
Are statements from the Australian app banks and neobanks supported?
Yes. Up and the app exports from the big four are read the same way as a mailed statement, because the check depends only on the printed opening and closing balances and the rows between them. Where the app also offers a CSV or OFX export, that file can be uploaded instead of the PDF and is charged at one page per 4,000 characters.