ANZ Bank Statement to Excel Converter

Converting ANZ Statements to Excel

ANZ statements put each amount in either a withdrawals column or a deposits column, with a running balance on the right. That is easy to read on paper, but when you copy the table into a spreadsheet the two columns often collapse into one, amounts come through as text, and longer card descriptions split over two rows. Finlyzers reads the statement as a table, keeps withdrawals and deposits apart, and checks that the balance still adds up.

How an ANZ Statement Is Usually Presented

• Header: account name, BSB and account number, and the statement period.
• Summary: an opening balance, totals withdrawn and deposited, and a closing balance.
• Transaction table: commonly labelled Date, Transaction Details, Withdrawals ($), Deposits ($) and Balance ($).
• Balance lines: opening and closing balance lines are balances rather than transactions, so they are left out of the transaction list and used for the balance check.

Everyday accounts such as ANZ Access Advantage, savings accounts such as ANZ Online Saver, and ANZ business accounts broadly follow this pattern. Labels can differ slightly between account types and older statement versions.

Reading ANZ Transaction Details

Australian statements spell payment types out in words. The wording below is typical of what you will see, but it varies:

• Visa Debit purchase: card spending, usually with part of the card number, the merchant and the location.
• EFTPOS: purchases made by choosing the savings or cheque option at the terminal.
• Payment from / Transfer from: money received, including salary and transfers from other people. Fast payments may show Osko or a PayID reference.
• Payment to / Transfer to: money sent from ANZ Internet Banking or the ANZ App.
• BPAY: bills paid through BPAY to a named biller.
• Direct debits: regular amounts collected by businesses such as insurers, phone providers or lenders.

Keeping the full wording in the Description column lets you filter in Excel, for example on Visa Debit to review card spending for a month.

When a PDF Is the Only Source

ANZ's own transaction export is fine for recent activity on accounts you can sign in to. You will usually need to convert the PDF when:

• You need transactions from further back than the export reaches.
• The account is closed, or belonged to a family member whose affairs you are managing.
• You are an accountant or bookkeeper and a client has emailed you their statements.
• A mortgage broker has asked for statements and you want to check the figures in a spreadsheet first.
• You only have a printed statement that you have scanned.

Using ANZ Data for Tax and Bookkeeping

• Sole traders and small businesses: import into accounting software, code each transaction and reconcile before preparing a BAS. Download QBO for QuickBooks Online, or OFX or CSV for Xero. For MYOB, check which bank statement file formats your edition imports.
• Individual tax returns: total interest earned, donations and work-related purchases for the financial year from 1 July to 30 June.
• Investment properties: list rent received and expenses such as rates, strata and repairs, and keep the spreadsheet with your property records.
• Household budgets: pivot a few months of card spending by merchant to see where the money goes.

Whichever software you import into, make sure it expects DD/MM/YYYY dates, otherwise days and months can be swapped.

Other Australian Banks

Statements from other major banks work the same way. If you also have accounts with the Commonwealth Bank, use the CommBank statement converter, and for Westpac accounts the Westpac statement converter.

Converting an ANZ credit card statement? Use the credit card converter, which keeps purchases and payments in separate columns. For paper statements, try the scanned statement converter.