Convert Bank Statements for Year-End Accounts (New Zealand)

What year-end needs from your bank

Whether your accountant works from Xero, MYOB or a spreadsheet, the financial statements and tax return are built from a complete record of the year's transactions:

• Total income, so revenue is stated correctly.
• Deductible expenses, sorted so nothing claimable is missed and nothing personal creeps in.
• Interest and bank fees, which have their own tax treatment.
• Anything unusual, like a large one-off, that the accountant will want explained.

For a 31 March balance date that's twelve months of statements, and the sooner they're clean data, the sooner the accounts are done.

From PDF to complete data

1. Download the year's statements as PDFs — ASB's FastNet, BNZ, Kiwibank, ANZ and Westpac all keep them in internet banking.
2. Convert each 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, or export an import file, to hand over the whole year at once.
4. Fill the gaps. If your Xero or MYOB feed didn't cover part of the year, import the converted months so the accountant isn't chasing missing periods.

Giving your accountant clean data

Accountants charge for time, and a lot of year-end time goes on tidying source data — chasing statements, fixing an import that won't reconcile, keying in a period that never came through a feed. Handing over a converted, reconciled set removes most of that. The particulars, code and reference on New Zealand payments are kept, so incoming money can be matched to customers, and the running balance is already checked, so the bank side ties out before the accountant even starts.

What the converter handles that a copy-paste won't

An ASB or BNZ statement wraps a long payee or reference onto a second line, and a plain copy-paste turns that into a stray row that throws the columns out. Over a full year that's a lot of small errors to hunt down. The converter joins each wrapped line back to its transaction and checks the balance across the file, so the year arrives as one clean, reconciled set rather than twelve PDFs to untangle.

What to flag for your accountant

A converted year isn't only faster to hand over — it lets you flag the things your accountant would otherwise have to ask about. A few are worth marking as you go. Payments to IRD for provisional tax or GST sit in the account and aren't business expenses, so note them rather than letting them look like costs. Drawings and shareholder transfers, common in a small New Zealand company, are out of the profit-and-loss and want separating. Interest earned and bank fees each have their own treatment. And any large one-off — an asset bought, a loan drawn down, a capital contribution — is exactly what an accountant will query, so a short note beside it saves a round of emails.

Doing that on a spreadsheet takes minutes and turns year-end from a back-and-forth into a single clean handover. The less your accountant has to chase, the faster the accounts are finished — and usually the lower the bill.