Rental Property Tracker

Rent, arrears, tenants, expenses and the real yield on every property you own. One file for the whole portfolio.

6 tabs, all connected

• Start Here — Portfolio, tax year, set-aside %
• Dashboard — Rent roll, arrears, profit, yields
• Properties — 15 properties
• Tenants — Leases with days left
• Rent Ledger — 400 rent rows
• Expenses — 300 rows per property
• Blank + Demo files — Start clean or explore the demo

What it does

Rent in, money out, what is really left

• Rent roll, collected, arrears, collection rate
• Expenses and net profit
• Tax to set aside from your own %
• Occupancy, and net yield per property

You always know who has not paid

• One row per month per property
• Due vs paid, arrears calculated
• Status writes itself: Paid, Part paid, Unpaid, Due
• 400 rows

Every property, with its own numbers

• What you paid, the monthly rent, the tenant
• Rent collected and expenses per property
• Gross yield, calculated
• Let, empty, being refurbished, for sale

No lease ever expires by surprise

• Lease start and end, deposit, contact
• Days left, counted from today
• Expired / renew soon / running, colour coded
• 25 tenants

Costs attached to the right property

• 12 landlord categories
• Repairs, insurance, management, service charge
• Feeds the net profit and net yield
• 300 rows

Set up in 15 minutes

1. Download & open — Open in Excel, or upload to Google Drive and choose 'Save as Google Sheets'.
2. List the properties — What you paid and the monthly rent. That gives you the yields.
3. Log rent and costs — A row per month per property, and every expense against the property it belongs to.

• One flat or fifteen
• Any currency, any country
• A tracking tool, not tax or investment advice

What you receive

An instant download containing a blank file to start clean, a demo file filled in so you can see how it works, and a short read-me. Works in Google Sheets (free) and in Microsoft Excel, on a phone, a tablet or a computer. Any currency, any country.

Digital download — nothing is posted. No refunds on digital files, but message us if anything does not work and we will fix it.