Effective Consolidation In Power BI & Excel

Worms eliminates menial spreadsheet tasks and automates financial reporting & consolidation

laptop

70%

Manual Efforts Reduced

Mangement

37%

Data Accuracy Improvement

time management

10

Person Days Saved Per Month

Worms Safety is a leading global alliance of specialists in safety and quality management with 30 group companies.

Worms safety

Challenge

Worms Safety is a leading global alliance of specialists in safety and quality management. Following the company’s introduction of a new Xero financial management system, Worms Safety turned to Acterys to automate the consolidation for 30 group companies. 

Solution

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.

Outcomes

Within a day, an initial solution that consolidated all companies was live. Shortly after, a comprehensive solution with interactive dashboards and specialized reports that Worms Safety required was in place. The ease of Acterys enables the Worms Safety team to maintain and modify their 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 their needs.
 
The new solution saved Worms Safety 10 days of work spent on manual spreadsheet maintenance a month, and it significantly improved analysis options in Power BI with:
 
•    Consolidated views across companies and segments
 
•    Cash flow and accounts receivables simulation
 
•    Ability to drill down to transaction level
 
•    Interactive visualizations of KPIs and financial results
 
“We couldn’t believe that within only one day Acterys enabled us to have an initial consolidation of 30 companies,” said Antoine Meunier, Worms Safety head of investment team. “We have the same flexibility for reporting in Excel, but all data is automatically updated from the central data mart for all companies. Power BI is seamlessly integrated with the solution and provides us now with enormously improved insights and visualization.”

Finance Innovation in the Services Industry

“We couldn’t believe that within only one day Acterys enabled us to have an initial consolidation of 30 companies. 

We have the same flexibility for reporting in Excel, but all data is automatically updated from the central data mart for all companies. 

Power BI is seamlessly integrated with the solution and provides us now with enormously improved insights and visualization. ”


– Worms Safety.
Antoine Meunier Investment Manager