Spreadsheet consolidation problems are the quiet tax on growth by acquisition. Spreadsheet consolidation is the practice of combining the financial results of several legal entities into one group view using a workbook: a tab per company, a set of formulas to add them up, and a column of manual adjustments to remove anything the entities traded with each other. It works well for one or two companies. It starts to fail the moment you acquire a third, because the work does not grow with the size of the business; it grows with the number of entities you are stitching together, and it grows faster than you expect. A consolidation that took a competent finance person a morning at two entities can take most of a week at six. The spreadsheet did not get worse. The problem got bigger underneath it.
This piece is for finance leaders and operators at companies that have started buying other companies. If you closed your first deal recently, or you are about to, this is the part of M&A integration that quietly turns into a monthly fire drill. Here is where the cracks appear, why they are about entity count rather than revenue, and how to tell when a workbook is still fine versus when it is costing you more than a better system would.
Why does spreadsheet consolidation break on entity count, not company size? Because the workload scales with the number of entities you stitch together, not with company size. The instinct is to assume a bigger company needs better tools and a smaller one can stay on Excel, but for consolidation that instinct is wrong. A single 200-person company with one set of books can run clean management accounts in a spreadsheet for years. A 60-person group made of five acquired businesses cannot, because every pair of entities that trades with each other creates an intercompany relationship that has to be reconciled and eliminated every period.
The number of those relationships rises faster than the number of entities. Practitioner guides put hard numbers on it : ten entities can carry around 45 potential intercompany pairs, twenty entities around 190, so the elimination work compounds and manual consolidation of thirty or more entities can push month-end close past fifteen business days. You do not need thirty entities to feel it. The jump from two to five is where most acquisitive companies first realise the workbook is no longer doing the job.
What are the five spreadsheet consolidation problems after an acquisition?
Breaking point What goes wrong in the workbook Why a deal makes it worse
Intercompany eliminations Manual adjustments to cancel sales, loans, and balances between entities A new entity adds a new set of relationships to reconcile every period Chart of accounts drift Each tab uses slightly different account names and codes The acquired company arrives with its own chart, mapped by hand Version control and audit trail "final_v7_REAL.xlsx", overwritten formulas, no record of who changed what More contributors, more handoffs, no system-level history for auditors Multi-currency Formula-based FX that someone has to update and reapply Cross-border deals add translation that shifts every month Human error base rate Broken links and bad formulas that propagate silently More cells, more tabs, more chances for one mistake to flow into the group numbers
Intercompany eliminations are the first to go If two entities in your group trade with each other, that internal activity has to be removed so the consolidated numbers reflect only real, external business. In a spreadsheet this is a column of manual journal entries that a person maintains by hand. Miss one and you overstate group revenue. The classic failure is one subsidiary booking a sale that the other never recorded as a purchase, so the two sides do not net to zero and someone spends a day of close hunting for the gap. Add an acquired entity and you have added a fresh web of these to chase every month.
Chart of accounts drift is the one acquisitions guarantee Two companies almost never keep their books the same way. The acquired business shows up with its own account structure, its own naming, and its own habits, and someone has to map all of it onto your group chart before its numbers mean anything next to yours. In a workbook that mapping lives in a person's head and a fragile lookup formula. We treat chart of accounts mapping as its own discipline for exactly this reason; it is the foundation everything else sits on.
The human-error base rate is not a people problem This is the part finance leaders underrate. Decades of research into operational spreadsheets find that most contain errors. Ray Panko's long-running work at the University of Hawaii put the share of spreadsheets carrying formula errors at close to nine in ten , and the spreadsheet-risk group EuSpRIG reports that around half of the models large businesses rely on operationally have material defects . These are not careless teams. They are normal teams, because manual cells have no validation and no test. The risk is real enough that a single Excel error contributed to JP Morgan's “London Whale” trading loss in 2012 . Now apply that base rate to group financials that the board, your lenders, and a future buyer all read.
Multi-currency turns a formula into a monthly chore The moment one acquired entity reports in another currency, the workbook needs translation: every balance restated at the right rate, with the difference parked where it belongs. Rates move every month, so this is not a one-time setup; it is a recurring manual step that someone has to remember, apply consistently, and not fat-finger. Cross-border deals make it permanent.
Version control is where trust quietly dies A spreadsheet is the most flexible tool in finance, which is exactly why it is dangerous for consolidation: the same flexibility that lets you build a custom report lets you overwrite a formula or save over last month's file. With one owner that risk is manageable. Add the people a group needs, and “which file is the real one” becomes a monthly question, with no system-level history to show an auditor who changed what and when.
The hidden cost: your best finance person becomes a spreadsheet operator The line item that does not appear anywhere is the one that hurts most. When consolidation lives in a workbook, the person who runs it has to be senior enough to understand eliminations, FX, and the group structure, which means you are spending expensive, judgment-heavy time on copying, pasting, and reconciling. Vendor research routinely estimates that finance teams lose the majority of their time to gathering and reformatting data rather than analysing it.
After an acquisition this is exactly backwards. The weeks right after a deal are when you most need that person thinking about integration, pricing, and where the synergies actually are . In the work we do, the same pattern shows up every time: the finance lead who owns the consolidation workbook loses the first stretch of every month to it, precisely when the group needs their judgment on the integration. The close swallows the calendar. The spreadsheet did not just create risk; it took your scarcest resource off the board at the worst possible moment.
When is a spreadsheet still fine for consolidation, and when is it not? A spreadsheet is still fine with one or two entities, little intercompany trade, a single currency, and one owner; you have outgrown it once three or more entities trade, a deal adds a second chart of accounts or currency, more than one person touches the file, or an auditor or lender depends on the output. This is not an argument that spreadsheets are bad: they are the most flexible tool in finance, and the honest test is your structure, not your size.
A spreadsheet is still the right call when you have one or two entities, little or no intercompany trade, a single currency, and one person who owns the model. Most single-company businesses sit here comfortably and should not spend a penny on consolidation software.
You have outgrown it when three or more entities trade with each other, when an acquisition has introduced a second chart of accounts or a second currency, when more than one person touches the file, or when an auditor or lender now depends on the output. At that point the workbook is no longer saving you money; it is quietly charging you in risk and senior time.
What should you use instead of a consolidation spreadsheet? Move the monthly group numbers off the workbook onto something purpose-built, and start by separating the reliable core from the optional extras and getting the core right first. The fix is not “buy the biggest consolidation platform you can find”.
The reliable core is financial consolidation: a single, repeatable group view of P&L, balance sheet, and cash, with eliminations and currency handled by the system rather than by hand, and an audit trail that holds up. This is the part that is tractable and that pays for itself fastest after a deal. Operational and CRM reporting is a separate question. It is genuinely valuable, but it depends on each acquired company's systems and data, so it cannot be promised as one universal switch across the group; it has to be scoped business by business. Get the financial core trustworthy first, then layer operational views where the data actually supports them.
For most acquisitive companies that means moving the monthly group numbers off the workbook and onto something purpose-built, whether that is a consolidation tool or a bespoke reporting layer over your existing ledgers . The full picture of how the group view fits together is in our guide to consolidated financial reporting , and if you would rather have it built for you, that is what we do .
If you have just made your first acquisition and the month-end workbook is already creaking, that is the normal time to fix it , not a sign you did anything wrong. The honest read on most spreadsheet consolidation problems is that the tool did its job and then ran out of room. The spreadsheet got you here. It is simply the wrong tool for the group you are now building, and the longer the fix waits, the more close cycles it costs you.
By Dylan Harrocks, Founder of PMI Stack, which builds consolidated reporting for companies growing through acquisition. Published 24 June 2026.
