01
Certificate Log
Expiry date, days left and a status for every record (Valid, Due soon, Expired, Done or Superseded), with Check messages for text in date columns or names not on your lists
For UK landlords, HMO landlords & small agents
7 reasons UK landlords stop tracking certificates in their head
A gas safety record that ran out last week, an EICR copy the tenant never got, and a new government Information Sheet you are not sure you gave. This tracker keeps every certificate and check for every property in one place, and tells you what is valid, due soon, expired or missing.
- Excel & Google Sheets, no macros
- Example + blank file
- Start-here guide
- One-off price, no subscription
Screens from the included example file. All names and figures are fictional.
50properties in one file
12requirements pre-set, from CP12 to HMO licence
1,000certificate records
0macros, add-ons or subscriptions
The list
Why a ready-made tracker beats paper and a blank spreadsheet
02
Tenant copies
For gas, EICR and deposit records, the date a copy is due (28 or 30 days, or the tenancy start) and whether it was given on time
Get the tracker · £16.99 Instant download · Excel & Google Sheets
03
Compliance Matrix
Every property against 12 requirements, with MISSING items and an overall status per property
12 requirements pre-set
Gas safety (CP12), EICR, EPC, smoke and CO alarms, deposit protection, Right to Rent, Legionella, PAT, HMO licence, fire risk assessment, selective licence and insurance. Rename them and change the months
Smart rules
Gas items only for properties with gas, PAT for furnished lets, HMO items for HMOs and licences for licensed properties
Tenancy Checks (England)
Renters' Rights Act Information Sheet or written terms, EPC rating (E now, C by 1 October 2030) and your PRS Database regional deadline
Dashboard
Compliance score, a "What needs your attention" list, a 12-month renewals and cost forecast, and 4 charts
Get the tracker · £16.99 Instant download · stuck? Email us for help
Compare
Three ways to keep these records
| Feature | Paper or notes | A blank spreadsheet | This tracker |
|---|---|---|---|
| Certificate Log | ✗No | ~ If you build it | ✓ Built in |
| Tenant copies | ✗No | ~ If you build it | ✓ Built in |
| Compliance Matrix | ✗No | ~ If you build it | ✓ Built in |
| 12 requirements pre-set | ✗No | ~ If you build it | ✓ Built in |
| Smart rules | ✗No | ~ If you build it | ✓ Built in |
| Cost | Free, plus your time | Free, plus your time | £16.99 once |
What's inside
Everything you download
3 files
- XLSX UK-Landlord-Compliance-Tracker.xlsxfilled with fictional example data (8 properties, 69 records) so you can see how it works
- XLSX UK-Landlord-Compliance-Tracker-BLANK.xlsxan empty copy, ready for your own properties
- PDF Start-here.pdfone-page quick-start guide, including how to open it in Google Sheets
Also included
- Due List: the 40 most urgent items, expired first
- Property Pack: one printable page per property with every certificate, tenant copy and tenancy check, plus a sign-off…
- Up to 50 properties and 1,000 certificate records
Good to know
- A Health check on the Start Here tab and a Check/Status column on every log flag missing or odd entries
- Renters' Rights Act: in force from 1 May 2026. For written tenancies that started before then, the government Information Sheet had to be given by 31 May 2026
- PRS Database: registration opens 15 December 2026, with a 3-month window per region in England (dates on Settings, editable)
- EPC: minimum rating E now; the government has confirmed C by 1 October 2030 for England and Wales
Is it right for you?
Made for some, honestly not for others
A good fit if you…
- UK landlords, portfolio and HMO landlords and small letting agents
- use Excel or Google Sheets on a computer
- want to pay once, not another subscription
Not for you if you…
- need Apple Numbers or mobile-only editing
- want someone to do the records for you
How it works
Three steps, about 10 minutes to set up
- 1
Set up once
Your settings and properties (about 10 minutes)
- 2
Log as you go
One row per certificate or check, and the tenancy details
- 3
Check and act
Open the Dashboard and Due List, print a Property Pack when you need one
Microsoft Excel2010 or newer (Windows & Mac) and Microsoft 365
Google SheetsFree Google account. Upload the .xlsx, then set the locale to United Kingdom
0
No macrosNothing to enable, no add-ons or subscriptions. Not designed for Apple Numbers or mobile-only editing. A computer is recommended
- Instant download
- Example + blank file
- Start-here guide
The offer
Master UK Landlord Compliance Tracker
£16.99one-off · no subscription
- Filled with fictional example data (8 properties, 69 records) (UK-Landlord-Compliance-Tracker.xlsx)
- An empty copy, ready for your own properties (UK-Landlord-Compliance-Tracker-BLANK.xlsx)
- One-page quick-start guide, including how to open it in Google Sheets (Start-here.pdf)
- Licensed for use within one business or household
Price includes VAT where applicable — calculated at checkout. Secure checkout by Payhip.
Questions? Email info@phkmedia.co.uk
Stuck after you buy? We'll help you set it up.
Digital download, nothing is posted. This tracker is a record-keeping aid, not legal advice. Terms & licence.
FAQ
Questions people ask
Does it send reminders?
No. It is a spreadsheet: open it weekly and the statuses update to today's date.
Does it work on a phone?
You can view it in the Google Sheets app, but entering data is easiest on a computer.
What happens after I pay?
This is a digital product. Nothing physical will be shipped. Your download link appears straight after checkout and is also emailed to you.
Can I get help if I'm stuck?
Yes. Message us at info@phkmedia.co.uk and we'll help you set it up.