HollandParker Client Case History | Largescale Building Solutions Provider

A merger created one of the largest U.S. providers of residential and commercial building solutions.

One company was already using the OneStream platform for financial data management. However, the other company was not using OneStream Software. We created a separate cube for the non-OneStream company to blend financial data in the OneStream environment and to help automate manual processes.

Created dynamic transformation rules to map data into OneStream.
Manually created time composite maps for all business entities and their segments.
Created journal entries and fixed transformation rules for financial statement creation.
Provided a more detailed level view of P&L Reports.
Created validation templates for each segment to standardize financial consolidations.

The Pre-Transformation Checklist for Finance

An 11-Step Risk Reduction Tool for CFOs and CAOs Who Aren’t Sure Where to Start

Summary

A merger created one of the largest U.S. providers of residential and commercial building solutions. One company was already using the OneStream XF platform for financial data management and the other was not. HollandParker was brought in to create a separate cube for the non-OneStream company to blend financial data into the OneStream environment for the newly-formed company and to help automate manual processes.

Woman and man talking in business environment

The Problem

Why Largescale Building Solutions Provider Approached HollandParker?

The non-OneStream company used calendar year data, while the current OneStream company used fiscal year data. HollandParker needed to move the current OneStream company from fiscal to calendar year to create a cohesive view of financial data from both parties. We also needed to solve these specific challenges for the non-OneStream company:

Inconsistent data mapping. The company came onboard with 12 entities broken into separate segments, and the segment mappings changed from month to month.
Lack of standardization for how financials were consolidated across segments. (OneStream needed to consolidate segments nationwide and automate manual processes.)
Financial statements were manually manipulated and not consistent between each segment.
Flat files required manual manipulation before loading into OneStream.

The Solution

How We Approached the Problem

In the cube we developed for the non-OneStream company’s data, we created dynamic transformation rules so that when data was loaded into OneStream for the merged company, the platform knew where to map the hundreds of new accounts for each segment. We supported this effort with the following actions:

Smiling husband and wife shaking hands with businesswoman

Manually created time composite maps for all business entities and their segments that changed month to month.
Created journal? entries and fixed transformation rules to have the data tie out for accurate financial statements.
Provided management a more detailed view of P&L Reports for the non-OneStream company.
Created validation templates for each segment to standardize how the financials were being consolidated.
Enhanced their Consolidations application to include a merged view.

Here Are the Key Achievements for This Client

HollandParker built the following capabilities that resulted in complete use of the OneStream platform to support the financial data needs of the newly-formed company:

Additional fiscal year cube for non-OneStream company.