Why Spreadsheets Quietly Fail as Practice Management — and When to Stop

The spreadsheet every firm has

One tab per year, a row per client, columns for each filing, colour applied by hand. It works — genuinely works — up to a point, which is why almost every firm has one and why almost every firm defends it.

Four structural failures

Ownership: a cell can hold a name but cannot hold accountability, and nothing notices when the named person leaves. Recurrence: next year's rows are typed by hand from last year's, which propagates last year's errors. Alerting: a spreadsheet never tells anyone anything. Concurrency: one person's sort or filter changes what everyone else sees.

• No ownership — a name in a cell is not accountability
• No recurrence — next period is retyped, including last period's mistakes
• No alerting — the file waits to be opened
• No safe concurrency — a sort or filter rewrites the shared view

What a missed deadline actually costs

The CRA's late-filing penalty on income tax returns is 5% of the balance owing plus 1% per full month, to a maximum of 12 months, with compound daily interest on top. Where the deadline was the firm's to manage, the cost is not just the client's penalty — it is the conversation, the credit, and sometimes the client.

The half-measures firms try first

Shared calendars, which have no client context. Task apps, which have no cadence. A second spreadsheet for the deadlines the first one missed. Each buys a few months and adds a system to maintain.

What replacing the spreadsheet must actually do

Encode the rule rather than the date, so each period generates itself. Attach a named owner to every obligation. Surface proximity without being opened. And hold the client context — year-end, cadence, remitter type — that makes the date correct in the first place.

Signals it is time

Someone maintains the spreadsheet as a job. Two people disagree about what is due. A deadline was missed and nobody can say who owned it. Or the file has a tab called 'do not sort'.