In order to sustain positive momentum, Crane evaluated a few corporate performance management (CPM) vendors to meet their demands. This included Oracle FCCS, Host Analytics and OneStream Software. OneStream’s unified platform, robust consolidation engine and intuitive workflow design quickly placed itself as the go-to strategy for Crane’s financial close and FP&A function.
The leadership team understood the value of the OneStream XF MarketPlace to continue to support their reporting requirements and further automate close tasks and responsibilities. The team also found that OneStream XF Cloud would provide an opportunity for site managers across the globe to access, review financials and drive accountability. A cloud solution would enable them to evaluate acquisitions aggressively without worrying about data integration.
Implementing OneStream XF Cloud
Crane partnered with Riveron to develop a roadmap to replace Insight and the manual, Excel-based consolidation and reporting processes with OneStream. With process improvement in mind, Riveron focused on designing a flexible application, one that would provide intuitive workflows for all end users, improve close efficiency and standardize a decentralized budgeting process.
“Once we went live on OneStream, our manual consolidation process went away, and everything became much more efficient,” said Ford. “We kicked off the project in January 2019, focusing on consolidations first. Then we rolled right into implementation of our budget process, which was up and running for our 2020 budget cycle. The entire implementation took only nine months to complete.”
Streamlined Close and Reporting
OneStream’s direct integration with Sage automated trial balance loading from each ERP instance on a scheduled basis and greatly reduced time in data preparation. Overall, OneStream has reduced the close process by three to four days, while cutting time spent on reporting process by nearly 50 percent. Each country’s site controller has a standardized workflow designed to verify their trial balance data, load journals, input supplemental cash flow and roll-forward inputs, and review a variety of financial statements. Corporate can monitor daily close progress without having to reach out to get a status update. In addition, each legal entity can review and reconcile intercompany balances and use built-in commentary to resolve differences while increasing transparency.
Parcel Service, an XF Marketplace solution, was vastly helpful in automating and distributing more than 400-plus reports consumed by individual sites, country managers, regional directors and corporate. This eliminated consolidation workbooks, linked spreadsheets and manual intervention to update POV selections.
Cash flow statements were previously completed quarterly due to the time-consuming nature of collecting various information across 50 entities. With roll-forward forms embedded into each entity’s workflow, as well as OneStream’s flow dimension and business rule calculation capabilities, the cash flow reporting process is now automated and provides leadership with a significant increase in cash expenditure information. “Previously, we would spend a full day linking spreadsheets, and two days manually linking data for cash flow,” said Ford. “Now the countries can fill that data into OneStream, and the cash flow is automated. I just go in and apply topside adjustments, taking a two-plus day process down to a couple of hours.”
Crane’s goal to remain lean and provide meaningful business insight to management was well supported by OneStream. From a more efficient close cycle, dynamic reporting—including automated cash flow—to drastically reducing days in planning cycle, Crane realized return on their investment. Crane is well suited to acquire new sites or create legal entities with full confidence in OneStream’s capabilities to handle integration and deliver results. Management can rely on OneStream to deliver quick results and make real-time decisions accordingly.
“The nice thing about OneStream is that the platform has proven that our data is now correct,” said Katrina Celestine, Financial Reporting Manager at Crane. “Everything from reconciliations to cube views to custom reporting has been huge. Best of all has been the drill-down functionality. When someone asks a question about an amount, I can drill into the detail and see exactly what’s pulling into it and provide support. With OneStream, the answer is always at your fingertips, which I really like.”
About the Implementation Partner
Riveron is a business advisory firm specializing in accounting, finance and operations. They partner with otheir clients to successfully prepare for and execute change across the entire transaction and business lifecycle. Riveron’s unique combination of consulting, public accounting and corporate experience allows them to offer an unprecedented level of understanding and results. Founded in 2006, Riveron is headquartered in Dallas, Texas and has offices across the country.
Riveron’s dedicated OneStream practice is comprised of CPM subject matter experts who supply practical solutions to a wide range of client requirements and critical objectives. Riveron’s OneStream expertise spans broadly across the platform with a number of client deployments fully leveraging the core functionality, as well as multiple marketplace solutions. For more information, visit Riveron.com.