Free spreadsheet for your actual rental costs
The Property Ledger records what each property actually costs you, month by month, from your statements. These are your real numbers, not a model.
By James Nelis, licensed buyers agent, The Nelis Group
The short answer: the Property Ledger is a free Google Sheets template for recording actuals, not modelling. Each month you enter what your lender charged, what rent arrived and what you paid out, from your statements. It shows your real weekly cash flow, property by property and across your whole portfolio. It's a blank version of the sheet I use for my own properties.
They answer different questions, and you need both. The model tells you what a property should cost before you buy. The Ledger tells you what it actually costs once you own it.
| Holding Power Check | Property Ledger | |
|---|---|---|
| What it is | A model | Your actual numbers |
| When you use it | Before you buy, and when things change | Every month after you buy |
| Based on | Assumptions: rate, rent, vacancy, growth | Your loan, rental and bank statements |
| Answers | What should this property cost me? | What did it actually cost me? |
The example property in the Ledger: a $520,000 interest-only loan at 6.5%, rented at $560 a week.
| Month | Interest paid | Rent received | Expenses paid | Cash flow |
|---|---|---|---|---|
| July | $2,817 | $2,427 | $187 | -$577 |
| August | $2,817 | $2,427 | $1,062 | -$1,452 |
| September | $2,817 | $2,427 | $2,037 | -$2,427 |
| Total | $8,451 | $7,281 | $3,286 | -$4,456 |
The model said this property should cost about $274 a week. Over these three months it cost $343 a week. Rates, water, insurance and fees were all in the model, so they weren't the problem. The hot water system was: it failed in September and cost $1,850, almost double the year's maintenance allowance. Without it, the quarter came in under the model. The other thing the Ledger catches is interest that's higher than planned, which usually means cash is sitting outside your offset.
I track my own properties in a sheet like this. The plan tells you what a property should cost. The Ledger tells you what it did cost, and the two are rarely the same.
One year I spent $10,000 on plumbing, with a fence replacement being quoted and gutters leaking at the same time. None of that was in the plan. It's in the Ledger, along with the month a rent went up and the week a rates notice arrived. After a few months, you stop guessing what your portfolio costs you.
James Nelis, Director and Lead Buyers Agent, The Nelis Group
It's a free Google Sheets template for tracking what each rental property actually costs you: the interest charged, the rent received and the expenses paid, month by month. It adds up your whole portfolio on one page. It's a blank version of the sheet James Nelis uses for his own properties.
Yes. Enter your email and we'll send you the link. You'll also get our newsletter, and you can unsubscribe at any time.
No. The link makes your own copy in your Google account. Your figures stay in your copy, and we can't see them. An Excel version is included if you don't use Google.
Three things from your statements: the interest your lender charged, the rent your property manager paid you, and everything else that left your account, such as rates, water, insurance, strata and repairs. Start with last month, because every figure has a statement behind it.
Interest is the cost of holding the property. On a principal and interest loan, part of each repayment pays down the loan, which is your money building equity, not a cost. Recording interest shows the property's true cash flow.
It comes with five property tabs, and you can leave any you don't need blank. If you own more, right-click a property tab, choose Duplicate and rename it Property 6, 7 and so on, up to Property 10. The Portfolio tab picks it up automatically.
Yes, because your interest, rent and expenses are already recorded month by month, in one place. Your accountant still prepares your return and decides what can be claimed. The Ledger keeps the records organised.
The Holding Power Check is a model. It estimates what a property should cost you, year by year, from assumptions about rates, rent and vacancy. The Ledger records what it actually costs, from your statements. Use the model to plan, and the Ledger to see what really happened.
No. It's a template for recording your own numbers, and general information. Lending decisions sit with your mortgage broker, tax with your accountant, and your wider personal finances with a licensed financial adviser.
Bring your Ledger to a review. We'll go through it against your goal and your next purchase.
Book a callFree investor emails
How I buy, what I hold and when I walk away.
Start with the decision rules I use, in the order you'll face them. Unsubscribe any time.