Today, confidence in data quality is needed more than ever. Executives must constantly respond to a multitude of changes and be provided with accurate and timely data to make the right decisions on what actions to take. It’s, therefore, more critical than ever that organisations have a clear strategy for ongoing financial data quality management (FDQM). Why? Well, better outcomes result from better decisions. And high-quality data gives organisations the confidence needed to get it right. This confidence in data then ultimately drives better performance and reduces risk.
Data quality matters for several key reasons, as shown by research. According to Gartner, poor data quality costs organisations an average of $12.9 million annually. Those costs accumulate not only from the wasted resource time in financial and operational processes but also – and even more importantly – from missed revenue opportunities.
As organisations turn to better technology to help drive better future direction, the emphasis placed on financial data quality management in enterprise systems has only increased. Gartner also predicted that, by 2022, 70% of organisations would rigorously track data quality levels via metrics, improving quality by 60% to significantly reduce operational risks and costs.
In a report on closing the data–value gap, Accenture said that “without trust in data, organisations can’t build a strong data foundation”. Only one-third of firms, according to the report, trust their data enough to use it effectively and derive value from it.
In short, the importance of data quality is becoming increasingly clearer to many organisations – creating a compelling case for a change in financial reporting software evaluations. There’s now real momentum to break down the historic barriers and move forward with renewed confidence.
Financial data quality management has been difficult, if not virtually impossible to achieve for many organisations. Why? Well, in many cases, legacy corporate performance management (CPM) and ERP systems were simply not built to work together naturally and instead tended to remain separate as siloed applications, each with their own purpose. Little or no connectivity exists between the systems, so users are often forced to resort to manually retrieving data from one system, manually transforming the data, and then loading it into another system – which requires significant time and risks lower quality data.
There’s also often a lack of front-office controls that leads to a host of issues:
All of that contributes to significant barriers to ensuring good data quality. Here are the top 3 barriers:
Yet even when such barriers are acknowledged, getting the Finance and Operations teams to give up their financial reporting software tools and traditional ways of working can be extremely challenging. The barriers, however, are often not as difficult to surmount as some believe.
The solution may be as simple as demonstrating how much time can be saved by transitioning to newer tools and technology. Via such transitions, reducing the time investment can result in a dramatic improvement in the quality of the data through effective integration with both validation and control built into the system itself.
There are some who believe Pareto’s law applies to data quality: Typically, 20% of data enables 80% of use cases. It is therefore critical that an organisation follows these 3 steps before embarking on any project to improve financial data quality:
At its core, a fully integrated CPM software platform with built-in financial data quality (see Figure 1) is critical for organisations to drive effective transformation across Finance and Lines of Business. A key requirement is providing 100% visibility from reports to data sources – meaning all financial and operational data must be clearly visible and easily accessible. Key financial processes should be automated and using a single interface would mean the enterprise can utilise its core financial and operational data with full integration to all ERPs and other systems.
The solution should also include guided workflows to protect business users from complexity by guiding them uniquely through all data management, verification, analysis, certification, and locking processes.
OneStream offers all of that and more. With a strong foundation in financial data quality, OneStream allows organisations to integrate and validate data from multiple sources and make confident decisions based on accurate financial and operating results. OneStream’s financial data quality management is not a module or separate product but built into the core of the OneStream platform — providing strict controls to deliver the confidence and reliability needed to ensure quality data.
In our e-book on Financial Data Quality Management, we shared the following 3 goals for effective financial data quality management with CPM:
Here’s one example of an organization that has streamlined data collection and improved data quality in the financial close, consolidation, and reporting process leveraging OneStream’s unified platform.
MEC Holding GmbH – headquartered in Bad Soden, Germany – manufactures and supplies industrial welding consumables and services, cutting systems, and medical instruments for OEMs in Germany and internationally. The company operates through three units: Castolin Eutectic Systems, Messer Cutting Systems, and BIT Analytical Instruments.
MEC has 36 countries reporting monthly, including over 70 entities and 15 local currencies, so the financial consolidation and reporting process includes a high volume of intercompany activity. With OneStream, data collection is now much easier with Guided Workflows leading users through their tasks. Users upload trial balances on their own vs. sending to corporate, which speeds the process and ensures data quality. Plus, the new system was very easy for users to learn and adopt with limited training.
MEC found that the confidence from having ‘one version of the truth’ is entirely possible with OneStream.
If your Finance organisation is being hindered from unleashing its true value, maybe it’s time to evaluate your internal systems and processes and start identifying areas for improvement. To learn how read our whitepaper on Conquering Complexity in the Financial Close.