Excel is still one of the most important tools in finance. It is flexible, familiar and useful. Most finance teams use it every day, and that is not going to change.

The problem is not Excel. The problem is when Excel becomes the consolidation system.

For many growing businesses, this happens gradually. A spreadsheet is created to support month-end. Another is added for group reporting. Another tracks intercompany. Another manages budget submissions. Another reconciles data from different entities. Another turns into the board pack.

The Warning signs

Spreadsheet consolidation is usually a sign that the finance operating model has outgrown the systems underneath it. Common signs include:

• Month-end reporting takes too long.
• Consolidation happens outside the ERP.
• Finance relies on manual exports and uploads.
• Different entities report in different formats.
• Board packs take too much manual effort.
• Intercompany balances are difficult to reconcile.
• Budgeting and forecasting are disconnected from actuals.
• Reports are only trusted after manual checking.

These issues are not just finance irritations. They create risk, reduce visibility and make it harder for leadership teams to trust the numbers quickly.

Different charts of accounts and GAAP make Excel consolidation fragile

The problem becomes especially risky when group companies use different charts of accounts, different local ledgers or different GAAP treatments. Finance then has to map local GL codes into a group chart of accounts manually, often inside Excel.

That mapping may work while the structure is stable, but it becomes fragile as soon as something changes. If a new GL code is created in one entity and is not mapped correctly into the group chart of accounts, the consolidation can be thrown out. Costs may appear in the wrong category, reporting lines may not agree, and the finance team may spend valuable time finding and fixing the issue manually.

The bigger the group becomes, the harder this is to control. Every new entity, acquisition, local reporting requirement or accounting treatment adds more mapping logic, more manual checking and more dependency on the people who understand the spreadsheet model.

Why spreadsheets become the workaround

Most businesses do not set out to build a finance process around spreadsheets. It usually happens because the business changes faster than the system. A single-entity business becomes multi-entity. A UK business expands internationally. A simple finance system has to support group reporting. Operational systems do not integrate properly. Investors, banks or the board ask for more robust reporting.

When the core system cannot support those requirements, finance fills the gap manually. That may be pragmatic in the short term, but over time it creates cost, risk and dependency.

The hidden cost of spreadsheet consolidation

Spreadsheet consolidation slows month-end, increases the risk of error and reduces confidence in the numbers. Finance spends too much time collecting, checking and reconciling data, and not enough time explaining what the numbers mean.

It also creates key-person dependency. When only one or two people understand how the spreadsheet model works, the process becomes fragile. If those people are unavailable, leave the business or are pulled into other priorities, the reporting process is exposed.

You may not need to replace your ERP immediately

Many businesses know their reporting and consolidation process is not good enough, but they are not ready for a full ERP replacement. The ERP may still work operationally, the business case for a replacement may not yet be approved, or the finance team may need reporting improvements sooner than a full transformation project would allow.

This is where a finance reporting and consolidation layer can be a practical first step. Instead of replacing the ERP immediately, the business can connect data from existing systems and create a more controlled reporting environment above them.

SAP Business Data Cloud as a practical reporting layer

SAP Business Data Cloud can provide a way to bring finance and operational data together from SAP and non-SAP systems. For businesses still using legacy ERP, this creates an important opportunity: better visibility and less spreadsheet dependency without forcing a full ERP replacement on day one.

This can be particularly useful where the business has:

• Multiple entities or finance systems.
• Legacy ERP that is not being replaced immediately.
• Manual consolidation and spreadsheet-based reporting.
• Different charts of accounts or local reporting structures.
• Disconnected budgeting and forecasting.
• Limited group-level visibility.
• A need for faster management reporting.

The objective is not to replicate every feature of a full statutory consolidation platform from day one. The objective is to give finance a better, faster and more controlled way of reporting across the group.

A lower-cost alternative to full SAP Group Reporting

SAP Group Reporting is a strong option for businesses that need a full consolidation and close solution inside SAP S/4HANA. However, not every business is ready for that level of solution.

Some companies need a more pragmatic first step. They want better group reporting, stronger visibility and less spreadsheet dependency, but they do not yet need, or cannot yet justify, a full Group Reporting implementation. For those businesses, SAP Business Data Cloud can be positioned as a lower-cost and lighter-weight alternative that can sit above a legacy ERP landscape.

What the package could include

A practical SAP Business Data Cloud consolidation and reporting package could include:

• Review of current finance systems and reporting process.
• Identification of source systems and key data requirements.
• Data model for entity, account, cost centre and reporting structures.
• Mapping from local charts of accounts to a group chart of accounts.
• Connection to legacy ERP and other relevant data sources.
• Standard management reporting pack and board dashboards.
• Roadmap for future ERP, SAP Group Reporting or wider finance transformation.

When SAP Group Reporting is still the right answer

This does not mean SAP Business Data Cloud replaces SAP Group Reporting in every case. If the business needs advanced statutory consolidation, complex ownership structures, formal consolidation rules, group close orchestration and deep integration with SAP S/4HANA finance, then SAP Group Reporting may be the better long-term solution.

The question is not which product is better. The question is which solution matches the business need, budget, timeline and current system landscape.

Where Percipere helps

Percipere helps finance leaders understand whether they need a reporting and consolidation layer on top of existing ERP, SAP Business Data Cloud, SAP Analytics Cloud planning and reporting, SAP Group Reporting, a wider SAP S/4HANA Public Cloud programme or a phased finance transformation roadmap.

Final thought

Spreadsheet consolidation is often a sign that the business has grown faster than its systems. Excel can still play a role, but it should not be the backbone of group reporting.

Still consolidating in Excel? Book a 30-minute finance reporting review and we will help you assess whether SAP Business Data Cloud could provide a practical consolidation and reporting layer for your current ERP landscape.