BNZ statement to CSV

Getting the PDF out of BNZ

1. In Internet Banking for Business, go to the Accounts tab.
2. Choose Statements and documents from the left-hand menu.
3. Choose the account from the drop-down menu, pick a date range if you want one, and click View.
4. Choose the statement you want; it opens in a new window.
5. Right-click anywhere on the statement and select Save or Save as to download a copy.

A new statement appears online at the same time as BNZ posts it, and statements for everyday and loan accounts stay there for the last seven years.

Anyone using Internet Banking for Business can view and download statements for any account they have permission to access.

In BNZ’s personal Internet Banking the path is different: Menu, then Documents, then Statements and the account, with a Download button on the statement.

From BNZ’s own help: Online statements: Business help and support, Viewing, saving or printing account statements.

What a BNZ statement looks like, and what we do with it

BNZ prints two tables. The newer one is headed Date, Name of Other Party, Type, Particulars, Code, Reference, Withdrawals, Deposits and Balance; the older one has only Date, Particulars, Type and the three money columns, beside a left margin holding the statement number, the period and the account. Either way withdrawals and deposits are bare figures in separate columns, the earliest day comes first, and on a busy account only the last row of a day carries a balance, with CARRIED FORWARD closing one page and opening the next.

Dates carry no year, written 06 Jan, and the period is printed in capitals with the month spelled out, so one that starts on the last day of December ends in January of the next year.

We read the period and give each row the year it falls in, so a 06 Jan row on such a statement belongs to the new year.

On some statements the period wraps over three lines down the left margin, its year level with the first transaction.

We read the margin top to bottom as one line, so the year still reaches the rows.

On the newer layout, Name of Other Party, Type, Particulars, Code and Reference are separate columns, often part empty.

We join them into one description in that order, so the payee comes first.

OPENING BALANCE sits above the table and CLOSING BALANCE below it.

We start the running balance from the first and check that the rows arrive at the second.

An overdrawn balance has OD after it rather than a minus, from the opening balance down, and loses it as soon as the account is back in credit.

We read a figure ending in OD as below zero, so a month spent mostly overdrawn still checks row by row.

After the closing balance, a business account prints an Account Fee Summary whose monthly fee line has a date and a charge period of its own, though the same fee is already a row in the table.

The summary gives no row, so the fee is counted once, on the day it was taken.

What this page is based on

Four statements filed with grant applications in a district council’s papers, 2022 to 2025: a six-page Bus First Transact statement of more than a hundred rows that sat overdrawn for most of the month, a Non Profit Org account, and two statements of a club account with no type printed. Not one row in the four disagreed with the balance beside it, and each statement’s rows led from its OPENING BALANCE to its CLOSING BALANCE. The club’s two statements, numbered 1 and 2, joined as one account when opened together, the second starting on the balance the first closed on.

BNZ keeps business credit card statements online back to July 2017, but we have not had one, whether from a Business First Lite Visa or an Advantage Visa Business. Nor has a Business First OnCall or Rapid Save statement come our way.

Once it is converted, the import steps for each accounting package are the same for every bank.

Questions

Privacy, scans and price work the same for every bank, and the home page answers them.