Why Spreadsheets Won't Exit the Financial Stage in the Short Term
Despite the rise of new technologies such as cloud ERP, spreadsheets remain indispensable in the financial field. Gartner research shows that 51% of finance leaders still use spreadsheets for detailed planning. This article analyzes the integration capabilities, cost-effectiveness, user familiarity, and data democratization role of spreadsheets, arguing that they should serve as a bridge to new technologies rather than being eliminated.
Author: Mike Helsel, Senior Director at Gartner, focusing on financial technology and transformation. The views expressed in this article are solely those of the author.
In the pursuit of modernization, some Chief Financial Officers (CFOs) face the temptation to abandon spreadsheets in favor of cloud ERP systems and other emerging technological innovations. Common reasons for abandoning spreadsheets include limited scalability and the need for more robust data management and collaboration capabilities.
However, taking financial planning software (FPS) as an example, recent research shows that 51% of finance leaders still prefer to use spreadsheets for detailed bottom-up planning processes, then load these tables into the FPS. Using spreadsheets in core financial tasks is not optimal, but the issue is far more complex than simply eliminating them altogether.
When spreadsheets are integrated as a feature of cloud applications, they can still provide unique advantages and enhance the financial operations of modern enterprises.
Integration Capabilities
Modern ERP systems have evolved to integrate seamlessly with spreadsheets. For example, Excel can directly connect to ERP databases, enabling real-time data manipulation. This integration means that financial professionals can work in a familiar interface while ensuring data is synchronized with the ERP system. This reduces the need for manual data uploads and minimizes errors, streamlining workflows.
Furthermore, spreadsheets offer a cost-effective solution that leverages existing talent. Training or hiring employees to use new systems for every use case can be expensive and time-consuming. By keeping spreadsheets as part of the financial toolkit, organizations can utilize the skills employees already possess, avoiding the steep learning curve and costs associated with new software.
Familiarity and Flexibility
Spreadsheets are versatile tools that financial professionals are very familiar with. Accountants and financial analysts have honed their skills in Excel, mastering functions to manipulate data efficiently. This expertise allows them to easily perform complex calculations, create pivot tables, and execute VLOOKUPs—tasks that often become cumbersome in rigid ERP interfaces.
Spreadsheets also allow users to customize and adjust their workspace to suit specific needs. This adaptability is crucial in dynamic business environments where financial scenarios change rapidly. CFOs should leverage the deep pool of talent within their functions rather than trying to leave it in the past.
Technology Adoption
Gartner research indicates that the successful implementation of new technologies in finance largely depends on user acceptance. Therefore, forcing the abandonment of spreadsheets may hinder financial transformation because it alienates employees who are accustomed to and proficient in spreadsheets.
It is common for employees to complete many tasks in spreadsheets anyway and then import the results into new systems. Rather than fighting this, CFOs should consider spreadsheets as a bridge to new technologies: seek systems with spreadsheet integration capabilities to facilitate a smoother transition and ensure employees remain engaged and productive. In this way, CFOs can achieve a balanced approach that leverages the strengths of both traditional and modern tools while reducing employee resistance to new technologies.
Data Democratization
Spreadsheets are not only tools to mitigate employee resistance to technology but can also play a broader role in financial transformation as catalysts for change. They allow organizations to experiment with new processes and models without requiring a comprehensive system overhaul. This capability is especially important in the early stages of transformation when flexibility and adaptability are key.
By using advanced features of spreadsheet applications, finance teams can pilot new initiatives, gather insights, and achieve process optimization by automating tasks, processes, or workflows. This iterative approach not only reduces risk but also accelerates the transformation process, enabling organizations to quickly adapt to market changes and emerging opportunities.
Moreover, spreadsheets contribute to data democratization within organizations. They empower financial professionals at all levels to engage with data, derive insights, and contribute to decision-making. This democratization fosters a culture of innovation and collaboration, which is a vital component of successful financial transformation.
The Future of Spreadsheets in Finance
As organizations continue to evolve, the role of spreadsheets will undoubtedly change. However, their core strengths will ensure they remain a valuable asset in the financial toolkit. CFOs should not view spreadsheets as outdated tools but rather embrace their flexibility, integration capabilities, cost-effectiveness, and user familiarity.
By leveraging spreadsheets integrated with cloud applications, CFOs can create a more agile and efficient financial environment, ensuring their teams are equipped to meet the challenges of an ever-changing business landscape. Spreadsheets are not just tools of the past; they are an essential part of the future of finance.