UK Landlord Spreadsheet, Rental Property Management Tracker, Excel & Google Sheets

🏠 Run your whole UK rental portfolio from one spreadsheet — rent, arrears, compliance, maintenance and tax. Works in Excel and Google Sheets. Instant download.

Most landlord spreadsheets are just a list of numbers.
This one tells you what needs doing.

Open it and you can see at a glance who is late with rent, which gas certificate expires next, which lease is ending, and what your tax bill is shaping up to be — all worked out from what you already typed in.

Made for the UK, so the tax and compliance side matches the rules you actually live with.

━━━━━━━━━━━━━━━━━━━━

✨ WHAT IT DOES FOR YOU

💷 Works out the balance, days overdue, arrears band and the next chase action for every tenant

🔔 Live action list on the dashboard — overdue rent, expiring certificates, urgent repairs, unprotected deposits, missing receipts

🛡️ Certificate expiry dates calculated from the issue date — gas 12 months, EICR 5 years, EPC 10 years (all editable)

📋 A compliance matrix that fills itself in: every property against every requirement — OK, DUE SOON, OVERDUE or MISSING

⏳ Lease expiry countdowns and deposit 30-day protection deadlines

🧾 Expenses tagged for tax automatically — pick a category and the tax treatment, SA105 box and MTD category fill in on their own

📈 Yield, equity, LTV, occupancy and cash flow for every property

🇬🇧 Income tax estimate including the Section 24 finance cost credit

📊 Charts and monthly summaries that redraw themselves

━━━━━━━━━━━━━━━━━━━━

📦 WHAT YOU GET — 3 files, instant download

1️⃣ Main workbook — blank and ready, formulas already built into every row

2️⃣ Demo workbook — the same file filled with example data so you can see it running

3️⃣ User guide (PDF, 7 pages) — setup in six steps, sheet-by-sheet reference and a full FAQ

📁 28 linked sheets · 100 properties · 200 tenancies · 500 rent rows · 500 transactions · 300 maintenance jobs

━━━━━━━━━━━━━━━━━━━━

📑 THE SHEETS

🔹 Daily use — Dashboard · Portfolio Overview · Rent Ledger · Transactions · Maintenance

🔹 Your records — Properties · Tenants & Leases · Deposits · Documents · Contractors

🔹 Staying legal — Compliance · Compliance Matrix · Inspections · Move In-Out · Landlord Checklist

🔹 Money & tax — Monthly Summary · Property P&L · Expense Summary · Tax & SA105 · MTD Quarterly

🔹 Supporting — Mortgage & Section 24 · Tax Deadlines · Mileage Log · Bank Reconciliation · Receipt Tracker

🔹 Setup — Start Here · Setup & Controls · Reference & Sources

━━━━━━━━━━━━━━━━━━━━

👤 WHO IT IS FOR

✔️ First-time landlords with one property who want to start properly
✔️ Portfolio landlords juggling several properties and tenancies
✔️ HMO landlords tracking rooms, licences and fire safety
✔️ Letting agents and rent-to-rent operators — head rent, management fees, rechargeable costs and owner payable are all handled
✔️ Anyone who dreads January and wants their figures ready before it arrives

━━━━━━━━━━━━━━━━━━━━

💻 WORKS WITH

✔️ Microsoft Excel — Windows and Mac · 2016, 2019, 2021 and 365
✔️ Google Sheets — free, in any browser (File ▸ Import ▸ Upload ▸ Replace spreadsheet)
✔️ Also opens in LibreOffice Calc and Apple Numbers (a few colours and dropdowns may look different)
✔️ No macros · no add-ons · no subscription · nothing password protected
✔️ View on tablet or phone in the Excel or Sheets app — typing is easier on a laptop

━━━━━━━━━━━━━━━━━━━━

🚀 HOW IT WORKS

1️⃣ Buy and download — files land in your Etsy downloads straight away, nothing is posted

2️⃣ Open the demo file first to see it running, then work in the blank one

3️⃣ Follow Start Here — six steps, about 20 minutes, then roughly 10 minutes a month

━━━━━━━━━━━━━━━━━━━━

❓ FREQUENTLY ASKED

Do I need to be good at Excel?
No. You type into the cream cells, the blue ones work themselves out. Nothing to build, no formulas to drag down.

Does it start over each month?
No. Add the new month's rows underneath and everything updates. Your history stays put.

Can I use it for more than one property?
Yes — up to 100, and you can filter the dashboard down to any single one.

Is my data going anywhere?
No. It is a file on your computer or your Google Drive. Nothing is uploaded to us, nothing needs an internet connection.

Can I change it?
Yes. Nothing is locked — rename sheets, add columns, change the colours. It is yours.

Will it still work next tax year?
Yes. Change the reporting year and tax year start on the Setup sheet. Allowances and rates sit there too, so it keeps working when HMRC changes them.

━━━━━━━━━━━━━━━━━━━━

ℹ️ PLEASE NOTE

📥 Digital download — no physical item is shipped. All sales are final and it cannot be returned. If something is not working, message me and I will sort it.

⚖️ This workbook is a record-keeping and planning tool, not tax, legal or financial advice, and