Social Housing Repairs Under Awaab's Law: Tracking Deadlines Without Spreadsheets

Imagine your repairs spreadsheet has over a hundred open rows. Some of those cases have Awaab's Law deadlines expiring in the next five working days. You do not know which ones — not without manually checking each row, recalculating working days around the Easter bank holidays, and hoping nobody entered a date wrong three weeks ago.

This is the gap that Awaab's Law exposed. The deadlines are strict, the penalties are real, and the tracking systems most small providers use were never designed for statutory compliance. (For the full deadline framework, see The Complete Guide to Awaab's Law.)

The Tracking Problem Is Specific

General repairs tracking — logging what broke, who reported it, which contractor is assigned — works fine in spreadsheets. Awaab's Law compliance tracking is different because it adds three requirements that spreadsheets handle badly:

Working-day countdown deadlines. Every Awaab's Law timeframe runs on working days, excluding weekends and England and Wales bank holidays. A 10-working-day investigation deadline starting on a Monday before a bank holiday weekend is not "two weeks from Monday." It is 14 calendar days. Get this wrong once and you might catch it. Get it wrong across 50 concurrent cases and the errors compound silently. The MHCLG Digital team found that poor data costs housing repairs and allocations an estimated £400 million per year — deadline miscalculations are one piece of that.

Cascading deadlines. Awaab's Law deadlines are sequential: the investigation deadline triggers the make-safe deadline, which triggers the supplementary works deadline. Each downstream deadline is calculated from when the previous step completed — not from the original report date. In a spreadsheet, this means updating formulas in real time as each step closes. Miss one update and every subsequent deadline for that case is wrong.

Audit trail completeness. When the Housing Ombudsman requests evidence for a case, they want a single timeline: report received, investigation completed, tenant notified, works ordered, works completed, with dates and supporting documents at each stage. In a spreadsheet workflow, the evidence sits in email attachments, shared drives, contractor portals, and sometimes filing cabinets. Reconstructing the timeline takes hours or days — time you do not have during an active complaint investigation.

What Actually Breaks

Three common failure patterns in Awaab's Law compliance at small providers:

1. The silent miscalculation

A housing officer creates a new case row on Tuesday. They type a formula to add 10 working days for the investigation deadline. The formula uses NETWORKDAYS but references a bank holiday list that was last updated in January — missing the May bank holiday. The calculated deadline is one working day early. Nobody notices because the wrong date looks exactly like a right date.

Check your existing cases now: the deadline calculator handles all 2026 bank holidays automatically. If any of your spreadsheet deadlines disagree with the calculator, investigate why.

2. The handoff gap

A housing officer goes on leave. Their colleague covers the caseload but does not understand the spreadsheet structure — which column tracks which deadline, which cells need updating when an investigation completes, which cases are flagged amber. By the time the original officer returns, three cases have silently passed their make-safe deadline because the covering officer updated the wrong column.

3. The evidence scramble

A tenant escalates a complaint to the Housing Ombudsman eight months after the original report. The housing officer needs to reconstruct the full case timeline. The original report was an email (in the officer's inbox — they have since left the organisation). The inspection photos are on the contractor's phone. The written summary was a Word document saved to a shared drive folder that has since been reorganised. The completion certificate is in a paper file.

The GOV.UK guidance requires landlords to keep clear records of all correspondence with residents and contractors. "Clear records" means producible on request — not theoretically recoverable from scattered systems.

What a Workable System Needs

You do not necessarily need expensive software. But you do need a system — whether it is a better-structured spreadsheet, a low-code tool, or a purpose-built tracker — that handles these four things reliably:

1. Automatic working-day calculations. Enter a report date and hazard type; get all statutory deadlines calculated correctly, including bank holidays, without manual formula maintenance. This eliminates the single most dangerous failure mode.

2. Proactive deadline alerts. The system tells you when a deadline is approaching — you do not have to go looking. At minimum: a daily summary of cases entering the amber zone (within 2 working days of any deadline) and an immediate alert for anything entering the red zone (deadline day).

3. Cascading deadline updates. When you mark an investigation as complete, the downstream deadlines (make-safe, written summary, supplementary works) recalculate automatically from that completion date. No manual formula updates, no chance of a missed recalculation.

4. Case-level evidence storage. Everything related to a case — reports, photos, correspondence, contractor documents, decision records — lives in one place, linked to the case timeline. When someone requests the audit trail, you produce it in minutes, not days.

If your current system does all four of these things, you are in a stronger position to demonstrate compliance regardless of what software you use. If it fails on any one of them, you have a gap that Awaab's Law will eventually find.

The Phase 2 Multiplier

Everything above applies to Phase 1 (damp and mould). From 2026, Phase 2 extends the same deadlines to falls, fire, cold, heat, structural collapse, and electrical hazards. The tracking requirements are identical — the same working-day rules, the same cascading deadlines, the same audit trail duties.

The difference is volume. A provider currently handling a manageable number of damp/mould cases under Awaab's Law deadlines may see that rise significantly across all Phase 2 hazard categories. The spreadsheet approach that barely works for a small caseload will not scale.

Use the Phase Checker to see which hazard types fall under which phase, and the compliance checklist to walk through the full case lifecycle for each hazard type.

Start With the Highest-Risk Gap

If you are currently tracking deadlines in spreadsheets, the single most impactful change is fixing the working-day calculation problem. Use the deadline calculator to verify your existing cases are on the right dates. If they are not, correct them immediately — a case you think has three days remaining may actually be overdue.

For a step-by-step framework covering the transition from spreadsheets to structured tracking, see How Small Housing Associations Can Comply Without Enterprise Software.

If you want automated deadline calculations, countdown alerts, and case-level evidence storage without the £10,000+ enterprise price tag — join the HazardClock waitlist. We are building an affordable compliance tracker specifically for providers managing fewer than 5,000 units.

This is general guidance, not legal advice. Always confirm your compliance approach against the latest GOV.UK guidance.

Sources

• Awaab's Law: Guidance for social landlords — Timeframes for repairs in the social rented sector — GOV.UK
• Delivering a data standard to support Awaab's Law in social housing — MHCLG Digital
• Awaab's Law learning resources — Housing Ombudsman