Convert BNZ Bank Statements to CSV

To convert a BNZ bank statement to CSV, upload your digital or scanned PDF statement to BankStmtConverter. The extraction engine reads every transaction table, extracts the transaction date, particulars, code, reference, payee details, debits, credits, and running balance, and outputs a structured CSV file ready for import into your accounting software.

How to convert your BNZ PDF statement to CSV

1. Download your official PDF statement from BNZ Internet Banking or scan a physical paper statement.
2. Upload the PDF file to the converter tool.
3. The parser extracts the transaction rows, separates credit and debit values, and validates the extracted figures against the statement opening and closing balances.
4. Download your processed .csv file, formatted with standard New Zealand date structures (DD/MM/YYYY) and clean decimal amounts.

If you prefer dedicated spreadsheet layouts with built-in arithmetic validation formulas, you can also convert BNZ bank statements to Excel or generate files directly for accounting packages via BNZ bank statement to Xero conversion.

What data gets extracted from BNZ statements?

BNZ statements contain detailed payment fields that New Zealand businesses rely on for reconciling payments. The converter preserves this context by pulling specific column values into designated CSV headers:

• Transaction Date: Formatted cleanly as DD/MM/YYYY.
• Transaction Details / Description: Extracts the core description along with Payee, Particulars, Code, and Reference fields.
• Withdrawals (Debits): Negative cash movements represented either in a dedicated Debit column or as signed negative values depending on your preference.
• Deposits (Credits): Incoming funds clearly isolated in the Credit column.
• Balance: The running account balance after each transaction.

The parser handles both standard BNZ business accounts, personal everyday accounts, and foreign currency accounts, adapting cleanly across multiple pages.

Working with your converted CSV in New Zealand accounting workflows

CSV is the universal format for financial data manipulation. Unlike locked PDF tables, a clean CSV lets you map columns directly into accounting software, run automated scripts, or build custom database feeds.

Importing into MYOB Business or AccountRight

MYOB requires a distinct layout for manual bank imports. Once you download your BNZ CSV, ensure the columns match MYOB's default bank statement import order: Date, Description, and Amount (where debits are negative and credits are positive). Because the converter standardizes dates to DD/MM/YYYY, MYOB reads the chronological order without regional parsing errors.

Importing into Xero via Custom CSV Mapping

While automatic bank feeds are common, backdated reconciliation often requires manual uploads for historical periods or newly opened accounts. Upload your BNZ CSV into Xero's manual statement import screen. You can map the combined description line or separate fields (Payee, Reference, Particulars) into Xero's transaction description and reference fields to speed up bank rule matching.

Custom spreadsheets and ERP ingestion

If you manage payroll, job-costing spreadsheets, or custom SQL databases, raw CSV eliminates manual keying errors. You can immediately run =VLOOKUP() or =XLOOKUP() formulas against invoice numbers extracted from the BNZ statement reference text.

Sample BNZ statement conversion

Here is an example showing how raw BNZ transactional rows are structured in the resulting CSV output:

Comparison: Manual retyping vs. automated conversion

Bookkeepers and business owners handling multiple BNZ accounts save hours each month by removing manual data entry.

Handling scanned and multi-page BNZ statements

Old archive statements or physical printouts scanned to PDF present unique challenges, such as skewed lines, low DPI, or background artifacts. BankStmtConverter uses trained optical character recognition models specifically tuned for financial tables.

During processing, the software performs an automatic mathematical audit. It calculates the net sum of all debits and credits from the extracted rows and compares it with the printed starting and ending balances on the statement. If a discrepancy exists due to a faint print or obscured digit, the system alerts you immediately, ensuring that no unreconciled cent slips into your ledger.

We also support statement processing for other financial institutions across the region. You can view our full directory on the New Zealand bank statement directory.

Data privacy and security

Financial records contain confidential supplier details, employee wages, and business revenue. Your BNZ statements are processed automatically via encrypted 256-bit SSL connections. Files are deleted from conversion servers automatically after processing and are never retained, sold, or used to train public language models.