The Challenge
A large technology consulting firm with 13 business verticals had the same problem every year: the budget was never finished before the year started.
It was not for lack of effort. The process began months ahead. But eight separate departments each built their own budget, with several people contributing inside each one, and every C-level executive and business lead working in their own file with their own structure. Headcount was laid out one way in one vertical and another way in the next. Assumptions were buried in formulas. Some files ran by month, others by quarter.
Pulling all of it together meant merging and reconciling files that were never designed to fit. Each round of changes started the consolidation again. The crunch always landed in the holiday season, the budget was still incomplete when people left for the break, and the new year began with something always outstanding.
Our Process
Agreeing one structure. We worked with the C-suite and the budget owners in each vertical to agree a single chart of accounts, one set of drivers and one calendar. That conversation was the real fix; the model enforces what was agreed in it.
Zero-based, not last year plus a percentage. Every cost line is built up from its drivers: people, rates, utilisation, vendors and programmes. Each budget owner justifies the number from zero rather than rolling last year forward. For a consulting business, where people are both the cost base and the revenue engine, that discipline matters.
One model, with each owner's part carved out. Every C-level and budget owner gets their own input section covering exactly their area, and nothing else. They fill in their assumptions; the model calculates and consolidates automatically. Many people can work on it at the same time.
Consolidation built in. Vertical and firm-wide views, profit and loss, headcount and cash all update as inputs change. There is no merge step, because there is nothing to merge.
Key Outcome
The work that used to consume the budget season, building spreadsheets, aligning formats, merging files and chasing versions, has been designed out.
No budget owner now spends time building an Excel model, because the model is already built for them. The partners' time goes where it should have been going all along: into the assumptions, not into formulas and formatting.
The result is the first budget the firm has finished on time. It was completed with a month of the financial year still to run, and is now with the board for discussion and resource planning. The new year will open with a board-approved budget and resources already allocated against it. December, once the crunch month, is now reserved for updating the budget with actuals and adjusting only for material events, if any arise.
Results
- ·Budget completed a month before the financial year closes, for the first time
- ·Board-approved budget and resource allocation in place before the new year starts
- ·One zero-based budget model replacing separate files across eight departments and 13 verticals
- ·Structured input sections for each budget owner, so everyone works in the same model at once
- ·No manual merging or consolidation: firm-wide and vertical views update automatically
- ·No model-building burden on budget owners; time redirected to assumptions and decisions
- ·December freed up for updating with actuals and adjusting only for material events, rather than finishing the budget
Why this matters
Late budgets are rarely about late starts. They are about structure. When every leader builds their own file, the work is not adding up the numbers; it is translating between formats that were never designed to fit together. Fix the structure, and the budget becomes a conversation about the business rather than a spreadsheet project.
Related reading