Convert your ANZ bank statement to Excel or CSV

Upload an ANZ statement PDF and get a clean spreadsheet built for its split Withdrawals and Deposits columns, opening balance row and day-first Australian dates.

  • CSV
  • Excel

Drag & drop or click here

  • Secure encrypted upload
  • We never sell or share your data
  • Totals checked against your statement

ANZ statements use a ledger-style table with separate Withdrawals and Deposits columns, a Balance column, and an OPENING BALANCE row before the transaction activity. Copy-pasting that PDF into Excel often loses which side an amount came from and leaves the opening balance mixed in with real transactions.

This converter is tuned for the verified ANZ sample layout. It reads withdrawals and deposits from their own columns, preserves the running balance ANZ prints on the day's last row, infers the missing year from the statement period, and keeps long Visa Debit descriptions together instead of splitting them across columns.

How ANZ statements are laid out

The verified ANZ sample lists transactions in five columns: Date, Transaction Details, Withdrawals ($), Deposits ($), and Balance ($). The statement opens with an 'OPENING BALANCE' row. Dates are printed day-first as DD Mon, such as 12 Aug, without a year on each row. The Balance column is shown on the day's last row, and card-purchase descriptions can include an effective date and card last-4 inside the description text.

Transaction columns
Date · Transaction Details · Withdrawals ($) · Deposits ($) · Balance ($)
Date format
DD Mon (e.g. 12 Aug); the year is inferred from the statement period
Length
Multi-page
File type
Digital PDF (text-based)
Password protected
Usually no
Currency
AUD

How to download your statement from ANZ

  1. 1

    Sign in to ANZ Internet Banking

    Log in to ANZ Internet Banking or the ANZ app with the profile that can view the account statement.

  2. 2

    Choose the account

    Select the transaction, savings or card account whose statement you need to convert.

  3. 3

    Open statements

    Open the statements or documents area for that account and pick the statement period you want.

  4. 4

    Download the PDF

    Download the statement as a PDF. Use the original digital PDF when possible rather than a scan or screenshot.

  5. 5

    Upload it here

    Upload the ANZ PDF to convert the transaction table into Excel or CSV with debit, credit and balance fields preserved.

ANZ conversion quirks we handle

  • Split amount columns: ANZ separates money out and money in into Withdrawals ($) and Deposits ($), so the converter signs transactions from the column position instead of guessing from the description.

  • OPENING BALANCE row: the statement begins with an opening-balance line that must seed reconciliation without being exported as a normal transaction.

  • Day-first dates with no year: rows use DD Mon dates such as 12 Aug, so the converter takes the year from the statement period.

  • Balance on the day's last line: the running balance is shown on the last transaction for a day, not necessarily every row, so the converter carries it through the grouped transactions.

  • Long Visa Debit descriptions: card-purchase rows can include merchant, city, card last-4 and an EFFECTIVE DATE such as 'VISA DEBIT PURCHASE CARD 8879 ... EFFECTIVE DATE 11 AUG 2024'. The converter keeps that text as one description.

ANZ bank statement FAQ

Does it handle ANZ withdrawals and deposits as separate columns?+

Yes. The converter reads ANZ's Withdrawals ($) and Deposits ($) columns separately, then signs each transaction correctly in the Excel or CSV output.

How does it treat the ANZ opening balance row?+

The OPENING BALANCE row is used for reconciliation, not exported as a normal payment. That keeps the transaction list clean while still checking totals against the statement.

What happens when ANZ dates do not show a year?+

ANZ rows in the verified sample use DD Mon dates without a year. The converter infers the year from the statement period so August and year-boundary statements stay correctly dated.

Will Visa Debit descriptions stay intact?+

Yes. Long ANZ card rows, including merchant text, card last-4 and embedded EFFECTIVE DATE details, are kept together as the transaction description.

Is it safe to upload an ANZ statement?+

Your file is uploaded over an encrypted connection, we never sell or share your data, and totals are checked against your statement during conversion.

Other Australia bank statement converters

Convert to a specific format

Need a different bank or format? Our bank statement converter converts any bank statement into clean Excel and CSV.

Convert a ANZ statement now