Export Bank Statement — bank statement PDF to Excel
ANZ logo
account_balanceAustralia bank

Convert a ANZ statement to checked Excel

Drop your ANZ PDF here — scanned ones too. Every transaction is checked to balance before you download.

  • check_circlePersonal & business
  • check_circleScanned PDFs too
  • check_circleXero-ready
cloud_upload

Drop your ANZ statement

Scanned ones too. Get clean, reconciled Excel or CSV in seconds.

verifiedTotals reconciled ✓

schedule3 min read · Australia bank guide

bolt

Upload an ANZ statement PDF and every transaction comes back as clean rows — date, description, debit, credit and the running balance — checked so the closing figure ties out. Export to Excel, CSV, or an import file for Xero, MYOB or QuickBooks.

Where ANZ statements get fiddly is the card-purchase detail. A single debit-card line often carries the merchant name, the location and the date the purchase was actually made — which can differ from the date it was processed — and all of that is packed into the description. It reads fine on paper and falls apart in a copy-paste.

What an ANZ statement looks like

An ANZ transaction account statement uses these columns:

Column

What's in it

Date

The processing date, `DD Mon YYYY`

Transaction

The payee or, for cards, the merchant, location and purchase date

Debit

Money out

Credit

Money in

Balance

Running balance after the transaction

The detail worth protecting is in the Transaction column. A card purchase might read as a merchant, a suburb and the original purchase date, then wrap onto a second line — which a rough export reads as its own row and shoves into the balance column. The converter keeps the whole purchase on one transaction, so you're not left reconciling a merchant name against a stray date. Direct debits, BPAY payments and transfers each keep their full detail the same way.

Because ANZ operates across both Australia and New Zealand, some customers hold accounts in both; each statement keeps its own country's currency and balance rather than being mixed together.

Where to download your ANZ statement

  1. ANZ Internet Banking: log in at anz.com.au, choose the account, open Statements, select the period and download the PDF.
  2. ANZ app: tap the account, go to Statements, pick a statement and save the PDF.

A statement downloaded from Internet Banking is a digital PDF with selectable text, so the conversion is exact. If you only have a scan or a photo of a mailed statement, the converter reads it with OCR — that just takes a little longer.

Getting the numbers where you need them

  • Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total and filter.
  • Xero or MYOB — an import-ready bank file so the lines arrive as statement entries to reconcile.
  • QuickBooks, Zoho and others — the same data in each one's format.

The figures are reconciled before download: opening balance, plus credits, minus debits, must reach the closing balance. Where card lines carry two dates, that check is what confirms each purchase landed on the right row rather than being split across the wrong day.

Common snags with ANZ statements

  • Card detail wrapped over two lines. Merchant, location and purchase date are kept on the one transaction.
  • Purchase date vs processing date. Both stay with the transaction instead of being read as separate entries.
  • Business accounts. ANZ business transaction-account statements use the same layout, so the same conversion works.

Frequently asked questions

Can I convert an ANZ statement to Excel for free?keyboard_arrow_down

Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the running balance checked so the import lines up.

Why do my ANZ card purchases come out split in other tools?keyboard_arrow_down

Because a card line carries the merchant, location and purchase date, often wrapped onto a second line. Tools that read line by line treat the overflow as its own row. This one keeps the whole purchase on one transaction.

Can I import it into Xero or MYOB?keyboard_arrow_down

Yes. Export an import-ready bank file and the transactions arrive as statement lines you reconcile as usual in Xero, MYOB or QuickBooks.

Will it read a scanned ANZ statement?keyboard_arrow_down

Yes, with OCR. A PDF downloaded from Internet Banking will always convert faster and cleaner than a scan.

Straight into your software

Convert ANZ to your accounting software

More banks

Other Australia banks

Related guides

Import it into your accounting software

verifiedChecked to balance

Convert your bank statement — every transaction verified

Upload any PDF, get clean Excel or CSV ready for Xero & QuickBooks. Scanned statements too.

upload_fileConvert a statement free