OneStream consolidations implementation

Project overview and objectives

Let’s set the scene. A cryogenic manufacturer had an extensive entity structure—we’re talking over 900 global entities—that caused complexities in their intercompany relationships. They engaged Clearsulting to help improve visibility into their cash flow with OneStream. Here’s where they were at the start of their transformation:

• Originally performing consolidations through their primary ERP, this limited the level of data granularity they could obtain from units that used other ERPs ​​
• When doing validation checks, the data submission and review process caused back and forth between corporate and subsidiaries to get accurate data​
• At the time, their current setup had minimal data access security applied

What we did

Projects like this require a lot of stakeholder buy-in. We kicked-off with collaboration in mind:

• Conducting workshops to engage global finance stakeholders and gain input for the future state design​
• Analyzing processes and data model to identify inefficiencies, limitations, and improvement opportunities​
• Creating prototypes of new designs that were iterated to a final state together with stakeholders

Impact

By the time we hit go-live, there was a dramatic difference in cash flow visibility, making for easier audits and simplifying the review process. But that’s not all. We also:

• Streamlined the global data collection process by integrating ERPs directly into OneStream, allowing for increased data granularity and scheduling of data loads​​
• Automated intercompany matching and reporting​
• Redesigned cash flow to be viewed at a more detailed, company level (instead of by currency)​
• Implemented a global access security framework

Ready to expand your confidence in your data and business processes? We can help. Learn more about what we do with OneStream.