Why the deadline spreadsheet always fails eventually
The three failure modes of a hand-maintained compliance calendar — staleness, single ownership and silent divergence — and what replaces it.
Almost every firm starts with a deadline spreadsheet, and it works. It works for years. Then it does not, and the failure is rarely dramatic — it is one date, on one client, in a busy month.
Failure one: it goes stale where nobody looks
A spreadsheet records the state of the world on the day someone updated it. A client changes their fiscal year-end, or crosses a GST threshold and becomes monthly, and the row does not change unless a person changes it.
The stale rows are invisible precisely because they look identical to the correct ones.
Failure two: it has exactly one real owner
There is always one person who understands the tab structure, the colour coding and which columns are formulas. The calendar's reliability is that person's attendance record.
This is fine until they are on leave in March.
Failure three: copies diverge silently
Someone downloads it to work offline. Someone else emails a version to a partner. Two people now hold documents that disagree, and neither knows.
By the time the divergence is found, the question is not which copy is right but which filings were made from the wrong one.
What actually replaces it
Not a better spreadsheet, and not a shared calendar — a calendar is still hand-maintained, it just fails in a nicer font. The replacement is derivation: dates computed from the client's fiscal year-end and service cadences, so changing the client's data changes the calendar.
The test is simple. Change a client's year-end and see whether the deadlines move on their own. If a person has to move them, the failure modes above are still present, whatever the tool is called.