Henniges

“OneStream’s Guided Workflows give each business user a step by step process that ensures the quality of data and delivers the reporting and analysis at each step. We now have one system owned by the office of Finance that delivers powerful management and ad hoc reporting for management and business users.”

— Linda Hellebuyck | Corporate Controller, Henniges Automotive
 
 

The Challenge

Henniges previously used Hyperion Enterprise as a consolidation tool and Hyperion Retrieve for reporting. They also used a home-grown SQL Database for all data loading, integration, and mapping activities. The company wanted a unified solution for all their financial consolidation and reporting, forecasting, and analysis – all maintainable by the same staff that maintained Hyperion Enterprise.
 
 

The OneStream™ Solution

Henniges initially implemented OneStream to deliver multiple solutions to meet all their financial reporting requirements in one application.

This included:

• Corporate financial consolidation and reporting
• Sales/EBITDA bridging, with automated stackingHigh-level product profitability
• Departmental reporting for corporate
• Automated integration with Plex GL
• Purchase accounting and change in control
• Conversion to IFRS in 2017

Henniges also had a need for more detailed customer and product profitability analysis and extended their implementation to address these requirements in 2017. This entailed integrating non-GL data and leveraging OneStream to harmonize, store, allocate, and aggregate the data at a detailed (part number) level. The solution helps Henniges perform detailed allocations and produce a summarized P&L (thru EBITDA) for any part, vehicle, product, or customer.
 
 

Replacing Hyperion and Streamlining Financial Reporting

Henniges was able to replace several disparate systems (Hyperion Enterprise, custom SQL Database, remote desktop for accessing HE, and manual Excel uploads for actuals) with a singularly integrated OneStream solution.

Said Linda Hellebuyck, Corporate Controller, “OneStream’s Guided Workflows give each business user a step by step process that ensures the quality of data and delivers the reporting and analysis at each step. We now have one system owned by the office of Finance that delivers powerful management and ad hoc reporting for management and business users.”

According to Ms. Hellebuyck, “Significant benefits have been achieved around audit, controls, intercompany eliminations and automated update of forecast when actuals are loaded. This has been a huge benefit to the business. OneStream also provides a simplified process for reviewing our constant rate analysis to eliminate the currency effects for results.”
 
 

Improving Profitability Insights

For the product and customer profitability project, Henniges created a new virtual “cube” within the OneStream application and leveraged its extensible dimensionality. While the profitability cube shares some dimensions with the financial cube, it includes several additional dimensions, including customers, products, parts, platforms and others.

The application leverages OneStream to automatically add new part numbers during data loads, handle end-user assignment of costs to products/vehicles, perform automatic allocation of costs, identify intercompany sales and profits by plant, customer, vehicle and product.

According to Ms. Hellebuyck, “Because it’s one Application, we can share both metadata and data across the two cubes, making cross-cube comparisons and reconciliations easy. We don’t even move data between the two cubes. The allocation formula simply cross-references data in the Financial Cube. In other multi-product solutions, marrying the consolidations data with the part-level analytical data would be significantly more complex.”

The new profitability solution has yielded many benefits to Henniges. Leveraging the OneStream platform, data can be collected more quickly (e.g, day 4 vs. day 16). Data can also be collected more frequently, currently quarterly and eventually monthly. Moreover, the solution provides Henniges management with deeper insight into what pieces of the business are producing (or not producing) bottom-line profits.
 
 

About OneStream™ Software

OneStream Software provides a market-leading intelligent finance platform that reduces the complexity of financial operations. OneStream unleashes the power of finance by unifying corporate performance management (CPM) processes such as planning, financial close & consolidation, reporting and analytics through a single, extensible solution. We empower the enterprise with financial and operational insights to support faster and more informed decision-making. All in a cloud platform designed to continually evolve and scale with your organization.

OneStream’s Intelligent Finance platform can easily be extended with over 50 solutions from the OneStream MarketPlace. These downloadable solutions are fully battle-tested and optimized for the OneStream platform. They allow customers to easily extend the value of their investment to meet the changing needs of finance and operations.

For more information, please visit OneStream Software https://www.onestream.com or on Twitter @OneStream_Soft.
 
Download the Case Study