Property - Template 15
Rental Property & Landlord Tracker
Run your whole buy-to-let portfolio from one spreadsheet.
Microsoft Excel◆Google Sheets◆.xlsx file
Run your whole property portfolio from one simple spreadsheet. Log the rent and the costs for each property and your value, yield, cashflow, arrears and 5-year equity all update themselves. Built for UK buy-to-let landlords and ready for Self Assessment, with categories that follow the HMRC SA105 property pages. Track 1 to 50 properties in one file, see who has paid and which months were void, keep a mileage log and even model a short-let or Airbnb unit. Realistic sample data (a 5-property portfolio worth £1,000,000) is included so you can see it working. No formulas to write, and you can change the currency in one click.
What's inside · 9 tabs
- Portfolio Dashboard - value, gross rent, net profit, yield and occupancy at a glance - plus a where-your-rent-goes breakdown, income vs expenses by property, monthly cashflow and a live 5-year equity trend
- Properties - your register of up to 50 units - equity, gross yield and loan-to-value worked out for each one
- Income & Expenses - one ledger for every property, each transaction categorised to its HMRC SA105 property box
- Rent & Tenant Ledger - who has paid, who is in arrears and which months were void - with occupancy worked out for you
- 5-Year Overview - value, rent, profit and equity year on year for the long view
- Mileage Log - simplified 45p / 25p per-mile travel for trips to your properties
- Short-Let & Airbnb - a nightly-let calculator - nights, occupancy, cleaning, platform fees and net profit, month by month
- Settings - your property list, categories and currency drive everything - re-list-ready each year
In Motion
Your portfolio, worked out for you.
Log rent and costs per property and the dashboard answers - value, yield, cashflow, arrears and a 5-year equity trend, all live.
Pairs Beautifully With
