Convert a BNZ bank statement CSV for Xero or QuickBooks

BNZ internet banking exports transaction history as CSV from each account's search view. The export is rich in narrative fields, which is great for reconciliation once mapped properly. Here is the export path and the conversion to Xero, QuickBooks or OFX, all in your browser.

Exporting the CSV from BNZ

In BNZ internet banking, open the account, use the transaction search, choose your date range, and export as CSV. Business and personal accounts can differ slightly in which columns appear, so glance at the header row of your download before converting.

What the BNZ export looks like

BNZ files typically carry a signed Amount, a Date, and separate narrative fields like Payee, Particulars, Code and Reference. Map Payee to Payee, Particulars to Description and Reference (or Code) to Reference. The converter auto-detects most of this and you can adjust any column by hand. Keep date reading on DD/MM for NZ files.

Convert it

  1. Open the converter and drop in your BNZ CSV. Processing is local; nothing is uploaded.
  2. Check the preview: correct months, money out negative.
  3. Download Xero CSV, QuickBooks CSV or OFX and import it.
Convert your BNZ CSV free

Tips

For Xero bank rules, keeping Payee and Particulars in separate output columns (rather than one combined narrative) makes matching far more reliable, so map both.

© 2026 StatementShift · Converter · Xero import guide · Other banks: ANZ, ASB, Westpac, Kiwibank