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: 

  1. How much time do you spend on collecting and inputting data into Excel for month end?  
  2. 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. 

Summary

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.

Recent Posts

7 Significant Benefits of Using AI To Support Your FP&A Team 

In today’s fast-paced world, your ability to forecast both short and long-term...
Read More
Power BI

Can Power BI be used for planning?

We often hear from organisations that have hit a ‘data wall’ when...
Read More
AASB

How to turn AASB 16 Reporting from a burden into a beneficial business process

The introduction of the AASB 16 Leases Accounting Standard in FY2020 has...
Read More
Budget blog

It’s Budget Time: Is Excel Holding You Back?

Let’s set the scene. It’s the start of another budget season. As...
Read More
enterprise performance management system

What do you require from an enterprise performance management system?

So, your organisation has finally decided to invest in an enterprise performance...
Read More
Framework for digital transformation

A Framework for Digital Transformation

If you want to increase the pace of innovation and drive business...
Read More
Why digital transformation is important

Why digital transformation is important for business

By now you would have heard a lot about digital transformation and...
Read More
digital transformation team

Digital transformation team – who to involve?

If you are considering a digital transformation, one of the first questions...
Read More
data migration

Managing a data warehouse migration

Managing a data warehouse migration can seem like a daunting and overwhelming...
Read More
Cloud costs

Optimising cloud costs – alternate payment models in the SaaS industry

Optimising cloud costs and alternate payment models are top of mind for...
Read More
data cubes

Most data warehouse projects fail – avoid these mistakes

Data warehouse projects can accelerate revenue, reduce cost, increase operational efficiency, improve customer experience - plus more. However, improved efficiency is not a guarantee.
Read More
FP&A Model

How to develop FP&A models that adapt to your business

FP&A models need to adapt and change as your business grows. In...
Read More
Predictions for FP&A

5 Predictions for the FP&A Professional in 2022

For many, the first quarter of 2022 has not been the energised...
Read More
acceleration of digitisation

What the acceleration of digitisation means for FP&A professionals

The acceleration of digitisation is here and the office of finance can...
Read More
digital ecosystem

Reassess your digital ecosystem and drive business performance

Now is a critical time for finance professionals to reassess their digital...
Read More
Cloud data warehouse project - part 1

A successful cloud data warehouse project – part 1

If you want to implement a cloud data warehouse or have made...
Read More
Cloud Data warehouse - part 2

A Successful Cloud Data Warehouse Project – Part 2

A Successful Cloud Data Warehouse Project - Part 2 In part 1...
Read More
Finance of the future

Finance of the future relies on digital transformation

If you have read the recent research on finance of the future,...
Read More
data strategy

5 Questions to complete your data strategy

Your data strategy and action plan are critical in helping you maximise...
Read More
Data silos

Are data silos compounding your data visibility challenges?

In the age of information and technology, data silos are stopping organisations...
Read More
future of excel

Will Excel still be used by the FP&A team of the future?

FP&A teams strongly rely on Excel and are comfortable operating in this...
Read More
elevate the value of finance

How to ditch manual tasks and elevate the value of finance

Unfortunately, low-value, manual tasks dominate the day-to-day lives of many FP&A professionals....
Read More
budgeting cycle

4 Tips to improve your Annual Budgeting Cycle

It is June and you are probably in the throes of the...
Read More
improve forecasts

3 changes to help you improve forecasts and drive profitability

The last few years in business have changed much of the way...
Read More
strategic alignment

How CFOs can provide greater strategic alignment

The role of the CFO has changed and there is a greater...
Read More

Leave a Reply

Search here...

Leaders in Management Consultancy. Minerva Partners makes digital transformation simple, more effective, less time consuming and seamlessly integrated.

Contact Us