New Zealand bank statements to Excel

A bank statement from a New Zealand bank goes into ExtractPro as a PDF and leaves as an Excel workbook (.xlsx): a row for every transaction, date, description and amount in their own columns, amounts that Excel can total and, when the statement shows it, a balance column. Below, bank by bank, is what each one says about its statements on its own website, followed by links to the 8 New Zealand banks with a page on ExtractPro.

What each bank says about its statements

In the bank’s own words:

• ANZ NZ: its guide says you can “see, download, email, and print up to seven years of statements and advice in goMoney and Internet Banking”, and the video on that page describes “a PDF version of the account statement”.
• BNZ: in Internet Banking, “To save the statement, click on Download.” For business accounts, its page adds: “To find and download a PDF copy of a statement, go to the ‘Accounts’ tab of Internet Banking for Business”. If the statement you save from Internet Banking is a PDF, that is the file to upload.
• ASB: in the Document Centre of FastNet Classic, “Your statements are in .pdf format, so are easy to download if you need to.”
• Westpac NZ: in online banking you “Select Download statements if you’re using a computer or laptop”, and “We hold copies of your statements electronically for at least seven years in case you need a copy.”
• Kiwibank: “Click 'Download' for each statement and it'll download as a PDF.” and “To view statements older than 12 months, click 'Show All'.”
• TSB: “Your statement will open in a pdf to view”, and “Review up to 12 months of past statements.”
• Co-operative Bank: “You can view and download PDF Statements and recent transactions lists via Internet Banking or our mobile app.” Beyond a year: “If you need more than 12 months of statements, they are available on Internet Banking.”
• SBS Bank: in internet banking, “select ‘estatements’ at the top and then ‘view estatements’ from the dropdown list.” Its help says “You’ll need to have a PDF Reader installed on your computer or device.”

Source: ANZ, Statements, documents, and going paperless, www.anz.co.nz/banking-with-anz/ways-to-bank/guides/statements/; BNZ, Viewing, saving or printing account statements, www.bnz.co.nz/support/internet-banking/statements/account-summaries, and Online statements, www.bnz.co.nz/business-banking/support/internet-banking-for-business/transactions-reporting-and-exporting/online-statements; ASB, How far back can I go to see my statements in FastNet Classic?, www.asb.co.nz/help/how-far-back-can-i-go-to-see-my-statements-in-fastnet-classic.html; Westpac NZ, How do I download transactions and statements?, www.westpac.co.nz/help/how-do-i-download-transactions-and-statements/, and How do I get a copy of my bank statement?, www.westpac.co.nz/help/how-do-i-get-a-copy-of-my-bank-statement/; Kiwibank, Bank statements, www.kiwibank.co.nz/help/accounts/balances-statements/bank-statements/; TSB, Online banking, www.tsb.co.nz/ways-to-bank/online-banking; Co-operative Bank, Getting a statement or recent transactions list, www.co-operativebank.co.nz/help/managing-your-account-everyday-banking/getting-a-statement-or-recent-transactions-list; SBS Bank, Internet banking, www.sbsbank.co.nz/everyday/internet-and-mobile-banking/internet-banking. All accessed 7 October 2026.

The PDF is named by ANZ NZ (in its video), ASB, BNZ (for business accounts), Kiwibank, TSB and the Co-operative Bank. With BNZ for personal accounts, Westpac NZ or SBS Bank, the PDF is the file to upload if that is what you saved. For ANZ NZ, ASB, Westpac NZ and Kiwibank there are also guides that walk through the download in order.

Where a bank’s export ends and a statement carries on

The banks that export transactions say how far the export reaches. Kiwibank’s business internet banking says: “Exports are limited to two years. To view older transactions, use your statements.” BNZ, on its page about saving transaction history, covers “up to 3 years of previous transactions”. ASB: “You can export up to 10,000 transactions per file download.” When a period falls outside a window like these, or a client has sent only the statement, the statement PDF is what you convert. Source: Kiwibank, View and export your transactions, www.kiwibank.co.nz/business-banking/thrive-hq/online-banking/internet-banking/view-and-export-your-transactions/; BNZ, Printing or saving transaction history, www.bnz.co.nz/support/internet-banking/transactions-and-transfers/printing-or-saving-transaction-history; ASB, What is Statement Export and how do I use it?, www.asb.co.nz/help/what-is-statement-export-and-how-do-i-use-it.html. All accessed 7 October 2026.

The 8 New Zealand banks on ExtractPro

Follow a name to see that bank’s own page, with the questions people ask about it.

• ANZ NZ
• BNZ
• ASB
• Westpac NZ
• Kiwibank
• TSB
• Co-operative Bank
• SBS Bank

From the statement to a spreadsheet

Whichever bank issued it, the route is the same, and it works for a statement that came from internet banking, an app, an email or a client:

1. 1Upload the statement PDF unchanged. A password, if there is one, is typed in at upload and the file opens in your browser.
2. 2ExtractPro reads the transactions and sets them out in a table, one for each row.
3. 3Download the workbook (.xlsx) with date, description and amount, the balance included when the statement shows it, and amounts as numbers. The custom format can give you a CSV instead.

If the file is going into Xero, the Xero guide shows which custom format options to select. Before you reconcile, check two things: the last balance in the workbook against the statement, and the number of rows against the transactions printed on it.

Frequently asked questions

The questions that come up most: