Bank Statement Converter for GST Returns (New Zealand) — PDF to Excel

What the GST return needs from your statements

Once your turnover passes $60,000 you're required to register for GST, and from then on IRD wants a return — usually two-monthly or six-monthly. GST in New Zealand is 15%, and the return comes down to GST on sales against GST on purchases, with the net paid to or refunded by IRD. Every figure traces back to money through your bank account.

The work is getting those transactions into a usable form. A period is several monthly statement PDFs, where the payee and the payment detail sit in a column you can't filter while it's a PDF. As rows in Excel, you sort the income, sort the expenses, and the GST falls out.

From PDF to a GST-ready spreadsheet

1. Download each month's statement as a PDF — ASB's FastNet, BNZ, Kiwibank, ANZ and Westpac all keep statements in internet banking.
2. Convert each PDF to Excel or CSV. Every transaction returns as a row — date, description, withdrawal, deposit and balance in NZD — with the closing figure checked.
3. Combine the months into one sheet for the full GST period.
4. Tag and total. Mark each line as a GST-inclusive sale, a claimable expense, or out of scope (wages, drawings, transfers), then total each for the return.

New Zealand payments carry the particulars, code and reference a payer entered, so keeping that detail is what lets you match a deposit to the customer and invoice behind it.

Keeping the particulars, code and reference

New Zealand's payment system is a little unusual: when someone pays you, they fill in three separate fields — particulars, code and reference — and those are exactly what you match a GST-able sale against. On an ASB or BNZ statement they sit in the transaction description, and a plain copy-paste flattens them, so you lose the very detail that ties a deposit to a customer and an invoice. The converter keeps all three on the transaction they belong to, which is what makes the income side of a GST return actually reconcile rather than just add up.

The math is checked too, before you download: opening balance, plus deposits, minus withdrawals, has to reach the closing balance. Over a period's statements, that catches a line dropped between pages before it throws your GST figure out.

Straight into Xero or MYOB

Most New Zealand businesses reconcile in Xero or MYOB, and both import a bank file. Instead of a spreadsheet you can export an import-ready file and bring the period in as bank transactions to code against your GST rate, so the return is prepared from reconciled data. If your accountant or bookkeeper files it, a clean file is what they'd rather have than a folder of PDFs.

Common pitfalls to avoid

• Second-hand goods and zero-rated supplies. New Zealand has specific rules for these; tag them so they aren't swept into standard-rated 15%.
• The provisional-tax overlap. If you pay provisional tax, those payments to IRD show in the account too — keep them on their own rows so they don't get mistaken for GST-relevant spending.
• Drawings and shareholder transfers. Common in NZ small companies and out of scope for GST — keep them separate so neither side is inflated.
• Filing frequency. Whether you're on two-monthly or six-monthly, converting each statement as it closes keeps the return a short check rather than a catch-up.