Australia
Convert bank statements in Australia
Statement formats, date and amount conventions and accounting imports for banks in Australia.
Quick answer
StatementPilot converts statements from any bank in Australia into Excel, CSV, QBO, OFX or QIF. Dates default to DD/MM/YYYY, amounts are read in Australian dollars (AUD), and exports are ready for Xero, MYOB, QuickBooks Online.
Banks in Australia
How statements in Australia are laid out
Australian statements list Debit, Credit and Balance columns with an 'Opening Balance' row and a 'Closing Balance' summary; dates usually read '05 Jan'.
Amounts and dates
Amounts use 1,234.56. Balances are frequently suffixed with 'CR' or 'DR' instead of a sign.
The usual date format is DD/MM/YYYY. When a statement is ambiguous we use the statement period and other rows to decide the order.
Account identifiers
Accounts are identified by a six-digit BSB plus an account number.
Accounting software
The most common destinations in Australia are Xero, MYOB, QuickBooks Online, Excel. Every export format is included on every plan.
Why statements still matter
Under the Consumer Data Right banks share data electronically, yet accountants and lenders still rely on PDF statements for older periods.
Frequently asked questions
Does the converter support AUD statements?
Yes. Amounts in Australian dollars are read with the local number format and the currency is carried into Excel, OFX and QBO exports.
What if my bank in Australia isn't listed?
Upload it anyway — there are no bank templates. The reconciliation check confirms whether every transaction was captured.
Which date format will my export use?
Excel and OFX use real dates. For CSV and QIF you can choose MM/DD/YYYY or DD/MM/YYYY at export time; DD/MM/YYYY is typical in Australia.
Convert your first statement in under a minute
20 free pages every month. No credit card. Every export format included.