Convert ANZ statement PDFs to Excel, Xero and CSV.
Xero, MYOB, Excel files from the PDF.
ANZ does not password-protect statement PDFs in Australia or New Zealand. 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.
Drop your ANZ statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in AUD.
Last updated
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 of ANZ statements at once come back as one workbook.
Is the ANZ 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.
Why not 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.
Where ANZ statements trip up converters
- Both AU and NZ layouts are handled; the currency is taken from the statement, not assumed.
Which software ANZ customers import into
ANZ customers most often import into Xero, MYOB, Excel.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
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 it from ANZ using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
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.