Henniges initially implemented OneStream XF to deliver multiple solutions to meet all their financial reporting requirements in one application.
- Corporate financial consolidation and reporting
- Sales/EBITDA bridging, with automated stacking
- High-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 XF 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.