Convert BNZ Bank Statements to Xero Format

To convert your Bank of New Zealand (BNZ) bank statement to Xero, upload your PDF statement to the converter, let the system parse the statement rows, and download a pre-formatted Xero CSV file. The resulting file contains clean transaction dates, reference descriptions, and positive or negative amounts ready to import directly into your Xero bank account feed without manual column adjustments.

How do you convert a BNZ PDF statement for Xero?

1. Upload your original digital or scanned BNZ PDF statement.
2. Wait a few seconds while the parser extracts every statement line, separating transaction dates, payee particulars, reference numbers, and withdrawal or deposit values.
3. Review the extracted preview table to ensure the opening balance, transaction sums, and closing balance match your BNZ document.
4. Select Xero as your output format to download the file matching Xero's required CSV structure.
5. Log into Xero, open the relevant BNZ bank account, click Manage Account > Import a Statement, and upload your converted file.

What data is extracted from BNZ bank statements?

BNZ statements present transaction data across distinct sections, including transaction dates, particulars, codes, references, withdrawals, deposits, and the running balance. The parser captures these fields reliably:

• Transaction Date: Formatted as DD/MM/YYYY to align with New Zealand accounting standards and Xero default date configurations.
• Description / Payee Details: Combines the transaction particulars, code, and reference fields into a clean text string for the Xero "Description" or "Payee" field.
• Amount: Extracted as a signed number (negative values for debits/withdrawals and positive values for deposits) or mapped into separate debit and credit fields according to Xero template requirements.
• Running Balance: Used to verify transaction accuracy against the statement's printed closing balance.

If you prefer a raw spreadsheet for custom reporting, you can also convert your statement to BNZ to Excel or use the general BNZ to CSV format.

Importing BNZ converted statements into Xero

Xero requires specific column headers to process manual bank statement imports without errors. When you upload a generic CSV, you often have to manually map columns, fix unrecognised date patterns, or flip inverted debit and credit signs. The BNZ to Xero converter avoids these manual steps by pre-assigning headers that Xero recognises immediately:

After importing, the transactions appear on the left side of your Xero Bank Reconciliation screen as imported statement lines. You can then use your existing bank rules to match them with bills, invoices, or general ledger codes. This workflow is especially helpful for historical periods where an active BNZ direct bank feed was not connected or for reconciling archived business accounts across other New Zealand banks.

Comparison: Manual entry vs PDF conversion for Xero

Entering transaction rows manually from a printed or PDF BNZ statement into Xero introduces data entry risks and takes considerable administrative time. Here is how direct PDF conversion compares to traditional methods:

Does it work with scanned or photographed BNZ statements?

Yes. If you only have scanned copies, photocopies, or image-only PDF files of older BNZ paper statements, the built-in Optical Character Recognition (OCR) engine identifies the printed text and numbers. The system processes the image layer, extracts the transaction columns, and checks that all debits and credits mathematically reconcile with the opening and closing balances printed on the statement header and footer.

Security and data privacy

Your financial data remains confidential. Uploaded PDF statements and generated CSV files are encrypted in transit and processed on secure servers. Files are automatically purged shortly after processing, and your transaction details are never retained, sold, or used to train public machine learning models.

Next steps for other accounting workflows

If your advisory firm or business uses multiple software platforms alongside Xero, you can convert BNZ files into other formats, including BNZ to QuickBooks or standard desktop accounting feeds via BNZ to OFX.