← Insights

HR operations

One place for every employee record, with the alerts built in

July 2026 · 5 min read

Somewhere in most small organisations there is a staff list. It lives in a spreadsheet, it is mostly accurate, and it does exactly one thing: it sits there. Then a probation review is missed because nobody was watching the date, or a right-to-work permission lapses and is only noticed during an audit, and the cost of a passive list becomes very clear very quickly.

The fix is not a bigger HR system. It is a staff list that watches the dates for you - the same single register, but one that flags what is coming before it arrives. Three date-driven alerts do most of the work.

The register first

Before the clever part, the boring part has to be right: one reliable record of who works here. Employee ID, department, role, employment type, start date, status - one row per person, one source of truth, kept current. Everything else in this article depends on that register being complete and trusted, because an alert is only as good as the date it is watching. Get the list right, keep it in one place, and stop the three or four rival copies that always drift apart.

Alerts that fire before the date, not after

The mechanism is simple and it is the whole point. Excel's date functions can look at a stored date, compare it to today, and change a cell before the deadline rather than after it. A record that flags "Due soon" while you can still act on it is worth an order of magnitude more than one you check the day it has already passed.

Probation ends. A probation review has a window, and missing it has consequences - continued employment on default terms, a conversation you should have had left unhad. Watch the probation-end date and flag it "On track", "Due soon" a month out, or "Overdue", and the review stops depending on someone happening to remember.

Right-to-work expiry. This is the costly one. Where an employee's right to work is time-limited, the permission has to be re-checked before it lapses, and letting it slip is one of the more expensive administrative errors an employer can make. A first-class column with a live countdown - "Due soon" at sixty days, "Expired" the moment it passes - turns a landmine into a diary entry.

Work anniversaries. Not every alert is a risk. Compute each person's next anniversary from their start date, and you have a ready prompt for service awards, long-service recognition and the small acts of noticing that quietly help retention. The same date logic that guards against a missed check also powers the nicer things.

A static list tells you the state of the world today. A watched list tells you what is about to change - and gives you time to do something about it.

The headcount picture, for free

Once the register is clean, the numbers people are forever asking for compute themselves: active headcount, starters this year, leavers, headcount by department, and the permanent versus fixed-term versus contract split. These are the figures that get requested at short notice for a board pack or a budget round, and pulling them from a live register beats rebuilding them by hand every time.

Handle it as the personal data it is

A word that matters more here than in any other HR tool: an employee register is a concentrated store of personal data, and under UK GDPR that carries real obligations. Keep access limited to the people who genuinely need it, hold only the fields you actually use, be clear about how long you retain records, and protect the file properly. Convenience and good data protection are not in tension - a single controlled register is easier to secure than four copies scattered across inboxes and desktops.

None of this is employment-law or HR advice, and the alerts are prompts rather than guarantees - the right-to-work flag reminds you to re-check, it does not perform the check. But a register that surfaces what is coming, keeps the headcount honest and lives in one place is the difference between HR admin that runs quietly in the background and HR admin that ambushes you.