The month has ended, but the CFO is still waiting for consolidated financial statements. One subsidiary has submitted its numbers late, another has intercompany mismatches to resolve, and the group finance team is busy reconciling spreadsheets.
For organisations operating across multiple entities, this is a familiar month-end struggle. Consolidation becomes a lengthy exercise involving data collection, adjustments, reconciliations, and repeated reviews.
But why does bringing financial information together take so long, even when individual entities have already closed their books?
The answer often lies in fragmented systems, manual processes, and inconsistent reporting practices. Let’s explore the common causes of consolidation delays and how finance teams can address them.
A growing organisation may operate through multiple subsidiaries, each with its own accounting systems, reporting practices, and financial close schedules. One entity might use SAP S/4HANA, another might rely on a legacy ERP, while a third submits financial data through spreadsheets.
Before consolidation begins, the group finance team must collect these different outputs, standardise formats, map local accounts to the group’s chart of accounts, and resolve missing information.
As the organisation expands, these activities become increasingly difficult to manage manually. A delay at one subsidiary can affect the entire reporting schedule.
How to address it: Establish common reporting templates, submission deadlines, validation rules, and account mappings. Reliable data integration can also reduce repetitive manual work and help ensure that financial information is ready for consolidation when required.
Spreadsheets are useful for financial analysis, but relying on them to manage the entire consolidation process introduces unnecessary complexity.
Imagine a group with 15 subsidiaries submitting separate workbooks. The finance team must combine the files, check formulas, update currency conversions, reconcile differences, and prepare consolidated statements. When an entity corrects its figures, the team may need to update multiple files and verify that the changes flow through correctly.
Version conflicts and manual errors add further delays, making it difficult to establish which figures are final.
How to address it: Automate recurring activities such as data collection, account mapping, and validation. A dedicated consolidation solution can centralise workflows, strengthen controls, and reduce dependence on manually maintained spreadsheets.
Intercompany transactions create additional reconciliation requirements during group consolidation. When one subsidiary sells goods or services to another, both entities must record the corresponding transactions appropriately. Differences between their records must be investigated before the relevant balances can be eliminated during consolidation.
For example, one entity might record an invoice while the other has not yet recognised the corresponding expense. Differences can also arise from transaction timing, exchange rates, or inconsistent account mappings.
Across multiple entities, resolving these discrepancies can consume days of the reporting cycle.
How to address it: Introduce standardised intercompany processes, common transaction identifiers, and automated matching where appropriate. Identifying mismatches throughout the reporting period allows finance teams to resolve exceptions before they become month-end bottlenecks.
Multinational organisations must often consolidate financial statements prepared in different functional currencies. These figures need to be translated into the group’s reporting currency using the applicable accounting rules.
The process may also involve intercompany eliminations, reclassifications, and other consolidation adjustments. When these activities depend on separate spreadsheets or manually maintained calculations, teams must repeatedly verify whether the correct rules have been applied.
A change in one entity’s financial data can trigger further calculations and reviews, extending the reporting timeline.
How to address it: Establish consistent group accounting policies and configure currency translation and consolidation rules centrally. Where supported by the chosen platform, automation can apply these rules consistently across reporting periods. Clear documentation and traceable adjustments also help reviewers understand how consolidated figures were calculated.
A group reporting calendar may assign clear deadlines to every subsidiary, but meeting those deadlines is another matter. Some entities close their books on time, while others need additional days to complete reconciliations, process transactions, or obtain approvals.
The group finance team cannot finalise its work until the required information arrives. Late submissions then compress the time available for validation, reconciliation, and management review.
Teams often compensate by working longer hours towards the end of the reporting cycle, but this does little to address the underlying delays.
How to address it: Use a central close calendar with clear task ownership, automated reminders, and progress tracking. Where feasible, perform reconciliations and data validation throughout the month rather than leaving all outstanding work until the final reporting stage.
Group finance teams are expected to produce accurate consolidated statements, but fragmented processes can leave them spending much of their time chasing information and correcting errors.
They may need to follow up with subsidiaries, investigate unexplained movements, request revised submissions, and manually verify adjustments before preparing the final reports. As the organisation grows, this workload increases without necessarily improving the quality of financial analysis.
Consequently, finance professionals have less time to investigate business performance, understand financial risks, and support strategic decisions.
How to address it: Define responsibilities across local finance teams, group controllers, and consolidation reviewers. Automate repeatable tasks such as validation and matching, while retaining human oversight for accounting judgements and material adjustments. This allows finance teams to focus on exceptions rather than routine data processing.
An ERP system helps organisations record transactions and manage entity-level accounting. However, group consolidation involves additional requirements, including combining financial results, applying group accounting policies, reconciling intercompany balances, and preparing consolidated statements.
When an organisation operates across different systems or reporting structures, its existing ERP environment may not provide everything needed for an efficient consolidation process. Finance teams may still depend on spreadsheets, manual data transfers, and separate reconciliation tools.
This creates gaps between recording financial information and producing a consolidated view of group performance.
How to address it: Assess whether the current financial systems support the organisation’s consolidation requirements. For businesses using SAP S/4HANA, SAP Group Reporting offers dedicated capabilities to help integrate financial data and manage consolidation activities within a more connected reporting environment.
For organisations using SAP S/4HANA, SAP S/4HANA Finance for Group Reporting provides capabilities designed to support group consolidation and financial reporting.
Depending on the implementation and system architecture, these capabilities can help finance teams:
However, implementing the technology alone will not guarantee a faster close. Data quality, process design, accounting policies, and user responsibilities remain essential to achieving measurable improvements.
Before investing in new technology, finance leaders should understand where the reporting cycle loses time. Reviewing the previous three to six monthly closes can help identify recurring bottlenecks.
Start by asking these questions:
These questions help distinguish delays originating in the entity-level close from those introduced during consolidation. Addressing both is essential to improving the overall reporting timeline.
Group financial consolidation becomes more complex as organisations expand across entities, currencies, and accounting systems. However, weeks of manual work are not an inevitable consequence of growth.
Disconnected systems, spreadsheet dependencies, late reconciliations, and inconsistent reporting processes can all extend the close. Addressing these challenges requires standardised processes, reliable data integration, appropriate automation, and stronger financial controls.
For organisations using SAP S/4HANA, SAP Group Reporting can support a more integrated approach to financial consolidation. The key is to align the technology with the organisation’s accounting requirements and reporting processes.
The goal is not simply to publish consolidated numbers sooner. It is to give finance leaders a reliable view of group performance while there is still time to investigate results and make informed decisions.
Is your group consolidation process taking longer than it should?
PPN Solutions helps organisations assess financial reporting processes, identify consolidation bottlenecks, and explore SAP Group Reporting implementation approaches aligned with their business requirements.
Connect with PPN Solutions to discuss how your organisation can simplify financial consolidation and improve group reporting efficiency.
