Case Studies Renewi's Integration of OneStream for Enhanced Financial Reporting and Consolidation

Edit This Case Study Record

	Renewi's Integration of OneStream for Enhanced Financial Reporting and Consolidation

Renewi's Integration of OneStream for Enhanced Financial Reporting and Consolidation

Technology Category	Analytics & Modeling - Predictive Analytics Application Infrastructure & Middleware - Data Exchange & Integration Functional Applications - Enterprise Resource Planning Systems (ERP)
Applicable Industries	Recycling & Waste Management
Applicable Functions	Business Operation Quality Assurance
Services	Software Design & Engineering Services System Integration
Challenge	Creating innovative renewables, Renewi is the leading waste-to-product organization in the Benelux. With more than 7,000 employees, Renewi operates through five business units in their organizational structure. Formed from the result of a merger, Renewi was faced with the challenge of integrating two sets of reporting processes and two legacy CPM systems: Infor PM10 and Longview. With six main data sources, including Exact, JD Edwards, Metacom, Agresso, Navision, Pegasus and Excel®, Renewi was spending too much time manually managing data. The company was in urgent need of a solid tool to streamline statutory and management reporting. “Our CPM systems and processes were not fit for the future — both were dated, cumbersome and inefficient,” said John Wiericx, Reporting Manager Benelux at Renewi. “Creating full consolidated group numbers was a very manual process, and we had limited support for budgets and forecasts and analysis.” Read More
About Customer	Renewi PLC was created in 2017 by the merger of UK-based Shanks Group PLC and Netherlands-based Van Gansewinkel Groep B.V. It is a leading waste-to-product business collecting and recycling waste to energy and fuel, paper, metal, plastic, glass, woodchips compost and other products. Of the 14 million tons of waste handled per year, 89% is either recycled or used for energy recovery. The organization operates in the Netherlands, Belgium, UK, France and Portugal and is headquartered in Milton Keynes UK. Renewi generates more than €1.8B in annual revenue. Read More
Solution	Renewi was in search of a modern, future-proofed CPM solution to support the ambitions of the entire organization. “We wanted a powerful tool that would bring together group reporting for all our business units in one system. We needed to optimize reporting processes to create better insights and save time.” Renewi evaluated a long list of 10 vendors before selecting their final two contenders: OneStream and CCH Tagetik. OneStream provided Renewi four customer references. After speaking with real OneStream users, Renewi was thrilled about the positive feedback in relation to strategic fit, functional relevance, ease of use and implementation experience. “We originally considered Tagetik to be on par with OneStream. But when we went into the details of our consolidation functionality and how we handle intercompany reconciliations, there was no comparison,” said Wiericx. “OneStream was capable of delivering consolidation, reporting, budgets, forecasts, non-financial analytics and so much more from a single platform.” The OneStream project started with Concentric Solutions as Renewi’s implementation partner. Renewi had a desire for simplicity, while also fulfilling their need to manage complexity and change. Core requirements for the project included aligning group-wide processes and practices and designing an integrated data model with multidimensional analysis. The first phase of the project focused on management reporting and ad-hoc analysis. This included group, divisional and regional reporting with the capability for comparatives against budget and forecast. OneStream was set up for analysis by cost center, intercompany matching and eliminations, and direct data loads from Renewi’s six source systems. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Predictive Analytics

Application Infrastructure & Middleware - Data Exchange & Integration

Functional Applications - Enterprise Resource Planning Systems (ERP)

Applicable Industries

Recycling & Waste Management

Applicable Functions

Business Operation

Quality Assurance

Services

Software Design & Engineering Services

System Integration

Challenge

Creating innovative renewables, Renewi is the leading waste-to-product organization in the Benelux. With more than 7,000 employees, Renewi operates through five business units in their organizational structure. Formed from the result of a merger, Renewi was faced with the challenge of integrating two sets of reporting processes and two legacy CPM systems: Infor PM10 and Longview. With six main data sources, including Exact, JD Edwards, Metacom, Agresso, Navision, Pegasus and Excel®, Renewi was spending too much time manually managing data. The company was in urgent need of a solid tool to streamline statutory and management reporting. “Our CPM systems and processes were not fit for the future — both were dated, cumbersome and inefficient,” said John Wiericx, Reporting Manager Benelux at Renewi. “Creating full consolidated group numbers was a very manual process, and we had limited support for budgets and forecasts and analysis.”

About Customer

Renewi PLC was created in 2017 by the merger of UK-based Shanks Group PLC and Netherlands-based Van Gansewinkel Groep B.V. It is a leading waste-to-product business collecting and recycling waste to energy and fuel, paper, metal, plastic, glass, woodchips compost and other products. Of the 14 million tons of waste handled per year, 89% is either recycled or used for energy recovery. The organization operates in the Netherlands, Belgium, UK, France and Portugal and is headquartered in Milton Keynes UK. Renewi generates more than €1.8B in annual revenue.

Solution

Renewi was in search of a modern, future-proofed CPM solution to support the ambitions of the entire organization. “We wanted a powerful tool that would bring together group reporting for all our business units in one system. We needed to optimize reporting processes to create better insights and save time.” Renewi evaluated a long list of 10 vendors before selecting their final two contenders: OneStream and CCH Tagetik. OneStream provided Renewi four customer references. After speaking with real OneStream users, Renewi was thrilled about the positive feedback in relation to strategic fit, functional relevance, ease of use and implementation experience. “We originally considered Tagetik to be on par with OneStream. But when we went into the details of our consolidation functionality and how we handle intercompany reconciliations, there was no comparison,” said Wiericx. “OneStream was capable of delivering consolidation, reporting, budgets, forecasts, non-financial analytics and so much more from a single platform.” The OneStream project started with Concentric Solutions as Renewi’s implementation partner. Renewi had a desire for simplicity, while also fulfilling their need to manage complexity and change. Core requirements for the project included aligning group-wide processes and practices and designing an integrated data model with multidimensional analysis. The first phase of the project focused on management reporting and ad-hoc analysis. This included group, divisional and regional reporting with the capability for comparatives against budget and forecast. OneStream was set up for analysis by cost center, intercompany matching and eliminations, and direct data loads from Renewi’s six source systems.

Impact #1	OneStream’s concept of separate virtual cubes sharing dimensions within a single application enabled Renewi to map out reporting needs for the whole group in a single application. Having one centralized data source has standardized internal processes and improved reporting with ownership for all local, divisional and functional users.
Impact #2	A core element of Renewi’s new reporting system is the Guided Workflow functionality. This has enabled Renewi to push responsibility away from the head office and onto its reporting sites. Workflows link tasks to the appropriate user interfaces, governing user rights and security. Reporting processes are now defined centrally with local autonomy through a newly designed global chart of accounts. The global chart of accounts sets the group standard with constraints applied that filter the analysis codes to the relevant divisions. Best of all, system or data changes are now easily visible on audit reports.
Impact #3	With OneStream, Renewi has enabled greater efficiencies across their finance organization. They’ve enhanced business insights with group and divisional reporting from one single source. And visibility of the close cycle has dramatically improved through entity workflows and submission statuses. The entire close cycle is visible, enabling the head office to step in and ensure the bottlenecks that happened before OneStream no longer delay the close. The user feedback has been very positive. We now have a single truth on the state of the business.

Impact #1

OneStream’s concept of separate virtual cubes sharing dimensions within a single application enabled Renewi to map out reporting needs for the whole group in a single application. Having one centralized data source has standardized internal processes and improved reporting with ownership for all local, divisional and functional users.

Impact #2

A core element of Renewi’s new reporting system is the Guided Workflow functionality. This has enabled Renewi to push responsibility away from the head office and onto its reporting sites. Workflows link tasks to the appropriate user interfaces, governing user rights and security. Reporting processes are now defined centrally with local autonomy through a newly designed global chart of accounts. The global chart of accounts sets the group standard with constraints applied that filter the analysis codes to the relevant divisions. Best of all, system or data changes are now easily visible on audit reports.

Impact #3

With OneStream, Renewi has enabled greater efficiencies across their finance organization. They’ve enhanced business insights with group and divisional reporting from one single source. And visibility of the close cycle has dramatically improved through entity workflows and submission statuses. The entire close cycle is visible, enabling the head office to step in and ensure the bottlenecks that happened before OneStream no longer delay the close. The user feedback has been very positive. We now have a single truth on the state of the business.

Benefit #1	Of the 14 million tons of waste handled per year, 89% is either recycled or used for energy recovery.
Benefit #2	Renewi generates more than €1.8B in annual revenue.

Benefit #1

Of the 14 million tons of waste handled per year, 89% is either recycled or used for energy recovery.

Benefit #2

Renewi generates more than €1.8B in annual revenue.

Download PDF Version

Overview

Renewi's Integration of OneStream for Enhanced Financial Reporting and Consolidation

Operational Impact

Quantitative Benefit