ANZ NZ Bank Statement to Excel Converter

ClearlyLedger converts ANZ New Zealand PDF statements into structured Excel and CSV files for NZ chartered accountants, bookkeepers, SMEs, contractors, property investors, and lenders. The ANZ NZ profile handles NZD formatting, single-amount statement layouts, automatic payment and direct debit narration, year inference, and balance verification before export.

Last updated 2026-06-05

What does an ANZ New Zealand statement format look like?

ANZ NZ statements commonly use a compact transaction table with date, description, amount, and balance fields. Some layouts use a single signed amount column rather than separate debit and credit columns.

ClearlyLedger detects ANZ New Zealand layouts, splits signed amounts into debit and credit columns, and preserves transaction narration for review.

What New Zealand-specific transaction handling does ClearlyLedger apply?

New Zealand statements often include AP and DD prefixes for automatic payments and direct debits, bill-payment references, EFTPOS narration, and rows where the year must be inferred from the statement period.

The ANZ NZ profile keeps those details usable while normalizing NZD amounts and dates for Excel, Xero NZ, MYOB, and lender-review workflows.

Which export should I use for Xero NZ, MYOB or GST review?

Use Excel when reviewing ANZ NZ statements for GST return support, IR3 or IR4 preparation, mortgage packs, or property-investor reconciliation. Use CSV when importing into Xero NZ or MYOB.

ClearlyLedger verifies that the extracted transactions reconcile to the printed balance before export so page-break, sign, and year-inference errors can be caught before bookkeeping starts.

ANZ New Zealand source profile used by this guide

Printed statement structure: PDF with Date, Details, Amount, Balance — debit amounts shown as negative

Source conventions: DD/MM/YYYY dates, NZ$ NZD amounts, and 3–12 pages.

ANZ NZ observations to sample during review

  • New Zealand's largest bank by assets, formed when ANZ acquired the National Bank of New Zealand from Lloyds TSB in 2003 and merged the two networks over the following years
  • Consistently ranks as New Zealand's single largest bank by both total assets and customer numbers among the four major Australian-owned banks operating there
  • Single Amount column with negatives for debits — no separate debit/credit columns
  • Paymark and eftpos transactions show a merchant terminal ID rather than a plain merchant name
  • Automatic Payments are identified by an 'AP' prefix in the Details field rather than a dedicated transaction-type column
  • Bank charges are grouped at period end with no individual row dates, unlike ordinary transactions

These ANZ NZ details identify the rows most likely to need inspection after extraction. Review the first and final transaction, each PDF page boundary, and any row affected by the observations above before using the spreadsheet in an accounting import.

Related workflows

Continue from this guide into the matching converter, accounting import, security, or country hub pages so crawlers and readers can follow the full workflow.

Frequently asked questions

How do I convert an ANZ NZ statement to Excel?

Upload the ANZ New Zealand PDF to ClearlyLedger. The ANZ NZ layout is detected automatically, signed amounts are normalized, dates are inferred where needed, the balance is verified, and the statement is exported to Excel.

Can I convert ANZ NZ statements to CSV for Xero?

Yes. ClearlyLedger exports ANZ NZ transactions to CSV with date, description, reference, debit, credit, and balance columns suitable for Xero NZ, MYOB, and reconciliation workflows.

Does it handle single-amount ANZ NZ layouts?

Yes. The ANZ NZ parser detects signed amount columns and splits them into separate debit and credit fields during export.

Does it preserve AP and DD references?

Yes. Automatic payment, direct debit, EFTPOS, bill-payment, and transfer narration is preserved where possible so transaction matching remains useful.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free