Rental Property Portfolio Tracker UK

Rental Property Portfolio Tracker UK: yield, cash flow, arrears, voids and compliance dates for up to 20 rental properties, in pounds, in Excel and Google Sheets.

Most landlords know what rent they are owed. Fewer know what each property earns after costs and mortgage, which one has gone quiet, or when the gas safety date comes round. This workbook puts all of it on one dashboard, in pounds, for up to 20 properties.

WHAT THE DASHBOARD SHOWS, FOR EACH PROPERTY AND FOR THE WHOLE PORTFOLIO

• Gross yield and net yield
• Cash flow per month, after running costs and the mortgage payment
• Return on the cash you put in (your share, if you own part of it)
• Equity and loan to value
• Void months
• Rent arrears
• Income, costs and profit for the year to date
• Compliance dates with red, amber and green flags

WHAT YOU TYPE IN

• Properties: address, purchase price and date, current value, mortgage balance, interest rate, monthly payment, ownership share and the cash you put in. Up to 20.
• Tenancies: tenant, start and end dates, rent, deposit amount and the deposit protection reference. A renewal flag turns amber and red as the end date gets close.
• Monthly rent log: type what you received each month. The workbook fills in the rent you expected from your tenancies and keeps a running total of arrears.
• Costs log: one line per cost, picked from 12 categories such as repairs, insurance, letting fees and council tax while empty.
• Compliance: the next date for gas safety, EICR, EPC expiry, insurance renewal and any licence. Days left are counted from today and coloured. Keep your own records of these dates.

You type only in the pale yellow cells. Everything else is a formula and is locked (no password, so you can unprotect a sheet if you want to change something).

HOW THE NUMBERS WORK

Year to date runs from the first month you set to today. Rent and costs for that period are scaled up to a full year for the yields and the cash flow. Gross yield is rent per year over current value. Net yield takes running costs off the rent first. Mortgage payments are left out of both yields and counted in cash flow. You type the current value yourself; the workbook does not look it up.

WHAT YOU GET

Two .xlsx files, ready to download straight after purchase: an example copy with three made-up lets so you can see it working, and a blank copy for your own portfolio. They open in Excel 2016 or later and in Google Sheets (File, Import, Replace spreadsheet). No macros. Functions used are ordinary ones (SUMIFS, COUNTIFS, IF), so it behaves the same in both.

WHAT IT DOES NOT DO

It does not work out tax. For tax records and Making Tax Digital totals, see the Landlord MTD Record Book from High Street Stack, and use the free landlord tax calculator at highstreetstack.com/tools/landlord-tax-calculator. It does not connect to a bank or send anything anywhere. Figures are estimates for your own planning, not financial advice.

Questions: help@highstreetstack.com