Every professional-services firm has one. The master spreadsheet. It tracks utilization, or revenue, or the pipeline, or all three. Someone built it two years ago, and now the entire firm depends on it.
Here's the problem: that spreadsheet is a single point of failure attached to a single person's institutional knowledge. When that person leaves — or goes on vacation, or just gets busy — the numbers stop updating. Decisions get made on stale data. Or worse, they don't get made at all.
The pattern we see
We've worked with dozens of firms at the 15–50 person stage, and the pattern is remarkably consistent:
- Phase 1: Founder tracks everything in their head
- Phase 2: Someone builds a spreadsheet to capture what the founder knows
- Phase 3: The spreadsheet becomes the system of record
- Phase 4: The spreadsheet breaks under its own weight
Most firms call us at Phase 4. The spreadsheet has 47 tabs, circular references, and a macro that only works on Dave's laptop.
What to do about it
The fix isn't to build a better spreadsheet. It's to identify which data actually drives decisions and build proper infrastructure around it.
That means: a real database (even if it's just a well-structured Airtable), automated data flows from your source systems, and dashboards that update without human intervention.
The spreadsheet got you here. It won't get you to 50 people.