Finding the gaps in next week’s rota before Monday

The job nobody scheduled

It usually happens on a Friday afternoon or a Monday morning. Somebody exports next week from the care system, opens it, and starts reading. They are looking for rows where the Care Pro column is empty, and for clients whose regular pattern has quietly lost a visit.

For an office of thirty Care Pros that export runs to well over a thousand rows. Reading it properly takes the best part of an hour. Reading it at four o’clock on a Friday takes less, which is exactly the problem.

Why the manual pass misses things

Three reasons, consistently. Sorting by client hides a gap that only shows when you sort by day. A visit that exists on the rota but not on a template looks covered until the template runs and it disappears. And a Care Pro who has been allocated beyond the hours they actually declared looks fine on paper right up to the point they decline.

None of these are failures of attention. They are failures of format: a flat export cannot show you three different views at once, and a person reading it can only hold one at a time.

Cover the gap, then find out why it existed

The immediate job is filling the visit. The more useful job is noticing the pattern. A client who appears in the uncovered list three weeks running does not have a staffing problem, they have a template problem. A Care Pro who repeatedly appears as working outside their availability is telling you something about how the rota is being built.

Offices that only ever fix the immediate gap spend the same hour every week forever. Offices that look at the pattern spend it less often.

What to send, and to whom

When you do have the list, the message matters. A single message to everyone listing every gap gets ignored. A message grouped by client, sent to the Care Pros who could realistically cover those calls, gets answered. It is more work to write, which is why it usually is not done.

That is worth automating rather than abandoning. The list and the draft message are the same piece of work, and one should produce the other.

Doing it in a few seconds

Sterling reads the same export your scheduler opens and returns every visit with nobody against it, grouped by client, with an editable email ready to send. It also flags the template gaps and the availability conflicts the manual pass tends to miss.

Common questions

What is an unallocated visit?

A visit that exists on the rota for a given date and time but has no Care Pro assigned to it. If it is still unallocated when the week starts, it is a missed call unless somebody notices first.

How do you find unallocated visits in a rota export?

Manually, you filter for rows with an empty carer field, then sort by client and by day to catch gaps that only appear in one view. The reliable method is to check three things at once: visits with nobody assigned, clients whose visits never reached a template, and Care Pros allocated outside their declared availability.

How far ahead should you check the rota?

At least a full week, and ideally before the weekend so there is time to make calls during working hours. Checking on Monday morning for the week you are already in leaves no room to fix anything.

What should you do with a visit nobody can cover?

Escalate it rather than let it sit. Contact the client early, look at whether the call can be moved rather than missed, and record the decision. An uncovered visit that was noticed, communicated and managed is a very different thing from one that simply did not happen.

Last reviewed 12 September 2026. General guidance for home-care providers, not legal advice.