NZ
Upload an ASB Bank 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.
New Zealand payments work a little differently from most of the world, and ASB statements show it. Alongside the payee, each transaction can carry three separate fields — particulars, code and reference — and those fields are how Kiwi businesses tell one payment from another. Flatten them with a copy-paste and you lose the very detail you reconcile against.
What an ASB statement looks like
An ASB transaction account statement uses these columns:
Column | What's in it |
|---|---|
Date | `DD Mon YYYY`, New Zealand format |
Transaction | The payee plus the particulars, code and reference |
Withdrawal | Money out |
Deposit | Money in |
Balance | Running balance after the transaction, in NZD |
The particulars / code / reference trio is the ASB detail worth protecting. When someone pays you, they fill those fields in — an invoice number in the reference, a name in the particulars — and that's how you match the deposit to the right customer. A payment can also be an EFTPOS purchase, a direct debit, an automatic payment or a bill payment, and the description often wraps onto a second line. A rough PDF export reads that overflow as its own row; the converter joins it back so every field stays on the transaction it belongs to.
Where to download your ASB statement
- FastNet Classic internet banking: log in at asb.co.nz, choose the account, open Statements, select the period and download the PDF.
- ASB Mobile 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.
Every figure is checked before download: opening balance, plus deposits, minus withdrawals, has to equal the closing balance. Because the particulars and reference fields are exactly what a GST reconciliation leans on, keeping them intact is what makes the exported month usable rather than just tidy.
Common snags with ASB statements
- Particulars, code and reference dropped. All three stay attached to their payment so you can still match deposits to customers.
- Wrapped transaction lines. A long payee or reference on a second line is joined back to the right entry.
- Business accounts. ASB business transaction-account statements use the same layout, so the same conversion works.
Frequently asked questions
Can I convert an ASB 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.
Are the particulars, code and reference fields kept?keyboard_arrow_down
Yes. Those three New Zealand payment fields stay attached to the transaction they belong to, so an incoming payment can still be matched to the customer and invoice behind it.
Where do I download my ASB statement?keyboard_arrow_down
In FastNet Classic internet banking or the ASB Mobile 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, which is far faster to reconcile for a GST period than working from the PDF.
