The Curtis team evaluated several corporate performance management (CPM) solutions from Oracle, IBM, SAP, Infor and OneStream. OneStream was selected based on the software functionality, knowledge and quality of the sales and services team, the team’s commitment to customer success, and ability for the Finance department to manage the system themselves and reduce reliance on their information technology (IT) group. Curtis Instruments initially implemented OneStream XF for financial consolidation and reporting – including generation of balance sheets and income statements at corporate and subsidiary levels. They later extended the implementation to address their budgeting, planning and forecasting requirements.
Streamlining Financial Consolidation and Reporting
Working with OneStream partner Finit, the Curtis team integrated OneStream with its Syteline ERP system and has empowered business unit Finance teams to be more responsible for their own financial reporting. The new system allows Curtis to consolidate and report their results in multiple currencies with second tier subsidiary currency overrides.
The team improved the corporate consolidation and reporting process and reduced the number of reporting errors by replacing manual data load and elimination of intercompany transactions with an automated process. As a result, the complex intercompany elimination process that used to take 10 days is down to 3 days.
“With OneStream, consolidation is much faster, with fewer errors, providing the Finance team more time to analyze financials – which is a huge improvement,” said George Galdo, Director, International Financial Reporting & Contract Review at Curtis Instruments. “The ability for users to view and drill into data is great, they can answer questions faster and focus on real issues. Information is timelier, so there’s deeper analysis and better problem-solving.”
Supporting More Detailed Budgeting and Planning
Also working with Finit, the Curtis team extended OneStream to address their budgeting and planning requirements at corporate and the subsidiary level. Revenue and expense budgets are created at a very granular level, across 2,400 customers and over 5,000 products. Sales volume is budgeted by customer, by item and average selling price and standard costs are applied at the same level of detail. This enables very detailed variance analysis throughout the year.
Improving Sales and Operational Reporting
Going beyond the typical month-end or quarter-end reporting process, Curtis Instruments is loading and consolidating data nightly into OneStream from source systems. This allows the CFO and CEO to see a daily snapshot of global sales, and progress against budget throughout the month – instead of waiting for month-end or quarter-end to see the results
Said Mr. Galdo, “With OneStream, Curtis Instruments management team has gained improved visibility into business performance, as well as sales and margins across locations and product SKUs.” They achieve this by loading results and reporting actuals against budget at the customer and item level. The OneStream system captures sales invoice details, the transaction price, local currency, and standard cost data – across thousands of parts.
“My favorite thing about OneStream is the Excel Quick View tool. This gives users the ability to directly access GL data in OneStream, compare trends and results vs. budget and quickly get answers,” said Mr. Galdo.