Export Bank Statement — bank statement PDF to Excel
ANZ NZ logo
account_balanceNew Zealand bank

Convert a ANZ NZ statement to checked Excel

Drop your ANZ NZ PDF here — scanned ones too. Every transaction is checked to balance before you download.

  • check_circlePersonal & business
  • check_circleScanned PDFs too
  • check_circleXero-ready
cloud_upload

Drop your ANZ NZ statement

Scanned ones too. Get clean, reconciled Excel or CSV in seconds.

verifiedTotals reconciled ✓

schedule3 min read · New Zealand bank guide

bolt

Upload an ANZ New Zealand statement PDF and every transaction comes back as clean rows — date, description, withdrawal, deposit and the running balance in New Zealand dollars — checked so the closing figure ties out. Export to Excel, CSV, or an import file for Xero, MYOB or QuickBooks.

ANZ is New Zealand's largest bank, and while it shares a name with ANZ in Australia, this is the New Zealand business, in New Zealand dollars, with the local payment fields Kiwi accounts use. That's what a statement has to carry, and what a plain copy-paste tends to lose.

What an ANZ NZ statement looks like

An ANZ New Zealand transaction account statement uses these columns:

Column

What's in it

Date

`DD Mon YYYY`, New Zealand format

Transaction

The payee, with the particulars, code and reference

Withdrawal

Money out

Deposit

Money in

Balance

Running balance after the transaction, in NZD

As the country's biggest bank, ANZ NZ is where a huge share of Kiwi businesses run their day-to-day accounts, so its statements tend to be busy — a lot of card spending, transfers and scheduled payments in a month. Each line names the payment and, on money coming in, carries the reference the payer entered, and a long entry runs onto a second row. Left to a copy-paste, that second row is read as its own transaction and the withdrawal and deposit columns drift out of line. The converter reattaches it, so even a heavy ANZ month comes out as clean single rows you can sort and total.

Where to download your ANZ NZ statement

  1. ANZ Internet Banking: log in at anz.co.nz, choose the account, open Statements, select the period and download the PDF.
  2. ANZ goMoney app: tap the account, go to Statements, pick a statement and save the PDF.

A statement downloaded this way is a digital PDF with selectable text, so the conversion is exact. If you only have a scan or a photo of a posted statement, the converter reads it with OCR — that just takes a little longer.

Getting the numbers where you need them

  • Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total and filter.
  • Xero or MYOB — an import-ready bank file so the lines arrive as statement entries to reconcile.
  • QuickBooks, Zoho and others — the same data in each one's format.

Before you download, the figures are reconciled: opening balance, plus deposits, minus withdrawals, has to reach the closing balance. On a busy ANZ account with a lot of lines, that automatic check is what catches one that slipped between pages before it skews the total.

Common snags with ANZ NZ statements

  • Busy months stay in order. Even a heavy statement comes out one clean row per transaction, sorted by date.
  • Payment references kept. The reference a payer entered stays with the deposit, so you can match it to an invoice.
  • Not the same as ANZ Australia. This handles the New Zealand statement, in NZD; the Australian ANZ statement is a different document.

Frequently asked questions

Can I convert an ANZ NZ statement to Excel for free?keyboard_arrow_down

Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the running balance checked so the import lines up.

My ANZ statement has hundreds of lines — will it handle that?keyboard_arrow_down

Yes. ANZ is New Zealand's largest bank and its accounts can be busy; the converter processes a long statement the same way, returning one clean row per transaction with the running balance checked.

Is this the same as ANZ Australia?keyboard_arrow_down

No. ANZ operates separately in each country; this page is for the New Zealand statement in NZD. The Australian ANZ statement is handled on its own page.

Can I use it for my GST return?keyboard_arrow_down

Yes. A clean Excel or Xero import gives you every withdrawal and deposit as sorted rows, far faster to reconcile for a GST period than working from the PDF.

Straight into your software

Convert ANZ NZ to your accounting software

More banks

Other New Zealand banks

Related guides

Import it into your accounting software

verifiedChecked to balance

Convert your bank statement — every transaction verified

Upload any PDF, get clean Excel or CSV ready for Xero & QuickBooks. Scanned statements too.

upload_fileConvert a statement free