How Small Housing Associations Can Comply with Awaab's Law Without Enterprise Software

You manage fewer than 5,000 units. You have a repairs team of two to five people. Your board wants Awaab's Law compliance confirmed, but nobody has approved a £10,000+ software budget — and nobody is going to.

This is the reality for roughly 1,200 of the 1,700 registered providers in England. (If you need a refresher on the full deadline framework, see The Complete Guide to Awaab's Law.) Enterprise housing management suites are built for organisations ten times your size. But spreadsheets are not built for statutory deadline tracking. There is a middle ground, and finding it quickly matters: the Housing Ombudsman made 7,082 determinations in 2024-25, with 714 findings of severe maladministration.

What You Actually Need to Track

Awaab's Law compliance boils down to five data points per case:

1. Report date — when the tenant reported the hazard. This starts the clock.
2. Hazard type — emergency (24-hour track) or significant damp/mould (10 working-day investigation). After Phase 2 comes into force in 2026, this expands to 14 hazard categories.
3. Investigation completion date — this triggers three downstream deadlines (written summary, safety works, supplementary works).
4. Action dates — when each required action was completed.
5. Evidence — photos, contractor reports, tenant correspondence, and completion confirmation.

If you can reliably track these five things across every open case, with an audit trail you can produce in minutes rather than days, you are in a much stronger position to demonstrate compliance. The question is how.

Where Spreadsheets Break Down

Most small providers currently track repairs in Excel or Google Sheets. For basic case logging, this works. For Awaab's Law compliance, it breaks in three specific ways:

Working-day calculations. Awaab's Law deadlines run on working days — excluding weekends and bank holidays. Excel's NETWORKDAYS function handles weekends but requires a manually maintained bank holiday list. Get the list wrong (or forget to update it for the next year), and your deadline dates are silently incorrect. Across 50-200 open cases, nobody is checking each formula. Use the free deadline calculator to verify your spreadsheet is counting correctly.

No automated alerts. A spreadsheet shows you the data when you look at it. It does not send an email on Wednesday afternoon warning that three cases hit their investigation deadline on Friday. The gap between "the data exists" and "someone acts on it" is where compliance failures happen. The Housing Ombudsman's 2024-25 report found that landlords with over 10,000 homes received nearly four in five severe maladministration findings — scale amplifies the problem, but small providers are not immune.

Audit trail fragmentation. When the Ombudsman requests evidence for a case, you need dates, actions, communications, and supporting documents in a single timeline. In a spreadsheet workflow, evidence is scattered across email attachments, shared drives, filing cabinets, and individual inboxes. Reconstructing a case timeline during an investigation takes days. Under Awaab's Law, landlords must keep clear records of all correspondence with the tenant and any contractors.

A Practical Compliance Framework

You do not need to replace everything overnight. Start with the highest-risk gap and work outward:

Step 1: Fix the deadline calculation problem

This is the most dangerous gap because it is invisible — wrong dates look exactly like right dates in a spreadsheet. Two options:

• Quick fix: Use the deadline calculator for each new case. Enter the report date and hazard type, get the correct deadlines, and paste them into your spreadsheet.
• Better fix: Replace the spreadsheet formulas with a tool that handles working-day rules natively. This is what purpose-built compliance trackers do.

Step 2: Build a basic alert system

If you are staying with spreadsheets for now, create a daily check process:

• Filter your tracker by "investigation deadline within 3 working days" and "make-safe deadline within 2 working days."
• Assign someone to run this check every morning. Put it in a calendar recurring event so it actually happens.
• Escalate anything that has entered the amber zone (within 2 days of deadline) to the responsible officer and their manager.

This is manual, and it depends on a person remembering to do it. It will work until it does not — and when it does not, you will find out after the deadline has passed.

Step 3: Centralise evidence

Create one shared location per case (a folder, a case record, whatever your team will actually use) containing:

• The original report (email, form, or call log)
• Inspection notes and photos
• Contractor instructions and completion confirmations
• Tenant communications (written summaries, response letters)
• Dates for every action taken

If you can produce this folder within 30 minutes when asked, your audit trail is adequate. If it takes longer than a day, you have a problem.

Step 4: Use the compliance checklist for each case

Work through the compliance checklist for every new case. It mirrors the five stages of the Awaab's Law lifecycle — report, investigation, make safe, supplementary works, and closure. Export a PDF at the end and file it with the case evidence.

When to Move Beyond Spreadsheets

The spreadsheet-plus-checklist approach works when you have:

• Fewer than 30 open cases at any time
• A single person responsible for deadline monitoring
• Low staff turnover (institutional knowledge stays)
• Phase 1 hazards only (damp/mould and emergencies)

It stops working when Phase 2 comes into force in 2026 and your case volume increases substantially. It stops working when your compliance officer leaves and the replacement cannot reconstruct the tracking logic. It stops working when you receive your first Housing Ombudsman information request and the clock starts ticking on producing evidence.

The transition point is not a specific unit count — it is the moment when manual tracking creates more risk than it removes. For most small providers, that moment arrives with Phase 2.

If you are ready to evaluate dedicated tools, see What to Look for in Compliance Software for a buyer's checklist. Or join the HazardClock waitlist to be notified when an affordable compliance tracker launches — purpose-built for providers under 5,000 units, priced below enterprise budgets.

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 — GOV.UK
• Annual Complaints Review 2024-25 — Housing Ombudsman