Skip to content

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:

  1. Property details: address, purchase date and price, purchase costs, your ownership share, and the property manager.
  2. Income: rent received, and any other rental-related income.
  3. Expenses: every running cost, by category, with the date and amount.
  4. The loan: each repayment split into interest and principal, plus the balance.
  5. 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 monthPer 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

Last reviewed: 3 November 2026

General information only, not tax or financial advice. Speak to your registered tax agent about your situation.

Your investment property deserves better than a spreadsheet.

Join early access. Founding member pricing, open to the first 100 members. Limited-time offer · terms apply

Join early access

Be first in when FreeHolder opens, and get the founding member offer: Plus at $99 a year, open to the first 100 members. Waitlist members hear first. Limited-time offer · terms apply

We'll email you when FreeHolder opens and send occasional updates, articles and offers. Unsubscribe any time. See our Privacy Policy.