Bank Statements for a Home Loan (New Zealand) — Convert to Excel

What the lender assesses

New Zealand lenders work within the responsible-lending framework, and a mortgage assessment turns on affordability. From your statements they check:

• Income. Salary or self-employed income landing regularly, matching what you've stated.
• Regular expenses. Your actual living costs and commitments, which the servicing test measures against the new repayments.
• Existing debt. Other loans, buy-now-pay-later and card payments that reduce what you can service.
• Conduct. A steady account without unarranged overdrafts or dishonoured payments.

Seeing three months as sortable rows means you understand your own affordability before the bank runs its test.

From PDF to a clear spreadsheet

1. Download the recent months' 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 so income and spending are in one place.
4. Total the key figures. Sum your income, group your regular outgoings, and list existing debt payments — the inputs to the servicing test.

The servicing test, and how spending reads

The heart of a NZ mortgage decision is the servicing calculation: can your income cover the new repayment on top of your existing commitments and living costs, with a buffer. Lenders increasingly scrutinise discretionary spending, so how your account reads matters. With your statements converted, you can group spending into categories, see where the regular commitments are, and identify anything a lender might flag — frequent buy-now-pay-later instalments, gambling, or a run of unarranged overdrafts. Knowing that in advance lets you tidy where you genuinely can and explain what you can't, rather than being caught out mid-application.

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 — making your spending picture harder to read, not easier. The converter joins each wrapped line back to its transaction and checks the balance across the months, so your income and outgoings are clean, complete and tie out.

Pre-approval and your deposit

Most people convert their statements at pre-approval, when the bank is sizing what you can borrow, and it's the moment the picture matters most. Two things stand out in the account at that stage. Your deposit — and in particular your genuine savings, money you've built up rather than been gifted — is strong evidence to a lender, so a steady transfer to a savings account, or a growing balance, is worth being able to show clearly. And the bank wants to see that your everyday spending leaves room for the repayment, not that every dollar is already committed. Converting the statements lets you total your savings pattern and your discretionary spending separately, so at pre-approval you can point to what supports the application rather than leaving the lender to piece it together. It's the difference between a smooth pre-approval and a request for more information.