UK Landlord Spreadsheet 2026/27 | Rent Tracker, Arrears, Deposits, Gas Safety and EICR Dates, SA105 Expenses | Excel and Google Sheets

UK Landlord Spreadsheet for Excel and Google Sheets — rent tracker with arrears, tenancy deposits, Gas Safety / EICR / EPC expiry dates and SA105-style expense categories, organised by the UK tax year (6 April – 5 April). England, Wales and Scotland. No subscription.

Built for UK landlords, not converted from a US template: weekly, fortnightly and 4-weekly rent, HMO rooms, Universal Credit, deposit protection deadlines by nation, and finance costs kept apart (Section 24).

✅ RENT AND ARREARS — AUTOMATIC

• Weekly, fortnightly, 4-weekly, monthly, quarterly or annual rent
• Part, late and early payments; rent increases mid-tenancy; grace period
• Arrears now, days late and since when — including rent still unpaid from earlier tax years
• Rent due in the next 45 days

✅ TENANCIES AND DEPOSITS

• One row per tenancy, full history kept (move-outs, new tenants, renewals)
• Deposit protection deadline for England, Wales and Scotland (Scotland: 30 working days)
• Prescribed information reminder, deposit cap check (England 5/6 weeks), deposit return at the end of the tenancy

✅ CERTIFICATES AND COMPLIANCE

• Gas Safety (CP12), EICR, EPC, smoke and CO alarms, Legionella, HMO / selective licences
• PRS Database, Rent Smart Wales, Scottish Landlord Register
• Expiry dates calculated, alerts at 90 / 60 / 30 days, missing certificates flagged per property

✅ EXPENSES, SA105 AND MTD QUARTERS

• Every expense mapped to a suggested SA105 box (you can change them)
• Mortgage interest shown separately as a residential finance cost (Box 44)
• Quarterly totals by Making Tax Digital update period, ready to use with HMRC-recognised bridging software
• Capital costs log (purchase price, stamp duty, legal fees) and a 60-day CGT reminder when you sell

✅ DASHBOARD AND REPORTS

• Rent roll (PCM), money in, arrears and cash flow at a glance
• Filter by tax year, MTD quarter or property
• Profit before finance costs, cash flow, yields, void days per property — and a split for joint owners

WHAT'S INCLUDED

• READY workbook (.xlsx) for your own portfolio
• DEMO workbook with fictional UK sample data
• Google Sheets versions (READY and DEMO — open the link, Make a copy)
• Quick Start Guide (2-page PDF) and User Guide (20-page PDF)

GOOD TO KNOW

• Works in Microsoft Excel 2019 or newer / Microsoft 365 (Windows and Mac) and Google Sheets
• No macros, add-ons or subscription — your data stays in your own file
• Pounds sterling (£), DD/MM/YYYY dates, British English
• Up to 25 properties, 100 units or HMO rooms, 100 tenancies, 2,000 payments and 2,000 expenses
• Northern Ireland: basic support (deposit deadline and cap, notice period, registration)
• This is an organisational tool. It is not accounting or tax software, it is not HMRC-recognised software, it does not submit anything to HMRC and it is not tax or legal advice. SA105 boxes and dates are reminders based on official guidance — check GOV.UK or a qualified adviser.

🚀 LAUNCH OFFER: use code LAUNCHUK for €6 off until 2 December 2026.

INSTANT DIGITAL DOWNLOAD — no physical item will be shipped.

BOMDOXI — Simple tools. Smarter work.