<img height="1" width="1" style="display:none;" alt="" src="https://px.ads.linkedin.com/collect/?pid=94228&amp;fmt=gif">

Prince Success Story



About Prince

Headquartered in Houston, Texas with manufacturing facilities and sales offices on six continents, Prince specializes in developing, manufacturing and marketing performance-critical additives for niche applications utilized in the construction, electronics, consumer products, automotive, industrial and similar end markets. Prince is a value-added processing intermediary between large global raw material suppliers and end market customers with approximately 1,300 employees and $600M in revenue. For more information, visit princecorp.com.

The Challenge

With processing centers strategically located across six continents, Prince was growing at an exponential rate. Over the last 13 years, they have had 18 acquisitions and today are managing over 25 entities, with more than half outside of North America. There are multiple ERP systems in use across the enterprise, including IFS, Ross and SAP. And to make matters worse — they were relying on Excel® to reconcile, translate, consolidate and report financial information.

“We ended up with several ERP systems due to acquisitions, and we didn’t have any CPM tools in place — no BI or automation at the consolidation level,” said A.J. St. Angelo, Controller at Prince. There was a general lack of controls, versioning and audit trails, and using multiple workbooks made it difficult to integrate newly acquired companies into the process. “Currency translation was challenging, and there were several issues with data quality. We were constantly worried about manual adjustments and the timeliness of data.”

Implementing a Modern CPM Platform

“We knew we had to implement a better process — it was a known business need,” St. Angelo explained. “Given the company’s focus on acquisitions, we needed to focus on a plan to implement and leverage a systematic consolidation tool.” Prince began their solution evaluation with presentations from Oracle, OneStream and Host Analytics. OneStream was more cost-effective and provided greater flexibility than the other solutions presented. “Being an open platform and having the ability to configure OneStream to meet the ever-changing needs of the company was a big selling point,” St. Angelo explained. “OneStream gave us the flexibility to configure the platform to meet the needs of the company into the future.

Prince went live with financial consolidation and reporting in just three months, and has since continued to add additional capabilities over time. We were quickly able to source our financial statements, including the calculation of adjusted EBITDA, from OneStream,” said St. Angelo. “We next added the budget, and we began generating the majority of our financial reporting from the system.”

Prince built an exchange rate interface that is automatically updated daily, followed by automated cash flow calculations. They also created a specialty profitability analysis solution for visibility into customer and product detail across each entity with a vertical reporting cube looking at labor, overhead costs and raw materials changes per unit.

Financial Consolidation & Reporting Results

Automating the financial consolidation process with OneStream has enhanced the transparency, timeliness and availability of information at Prince. St. Angelo and his team are bringing in ERP sales, customer and product master data, along with GL information, and reconciling that data in OneStream. They have automated data loads happening nightly and three times a day during close.

OneStream provides Prince with the ability to drill-back to the ERPs to understand data at the transactional level, by voucher line item or journal line item. “All currency translations are automated, and every data source has a direct connection into OneStream, so the data quality issues that plagued us were mitigated,” said St. Angelo. By using statistical accounts for validations, Prince has set up extensive allocation rates in OneStream that drive end market P&L down to net income.

For reporting and analysis, Prince is leveraging pre-defined standard reports and have set up dashboards for users to get summary financials, balance sheet and income statement data. St. Angelo said, “OneStream is the one source of truth for the company, and information is readily available and can be tailored depending on the individual user’s need.”

Benefits of OneStream XF

“We’ve been very happy with OneStream,” St. Angelo said. “A huge benefit has been the ability to configure the business rules, create new cubes, dynamic calculations and dashboard views quickly — the possibilities are endless.”

With the OneStream XF MarketPlace, Prince saw additional opportunities to leverage their existing OneStream investment. Using the Account Reconciliations solution, Prince was able to create dashboards to make life easier for end users. From a unique landing page, accountants can look at an overview of their reconciliations, which has saved a significant amount of time vs. navigating through spreadsheets.

The vertical reporting cube with customer and product profitability is significantly better than their prior Excel method. Prince is accumulating variance explanations faster with real-time tracking and having the ability to drill into ERP details to research variances has been key to their success. OneStream has helped Prince reduce the close process from 20 days to six days for final financials


About the Implementation Partner

AIT Consulting is a Management Consulting Firm that provides a “handson” people first approach to transforming finance organizations. We have a strong focus on improving financial consolidation, planning, and reporting processes leveraging the OneStream Corporate Performance Management Platform. We recruit individuals that understand both the technical accounting and IT aspects of the modern finance organization and leverage this unique combination to provide an unparalleled level of service to our clients. We are also focused on the communities in which we work and live. Our firm is committed to volunteering within the greater Houston area and providing financial assistance to different organizations and ministries in the area. For more information, visit AITConsultingServices.com.

About OneStream Software

OneStream Software provides a marketleading CPM 2.0 solution, the OneStream XF SmartCPM™ platform. OneStream XF unifies and simplifies financial consolidation, planning, reporting, analytics and financial data quality for sophisticated organizations. Deployed via the cloud or on-premise, OneStream’s unified platform enables organizations to modernize Finance, replace multiple legacy applications, and reduce the total cost of ownership of financial systems. OneStream unleashes Finance teams to spend less time on data integration and system maintenance – and more time focusing on driving business performance.

The OneStream XF MarketPlace features more than 50 downloadable solutions that allow customers to easily extend the value of their CPM platform to quickly meet the changing needs of finance and operations. We are driven by our mission statement that every customer must be a reference and success.

For more information, please visit OneStream Software http://www.onestreamsoftware.com or on Twitter @OneStream_Soft.