Dril-Quip previously used Microsoft Excel® spreadsheets as a consolidation and reporting tool for their month end close process.
Inconsistencies in data collection via Excel spreadsheets created a lengthy and inefficient close process for Dril-Quip. Further, the visibility senior management had within geographic segments limited the ability to make strategic decisions.
Budgeting and forecasting were prepared in Excel® using a top-down approach. The regional controllers were responsible for taking the Excel spreadsheets from each entity and department within their responsibility and aggregating the data into income statement format using Excel formulas. Drivers and versioning were disjointed and not easily identified.
The company wanted a unified and streamlined solution for all their financial consolidations, internal and external reporting, forecasting, and analysis – that is easily maintained, with the ability to push down accountability to global regions and that delivers accurate reporting.
The company also had a need to strengthen its internal controls over financial reporting.
OneStream XF is a unified SmartCPMTM platform solution, it is not a siloed set of solutions that are fused together. OneStream XF solutions can be expanded upon, extended, and in a very real sense - blended together to meet the needs of a data consumer.
Nucleus Research takes a different approach to their vendor rankings vs. other IT analyst firms. Through the analysis of user experiences, Nucleus evaluates software vendors based on functionality and usability – key drivers of value - and places them into four categories: Leaders, Experts, Facilitators, and Core Providers.
Enterprise-class consolidation software applications provide intercompany eliminations that are powerful enough to handle sophisticated business needs yet allow for easy reconciliation. Not all software that claims to do financial consolidations provides both, and in some cases, it provides neither.
Intercompany transaction volume can be significant and difficult to identify. To ensure all this activity is identified, eliminated and documented correctly for auditors requires a detailed system of controls.
Upgrades to modern ERP, CRM and HCM systems have helped many organizations improve their transactional processes. However, many are hindered in gaining efficiencies in their management processes due to reliance on legacy corporate performance management (CPM) applications.
Straight aggregation engines are not designed for the complexities of financial consolidation, currency, eliminations, consolidation status, cash flow, and entity adjustments that only apply to specific hierarchical roll-ups that can be critical for true statutory reporting compliance. It doesn’t mean that you can’t solve some of these problems with a straight aggregation system, the question is, how agile is it, how easy is it to maintain and what is the cost and sustainability of your end solution?
The limitations inherent in legacy CPM applications may be one of the reasons CPM software often gets deployed in Finance and doesn’t get into the hands of managers in other departments. If the software is too expensive, difficult to deploy, and not easily extensible – expanding beyond Finance is challenging.
There was a time when all cash flow reports were done apart from the trial balance in a tool like Excel. The reasons were, among others, that most consolidation systems could not calculate currency translation and intercompany eliminations correctly and easily. This made writing a cash flow report very difficult. But times and technologies have changed.
In most organizations, account reconciliations are performed as a parallel process to the financial consolidation, close and reporting cycle, either in spreadsheets or an account reconciliation system that’s separate from the consolidation and reporting system. This approach limits visibility into the entire set of closing activities, leads to inefficient communication, time lags, and gaps between people, processes and systems used in the financial close and reporting cycle.