Why the CQC gap-analysis spreadsheet stops working past a handful of services

Most providers we talk to already have a gap-analysis spreadsheet somewhere: a tab per key question, a row per quality statement, a column for evidence, a column for RAG status, a column for the gap, a column for the action. It’s exactly the shape a consultant would build, because it is what a consultant builds, usually on the first visit.

For a single, one-off exercise, that spreadsheet works. The trouble starts the moment it needs to stay true.

Where it breaks

A RAG status in a spreadsheet is a claim, typed in by a person, on a particular day. It has no relationship to the actual document it’s describing. The certificate could expire next week, the policy could be superseded next month, the staff member it’s about could leave, and the cell stays green regardless, because nothing connects the cell to the thing it’s meant to represent.

That gap between the record and the reality is where most inspection surprises come from. Not because the provider was careless, but because a spreadsheet has no way to notice that something it was told six months ago is no longer true.

It doesn’t scale sideways either

Run the same exercise for a second service, a domiciliary care agency alongside the care home, say, or a second GP site, and the spreadsheet doesn’t get more useful. It gets duplicated. Two spreadsheets, two sets of RAG statuses to keep current, no shared view of where the group actually stands, and no way for evidence gathered in one place (a safeguarding policy, say) to count automatically toward the same requirement somewhere else.

The same problem shows up going forward rather than sideways: CQC’s move toward sector-specific frameworks means the detail underneath the five key questions will differ by setting. A spreadsheet built for one framework has to be substantially rebuilt for another.

What a living evidence tracker changes

The structure that makes a gap-analysis spreadsheet useful in the first place, Key Question to Quality Statement to regulation to evidence to status to gap to action, is exactly right. What needs to change is what sits behind the status column: not a typed-in guess, but a computed result, driven by the actual document that was uploaded, its date, and whether it still matches what’s required.

That’s the difference between a snapshot and a live view. The spreadsheet tells you what someone believed on the day they filled it in. A tracker tied to the real evidence tells you what’s actually true right now, and flags the moment that stops being the case.