Settlement Apportionment Calculator NZ
Nothing about a property settlement surprises first home buyers more than the outgoings adjustment, because it appears late, it is never a round number, and it can go either way. The idea behind it is simple enough. Councils and body corporates bill for a whole period, the house changes hands part way through, and somebody has to work out who owes what for which days. The part that catches people is the second step: the split by days is then netted against what has actually been paid, so a vendor who paid two instalments in advance is reimbursed on settlement day and a vendor who paid nothing hands over a credit instead. Which of those you are looking at has nothing to do with fairness and everything to do with the vendor's payment habits, which is why the figure cannot be guessed in advance.
| Outgoing | Amount for the period | Period starts | Period ends | Paid by vendor so far |
|---|---|---|---|---|
| Council rates | ||||
| Water | ||||
| Body corporate levy Leave at zero for a freehold house |
Each outgoing, split by days
| Outgoing | Full period | Vendor's share | Purchaser's share | Already paid | Adjustment |
|---|---|---|---|---|---|
| Council rates | $3,600.00 | $749.59 | $2,850.41 | $1,800.00 | $1,050.41 |
| Water | $700.00 | $145.75 | $554.25 | $0.00 | -$145.75 |
| Body corporate levy | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Net adjustment | $904.66 |
A positive adjustment is payable by the purchaser to the vendor, because the vendor has paid for days the purchaser will own. A negative one is a credit to the purchaser, because a bill is coming that covers days the vendor owned.
The rates adjustment in full
Why the adjustment can go either way
The split by days is only half of the calculation, and it is the half people expect. The other half is what has actually been paid, and that is where the direction comes from. A vendor who has paid two rates instalments in September has paid for months the purchaser will own, so the purchaser reimburses them and the adjustment is payable on settlement. A vendor who has paid nothing has left a bill that will arrive in the purchaser's name covering months the vendor owned, so the vendor credits the purchaser and the adjustment reduces what changes hands. The same property, the same date and the same rates bill can therefore produce an adjustment in either direction, which is why it cannot be estimated without knowing the vendor's payment position.
The rating year is the reason the numbers look odd
Council rates run 1 July to 30 June and are usually billed in four instalments, which means the amount paid at any point in the year bears no simple relation to the time elapsed. Settling in mid September, roughly a fifth of the way through the year, a vendor may well have paid half. That mismatch is the whole source of the adjustment, and it is also why the figure is rarely round. It is a daily rate multiplied by an awkward number of days, netted against instalments that follow their own schedule.
Special levies are a separate conversation
Ordinary body corporate levies apportion by days like anything else. A special levy does not necessarily follow, because it is struck for a particular purpose at a particular time, and whether it falls on the vendor or the purchaser turns on when it was resolved and what the agreement says. It is one of the few items in a settlement that can run to tens of thousands of dollars, and it is worth asking the question before the agreement goes unconditional rather than after.
Worked example
Settlement is Tuesday 15 September 2026. Rates for the year 1 July 2026 to 30 June 2027 are $3,600.00 across 365 days. The vendor owns the property for 76 days of that year and the purchaser for 289 days.
The vendor's share is $749.59 and the purchaser's is $2,850.41. Because the vendor has already paid $1,800.00, which is more than their share, the purchaser reimburses the difference of $1,050.41.
Water of $700.00 for the same period has not been paid at all, so the vendor's share of $145.75 becomes a credit to the purchaser. Netting the two leaves $904.66 payable by the purchaser to the vendor on settlement.
How this is calculated
For each outgoing the period length is counted in days from the first day to the last day inclusive. The vendor's days run from the start of the period to the settlement date, and the purchaser's days are the remainder, with the setting for who bears settlement day moving the boundary by one. Each party's share is the amount for the period multiplied by their days divided by the total days. The adjustment for that outgoing is what the vendor has paid less the vendor's own share, so a vendor who has paid more than their share is owed the difference and one who has paid less owes it. The net adjustment is the sum of those three figures, and a positive result is payable by the purchaser.
Official sources
- Local Government (Rating) Act 2002, legislation.govt.nz
- Unit Titles Act 2010, legislation.govt.nz, for body corporate levies
- Buying and selling property, New Zealand Law Society
Related NZ calculators
- Settlement Funds Shortfall Calculator for what has to be available on the day
- House Closing Costs Calculator for the other costs of buying
- Rates Bill 2026 Estimator for the rates themselves
- Late Settlement Interest Calculator if the date is at risk
- Unit Title Long-Term Maintenance Levy Calculator for body corporate levies
Related calculators
- Settlement Funds Shortfall Calculator NZ: What Has to Be There on the Day.
- Sunset Clause Exposure Calculator NZ: Buying Off the Plans.
- Vendor Marketing Spend (VPA) Break-Even Calculator NZ 2026/27: a basic against a premium marketing package.
- Auction Day Cash Required Calculator NZ: What You Need on the Day.