NZ
Upload a Kiwibank statement PDF and every transaction comes back as clean rows — date, description, withdrawal, deposit and the running balance in New Zealand dollars — checked so the closing figure ties out. Export to Excel, CSV, or an import file for Xero, MYOB or QuickBooks.
Kiwibank is New Zealand-owned and a common choice for sole traders and small businesses, which means its statements often end up in front of a bookkeeper. And a bookkeeper needs the numbers as rows to sort and total — not as a PDF that has to be read and retyped line by line.
What a Kiwibank statement looks like
A Kiwibank transaction account statement uses these columns:
Column | What's in it |
|---|---|
Date | `DD Mon YYYY`, New Zealand format |
Description | The payee and how the payment was made |
Withdrawal | Money out |
Deposit | Money in |
Balance | Running balance after the transaction, in NZD |
The Description column holds the payee and the payment channel, and on money coming in, the reference the payer added — the detail that tells a sole trader which invoice a deposit settled. Kiwibank prints that alongside the withdrawal or deposit amount and the balance after it. The snag is length: a fuller description runs to a second line, and a plain export treats that second line as a new row. The converter stitches it back so every entry is one row, amount and reference together.
For the small business
A lot of Kiwibank's account holders are one-person operations — a tradie, a consultant, a side business — and for them the statement isn't bedtime reading, it's the raw material for a GST return or a set of accounts. The moment it's a spreadsheet, you can tag the deductible spending, total the income, and drop the lot into Xero or hand it to an accountant. What takes an evening by hand takes a couple of minutes once the PDF is rows.
Where to download your Kiwibank statement
- Kiwibank internet banking: log in at kiwibank.co.nz, choose the account, open Statements, select the period and download the PDF.
- Kiwibank app: tap the account, go to Statements, pick a statement and save the PDF.
A statement downloaded this way is a digital PDF with selectable text, so the conversion is exact. If you only have a scan or a photo of a posted statement, the converter reads it with OCR — that just takes a little longer.
Getting the numbers where you need them
- Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total and filter.
- Xero or MYOB — an import-ready bank file so the lines arrive as statement entries to reconcile.
- QuickBooks, Zoho and others — the same data in each one's format.
Before you download, the figures are reconciled: opening balance, plus deposits, minus withdrawals, has to reach the closing balance. For a small business squaring up a GST period, that check is what confirms nothing went missing between the pages.
Common snags with Kiwibank statements
- Second-line descriptions. A payee or reference that spills over is joined back to its transaction.
- Payment references retained. The reference a payer entered stays with the deposit, so you can match it to the invoice.
- Business accounts. Kiwibank business transaction-account statements use the same layout, so the same conversion works.
Frequently asked questions
Can I convert a Kiwibank statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the running balance checked so the import lines up.
Where do I download my Kiwibank statement?keyboard_arrow_down
In Kiwibank internet banking or the Kiwibank app: choose the account, open Statements, pick the period and download the PDF. That digital PDF converts cleaner than a scan.
Can I use it for my GST return?keyboard_arrow_down
Yes. A clean Excel or Xero import gives you every withdrawal and deposit as sorted rows, far faster to reconcile for a GST period than working from the PDF.
Will it read a scanned Kiwibank statement?keyboard_arrow_down
Yes, with OCR. A PDF downloaded from internet banking will always convert faster and cleaner than a scan.
