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
    • Contributors
    • FP&A Trends Digest
    • FP&A Trends Research
  • FP&A Board
    • Amsterdam
    • Austin
    • Boston
    • Brisbane
    • Brussels
    • Chicago
    • Copenhagen
    • Dubai
    • Frankfurt
    • Geneva
    • Hong Kong
    • Houston
    • Kuala Lumpur
    • London Board
    • London Circle
    • Melbourne
    • Miami
    • New York
    • Paris
    • Perth
    • San Francisco
    • Seattle
    • Shanghai
    • Singapore
    • Stockholm
    • Sydney
    • Tokyo
    • Toronto
    • Washington D.C.
    • Zurich
  • AI/ML Committee
    • Introduction
    • Meetings
    • Members
    • Resources
  • Video Content
    • Digital FP&A Boards
    • FP&A Webinars
    • Short Videos
  • Contact Us
  • About Us
    • Ambassadors
    • Privacy Policy
    • Company Policy
    • Editorial Guidelines
    • Our Sponsors & Partners
image

FP&A Trends Survey 2023: Define the future of FP&A 

Click here to view details

 

Why Driver-Based Planning and Dedicated Planning Systems Matter for FP&A
New
August 8, 2019

By Elena Kiristova, CFO Russia and CIS at Groupon

FP&A Tags
Financial Planning and Analysis
Driver Based Planning
FP&A Technology
Corporate Performance Management (CPM)

Normally, integrating actuals into the planning cycle is not an easy task. Often financial and operating results are spread across multiple databases and actual results and plan detail are at different levels. All of this makes meaningful Performance Evaluation difficult.

If you do not have a dynamic driver-based model that is implemented through a good quality FP&A system, the following tasks will consume a lot of resources:

  • reporting on actuals and plan line items below natural class accounts;
  • getting a handle on activity driver relationships with units, rates and amounts;
  • capturing volume and rate impacts underlying plan variances;
  • calculating actual/plan operational metrics for conversion rates.

The excel-based planning process will not deliver consistency to the performance management process. In contrast, the dedicated planning solutions will let you build and maintain a solid infrastructure for fully integrating actuals and plan data through a driver-based planning model. They will also help you to overcome the following FP&A problems:

1.    Financial and operating results are spread across multiple databases. 

Excel is typically the focal point for integration and reporting. Nonetheless, managing imports to Excel and normalising data structures consume major FP&A and IT resources and can even increase the risk of producing incorrect data.

2.    Actual and plan detail are at different levels. 

Actuals financial data is readily available from the GL at the natural class account level; lower level actual detail is typically a one-off research project. By contrast, budgets and rolling forecasts are usually developed with line items below the natural class account level, e.g., Travel Asia Customers, Travel Conference, etc.

3.    Lack of underlying activity drivers. 

It‘s not just about the dollars. Meaningful planning and analysis require digging into the underlying drivers and rates that cause dollars to be spent. For example, call centre headcount and salaries are substantially driven by call levels. Too often the driver data for either or both actual and plan are not available or too difficult to pull together from disparate databases.

4.    Actual and plan structures get out of sync. 

New products, cost centres and, accounts are frequently added to the chart of accounts. Rolling Forecasts result in new line items being added to the planning application. Maintaining actual and planned structures to keep data in sync is the job that everyone hates and a resource sinkhole. It’s also the root of most data integrity issues—bad maintenance means bad numbers and incompatible comparisons.

5.    Actual and plan line items below natural class accounts. 

How people think is how people should be able to plan. Invariably, that means planning structures need to include the capability for any user to add line items below natural class accounts. Letting managers plan below the account level encourages more detailed and relevant data, more meaningful and logical thinking, and capture of information that would otherwise be lost in non-linked spreadsheets or scratch notes.

The same mentality should carry over to reporting of actuals. For the most important items, for example, detail of product sales and headcount, actual reports should be set up to capture the relevant line item detail from the CRM, personnel or other databases.

For the financially sensitive items, the GL alone should not drive the level of detail for planning or be the only source for actual reporting.

Conclusion

Driver-Based Planning Processes implemented through dedicated FP&A systems will help to create a solid basis for better Corporate Performance Management and overcome the above problems.

A good quality Variance Analysis that is delivered through this holistic process will help to improve the organisational Corporate Performance Management process.

As a result, the following three fundamental performance management questions will be answered easily and quickly:

1)    What are the targets that are missed or achieved?

Do we need to change behaviours and refocus current resources?

2)    What are important assumptions underlying future plans being proved or disproved by current experience? For example, product mix, utilisation rates, efficiencies, etc.

3)    What problems do we have in our accounting and/or planning systems that are generating bad or false information?

For example, CRM sales statistics are not tied with the GL, expense budget errors and omissions, etc. 

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

Related articles

Exceptional EPM/CPM Systems are an Exception
February 8, 2018

I like to think of the various EPM/CPM methods as an analogy of musical instruments in...

Read more
Evaluating CPM/FP&A System: Nine Key Areas for Consideration
December 28, 2017

There are many software products that claim to support CPM, but often they only support some...

Read more
Beware of FP&A System Demonstrations
October 23, 2017

Too often software evaluations are restricted to features and functions. It’s like evaluating a car by...

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

The FP&A Trends Webinar: The Winning Formula for Integrated FP&A

Click here to view details and register

Pagination

  • ‹‹ Previous
  • January 2023
  • Next ››
Su Mo Tu We Th Fr Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Inside the Crystal Ball: Top 7 Trends Shaping FP&A in 2023 and Beyond
 
22
23
24
25
26
27
28
Five Critical Roles for Building a World-Class FP&A Team
 
29
30
31
1
2
3
4
 
 
 
 
All events for the year
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

Future Meetings

Geneva FP&A Board
The Face-to-Face Geneva FP&A Board Five Critical Roles for Building a World-Class FP&A Team
February 7, 2023
The FP&A Paris Board
The Face-to-Face Paris FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)
February 9, 2023
Zurich FP&A Board
The Face-to-Face Zurich FP&A Board Five Critical Roles for Building a World-Class FP&A Team
February 9, 2023
Moving from FP&A to Extended Planning and Analysis (xP&A)
The Face-to-Face Dubai FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)
February 15, 2023
FPA Integration
The FP&A Trends Webinar The Winning Formula for Integrated FP&A
February 22, 2023
Five Critical Roles for Building a World-Class FP&A Team
The Face-to-Face San Francisco FP&A Board Five Critical Roles for Building a World-Class FP&A Team
March 7, 2023
The Face-to-Face Houston FP&A Board
The Face-to-Face Houston FP&A Board Five Critical Roles for Building a World-Class FP&A Team
March 14, 2023
New York FP&A Board
The Face-to-Face New York FP&A Board Five Critical Roles for Building a World-Class FP&A Team
March 16, 2023

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
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London(Circle)
  • Melbourne
  • Miami
  • New-York
  • Paris
  • Perth
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

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

0