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.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your ANZ statement into Excel

  1. 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.
    Go to ANZ Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. 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.

sample-statement-2026-01.xlsx Jan 2026 · AUD
Sample bank statement rows with made-up data, amounts in AUD
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 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.

    Files for QuickBooks Online

    Files for Xero

  • 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?
Not from the Internet Banking download, which only reaches back two years for open accounts. Save the statement PDFs for the periods you need and convert them here instead. Each file becomes a table with YYYY-MM-DD dates and one signed amount per transaction, ready for Excel or an accounting import.
I bank with ANZ Plus. Where are my statements?
They're under the Profile icon, then Statements, which is not where Internet Banking keeps them. Save the statement you need from there and upload it. The conversion doesn't depend on which service produced the PDF, and you get the same Excel and CSV options either way.
Should I convert the Transaction Report or the statement?
Use the statement whenever one covers the period, because its opening and closing balances let the converter confirm nothing is missing. A Transaction Report is useful for the weeks since your last statement was issued. If you upload both for the same dates, expect the overlap to be flagged.
Can I import converted ANZ rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your ANZ statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by ANZ.