innogy: Commodity Margin Planning and Monthly Accruals in SAP Analytics Cloud

We helped innogy Česká republika digitalize its commodity margin planning and the calculation of monthly gas and electricity accruals using SAP Analytics Cloud. Two new models bring together data from SAP BW/4HANA, Snowflake and other sources, standardize the calculations, and give a transparent, auditable view of both the expected margin and the value of monthly accruals.

From consumption planning to transparent margin management

When innogy Česká republika prepares budgets and updates forecasts, it needs to keep evaluating its expected commodity margin, which is the difference between planned sales revenue and the cost of purchasing gas and electricity. The calculation draws on planned offtake volumes, known contract prices, future sales prices and individual purchase tranches. At the end of each month, the company also has to quantify accruals for its large and medium-sized customers, including distribution costs.

Two models in SAP Analytics Cloud

Working with Mibcon consultants, innogy implemented two models in SAP Analytics Cloud: Commodity Margin and Accruals for Large and Medium Customers (Dohady VO/SO). The Commodity Margin model lets users import planned offtake volumes, calculate revenue and margin, match purchase tranches to planned offtake, add missing purchases and validate sales prices. The accruals model lets users choose the supply points of large and medium customers as needed and calculate monthly gas and electricity accruals, including distribution.

The solution pulls data from SAP BW/4HANA, Snowflake and Excel files stored in SharePoint. The SAC Excel Add-in supports flexible calculations, so users can adjust the formulas to fit their specific needs. Users can also define the supply points for a given monthly accrual simply by pasting in a list of them.

A single view of margin and a faster month-end close

The new solution creates one consistent data flow, from planned consumption through the purchase position and sales prices to the final margin. Users can now see exactly which purchase tranches cover specific planned offtake volumes and where the purchase position is still open. The month-end close is also faster, because accruals for large and medium customers, including distribution, are now calculated in a targeted way. The result is a single, auditable view of both the inputs and the calculations.

The solution was implemented between November 2024 and September 2025, while the data environment was being migrated to SAP BW/4HANA. Next steps include expanding it as users’ needs grow and gradually integrating more data sources.

You can find details about the project in this PDF document.

About innogy Česká republika a.s.

innogy Česká republika a.s. is one of the leading energy companies on the Czech market. It is the market leader in natural gas and one of the largest electricity suppliers in the Czech Republic, with around 1.7 million contracts. Besides supplying gas and electricity, the company is active in heating and clean mobility, including CNG. It employs about 1,520 people in the Czech Republic, and in 2025 the group’s Czech operations reported turnover of CZK 44.1 billion.