FP&A teams strongly rely on Excel and are comfortable operating in this environment for their planning and reporting processes. According to Gartner, a large majority of organisations continue to use Excel a the core of their planning process.
Yet with much of the industry looking to digitise, will Excel still hold a seat at the table when it comes to planning and reporting in the future?
Excels current role
Excel still dominates in finance teams for several reasons, it is a familiar environment, it allows analysts to edit data, create models and reports. In most cases, Excel has been part of the business for decades. With many organisations heavily invested in Excel and with the majority of FP&A professional’s being proficient in the tool, many people ask – Why change?
As a business matures, and begins gathering more data than ever before, Excel’s capacity and scalability limitations become more apparent. This is particularly true at an Enterprise and strategic level. Excel spreadsheets impede collaboration, resulting in data and planning siloes. The issue is further compounded by version control and no audit trail.
Requirements for the future of finance
The finance team of the future need to minimise risk, and the potential for human error. Plus, the last 12 months have taught us that budgets, plans, and forecasts require greater agility and flexibility.
If you are thinking about the role Excel will play in the future of your team, ask yourself these questions:
- How much time do you spend on collecting and inputting data into Excel for month end?
- How much time do you spend each month on validating that information?
If you answered any more than two-days you need to start considering the opportunity-loss your company is experiencing. You need to assess loss on a compounding monthly and yearly basis. Time is your most valuable asset, particularly when it comes to innovation.
So, what does the finance team of the future really need? If we could sum it up in one line:
A FP&A solution that delivers a high level of accuracy in planning and reporting, with speed and flexibility, along with the ability to scale.
A balancing act
At Minerva, we believe that in the mid-to-long term Excel will continue to provide a critical function to businesses. We work with some advanced finance teams, those performing best, have struck a balance between Excel and advanced web applications. This allows you to realise all the benefits of Excel, whilst overcoming its limitations. This “nirvana” exists where Excel and an advanced Enterprise Performance Management (EPM) tool work seamlessly together.
A leading-edge EPM, such as Jedox, allows FP&A teams to utilise familiar interfaces and leverage existing knowledge and skillset through its powerful native Excel integration tool. This gives the user the ability to transform limited, manual Excel spreadsheets into robust, flexible, and secure reports. Finance teams love the solution because they get the advantages of Excel while mitigating the risk and limitation of data management, secure user access and collaboration. At an enterprise-level, executives benefit from gaining access to historical comparisons, and variance analysis, all the while examining and testing these large queries in a fast and stable environment.
As mentioned above, an important piece of the puzzle is finding a solution that can scale with your team as they develop and mature. Jedox is a future-proofed solution as it also offers AI-augmented insight and foresight. Your may not be ready for AI yet, however, it is already being used by next generation finance teams. They are using AI to predict business outcomes, optimise for best business results as well as assist with agility in fast-changing markets.
If you are concerned about Excel future in your business, why not contact us at Minerva Partners?
We are a Management Consultancy that is laser focussed on business transformation. We assist CFOs and business transformation specialists every day to improve their data management, budgeting, forecasting, and planning. Our goal is to give you more time to focus on business growth and strategy.