Kiwibank Statement to Excel Converter

ClearlyLedger converts Kiwibank (New Zealand) PDF statements into clean Excel and CSV files. This guide covers the common Kiwibank pdf layout, DD MMM YYYY dates and NZD amounts. Exports are released only when verification checks pass. Most Kiwibank statements (3–10 pages) finish in under 60 seconds with no signup required for your first file.

Last updated 2026-09-03

What does a Kiwibank statement PDF look like?

Printed structure: PDF with Date, Description, Amount, Balance — debits as negative

Date notation: DD MMM YYYY. Money notation: NZ$ NZD. Observed statement size: 3–10 pages.

Amounts use a period decimal; particulars/code/reference fields are preserved as separate description parts.

What fields does Kiwibank print on each transaction row?

The profile uses the bank-specific observations below as review checkpoints. They describe the source document rather than making a generic promise about every PDF:

  • Kiwibank checkpoint 1: Wholly owned by the New Zealand government through Kiwi Group Capital; it was set up in 2002 specifically to give New Zealanders a bank not owned by an Australian parent, unlike ANZ NZ, Westpac NZ, or ASB
  • Kiwibank checkpoint 2: Single Amount column with negatives for debits — no separate Debit/Credit columns
  • Kiwibank checkpoint 3: Bill Pay entries include the biller code and customer reference
  • Kiwibank checkpoint 4: Account fees waived under the Kiwi Saver bundle appear as €0.00 audit rows
  • Kiwibank checkpoint 5: Statement format unchanged across personal and business accounts

How do I check a Kiwibank conversion before using it?

A typical Kiwibank file runs 3–10 pages. Confirm its DD MMM YYYY dates, NZD signs, first and final transactions, and page boundaries. Balance review is especially important on this layout. Wholly owned by the New Zealand government through Kiwi Group Capital; it was set up in 2002 specifically to give New Zealanders a bank not owned by an Australian parent, unlike ANZ NZ, Westpac NZ, or ASB. The PDF remains the source; the spreadsheet is the reviewable working copy.

  1. Upload the Kiwibank PDF.
  2. Inspect the documented Kiwibank row patterns.
  3. Reconcile the NZD transaction math.
  4. Download verified Kiwibank Excel or CSV data.

Which accounting tools accept Kiwibank Excel or CSV files?

Excel suits source-document review and coding. CSV suits mapped imports into Xero, MYOB, QuickBooks or another bookkeeping system. Those routes preserve the DD MMM YYYY interpretation and NZD values established from the Kiwibank source.

Is my Kiwibank statement data kept private?

The Kiwibank PDF is processed in memory and deleted after conversion. The Kiwibank transaction data is not used to train AI models. TLS protects the upload in transit, while the workflow is designed around New Zealand's Privacy Act 2020 for New Zealand account holders.

Kiwibank conversion FAQ

Which Kiwibank statement layouts can ClearlyLedger convert?

Kiwibank statements typically arrive as PDF with Date, Description, Amount, Balance — debits as negative. ClearlyLedger's Kiwibank profile reads that layout, plus scanned and password-protected exports, and reconstructs Date, Description, Debit, Credit and Balance columns.

How does ClearlyLedger handle Kiwibank-specific quirks?

This guide highlights common Kiwibank statement characteristics — for example: Wholly owned by the New Zealand government through Kiwi Group Capital; it was set up in 2002 specifically to give New Zealanders a bank not owned by an Australian parent, unlike ANZ NZ, Westpac NZ, or ASB. The conversion is released only after its verification checks pass.

Can I import a converted Kiwibank statement into Xero?

Yes. Export to CSV and import into Xero, MYOB, QuickBooks or any tool that accepts a transaction file. The DD MMM YYYY dates and NZD amounts are normalised so the import maps cleanly.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free