Where the spreadsheet breaks
- Nobody owns a row, so a task with no name against it is a task nobody is doing.
- Status is whatever was true when someone last remembered to update it.
- Deadlines live in the tracker but reminders live in someone's memory.
- Two people edit the same file and one version quietly wins.
What replaces it
| Need | What it looks like in practice |
|---|---|
| Client master | One record per client, with constitution, PAN, GSTIN and contacts |
| Work items | Each task owned by one person, with a due date and status |
| Compliance calendar | Statutory dates mapped against the client list, not a generic calendar |
| Recurring work | Retainers and renewals that regenerate rather than being retyped |
| Review step | A partner view of what is outstanding, without asking around |
| Billing linkage | Work completed connects to invoices raised |
Start with the calendar, not the tasks
Most firms attempting this begin by listing every task and lose momentum within a fortnight. The compliance calendar is a better starting point: statutory dates are known in advance, apply across many clients, and generate most recurring work automatically. Once dates drive task creation, the tracker stops needing to be maintained by hand.
Permissions matter more than features
Articles and staff need to see their own work. They do not need to see the firm's billing, margins or partner notes. A system without role-based access tends to be either over-shared, which creates awkwardness, or under-used, because the partner keeps the real tracker separately anyway.
What to measure once it is running
- Work outstanding past its due date, by owner
- Clients with no activity logged this month
- Recurring work not yet regenerated for the period
- Invoices raised against work completed but unbilled