Luxembourg investment group eliminates Excel consolidation chaos with CCH Tagetik, securing 300+ entity reporting processes.
Auditor-level access restrictions ensuring confidentiality while maintaining collaborative workflows
Weeks-long manual processes reduced to streamlined automated consolidation workflows
Seamless handling of 300+ entities across multiple independent consolidation scopes
Event-based design supporting dynamic portfolio changes without disrupting operations
Luxembourg investment group transforms from Excel consolidation chaos to secure centralized reporting—managing 300+ entities with enhanced security and operational efficiency.
This Luxembourg-based investment group operates in a world where complexity is the norm. Managing a diverse portfolio of companies across multiple industries and geographies, they oversee more than 300 entities through various holding structures while maintaining active acquisition and divestiture strategies.
But their consolidation processes hadn't kept pace with their portfolio sophistication.
The investment group faced mounting pressure from multiple directions as their traditional consolidation approach became a critical bottleneck:
As a Senior Finance Executive explained:
"We needed a solution that could handle multiple holding structures with complete security and audit control. The diversity of our portfolio companies required sophisticated mapping capabilities that Excel simply couldn't provide."
The weeks-long manual processes using Excel macros were becoming unsustainable for a group with an active acquisition strategy.
The investment group approached their transformation systematically, conducting a comprehensive evaluation of consolidation platforms and implementation partners.
They selected CCH Tagetik as their platform, partnering with Keyrus for implementation based on deep understanding of both functional requirements and technical complexities involved in multi-entity consolidation transformations.
Business Requirements Alignment
Technical Advantages
The 12-month implementation transformed the investment group's approach from fragmented, manual processes to integrated, automated workflows while maintaining the security and confidentiality their business model required.
Event-Based Consolidation Design: System architected to manage multiple independent consolidation scopes in parallel, each with their own ownership events and structural complexities, providing flexibility for their diverse portfolio
Unified Chart of Accounts Mapping: Custom dimensions implemented to unify disparate local charts of accounts across portfolio companies, enabling consistent group-level reporting while preserving local accounting requirements
Advanced Security and Access Controls: Smart filtering technology ensuring auditors and local teams could access only entitled data, maintaining confidentiality while enabling collaborative workflows
Integrated Consolidation Questionnaire: Comprehensive questionnaire embedded into the process, replacing manual Excel checklists and ensuring every submission included standardized quality checks
Knowledge Transfer and Best Practices: Consolidation specialists worked closely with the Luxembourg team, sharing expertise and implementing industry best practices to replace legacy manual processes
The collaboration delivered significant benefits extending far beyond traditional consolidation improvements:
Enhanced Security and Compliance: Auditor-level security controls providing complete confidence in reported figure integrity. More than 20 users, including local contributors and auditors, now access only entitled data, ensuring strict confidentiality compliance
Improved Accuracy and Data Integrity: Centralized platform eliminated version control issues and manual errors that previously plagued Excel-based processes. Integrated consolidation questionnaire standardized quality checks, dramatically improving consolidated figure reliability
Operational Efficiency and Speed: Overall closing process, previously taking weeks using Excel macros, reduced considerably through automated workflows and streamlined data collection for 300+ entities across multiple scopes
Scalability for Growth Strategy: As an active investment group regularly acquiring and divesting businesses, the new platform seamlessly integrates structural changes without disrupting ongoing operations
As Hilde, Keyrus Consolidation Expert, notes:
"The consolidation questionnaire and the business workflow were game-changers, standardizing checks and ensuring data quality. They are still in use today and have even been reused in other projects."
The platform's success has positioned the investment group to confidently manage their dynamic portfolio strategy with continued evolution focused on:
The team continues providing ongoing support during year-end closings, ensuring the system evolves alongside the business while maintaining their competitive advantage in managing complex portfolio structures.
Because when you're managing 300+ entities across multiple holding structures, your consolidation processes should be as sophisticated as your investment strategy.
About the Client
The Luxembourg-based investment group manages a diverse portfolio of companies across multiple industries and geographies. With complex ownership structures and strict regulatory requirements, the organization operates over 300 entities through various holding structures while maintaining active acquisition and divestiture strategies and ensuring full compliance with Luxembourg regulatory standards.
Access the full details of this customer story and see the results up close, available as a PDF.
Access the full details of this customer story and see the results up close, available as a video.
Access the full details of this customer story and see the results up close, available as a PDF and a video.
Have questions about our EPM solutions? Our team is ready to help you find the right approach for your business.
