Free spreadsheet for your actual rental costs

Track what your rental properties really cost you

The Property Ledger records what each property actually costs you, month by month, from your statements. These are your real numbers, not a model.

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.

What's inside

  • A tab for each propertyYour loan, rent and yearly costs, then a row for each month: interest charged, rent received, expenses paid and the cash flow left over.
  • Your plan against what happenedCopy the weekly figure from your model, such as the Holding Power Check, and the Ledger shows it next to what the property has actually cost on average. The gap is where the surprises are.
  • Your whole portfolioValues, loans, loan to value, usable equity estimates and cash flow for every property, on one page.
  • Tax time in one placeA year of interest, rent and expenses already recorded, ready to send to your accountant.

Model or actuals?

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 CheckProperty Ledger
What it isA modelYour actual numbers
When you use itBefore you buy, and when things changeEvery month after you buy
Based onAssumptions: rate, rent, vacancy, growthYour loan, rental and bank statements
AnswersWhat should this property cost me?What did it actually cost me?

What three months look like

The example property in the Ledger: a $520,000 interest-only loan at 6.5%, rented at $560 a week.

MonthInterest paidRent receivedExpenses paidCash 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.

How to use it

  1. Make your own copy. The link creates a copy in your Google account. It's yours, and we never see it.
  2. Fill in each property's details once: loan, rate, rent and yearly costs.
  3. Enter last month from your statements: interest from your loan statement, rent from your property manager's statement, and expenses from your bank account.
  4. Add each new month as the statements arrive, then check the Portfolio tab.

Why I built it

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

Questions people ask about the Ledger

What is the Property Ledger?

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.

Is it free?

Yes. Enter your email and we'll send you the link. You'll also get our newsletter, and you can unsubscribe at any time.

Do you see my numbers?

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.

What should I enter each month?

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.

Why interest and not my loan repayment?

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.

How many properties does it cover?

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.

Does it help at tax time?

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.

How is it different from the Holding Power Check?

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.

Is this financial advice?

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.

Three months of real numbers?

Bring your Ledger to a review. We'll go through it against your goal and your next purchase.

Book a call