Bank Statement for Rental Property Income (New Zealand) — Convert to Excel

What the rental return needs

Rental income is taxable and reported to IRD, and against it you can claim allowable expenses. From the bank account you need:

• Rent received. The credits from tenants or your property manager's payouts, totaled for the year.
• Deductible expenses. Rates, insurance, repairs and maintenance, property-management fees and similar.
• Interest. Deductibility of residential rental interest has been limited and phased under recent rules, so it needs to be identified and treated correctly, not just lumped into expenses.

Getting those out of the statements accurately is what makes the return right — and defensible if IRD looks.

From PDF to a rental spreadsheet

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 for the full year.
4. Sort rent and expenses. Total the rent credits, then add a category column for the expense types and total each for the IR3R.

If the rent comes through a property manager, their payout is net of fees and their statement fills in the detail; the bank deposit is what reconciles to your account.

Keeping the reference intact

New Zealand tenants and property managers usually pay with the particulars, code and reference filled in — often the property address or a tenant name — which is exactly what lets you tell one property's rent from another when you hold more than one. On an ASB or BNZ statement those fields sit in the description, and a plain copy-paste flattens them. The converter keeps all three on the transaction, so a portfolio's rent is easy to split by property, and each deposit ties back to the tenant behind it.

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

Beyond the reference fields, a long payee wraps onto a second line, and a plain export turns that into a stray row that throws the columns out. The converter joins each wrapped line back to its transaction and checks the balance across the year, so your rent total and expense totals are built on complete, reconciled data rather than a jumbled paste.

A record that holds up

Rental income is an area IRD pays attention to, and a clean, converted record does more than make the return easier to prepare — it's the evidence behind it if you're ever asked. Because every rent deposit and every expense payment is a dated row tied back to the statement, you can show exactly what came in and what went out, rather than reconstructing it later from memory or a shoebox. That matters for the interest rules in particular: with residential rental interest deductibility having changed, being able to point to the actual interest charged on the account, separated from other costs, keeps that part of the return correct. Keeping the year as reconciled data as you go turns the annual rental return from a scramble into a quick, defensible summary.