Bank of New Zealand Statement to Excel Converter

ClearlyLedger converts Bank of New Zealand (New Zealand) PDF statements into clean Excel and CSV files. This guide covers the common BNZ pdf layout, DD MMM dates and NZD amounts. Exports are released only when verification checks pass. Most BNZ statements (3–12 pages) finish in under 60 seconds with no signup required for your first file.

Last updated 2026-09-03

What does a BNZ statement PDF look like?

Printed structure: PDF with Date, Particulars, Code, Reference, Payments, Deposits, Balance

Date notation: DD MMM. Money notation: NZ$ NZD. Observed statement size: 3–12 pages.

Amounts use a period decimal; particulars/code/reference fields are preserved as separate description parts.

What fields does Bank of New Zealand print on each transaction row?

The profile uses the bank-specific observations below as review checkpoints. They describe the source document rather than making a generic promise about every PDF:

  • BNZ checkpoint 1: New Zealand's oldest bank, founded in 1861, and — unlike Kiwibank — owned by an Australian parent, the National Australia Bank, since 1992
  • BNZ checkpoint 2: BNZ needed a government-backed recapitalisation in 1990 after a period of aggressive lending losses during the era of 1980s financial-market deregulation, setting up the sale to NAB two years later
  • BNZ checkpoint 3: Particulars, Code and Reference are three separate narrative columns — merged into a single Description
  • BNZ checkpoint 4: Bill payment 'Code' column carries the biller reference number
  • BNZ checkpoint 5: Eftpos and payWave transactions tagged with merchant terminal location
  • BNZ checkpoint 6: Year-end statements split across two PDFs — combine before reconciliation

How do I check a BNZ conversion before using it?

A typical Bank of New Zealand file runs 3–12 pages. Confirm its DD MMM dates, NZD signs, first and final transactions, and page boundaries. Balance review is especially important on this layout. New Zealand's oldest bank, founded in 1861, and — unlike Kiwibank — owned by an Australian parent, the National Australia Bank, since 1992. The PDF remains the source; the spreadsheet is the reviewable working copy.

  1. Upload the Bank of New Zealand PDF.
  2. Inspect the documented BNZ row patterns.
  3. Reconcile the NZD transaction math.
  4. Download verified BNZ Excel or CSV data.

Which accounting tools accept BNZ Excel or CSV files?

Excel suits source-document review and coding. CSV suits mapped imports into Xero, MYOB, QuickBooks or another bookkeeping system. Those routes preserve the DD MMM interpretation and NZD values established from the Bank of New Zealand source.

Is my BNZ statement data kept private?

The BNZ PDF is processed in memory and deleted after conversion. The BNZ transaction data is not used to train AI models. TLS protects the upload in transit, while the workflow is designed around New Zealand's Privacy Act 2020 for New Zealand account holders.

BNZ conversion FAQ

Which BNZ statement layouts can ClearlyLedger convert?

Bank of New Zealand statements typically arrive as PDF with Date, Particulars, Code, Reference, Payments, Deposits, Balance. ClearlyLedger's BNZ profile reads that layout, plus scanned and password-protected exports, and reconstructs Date, Description, Debit, Credit and Balance columns.

How does ClearlyLedger handle BNZ-specific quirks?

This guide highlights common BNZ statement characteristics — for example: New Zealand's oldest bank, founded in 1861, and — unlike Kiwibank — owned by an Australian parent, the National Australia Bank, since 1992. The conversion is released only after its verification checks pass.

Can I import a converted BNZ statement into Xero?

Yes. Export to CSV and import into Xero, MYOB, QuickBooks or any tool that accepts a transaction file. The DD MMM dates and NZD amounts are normalised so the import maps cleanly.

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