This case study explores how Acterys helped Worms Safety consolidate financial data from 30 group companies manually. Within a day, Acterys enabled initial consolidation, followed by comprehensive solutions with interactive dashboards. This empowered Worms Safety to maintain and modify data models independently.
Background
Worms Safety is a leading global alliance of specialists in safety and quality management. Following the company’s introduction of a Xero financial management system, Worms Safety turned to Acterys to automate the consolidation for 30 group companies.
Key Challenges
- Manually consolidating financial data from 30 group companies was time-consuming and prone to errors.
- Outdated systems posed a challenge in integrating a new Xero financial management system with existing systems.
- Worms Safety wanted to maintain flexibility in reporting, similar to Excel, while ensuring that data was automatically updated from a central data mart for all companies.
Acterys Transforms Worms Safety Within a Day
After an extensive evaluation phase, Worms Safety chose Acterys based on its proven track record, Acterys’ ability to completely automate the process and the integration with market-leading Azure SQL Server and Power BI.
Results
Within a day, an initial solution that consolidated all companies was live. Shortly after came a comprehensive solution with interactive dashboards and specialized reports that Worms Safety required. The ease of Acterys enables the Worms Safety team to maintain and modify data models themselves instead of relying on outside help. The handling of accounting mappings, new scenarios, calculation metrics and more is now tailored exactly to the company’s needs.
The new solution saved Worms Safety 10 days of work per month that previously was spent on manual spreadsheet maintenance. It significantly improved analysis options in Power BI by providing:
- Consolidated views across companies and segments.
- Cash flow and accounts receivables simulations.
- Ability to drill down to transaction level.
- Interactive visualizations of KPIs and financial results.
“We have the same flexibility for reporting in Excel, but all data is automatically updated from the central data mart for all companies,” said Antoine Meunier, head of Worms Safety’s investment team. “Power BI is seamlessly integrated with the solution and provides us now with enormously improved insights and visualization.”
In embracing Acterys to automate financial consolidation for its 30 group companies, Worms Safety achieved transformative results. The rapid implementation, coupled with seamless integration with Azure SQL Server and Power BI, delivered significant time savings and enhanced data analysis capabilities. By empowering the team to maintain and modify data models independently, Worms Safety streamlined processes, improved reporting flexibility and gained valuable insights — ultimately bolstering their position as a leader in safety and quality management.
37%
Data Accuracy Improvement
70%
Reduction in Manual Effort
10
Working Days Saved Per Month
