Excel is a legitimate starting point for multi-company consolidation. At two entities with straightforward intercompany flows and no foreign currency, a well-maintained spreadsheet model is reasonable. The problem is that Excel’s costs accumulate gradually — each entity added, each currency introduced, each new intercompany relationship — until the point where the model is holding the finance team back more than it’s helping them. By then the costs are already significant. They just weren’t visible as they built up.
The obvious costs are apparent: it takes longer, it requires more manual work. The hidden costs are the ones that don’t appear on any budget line but are real — the decisions made on wrong data, the audit fees inflated by an unauditable close process, the institutional knowledge that walks out the door when the person who built the model leaves. Those are what this post covers.
Hidden Cost 1
Finance Team Time — Measured but Unbudgeted
The time cost of Excel-based consolidation is visible in the sense that someone knows the close takes three days. What’s less visible is what that actually costs in compensation terms — and what it displaces.
A finance controller at $90,000 salary costs approximately $430 per working day in direct compensation. Three days of consolidation work per month is $1,290 per month — $15,500 per year — in compensation alone, before benefits and overhead. That’s the direct cost of one person doing close work. It doesn’t include the time of the CFO reviewing outputs, the entity finance contacts submitting and resubmitting data, or the back-and-forth resolving intercompany mismatches by email.
What close time actually costs — illustrative example 5-entity group. Finance controller (£75k salary): 3 days/month consolidation. Entity finance contacts (3 × £50k average): 0.5 days each/month for submissions and queries. CFO (£150k): 0.5 days/month review.
Annual time cost in compensation: Finance controller ~£8,600 + Entities ~£2,900 + CFO ~£3,600 = ~£15,100 per year in direct compensation. Opportunity cost of analysis not done during that time: unquantified but real.
Hidden Cost 2
Decisions Made on Wrong Data
Excel consolidation errors don’t always announce themselves. A balance sheet that balances despite incorrect intercompany eliminations, a gross margin figure that’s wrong because an entity’s accounts were mapped to the wrong group line — these produce plausible-looking numbers that get reported to the board and used to make decisions.
The cost of a wrong decision isn’t the cost of the error — it’s the cost of the decision. A pricing strategy adjusted based on a gross margin figure that turned out to be inflated by an incomplete intercompany elimination is a real cost. A subsidiary investment approved on the basis of a group EBITDA that overstated profitability is a real cost. These don’t appear in any budget variance analysis because they’re invisible — the error was never discovered, or was discovered after the decision was already made.
How this plays out A group CFO reviews the March consolidated P&L. Gross margin appears at 38%. The board uses this to approve expansion investment on the basis of “strong margins.” In June, a reconciliation during audit prep reveals that management fee income in one entity — $180,000 — was never eliminated against the corresponding expense in another. Restated gross margin is 34.2%. The expansion investment was approved against an overstated financial position. The audit finds it; the decision has already been made.
Hidden Cost 3
Inflated Audit Fees
Auditors charge for time. An Excel-based consolidation with no audit trail — no record of who made which entry, when, and why — requires auditors to reconstruct the consolidation process from scratch in order to sign off on it. They request supporting workings, trace eliminations back to source data, and test manual journal entries that have no automated basis to verify against.
A purpose-built consolidation tool maintains a complete, timestamped audit trail: every journal entry, every rate applied, every elimination posted. This reduces the audit team’s time on consolidation mechanics and shifts their attention to the accounting judgements that actually require auditor input. The reduction in audit hours directly reduces audit fees — an amount that is typically larger than the annual cost of consolidation software for groups of meaningful size.
Hidden Cost 4
Personnel Dependency — Institutional Knowledge at Risk
Excel consolidation models accumulate institutional knowledge. The person who built the model knows which cells are linked to which entity files, which assumptions are hardcoded versus formula-driven, which elimination entries are posted manually and why, and which cells to check first when the balance sheet doesn’t balance.
This knowledge is not in the spreadsheet — it’s in that person’s head. When they go on leave, the model stops at a critical point. When they leave the company, the next person inherits a model they don’t fully understand and discovers its quirks under close deadline pressure, which is the worst possible time to discover them.
The transition cost A finance manager who built and maintained the group’s Excel consolidation model over three years resigns. Their replacement takes two close cycles to understand the model well enough to run it independently — during which the CFO and external accountant spend additional review time checking outputs they can’t fully trace. One elimination is missed in the first unassisted close; the error is caught at audit. Recruitment, onboarding, productivity ramp, and the audit adjustment collectively cost more than a year of consolidation software subscription.
Hidden Cost 5
Decision Latency — Six Lost Months Per Year
If the monthly close takes twelve working days to produce consolidated figures, decisions that depend on those figures are made with data that is two to three weeks old. Over twelve months, that’s two to three months of cumulative decision lag — every month, the board and management are making decisions based on results from the period before last.
For fast-moving businesses — growing groups, businesses in competitive markets, organisations responding to cost pressures — stale data is a strategic disadvantage. A cash position that was healthy three weeks ago may be tight today. A subsidiary that was on track in the last consolidated report may have deteriorated since. The monthly close that finishes on day 12 is delivering information that is already a quarter of the way to being outdated.
Hidden Cost 6
The Scale Ceiling — A Deferred But Certain Rebuild
The Excel model that works at three entities needs to be substantially rearchitected at five or six. Adding a new entity means extending every cross-entity formula, updating every summary sheet, and re-validating the entire model. Adding a new currency means building exchange rate logic that wasn’t in the original design. Adding an NCI requires ownership percentage tracking that the model was never built to do.
Each addition is a mini-rebuild. The cumulative cost of those mini-rebuilds — in time, in testing, in the errors introduced during rearchitecting — is a deferred cost that eventually becomes a forced migration when the model becomes too fragile to maintain. Groups that delay this migration pay for it in compounding maintenance cost and in the heightened error risk of a model being stretched beyond its design capacity.
When Excel Is Still the Right Answer
Two entities. Same currency. No NCI. Intercompany flows limited to a single management fee. Monthly close that takes half a day. In this situation, a well-maintained Excel model is a reasonable choice and consolidation software would be over-engineering the problem.
The right time to move is when the close is taking longer than it should, when a second person can’t run the model independently, when a new entity or currency is on the horizon, or when lender or investor reporting requires an auditable consolidation trail. At any of those points, the hidden costs described above are already accumulating — moving earlier rather than later reduces the total cost of the transition.
✅ The migration question to ask: Not “can we still run the Excel model?” but “what would it cost us over the next 12 months if we don’t migrate?” — in finance team time, in audit exposure, in decision quality, and in the risk of the model breaking at a critical point. That comparison almost always favours moving sooner.
BrizoConsol connects directly to Xero, QuickBooks, MYOB, and Zoho Books — eliminating the manual data entry and version control problems of Excel-based consolidation — with automated intercompany eliminations, multi-currency support, full audit trail, and entity-level drill-down. Learn more or see it in action →