Skip to main content
Home
The Online Resource for Modern FP&A Professionals
Please register to receive the latest FP&A news, updates and tips Login

Main menu

  • Home
  • FP&A Insights
    • FP&A Trends Digest
    • FP&A Trends Research
    • FP&A Trends Insight Paper
    • FP&A Trends Survey
    • Short Videos
    • Our Contributors
  • FP&A Events
    • International FP&A Board
    • FP&A Trends Webinars
    • Digital FP&A Circles
  • AI/ML Committee
    • Introduction
    • Members
    • Resources
    • Meetings
  • FP&A Tools
    • FP&A Trends Maturity Model
  • About Us
    • Company Policy
    • Privacy Policy
    • Editorial Guidelines
    • Our Ambassadors
    • Our Sponsors & Partners
    • Contact Us
image
How Companies May Use Systems to Improve FP&A Processes
April 22, 2021

By Douglas Yeung, Senior Finance Director at Genesys

FP&A Tags
FP&A Technology
Financial Planning and Analysis
FP&A Transformation
Modelling and Forecasting
Forecasting Quality

FP&A solutionsCompanies nowadays are looking at using specialised FP&A solutions to help improve the accuracy and efficiency of the forecasting process.  

Depending on the maturity of the FP&A function, we can roughly divide companies into the following three levels of maturity in terms of their use of specialised FP&A solutions.

1. Early stage

These companies are probably in their infancy when it comes to FP&A. They may have basic accounting functions but just started trying to do more analysis and to improve performance by implementing a forecasting and budgeting process. Most of the time, these companies are using spreadsheets to collect and collate information, as they probably neither have the scale nor see the value of investing in a system solution for FP&A.  

However, with some good planning and expertise in spreadsheets, this approach may make sense as organisations are still changing and discovering what works best for them. Also, spreadsheets do not require specialised software knowledge and can engage young teams in early-stage companies in the budgeting and forecasting exercise.  

In order to succeed in this environment, the organisation will need outside help with designing the spreadsheet and defining the requirement. This will provide invaluable insights that the organisation can refer back to in the future when the time comes for a more structured approach.

2. Mid-stage

At this stage, a lot of companies use a combination of a spreadsheet and a system for their forecasting and budgeting processes. Most companies will fall under this category. Do not be surprised if you find really established and mature companies still going through their forecasting or budgeting exercise with this approach.  

For companies in this category, it is typical to use spreadsheets to perform a lot of the analysis and then use a system to help consolidate information and organise the data for different kinds of reports and further analysis. 

The benefit of this approach is an opportunity to use spreadsheets to provide a lot of analysis, especially around the business drivers, so assumptions and backup information are kept. The system is then used mainly to consolidate data and provide different report levels.  

This approach is also easier to manage, as reports and analysis are typically more finance-based, e.g. divisional or regional P&Ls or cash flow analysis. The obvious downside is that the data used to come up with the financials are kept in separate and often non-standard spreadsheets, so it will be more difficult to refine the analysis or drill down on more details.

3. Advanced stage

At this stage, specialised FP&A solutions can automate and improve efficiencies of the forecasting and budgeting process. Data are automatically retrieved from various data sources and consolidated into appropriate levels of details in order for different finance teams to dig into the areas they are responsible for very quickly. 

There is also the benefit of getting accurate data into the model and avoiding errors that may be present in spreadsheet models. This type of FP&A solution is especially useful today when businesses are collecting more and more information about their business drivers, not only financial data.  

FP&A teams can also engage in better discussion with their business partners to understand how to adjust the forecast instead of disengaging the business because the forecast is too “financially drive” and lack business relevance. Joint ownership by both finance and the business can improve forecast accuracy and accountability to the budget.

By deploying specialised FP&A software for forecasting and budgeting, businesses can 

  1. take advantage of the flexibility offered by this software, 
  2. improve data accuracy by directly integrating data source to the analysis,
  3. provide better analytics and reporting capability by using tools like scenario analysis, data visualisation and easy access to all stakeholders. 

In the end, more engagement and ownership by all parties involved will be achieved. It will improve the overall quality of the process.

 

The article was first published in Unit4 Prevero Blog.

The full text is available for registered users. Please register to view the rest of the article.
  • Log In
  • or
  • Register

Related articles

fp&a department
Six Conditions for Building a Successful FP&A Department
February 23, 2021

In this article, I will share several challenges and dilemmas in building a strong FP&A department...

Read more
forecast
Five Methods for Unbiased Finance Forecasting
October 7, 2020

As long as there are humans involved in making a forecast, the forecast will be biased...

Read more
ABC for FP&A team
Three Foundations of a Good FP&A Team – The ABC of FP&A
September 15, 2020

Building a good FP&A team is essential to the success of the finance function and even...

Read more
fp&a
3 Things to Look for when Evaluating Software for FP&A
February 17, 2021

When an organisation decides to invest in an FP&A software, there are three things to look...

Read more
software
FP&A Software: If You Build it, Will They Come?
August 12, 2020

As a finance professional implementing an FP&A / CPM / EPM platform, you might face several...

Read more
+

Subscribe to
FP&A Trends Digest

We will regularly update you on the latest trends and developments in FP&A. Take the opportunity to have articles written by finance thought leaders delivered directly to your inbox; watch compelling webinars; connect with like-minded professionals; and become a part of our global community.

Create new account

image

Event Calendar

Pagination

  • Previous
  • May 2025
  • Next
Su Mo Tu We Th Fr Sa
27
28
29
30
1
2
3
 
 
 
 
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Transforming FP&A Together: Human & AI Synergy
 
18
19
20
21
22
23
24
Moving from FP&A to Extended Planning and Analysis (xP&A)
 
Five Critical Roles for Building a World-Class FP&A Team
 
25
26
27
28
29
30
31
FP&A Business Partnering and AI: A New Era
 
All events for the year

Future Meetings

BPAI
The FP&A Trends Webinar FP&A Business Partnering and AI: A New Era

May 28, 2025

The Face-to-Face London FP&A Board: Data Management & Analytics: Unlocking FP&A Value
The Face-to-Face London FP&A Board Mastering Data in FP&A: Smarter Analytics, Better Decisions

June 5, 2025

FP&A Trends Webinar The Evolving Role of FP&A: From Number Cruncher to Strategic Advisor
The FP&A Trends Webinar Making FP&A Teams Fit for the Future

June 11, 2025

The Face-to-Face New York FP&A Board
The Face-to-Face New York FP&A Board From Insight to Impact: FP&A Business Partnering in Action

June 17, 2025

FP&A Trends Webinar Practical Steps for FP&A Analytical Transformation.
The FP&A Trends Webinar Unlocking FP&A Analytical Transformation

June 18, 2025

The FP&A Trends Webinar How AI is shaping the future of Financial Planning & Analysis (FP&A)
The FP&A Trends Webinar Transforming FP&A with AI: Maturity, Impact, and Future Roles

June 25, 2025

The Face-to-Face Sydney FP&A Board
The Face-to-Face Sydney FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

June 26, 2025

The Face-to-Face Singapore FP&A Board: Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
The Face-to-Face Singapore FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

July 8, 2025

AI/ML FP&A
AI/ML FP&A
Data and Analytics
Data & Analytics
FP&A Case Studies
FP&A Case Studies
FP&A Research
FP&A Research
General
General
Integrated FP&A
Integrated FP&A
People and Culture
People and Culture
Process
Process
Technology
Technology

Please register to receive the latest FP&A news, updates and tips.

info@fpa-trends.com​

              

Foot menu

  • FP&A Insights
  • FP&A Board
  • FP&A Videos

Footer countries

  • Amsterdam
  • Austin
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Helsinki
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London (Circle)
  • Melbourne
  • Miami
  • Milan
  • Munich
  • New York
  • Paris
  • Perth
  • Riyadh
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

Copyright © 2025 fpa-trends.com. All rights reserved.

0