Rental income & expense tracker
Free New Zealand Rental Property Tracking Spreadsheet
Pre-populated Excel to track rental income and expenses for New Zealand — Transfer Tax and closing costs included. Generate a free rental property tracking spreadsheet with live formulas — track income and expenses month by month for New Zealand property. Pre-populated with Transfer Tax, closing costs, and per-item expense rows.
What's inside → See what's inside the tracking spreadsheet ROI calculator → Need full ROI analysis? →
How it works
- 1. Enter details — purchase price, rent, expenses, and mortgage terms below. — price, rent, expenses below.
- 2. Generate — we calculate Transfer Tax, closing costs, and a year-one projection. — Transfer Tax and closing costs calculated.
- 3. Download & track — log actual rent and costs in the workbook each month. — log actuals monthly in Excel.
Monthly income tracking
| Month | Est. income | Actual | Used |
|---|---|---|---|
| Jan | 12,500 | — | 12,500 |
| Mar | 12,500 | — | 12,500 |
Yellow cells are editable inputs — change purchase costs, rent, or expense assumptions. = editable inputs (costs, rent, assumptions).
Blue cells are where you log actuals. The Used column picks your actual when entered. = log actuals; Used picks actual when entered.
What's in your tracking spreadsheet
A 7-sheet rental property income tracker — log actuals monthly and compare against your projections over time.
Seven interconnected sheets — Summary, Purchase Costs, Income, Expenses, Projection, Exit Scenario, and Notes — with live formulas and monthly actuals tracking.
More calculators