Guide
Consolidation in Excel vs consolidation software: when to switch
Many groups consolidate in Excel for years, and for a small, stable group that can be a reasonable choice. This guide looks at where spreadsheet consolidations tend to break down, what dedicated software changes, what it does not change, and how to move without disrupting the close.
Updated · 7 min read · Conso 360
Key points
- Excel can work for a small group with one currency, few intercompany flows and no minority shareholders.
- Risk grows with every entity, currency, ownership change and manual adjustment, mostly because the logic is rebuilt each period.
- Software helps most with repeatability: the same mapping, rates and elimination rules applied every period, with checks before the run.
- Judgement-based entries, such as purchase price allocation or policy alignment, remain your team's work in either approach.
What every consolidation has to do
Whatever the tool, a consolidation follows the same steps. The question is not whether Excel can do them, but how reliably the steps can be repeated, reviewed and explained each period.
- Collect trial balances from each entity for the period.
- Map local accounts to the group chart of accounts.
- Align accounting policies where entities report under different frameworks.
- Translate foreign currency entities into the presentation currency.
- Eliminate intragroup balances, transactions and investments in subsidiaries.
- Calculate non-controlling interests and apply the equity method to associates.
- Record group adjustments, review the result and produce the reports.
When Excel is enough
A spreadsheet consolidation is often fine when the group is simple and stable. If most of the following describe your group, the main priority is good workbook discipline rather than new software.
- Two or three entities, all in the same currency.
- Few intercompany transactions, which agree on both sides most months.
- Wholly owned subsidiaries, no associates and no changes in ownership.
- One preparer who knows the workbook, and an independent reviewer.
- A reporting deadline that leaves time for manual checks.
Where spreadsheet consolidations break down
Problems rarely come from a single wrong formula. They come from logic that has to be copied, extended and re-checked every period as the group changes.
| Area | How it is usually done in Excel | Typical risk |
|---|---|---|
| Account mapping | Lookup tables copied into each period's workbook | New local accounts are missed or mapped inconsistently |
| Currency translation | Rates typed into each entity tab | Wrong rate type used; translation difference becomes a balancing figure |
| Eliminations | Manual entries per intercompany pair | Differences between the two sides are plugged rather than explained |
| Ownership changes | Formulas rebuilt for acquisitions and disposals | Non-controlling interests and equity calculated on outdated percentages |
| Versions | Files named final, final2, final-reviewed | Unclear which version was reported and what changed |
| Review | Following links across tabs and files | Hard to trace a group figure back to an entity balance |
What consolidation software changes
Dedicated software does not do anything an accountant could not do in a spreadsheet. The difference is that the structure and rules are stored once and applied the same way each time, so the work moves from rebuilding the consolidation to reviewing it.
- Group structure is held per period, with ownership percentages and consolidation methods.
- Mapping has effective dates, and unmapped accounts are listed before the run.
- Exchange rates are assigned by rate type, so each account is translated consistently.
- Eliminations are generated from intercompany partner information on every run.
- Validation checks stop the run when data or settings are missing.
- Adjustments are kept separate from entity data, with draft and posted status.
See how this works in practice in financial consolidation software.
What does not change
Software applies the conclusions your team reaches; it does not reach them. Several parts of the consolidation stay manual and judgement-based whatever tool you use.
- Assessing control, joint control and significant influence.
- Business combination accounting, including goodwill and purchase price allocation.
- Aligning accounting policies and deciding on reclassifications.
- The quality and timeliness of data from subsidiaries.
- Reconciling intercompany balances with counterparties before they are eliminated.
The last point is where many groups gain the most time; see intercompany reconciliation and our guide to intercompany eliminations.
A practical decision checklist
If you answer yes to several of these questions, a dedicated consolidation tool is likely to save time and reduce risk.
- Has the number of entities grown, or are acquisitions planned?
- Do any entities have a functional currency different from the group's presentation currency?
- Are there non-controlling interests, associates or joint ventures?
- Does the consolidation depend on one person who knows the workbook?
- Have auditors asked for evidence of how eliminations or translation differences were calculated?
- Have errors been found after reporting because of broken links or copied formulas?
How to move from Excel without disrupting the close
- Start with the group chart of accounts and mapping; these carry over from the workbook.
- Import entity trial balances from the same Excel files you already collect.
- Run one or two periods in parallel with the spreadsheet consolidation.
- Reconcile the results to the spreadsheet and document every difference.
- Switch over at a quarter or year end, once the reviewer is comfortable with the reconciliation.
This guide is general information for finance professionals, not accounting, tax or audit advice. Apply it to your own facts with your advisers and auditors. Standard references are to IFRS Accounting Standards as issued by the IASB.