SpreadsheetsLandlord Rental Property Tracker
Instant downloadEditable
£6.29£6.99 on Etsy · buy direct and save 10%
Buy now: instant downloadChristmas offer: 10% off with code XMAS10 at checkout, until 24 December 2026.
Or get every ThextonLabs product, including this one, in one go (new products included). See the Everything Pass
- Instant digital download, nothing is posted
- Files: PDF, XLSX
- Use on phone, tablet or computer
- Personal use licence
Checkout is handled securely by Stripe. Your download link appears straight after paying. See refunds & licence.
★★★★★
“Very happy with my purchase, instructions for download was easy to understand”
Etsy buyer review
Know which tenants have paid, what each property really makes, and when the next gas safety certificate is due, all in one spreadsheet that does the maths for you.
Made for UK landlords with 1 to 10 properties. The UK edition runs on the tax year (6 April to 5 April), groups every expense under the matching section of the property pages of the tax return, keeps mortgage interest on its own line, and gives you quarterly totals with the usual update dates. A US edition (calendar year, rental schedule lines, $) is included too. Works in Google Sheets AND Excel.
WHAT'S INSIDE (9 tabs)
- Dashboard: rent and income, running costs, profit and arrears this tax year, every property side by side (profit, your share if you own it jointly, arrears, gross yield) and the next 6 things due
- Setup: up to 10 properties with tenant, monthly rent, the day rent is due, tenancy start, deposit and scheme reference, your share and property value. 16 expense categories, each linked to a tax return section (all editable)
- Rent and Income: 600 rows for rent, late fees, deposit deductions you keep and other income
- Expenses: 600 rows. Pick a category and the tax return section fills in. Tick receipts, and missing ones are flagged
- Rent Check: every property, every month. Green = paid, amber = part paid, red = missed. Arrears worked out from the rent and due day
- Safety and Renewals: gas safety, electrical checks (EICR), energy certificates, smoke and CO alarms, deposit protection, insurance, tenancy renewals and more. Type when it was last done and how often, and lines turn amber when due soon and red when overdue
- Quarterly Totals: income and expenses for each quarter, by tax return section, with capital costs and mortgage interest kept separate
- Month by Month: income, running costs, mortgage interest and profit, with a chart
WHAT YOU GET
- 2 versions: £ (UK tax year) and $ (US calendar year)
- Quick Start guide (PDF)
Reusable every year: keep logging and the dates move on to the new tax year by themselves.
HOW IT WORKS
- Your download page opens straight after paying: download the files from there
- Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets
- Excel: just open it (Excel 2010 or later, Windows or Mac, or Excel for the web)
- Type in the cream cells. Everything else updates on its own
- A Quick Start PDF walks you through setup in 5 minutes
GOOD TO KNOW
- Plain formulas only: no macros, no add-ins, no subscriptions
- Formula cells are locked so you can't break them by accident (no password, so you can unlock and customise)
- Apple Numbers and LibreOffice aren't officially supported
PLEASE NOTE
- This is a DIGITAL download. Nothing physical will be shipped.
- Personal use only. Please don't share or resell the files.
This is a record-keeping tool, not tax or legal advice. It does not send anything to the tax office: quarterly updates need recognised software (bridging software can read your spreadsheet). Always check the official rules for your property.
Designed by Thexton Labs. Artwork and layouts were created with our own code, with the help of AI tools.