Records
The investment property spreadsheet: what to track, and where it breaks
By FreeHolder · · 7 min read
A good investment property spreadsheet tracks five things for each property: the purchase details, the rent, every expense by category, the loan (interest and principal separately), and depreciation. Set it up month by month across the financial year, from July to June, with one tab per property and expense categories that follow the ATO's rental worksheet. That gets you most of the way. The trouble starts with the things a spreadsheet doesn't do on its own: weekly rent in monthly columns, quarterly bills, mid-month changes and formulas that quietly stop adding up.
This guide covers both: what to put in, and where to watch for it going wrong. The ATO material quoted is from its Rental properties 2026 guide, which covers the 2025–26 financial year.
What should an investment property spreadsheet track?
For each property:
- Property details: address, purchase date and price, purchase costs, your ownership share, and the property manager.
- Income: rent received, and any other rental-related income.
- Expenses: every running cost, by category, with the date and amount.
- The loan: each repayment split into interest and principal, plus the balance.
- Depreciation: the yearly figures from your depreciation schedule, if you have one.
And across the portfolio: a monthly cashflow summary, and a yearly summary for tax time.
How should I set it up?
One tab per property. The ATO says to keep separate records for each property, including each unit in a block of apartments (ATO, records for rental properties; see also what records to keep, and for how long). A tab per property keeps the totals clean.
Months as columns, July to June. That's the same year your property manager's end-of-financial-year statement covers, so your totals can be checked against it. Start a new tab or file each July rather than adding columns forever.
Use the ATO's own expense categories. The ATO's rental worksheet (Rental properties 2026, for 2025–26) lists the lines your figures will end up on, including:
- Advertising for tenants
- Body corporate fees and charges
- Borrowing expenses
- Cleaning
- Council rates
- Insurance
- Interest on loans
- Land tax/State charges
- Property agent fees and commission
- Repairs and maintenance
- Water charges
- Deductions for decline in value, and capital works deductions
Using the same names means that, at the end of the year, your totals already line up with the worksheet your registered tax agent (or you) will fill in.
Record your ownership share. If you own a property with someone else, the ATO says co-owners "must divide the income and expenses for the rental property in line with their legal interest in the property" (Rental properties 2026: rental income). Joint tenants hold equal interests; tenants in common may hold unequal ones. Put the percentage on the property tab so every total can be split correctly.
Where do investment property spreadsheets break?
1. Weekly rent in monthly columns
Rent is usually quoted per week, but spreadsheets work in months. A month isn't four weeks.
Example. Fictional property: 14/22 Banksia Row, Braddon ACT, rented at $580 a week.
| Per month | Per year | |
|---|---|---|
| Counted as 4 weeks a month ($580 × 4) | $2,320 | $27,840 |
| Counted over a 52-week year ($580 × 52 ÷ 12) | $2,513.33 | $30,160 |
| Shortfall | $193.33 | $2,320 |
Check: $30,160 − $27,840 = $2,320, which is exactly four weeks' rent.
Four weeks of rent missing from the year is the kind of gap that makes a property look worse than it is all year, then doesn't match your property manager's statement in June.
2. Bills that don't arrive monthly
Strata levies usually come quarterly, council rates in instalments, insurance once a year. Entered in the month they're paid, they make some months look terrible and others look great. Your monthly cashflow swings for no real reason, and it's hard to tell a bad month from a lumpy one.
3. Changes in the middle of a month
A rent increase from the 17th, a new property manager with a different fee from the 10th, a new interest rate from the 5th. Each one means part of the month at the old figure and part at the new one. Most spreadsheets end up with the whole month at one rate, or a manual fix that nobody remembers next year.
4. Repayments not split into interest and principal
A single "loan repayment" line hides the split that matters. For tax, the deduction is for "the interest charged on the loan" (ATO, interest expenses), not the principal. On a principal and interest loan the split shifts a little every month, so you need the lender's statement, not a fixed percentage.
This is also why cashflow and your tax position can point in different directions. We explain that in cash positive but tax negative.
5. Formulas that quietly break
Insert a row, sort a column, copy last year's tab, and a total stops including what it should. Nothing turns red. The spreadsheet still shows a number; it's just the wrong one. The longer a spreadsheet lives, the more likely it is that one formula somewhere has drifted.
6. It only works if you update it
A spreadsheet is only as current as the last time you opened it. In practice, that's often once a month at best, or not until June. That's when the year gets rebuilt from bank statements, which is exactly the job the spreadsheet was meant to avoid.
When have you outgrown your spreadsheet?
You've probably outgrown it when:
- you have more than one property, or more than one loan;
- you can't say, without opening the file, whether each property is costing you money this month;
- your June totals don't match your property manager's end-of-year statement and you don't know why;
- you're the only person who understands how it works.
Keeping track of this
FreeHolder handles several of these for you. Rent, management fees, strata levies and loan repayments are entered automatically each month from the details you set up, including loan repayments on weekly or fortnightly cycles, strata levies on their own cycle, and rent or management fee changes that take effect part-way through a month. Essential is free for one property. On the Plus plan, FreeHolder adds your depreciation figures and an estimate of each property's net rental position, with a year-end report you can share with your tax agent.
Sources
- ATO, Rental properties 2026: worksheet, work out your net rental income or loss, last updated 30 May 2026
- ATO, Rental properties 2026: rental income (co-ownership), last updated 30 May 2026
- ATO, Records for rental properties and holiday homes, last updated 21 May 2026
- ATO, Interest expenses, last updated 21 May 2026
- © Australian Taxation Office for the Commonwealth of Australia
Last reviewed: 3 November 2026
General information only, not tax or financial advice. Speak to your registered tax agent about your situation.