The four spreadsheets every IT services firm still runs on.

Every IT services firm over 25 people runs on the same four spreadsheets. I have sat in the offices of more than 200 firms over the last fifteen years. The names on the tabs change. The four spreadsheets do not.

Pipeline. Margin. Forecast. Resource plan. They sit in a shared drive, get updated on a Sunday night, and the leadership team makes Monday decisions on whatever the spreadsheets said by midnight on Sunday. The numbers are always a week old. The decisions are always a week late.

The cost is not the spreadsheet. The cost is the lag.

The first one. The pipeline tracker.

Pipeline is the room temperature of the firm. If pipeline is hot, hiring loosens up, partners take longer holidays, the EXCO is calm. If pipeline is cold, everything tightens. The whole firm reacts to one number.

And that number sits in a spreadsheet that one person owns. Usually the founder. Sometimes a sales leader. Always behind. Always optimistic in week one of the quarter and pessimistic in week eleven. The firm reacts to a fiction.

What the right system gives you instead is a live pipeline that updates as deals move, scored by stage and confidence, with the partner attached, the source attached, and the close date that the system computes from velocity rather than what the salesperson typed.

The second one. The margin tracker.

Margin is found at month end. By the time the spreadsheet shows you the leak, the project is done. You cannot fix what you only see at the end.

The lag here is the most expensive of the four. A 10 percent margin compression on a flagship engagement, caught at month nine of a twelve month delivery, is half a million dollars of opportunity left on the table. Caught in week three, it is a conversation with the client and a change of plan.

Real signal looks like a live WIP and recovery view, refreshed as time entries get submitted and approved, with the rate hierarchy applied automatically. You see margin moving while you can still act on it.

The third one. The forecast.

The forecast spreadsheet gets built the night before EXCO. By one person. Usually with the wrong assumptions. The EXCO then makes decisions on those assumptions.

The forecast is the spreadsheet that should be the easiest to systematise. It is mostly arithmetic. Pipeline times confidence, plus retainer rollover, plus utilisation at billable rate, minus pass through. The reason it lives in a spreadsheet is not that the math is hard. It is that the data is in four different places and stitching them together by Tuesday morning is a one person job.

When the system holds the pipeline, the rates, the utilisation, and the retainer state in one place, the forecast becomes a button, not a Sunday night.

The fourth one. The resource plan.

Resource plan is where partners discover they have committed the same senior consultant to two flagship projects. It happens because the resource plan is built in a spreadsheet that one person maintains and three partners write into without telling each other.

Bench by accident. Overload by accident. Talent walking because they are burned out. None of this is visible until it is too late.

The right system shows capacity eight weeks out by person, by skill, by allocation type. Hard, soft, sales pipeline. Overallocation flags at configurable thresholds. The partners do not need to coordinate. The system coordinates for them.

What replaces the four.

One operating system instead of four spreadsheets. One source of truth. Live signal instead of weekly cleanup. The data shows the firm what to do next.

That is what ConsultancyOS does, and it is the first reason firms move. They are tired of running the business on lag.

If your firm is over 25 people and you are still on the four spreadsheets, you are not alone. Almost every firm we work with started exactly there. The question is whether you stay there for another year or whether you replace them this quarter.

We are taking on a founding cohort right now. If you want the system underneath your firm, apply for early access. Selected firms get founder led onboarding and founding cohort pricing locked for life.