NZ
Upload a Bank of 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.
A BNZ statement is easy enough to read one line at a time. The trouble starts when you need a whole year of it at once — for a GST return or an accountant — and realise a PDF can't be sorted, totalled or filtered. That's the gap the converter closes: it turns the document back into data.
What a BNZ statement looks like
A BNZ transaction account statement uses these columns:
Column | What's in it |
|---|---|
Date | `DD Mon YYYY`, New Zealand format |
Transaction | The payee and how the payment was made |
Withdrawal | Money out |
Deposit | Money in |
Balance | Running balance after the transaction, in NZD |
The Transaction column tells you how each payment moved — an EFTPOS purchase, a direct debit, an automatic payment, a bill payment or an ATM withdrawal — and it's what you sort by when you're separating business costs from everything else. Longer entries wrap onto a second line, and a rough export reads that overflow as its own row, leaving you a stray half-line to stitch back on. The converter keeps each payment on one complete row, so a month sorts cleanly by type the moment it's in a spreadsheet.
Where to download your BNZ statement
- BNZ Internet Banking: log in at bnz.co.nz, choose the account, open Statements, select the period and download the PDF.
- BNZ app: tap the account, go to Statements, pick a statement and save the PDF.
A statement downloaded from Internet Banking 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 download, the figures are reconciled: opening balance, plus deposits, minus withdrawals, has to reach the closing balance. Over a full year pulled together for the IRD, that check is what catches a single line dropped between pages before it throws the totals.
Pulling a full year together
GST and provisional tax rarely need just one month — they need a run of them. Convert each BNZ statement to rows and paste the results into a single sheet, and you've built a full year you can total, filter and hand to an accountant in one file. Because every statement is reconciled to its own closing balance first, the months join up cleanly: one month's close is the next month's open, with nothing dropped in between. That's far steadier than copying a year of PDFs into a spreadsheet by hand and hoping the totals survive.
Common snags with BNZ statements
- Wrapped transaction lines. A payee or detail spilling onto a second line is joined back to the right entry.
- Sorts by payment type. Once it's rows, EFTPOS, direct debits and automatic payments filter apart in one click.
- Business accounts. BNZ business transaction-account statements use the same layout, so the same conversion works.
Frequently asked questions
Can I convert a BNZ 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.
Where do I download my BNZ statement?keyboard_arrow_down
In BNZ Internet Banking or the BNZ app: choose the account, open Statements, pick the period and download the PDF. That digital PDF converts cleaner than a scan.
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 or year-end than working from the PDF.
Will it read a scanned BNZ statement?keyboard_arrow_down
Yes, with OCR. A PDF downloaded from Internet Banking will always convert faster and cleaner than a scan.
