Two people pull up the same client’s margin number in the same meeting and get two different answers. Neither one is lying. Neither spreadsheet is broken, not technically. They just built their version three days apart, and nobody noticed until someone asked the wrong question out loud.
That moment tells you something a broken formula never could. Your firm hasn’t got a spreadsheet problem. It’s got a visibility problem, and the spreadsheet is just where it shows up first. Here are the five signs that tell you which stage you’re actually at.
1. You Only Find Out a Project Lost Money After It’s Already Over
Allocated hours live in one tab. Actual hours land in another, usually a week or two behind, entered by whoever remembered to update it before the Friday deadline. Nobody’s comparing the two in real time, because comparing them properly means sitting down and doing it by hand, and there’s always something more urgent that week.
So the gap between what a project was supposed to cost and what it actually cost only becomes visible at the wrap-up meeting, or worse, on the final invoice. By then, the decision that would have fixed it, pulling a junior off the account, renegotiating scope, flagging the client early, is three weeks too late to matter.
Pro Tip: If allocated versus actual effort is something you check at project close rather than in week two, you’re not managing margin. You’re documenting it after the fact.
You might already log actual hours every week, which is a fair objection. But logging isn’t the same as comparing. The question that actually protects margin isn’t whether the hours got entered, it’s whether anyone put the allocated figure next to the actual figure while the project was still live enough to change course. Most firms can answer yes to the first and no to the second, and that gap is where the loss quietly builds.
We’ve mapped this pattern out in more detail in our piece on hidden scope failures buried inside your timesheets, where the effort gap usually starts long before it ever reaches a P&L.
2. Your Margin Number Depends on Who Built the Pivot Table That Week
Ask two people in the same firm what a client’s current margin is, and you’ll often get two different numbers, both technically correct, built from slightly different snapshots of the same messy source data. One tracker rounds differently. Another hasn’t been updated since the last invoice went out. A third had last month’s formulas copied into this month’s tab, and nobody checked whether the cell references still pointed where they should.
None of this is anyone being careless. It’s what happens when the source of truth is a file, not a system.
The real cost isn’t the confusion in the meeting. It’s the decision that gets made, or doesn’t, because nobody trusts the number enough to act on it. You can’t reprice a retainer, pull resources off a losing account, or have an honest conversation with a client about scope creep based on a figure three people would each calculate differently.
In practice, what we’ve consistently seen is that firms don’t fix this by asking people to be more careful with their spreadsheets. Carefulness isn’t the constraint. The constraint is that a spreadsheet has no memory of which version is correct, no audit trail of who changed what, and no way to stop someone from overwriting a formula by accident. A system that calculates margin from the same underlying task and timesheet data every time doesn’t need anyone to be careful, because there’s only one number to look at in the first place.
3. Utilisation Is a Guess, Not a Calculation
Utilisation should be simple: billable hours divided by available capacity. In practice, billable hours live in the timesheet file, available capacity lives in someone’s head or an HR spreadsheet, and the two rarely get reconciled on the same day, let alone the same hour.
So when someone in a Monday meeting says the team’s running at 78% utilisation, what they usually mean is that it felt about right last time they checked. Nobody’s being dishonest. There’s just no single, current source connecting hours logged to hours available.
Pro Tip: If your utilisation figure changes depending on who you ask, it’s not a metric yet. It’s an opinion with a percentage sign on it.
This matters more than it sounds like it should, because utilisation is a staffing signal, not just a reporting one. Consider a firm whose billable utilisation sits stubbornly around 60% for two consecutive quarters. That pattern usually points to one of two things: either the pipeline isn’t generating enough billable work for the team it has, or the team has grown ahead of the work in front of it. Those are two different problems with two very different fixes, and you can only tell them apart if the number in front of you is accurate on the day you’re looking at it, not an average someone eyeballed from last month.
We’ve written more on why this actually matters for a growing firm, not just as a reporting exercise but as a resourcing one, in why managing resources properly changes outcomes.
4. One Person Is the Only One Who Can Tell You What’s Actually Going On
Every firm running on spreadsheets eventually has one person who understands how the whole system fits together. They built the master tracker. They know which tab feeds which formula, which client’s numbers need a manual adjustment because of a billing quirk from eighteen months ago, and which cells you’re not allowed to touch.
That’s not really a personnel risk. It’s a visibility risk. When that person is on leave, in back-to-back client meetings, or simply hasn’t had time to update the tracker this week, nobody else can say with any confidence which clients are trending toward a loss right now. The business isn’t blind because people aren’t paying attention. It’s blind because the only person who can see is currently unavailable.
Pro Tip: A good test: pick any client today and ask someone other than your spreadsheet owner what that account’s margin looks like this month. If they can’t answer within a minute, the business is running on one person’s memory, not a system.
This isn’t a criticism of that person, and it isn’t fixed by hiring a backup or writing better documentation, although both help. It’s fixed by moving the knowledge out of a person’s head and into a system where the answer is the same regardless of who’s asking or who’s away. The firms that handle this well haven’t found a more disciplined spreadsheet owner. They’ve built a setup where the numbers don’t depend on any one person remembering anything.
5. Revenue Is Up, But You Can’t Say Which Clients Are Actually Paying For It
This is the sign that gets missed the longest, because it hides behind good news. Top-line revenue climbs. New logos come in. Everyone feels like the firm is growing. But growth in aggregate revenue says nothing about which specific clients are actually profitable and which ones are quietly eating the margin the profitable ones generate.
A growing firm can still be losing money on a meaningful slice of its client base at the same time, and a spreadsheet built around total revenue will never surface that. What it takes is a per-client breakdown: signed value against earned revenue, cost against margin, one row per relationship, not one column for the whole business.
There’s a related number worth naming here: backlog, the gap between what a client has signed and what’s actually been earned so far. A healthy backlog means there’s work still to deliver and bill. A backlog that keeps growing while margin on that same client keeps shrinking is an early warning that the relationship is heading toward trouble well before the invoice ever reflects it. Most spreadsheets don’t track backlog at all, because it requires connecting a contract value to ongoing delivery in a way a single tab was never built to do.
This is the pattern we built Skarya’s CFO Dashboard around: not a bigger spreadsheet, but a live per-client view that updates from the work itself, so margin erosion on one account shows up long before it drags down the average.
It’s the same underlying risk we cover more broadly in what actually threatens a growing service business, because a client quietly bleeding margin is a risk long before it’s a crisis.
What to Look For Before You Move Off the Spreadsheet
Recognising the signs is one thing. Knowing what actually needs to be true on the other side of the change is another. Whatever you move to next, four things need to hold, or you’ve just built a more expensive spreadsheet:
- One current source for planned and actual hours, not two files reconciled after the fact
- Margin calculated per client while the work is still live, not assembled at month-end
- Utilisation connected to real capacity and real logged hours, not estimated out loud in a meeting
- Visibility that doesn’t depend on one person, so the answer is the same regardless of who’s asking
A simple way to see the shift is side by side:
| Spreadsheet-led operation | Connected system |
| Margin checked at project close | Margin visible while work is delivered |
| Multiple personal versions of the truth | One current record everyone reads from |
| Utilisation estimated in conversation | Utilisation calculated from logged hours |
| Knowledge held by one spreadsheet owner | Visibility shared by role, not by memory |
| Revenue viewed in aggregate | Profitability viewed per client |
Where This Actually Leaves You
None of these five signs show up because a firm did anything wrong. Spreadsheets are the right tool for five people and one client each. They stop being the right tool somewhere around the point where checking the numbers takes longer than doing the work the numbers are supposed to describe.
The firms that catch this early aren’t the ones with better spreadsheets. They’re the ones who stop asking who has the latest version and start asking what a client’s margin looks like right now, and whether everyone who needs to know can actually see it. That’s a different question, and it needs a different kind of answer than another tab.