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
The Importance of Forecasting Accuracy – Part 1
July 4, 2024

By Robert Jaeger, Integrated Management Systems Team Lead at Continental

FP&A Tags
Modelling and Forecasting
Forecasting Quality

Forecasting accuracy is one of the topics that is regularly discussed when working in FP&A.

But what is forecasting accuracy?

Forecasting accuracy is the ability to give a reasonable outlook of the business financials relative to your expected sales volumes.

In this two-part article, I will show you how to improve forecasting accuracy using a manufacturing organisation as an example. I will also share a perspective outside of FP&A through the Quality Department techniques.

Forecasting consists of two equally important components: the Profit and Loss statement (P&L) and the Balance Sheet (BS). In the first part, we will focus on P&L and sales forecasting, while the second will cover the Balance Sheet.


Sales Forecasting

To get the best base for other components of your forecast, start with sales forecasting and get the rest from there. Unfortunately, we did not spend much time understanding our accuracy during my career. At the time of writing, I am working within Quality Management, being responsible for the Integrated Management Systems, and I see how important processes and continuous improvement of those systems are.
Within Quality, there is the Plan, Do, Check, Act (PDCA) cycle that exists and should also be applied within the forecasting cycle. It is important to get the sales forecast right, as it is a critical assumption for many of the forecast components.

Figure 1


Plan

The preparation you put into forecasting can be in the “plan” part of the forecasting activity. This may include meetings with the sales and marketing departments to gather the proper information.

You will need to do this with feedback from the sales department. As an FP&A leader, you must be involved in these discussions and serve as a “check and balance.”

Most salespeople are optimists. Obviously, they should be. Nobody wants people who don’t think they can increase sales. However, as an FP&A professional, you should challenge the sales department with questions such as:

  • “What is causing this sales increase?”
  • “Where is the historical data to support the trends moving forward?”
  • “What is your strategy to increase sales, and what proof do you have to move forward?”

The level of detail behind this depends on how far you look within the sales forecast. There are long-term, mid-term and short-term forecasts.

If we look at the planning time frame, your accuracy will depend on the amount of detailed information behind the forecast. In long-term planning, it is crucial to understand marketing trends. Many things like COVID and political conflicts cannot be planned beforehand. In general, FP&A will need to work with your marketing department to understand the trends for your specific market over the long term. The longer you try to plan, the more difficult it may become based on the market you are forecasting. You should consider this when looking at the time you devote to your sales forecasting.

If we look at a shorter time frame, such as a year or less, there should be more concrete plans in place to understand how your business will be able to obtain their goals. You should question and push for supporting data if there is no evidence to support an increase or decrease.


Do

The “Do” stage is the actual process of forecasting itself.

Many CRM and sales forecasting tools are available, and FP&A professionals should leverage them.

You can try different things and choose the most suitable option for your company. The quality of data input is paramount for the abovementioned kinds of software. If you want an accurate output, you will need to ensure an accurate input.

Another important consideration for ensuring forecasting accuracy is to examine your company’s infrastructure capability and determine whether it may support the forecasted sales.

I have worked in manufacturing for 13 years and have much experience in this field. An example I have seen and pushed back against was a sales increase expected to be supported by one of the plants. One part of the issue was the plant capacity, which could not support the increase because of a lack of labour. While the plant might provide the capacity to add shifts and the machine capability existed, they were unable to hire enough people to staff these shifts. They had spent over a year and could not increase the headcount. However, it wasn’t caused by a lack of effort, as the unemployment rate in the area was less than 4%. Understanding your infrastructure’s capacity to support a sales number is crucial. That is why you should always test whether the numbers brought to you by others are real.

As a financial professional, you should not allow politics to interfere with forecasting accuracy. The desire to hit numbers may influence the forecast and not necessarily be related to reality.


Check

After working in Quality for a year, I have seen different methods to help improve accuracy.

I have worked for three organisations: two very large and one a smaller manufacturer. I see that if the finance department does not generate money for the company, it usually becomes stretched thin. Once one cycle is over, it can move to a budget, do a working capital analysis for new machinery, or even do an analysis for Mergers and Acquisitions (M&A) to help expand the business. That is why it is imperative to take the time to reflect on the accuracy of the results and then see if we were right or wrong.

One of the tools our Quality team uses to help diagnose an issue with a product is a fishbone diagram.

Figure 2: A Fishbone Diagram

The above diagram shows how we can gather information. While the example comes from manufacturing, it can be utilised as your check to determine the causes of forecasting inaccuracies.

Most fishbone diagrams will use the following categories:

  • Methods
  • Machines (in the case of finance, it could be software)
  • People
  • Materials (once again, it could be replaced by a more relevant category)
  • Measurement (time periods, annuals versus monthly)
  • Environment (working remotely versus on-site)


Act

The final step within the PDCA cycle is the “Act”. Act is about continuous improvement. Continuous improvement can help you determine the causes of your inaccuracy and then take action to improve the accuracy. As forecasting always happens in cycles, it is easy to employ this method since the finance function is one of those departments already used to work within a set timeframe.

This method can be easily added to your department, and you will see a marked improvement in your forecasting accuracy. Then, you will begin the cycle again. It will continue in your next planning period. Improving your sales forecasting may subsequently improve your overall forecasting accuracy since so much of your forecast depends on this first step.

In the next part of this series, I will discuss the Balance Sheet and Working Capital and introduce more quality techniques that you can apply to improve your forecasting accuracy.

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

Related articles

Activity Forecasting: Key Challenges by Nick Arzenton
Activity Forecasting: Key Challenges
November 9, 2023

Nick Arzenton, Head of Finance GDO-IBO at Orange Business, shares how one of Orange Business's branches...

Read more
Nick-Arzenton-Forecasting-Consistency-Main
Achieving Forecasting Consistency within an Organisation
August 1, 2023

How can we ensure forecasts produced by different business units are combined into one single consistent...

Read more
Microsoft Central Forecast Case Study
Microsoft Central Forecast Case Study
May 18, 2023

In this video, Charles Peter, Finance Director Global sales, marketing and operations at Microsoft, shares his experience...

Read more
Christine-Fromont-Predictive-Planning-Main
The Future of Business Finance with Predictive Planning and Forecasting
May 16, 2023

In this article, the author explores the benefits of Predictive Planning and Forecasting and outlines how...

Read more
Machine Learning Revenue Forecasting - Microsoft Case Study
Machine Learning Revenue Forecasting - Microsoft Case Study
August 3, 2022

In this uncertain environment, FP&A professionals need to reconsider their approaches to forecasting and revenue management...

Read more
forecast
Caution: Forecast Accuracy is Seasonal Too!
December 13, 2021

The benefits of measuring seasonality of accuracy are that users can plan high/low scenarios for each...

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

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