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
Budget Tracking with Rolling Statistical Forecasts
April 30, 2018

By Hans Levenbach, PhD, CPDF author of Change & Chance Embraced

FP&A Tags
Planning and Budgeting
Forecasting Quality
Rolling Forecast

budgetingFor organizations with annual expense budgets, it is important to have procedures for monitoring expenditures and budget items throughout the year. It is particularly useful to have a procedure for estimating early in the year what the actual end-of-year expenditures are likely to be for various components of the budget. This allows for corrective action to be taken where necessary. It is also helpful if the estimation procedure is straightforward and systematic.

We can use simple predictive visualization techniques and exploratory data analytic methods to extrapolate expected expenditures as a function of spending year-to-date and historical spending patterns. This approach is based on the assumption that historical spending patterns remain relatively similar over time. We have observed this to be the case in different organizations in a corporation and medical departments in hospitals. Thus, future spending patterns may be predictable from past historical patterns.

Historical patterns of spending are determined by dividing the year-end expenditures into year-to-date expenditures for all months to derive cumulative proportions for year-end spending for all months in the year. The deviations from the cumulative monthly average of these cumulative proportions are then plotted to display the yearly spending patterns. See the real data examples below.

Real Data Examples. The data tables show the % of Total Budget (View) minus % of Year elapsed. Each month is taken as 1/12 of the annual Total. Upon further analysis and review, it might help to do better-weighted allocations.

With a predictive visualization of three months of actual outcomes displayed in the current year, you can see how the “pattern of drift” away and recovery has behaved for the previous three years. One way to summarize these is to say that W_Budget and C_Budget would come close to the View if they followed respective Budget T-3 patterns, but that I_Budget will have to do something quite new to get to the View.

We make the following judgments based on the first three months of the current year’s data. It appears that

  • W_Budget is headed for 90% - 95% of View
  • C_Budget is headed for 95% - 100% of View

BUT, It also appears that I_Budget is headed for perhaps 70% of View.

budgeting

Exploring Forward-Looking Budget Profiles

Once three or more years of monthly (or quarterly) budget patterns have been observed, you can begin to monitor current budgets with rolling forecast profiles using statistical forecasting models. Statistical forecasting models not only provide forward-looking budget patterns (forecast profiles) but can also establish uncertainty ranges on the projections. Using well-documented, valid and objective state space forecasting models, you can create credible “budget profiles” and ranges for tracking year-to-date budgets. The Budget View are the percentage difference between actual monthly expenditures. The Systematic View is the percentage differences between model projections and the actual monthly expenditures. The 12-month Views were created before the actual expenditures were booked. In this example, we might say that:

  • Budget view for February was overstated by at least five percentage points at the time of creation, based on the likely budget pattern
  • Systematic View appears to be about twice as precise (accurate) as the Budget View
  • Both Views were over-forecasts of the actual expenditures
  • For an unbiased View, the Budget patterns should vary around the zero line

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

Related articles

How Much Managerial Courage Resides in Forecasting?
April 23, 2018

Considering forecasting as an exercise to assess future financial performance as accurately as possible through a...

Read more
Best Practices in Rolling Forecasts
April 18, 2018

Many businesses have yet to discover the full benefits of evolving their planning process to include...

Read more
How to Manage Forecasting Risk?
March 4, 2018

In an uncertain and fast-changing world, line managers need to be made aware of the uncertainties...

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