Energy Services Company 2

Energy Services Company 2 1

Energy Services Company

Streamlined Close Complete Transparency Internal Controls

The public-facing portion of a large energy services company needed to consolidate their forecasts from individual entities into a rolling forecast.

Both the public and private portions had various needs, issues, and legal requirements that needed to be addressed. We created a solution to implement the OneStream platform for both the public and private sides of the organization.

  • Created financial separation of public and private access in single platform.
  • Implemented 12-month rolling forecast to compare forecast vs. actual results.
  • Created Scenario Blending Rules to combine actuals with forecast or planning data.
  • Dramatically improved forecasting lead times to refresh or make changes.
  • Eliminated many manual processes to create a single source of truth for data.
This field is for validation purposes and should be left unchanged.

Summary

The public-facing portion of a large energy services company needed to consolidate their forecasts from individual entities into a rolling forecast. Both the public and private portions had various needs, issues, and legal requirements that needed to be addressed. We created a solution to implement the OneStream XF platform for both the public and private sides of the organization.

Woman and man talking in business environment

The Problem

Why Energy Services Company Approached HollandParker?

The organization lacked a reliable method to consolidate forecasts, the budgeting process was cumbersome, and their Excel and Access databases were difficult to maintain for planning purposes. Additionally, various needs and issues for both the public and private sides of the organization needed to be addressed.

  • Consolidations required error-prone manual mapping for individual entities.
  • Multiple Excel models made it difficult to drive Gross Margin Forecasting.
  • The planning ecosystem was too bulky for nimble scenario analysis.
  • Excel spreadsheets were prone to error and there were no automated checks.
  • The budgeting process took one month to complete.
  • It was difficult to compare forecasts to actual results because of the manual nature of the process.
  • Long lead times held up any improvements or changes
  • The complexity of the system limited data accessibility for budget stakeholders.
Smiling husband and wife shaking hands with businesswoman

Here Are the Key Achievements for This Client

Dramatically improved the forecasting lead times to refresh or make changes.

Energy Services Company 2 2

Saved time for personnel by slimming down the planning ecosystem.

Energy Services Company 2 3

Made it possible to compare actuals to budget data as soon as monthly actuals are loaded.

Energy Services Company 2 4

More time to review user access & security changes.

Energy Services Company 2 5

Pre-Transformation Checklist for Finance eBook cover