From Excel to Integrated Financial Planning at RheinEnergie
RheinEnergie AG, one of the leading energy providers in the German state of North Rhine-Westphalia, set out to digitise its financial planning as part of a comprehensive transformation project. The company-wide migration from an older SAP system to SAP S/4HANA presented an opportunity to fundamentally rethink planning. Previously, financial planning was primarily carried out using decentralised Excel files, which led to poor data quality, time-consuming manual processes, and a lack of transparency. RheinEnergie recognised the need for an integrated EPM solution to enable efficient and high-quality centralised planning.
The aim of the project was to implement a centralised planning platform based on Jedox for cost centre, cost type, and profit centre planning. In the medium term, the application is also intended to support balance sheet and cash flow planning, as well as further modules. Particular focus was placed on improving the quality of
planning data and automating interfaces to the SAP system.
The project was embedded within the SAP migration and therefore had to contend with ongoing structural changes and system adjustments. In parallel, data structures and source systems – particularly SAP S/4HANA, SAP BW, and Tableau – were redefined, adapted, and integrated.
Find out all about the highlights:
Quality Improvement: Data quality and planning depth have significantly improved
Increased Efficiency: Uploads to the SAP system are now automated with a single click rather than manual
Validation & Transparency: Centralised reports and workflows enable structured review and approval of plans
Successful cooperation as a key factor for project success
RheinEnergie AG is one of the leading energy suppliers for electricity, gas, water and heat in North Rhine-Westphalia. Based in Cologne, the company supplies around 2.5 million people, industry, trade and commerce with energy and drinking water. RheinEnergie has holdings in numerous municipal utilities in the Rhineland.
| Industry | Region | Application | Software |
|---|---|---|---|
| Energy & Utilities | Cologne, Germany | Financial Planning | Jedox |
STRATO and bdg jointly developed the concept for the implementation of a BI/CPM solution for controlling. Board was chosen as the software; the intuitive and user-friendly design of the application was particularly decisive, enabling it to be used as a self-service BI.
When are modernizations due, which contracts are about to expire? The solution developed by bdg and alstria for property planning in the real estate industry collects these and countless other data in one slick application.
Planning and controlling are easier, and media discontinuities are avoided. All in all: an absolute win.
bdg and alstria have developed a tool for property valuation using the discounted cash flow (DCF) method to enable alstria to valuate its property portfolios more efficiently, quickly and cost-effectively – the volumes of data were simply no longer manageable in Excel and the processes were extremely time-consuming.
