Convert ANZ statements to Excel.
Checked to the cent.
Drop a ANZ PDF and get a clean spreadsheet, QuickBooks or Xero file in seconds. Every row is checked against the balances printed on the statement, so a misread is flagged, not hidden.
Drop your bank statements here
One file or a whole year. PDF, scanned image, CSV, QIF or OFX. Up to 12 files at a time; long PDFs are split for you.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in AUD.
How to download a ANZ statement as a PDF
- Log in to ANZ Internet Banking and select the account from the homepage.
- Click View statements in the left-hand menu, then choose the account from the dropdown if you hold more than one.
- Click Download beside the statement you want. It opens in a new browser window, so allow pop-ups.
- Use the browser's save or print icon to store the PDF.
- In the ANZ App: tap the account, then the Statements tab, tap the statement and use the share icon top right. Closed accounts are under More, then View statements.
Then drop the file above. Several months at once is fine; a year comes back as one workbook with a sheet per month.
Before you upload: is the PDF password-protected?
ANZ does not password-protect statement PDFs in Australia or New Zealand. If a file will not open in the app, ANZ's own advice is that it is too large and to download it from Internet Banking instead.
What ANZ statements look like
Date, Transaction details, Withdrawals ($), Deposits ($), Balance ($) with opening and closing balance rows.
The Australian layout is Date, Transaction Details, Withdrawals ($), Deposits ($), Balance ($), with an Opening Balance row on page one and Totals plus a Closing Balance at the foot. Everyday accounts are statemented monthly or quarterly and most run two to four pages; a business account with EFTPOS settlements can be ten or more. ANZ New Zealand statements are a different document, closer to Date, Details, Amount and Balance with a single signed amount column, and the currency is NZD, so the converter reads the currency off the page rather than assuming AUD from the logo. Card purchases carry the merchant, a location and sometimes a foreign currency amount on a second line, which is folded into the description.
Where ANZ statements trip up other converters
- Both AU and NZ layouts are handled; the currency is taken from the statement, not assumed.
None of this is bank-specific configuration. The balance check catches these cases for every bank; this list just explains what you will see on a ANZ file.
Why not just use ANZ's own export?
From the Transactions tab in Internet Banking there is a Download button offering a time period and a software package dropdown, which covers CSV, TSV, QIF and OFX. It reaches back two years for open accounts only, and the plain CSV gives date, amount and description without a running balance, so a missed row is invisible until the bank reconciliation fails. There is also a Transaction Report for the last 30, 60, 90 or 120 days, but that is a PDF, not data. Statements themselves are kept for up to seven years, which is why converting them is the route for anything older or for a closed account.
What you get back
- A green Balanced badge when the printed opening balance plus money in minus money out equals the printed closing balance, row by row. Or a red one pointing at the first row that does not add up, with a one-click swap if debit and credit look reversed.
- Click any misread cell, correct it, and the check re-runs before you download.
- Download Excel, CSV, QuickBooks (.qbo), Xero CSV or Tally XML, whichever Xero imports best, with a suggested category on every row.
Importing into Xero, MYOB, Excel
ANZ questions
I bank with ANZ in New Zealand. Is that the same as the Australian statement?
No, and the converter does not treat it as one. ANZ NZ uses its own column set and its own online banking, so the parser detects the layout and the NZD currency from the document itself. The output columns are the same either way: date, description, debit, credit, balance.
The ANZ CSV has no balance column. Does that matter?
It matters when something is missing or duplicated, because there is nothing on the row to catch it. The PDF statement has a running balance on every line, and the converter checks each row against it, so a dropped transaction is reported rather than silently carried into your books. That is the main reason to prefer the statement over the export for month-end work.
How do I convert a ANZ statement PDF to Excel?
Download the statement PDF from ANZ online banking or the app, drop it on this page, and wait about 10 to 40 seconds. You get every transaction in a table, a balance check against the printed opening and closing balance, and Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
Do I need a ANZ template?
No. The statement is read the way a person reads it, so ANZ layout changes do not break anything. What protects you is the balance check: opening balance plus money in minus money out must equal the printed closing balance, row by row.
Does it work with scanned ANZ statements?
Yes. Scanned PDFs and phone photos are read visually. Blurry pages may produce a flagged row; the check tells you exactly which one to look at.
Can I import ANZ transactions into Xero?
Yes. For Xero, download the Xero CSV and use Import a Statement on the bank account. Excel and CSV work everywhere else, including MYOB.
How many ANZ statements can I convert at once?
Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.
What happens to my statement?
It is processed once and deletion is attempted as soon as processing finishes; an AWS lifecycle rule removes anything left behind. The extracted table becomes eligible for deletion after 7 days (1 day without an account). Nothing is used for training.