“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.