Convert ANZ bank statements to Excel or CSV
ANZ's Internet Banking download is fine for recent months, but it stops at two years, and anything older sits in statement PDFs. This page is for bookkeepers, tax agents and account holders who need those ANZ statements as rows in a spreadsheet: a prior financial year, a loan application, or a client who only kept the PDFs. Upload the statement and you get Excel or CSV you can check line by line.
Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.
Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your ANZ statement into Excel
-
Download the PDF statement from ANZ online banking
- Log in to ANZ Internet Banking or the ANZ App.
- In Internet Banking, select your account and click 'View statements' on the left; in the app, select your account and tap 'Statements'.
- Choose the account from the dropdown list and click 'Download' to open the statement (in the app, tap the statement and the share icon to download or print).
- Save the statement for the period you need as a PDF.
-
Upload it here
Scans and phone photos work too.
-
Download Excel, CSV, or QuickBooks and Xero CSV
Check the rows against the statement, then export.
Sample result
Your ANZ statement in Excel
Made-up sample rows, not a real statement.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | Card payment - Fictional Coffee Co | 15.00 | 2,385.00 |
Statement notes
What to know about ANZ statements
The CSV download stops at two years
ANZ describes its transaction download as covering the last two years for open accounts. If you are catching up on an older financial year, or the history you need sits outside that window, the statement PDF is the record you have to work from. Converting it gives you the same kind of rows the recent download would have produced.
Transaction Reports overlap statements
Internet Banking can produce a Transaction Report for the last 30, 60, 90 or 120 days, and people often save these next to their regular statements. A report's dates rarely line up with a statement cycle, so the same purchases can turn up twice. Duplicate and overlapping periods are flagged, which lets you drop the repeats before they reach the ledger.
Debit and credit columns
Statement PDFs print withdrawals and deposits in their own columns beside a running balance. In the output each line carries one signed amount: money out negative, money in positive. The rows are then added to the opening balance and compared with the closing one, so a missed or misread line shows up before you import anything.
Online statements are scanned copies
ANZ describes its online statements as scanned copies of paper statements, produced monthly, quarterly or half-yearly. A scanned page may have no text layer at all, which is why copy-paste often fails outright. The converter reads scanned pages with OCR, and the balance check then shows whether every figure was read correctly.
Output and review
From ANZ PDF to your books
Accounting tip
Xero takes the Xero-ready CSV through its manual statement import. Amounts sit in one signed column, positive for money in and negative for money out, which is how Xero's own template works. MYOB is different: its statement import accepts QIF or OFX files rather than CSV, so plan that route separately.
-
Checked before export
Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.
-
Export formats
Excel, CSV, JSON, or QuickBooks and Xero CSV.
-
Private workspace
HTTPS uploads, kept private until you ask support to delete them.
FAQ
ANZ statement questions
Can I get ANZ transactions older than two years into Excel?
I bank with ANZ Plus. Where are my statements?
Should I convert the Transaction Report or the statement?
Can I import converted ANZ rows into QuickBooks or Xero?
Convert your ANZ statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by ANZ.