New Zealand
Convert bank statements in New Zealand
Statement formats, date and amount conventions and accounting imports for banks in New Zealand.
Quick answer
StatementPilot converts statements from any bank in New Zealand into Excel, CSV, QBO, OFX or QIF. Dates default to DD/MM/YYYY, amounts are read in New Zealand dollars (NZD), and exports are ready for Xero, MYOB, Excel.
Banks in New Zealand
How statements in New Zealand are laid out
NZ statements show Withdrawals, Deposits and Balance columns and print the full account number in the 00-0000-0000000-00 format in the header.
Amounts and dates
Amounts use 1,234.56; overdrawn balances may carry a minus sign or 'OD'.
The usual date format is DD/MM/YYYY. When a statement is ambiguous we use the statement period and other rows to decide the order.
Account identifiers
Account numbers combine bank, branch, account and suffix numbers.
Accounting software
The most common destinations in New Zealand are Xero, MYOB, Excel. Every export format is included on every plan.
Why statements still matter
Most banks keep several years of statements available in internet banking.
Frequently asked questions
Does the converter support NZD statements?
Yes. Amounts in New Zealand dollars are read with the local number format and the currency is carried into Excel, OFX and QBO exports.
What if my bank in New Zealand isn't listed?
Upload it anyway — there are no bank templates. The reconciliation check confirms whether every transaction was captured.
Which date format will my export use?
Excel and OFX use real dates. For CSV and QIF you can choose MM/DD/YYYY or DD/MM/YYYY at export time; DD/MM/YYYY is typical in New Zealand.
Convert your first statement in under a minute
20 free pages every month. No credit card. Every export format included.