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 Essentials of FP&A Analytical Transformation
October 4, 2018

By Mitan Patel, Solutions Consultant at Chargebee

FP&A Tags
FP&A Board Meetings Insights

I had the pleasure of attending the 7th London FP&A circle. The Circle is the educational branch of the International FP&A Board which shares the latest professional trends and developments with the UK FP&A community. It is open to both senior and mid-level finance practitioners.

On the 4th October in Central London, a series of presentations showed me that, done properly, FP&A can become that analytical powerhouse advising the business. Here, setting up the FP&A function properly can allow the us to harness the historical data and the commercial expertise of our stakeholders to give the story behind the numbers, allow us to leverage the drivers behind the business and provide a basis for leaders to act with confidence.

Colm Quinn, who attended the Toronto FP&A board, gives an eminently well-summarised look at many of the topics which were also discussed in London, which you can read here.

Therefore, I wish to focus on the three guest presentations at the event. 

Delivering Real FP&A Transformation in uncertain times

Finance Director at Interserve Support Services, Sile Lillis, discussed the company’s challenges towards, and enablers of, FP&A transformation. She took us on the company’s journey and where they have seen the benefits of FP&A transformation despite a challenging backdrop.

Sile explained that, coupled with the broader internal challenges of a new senior management team and the need for transformation, the following were seen as barriers to an effective FP&A process:

  1. Systems: Basic tools coupled with;
  2. Process: leading to frustration and suboptimal;
  3. Behaviour: frustration within the business leading to an inconsistent process and frustration with the systems.

These are also areas of opportunity, and Sile outlined the steps of transforming her function.

Transformation

From this position, implicitly highlighting elements of Kotter’s 8 step change model, the company saw the introduction of more advanced budgeting tools and standardised processes that have laid the foundation for, amongst others:

  1. Strong business partnering;
  2. What if analysis; and
  3. Generating plans within weeks, not months.

The future

From here, the next stage to become a leading FP&A function for that company are:

  1. Real-time forecasts;
  2. Scenario Analysis;
  3. Long-Term Cash Flow planning, linked with Treasury

Sile emphasised the drivers of change with good communication, cheerleaders, getting a project sponsor, and being strict about scope creep. Sile was also clear that money, and training, are critical to ensuring that the transformation not only introduces positive change; but beds it in.

Seven analytical models that every FP&A department should have

The first question to consider is what are you trying to achieve? Is the objective clear from those who contribute to them and does it differentiate on those elements that are controllable? 

From there, Michael Coveney, analytics thought leader and author, outlined that businesses can control three things:

  1. Arrangement of business processes;
  2. Resources; and
  3. Work carried out in these processes.

Therefore, planning is about adjusting these processes in an uncertain world. There are 7 essential FP&A business models, that look at the key business questions.


The Operational Activity Model which looks at how efficient and effective the business processes are, setting out the relationship between resources, workload and outputs.

The Cash and Funding Model looks at forecasting cash requirements and determining funding costs.

The Detailed History Model looks at “what actually happened” with a focus on multi-dimensional analysis.

The Target Setting Model is a driver based model between goals, resources and outcomes. 

The Detailed Forecast Model is a bottom-up forecast that looks at forecast against targets/plan, showing what happens if the organisation continues as present without change.

The Strategy Improvement Model links objectives, themes and initiatives, which are linked to specific business processes.  Here you can consider the costs, workloads and outcomes of each initiative either in isolation or in combinations- in essence “what can we do differently and what would it cost?”

Lastly, the Scenario Model looks at options and their impact on corporate goals, which looks at “what if?” scenarios and allows comparison of different scenarios.

The Management Processes (Reporting/Forecasting/Planning) then sit alongside these models, where there is a dynamic workflow and there needs to be continuous planning as these impact on each other.

The 5 myths of FP&A Analytical Transformation

Richard Hanson, Head of FP&A at Endava with over 20 years of FP&A experience with the tech sector, laid out his opinion on the 5 myths of FP&A Analytical Transformation.

Firstly, Our roles will be replaced by robots is relevant to data and analysis, but communication, negotiating and influencing are key skills used in turning data into useful information. 

Secondly, The budget is dead is to ignore the importance of targets, which are critical to a business. It also neglects the role of the budget as a driver for thinking and strategy planning. However, that the budget is not dead is not to say that the traditional budgeting method isn’t on its way out, especially with forecasting as a distinct, separate process. 

Thirdly, Forecasting can tell you everything is predicated on the assumptions that lie behind. As the forecasting horizon draws further into the future, so does the level of uncertainty, which increasingly relies on assumptions and trends. Moreover, as forecasts are determined by humans, personal biases or agendas become incorporated, from the ‘hero’ to the ‘sandbagger’.

Fourthly, You can run a business from a single dashboard relies on the measures established as the best possible determents of performance; can complex, dynamic entities be measured with a few metrics? While a potential solution, balanced scorecards as finance originated reports, are often skewed in favour of financial measures. Therefore, an attempt needs to be made to get the balance right – the “Goldilocks” philosophy. 

Lastly, There is a single ‘right way’ of doing things ignores that there are any manner of ways to tackle a project or process. Six 4x2 lego pieces have almost one billion different combinations to combine them together; thinking this way, consider projects or processes as modules and blocks, and build it from there. Diverse teams drive innovation, and sometimes it’s better to start from scratch. 

And there you have it: three great presentations that focused on different areas of FP&A analytical transformation.

One last thing sparked my curiosity: that of how long does it take to produce a forecast? There was an interesting debate in the audience of how accurate a three day long international forecast could be. Technology and talent was behind this position, which appears to be the two elements on all leaders’ mind; Finance, FP&A or otherwise. 

Last Thoughts

At the 7th London FP&A circle, we had an operational framework by Michael; thoughts to consider from Richard; and a case study of implementing FP&A transformation from Sile. Within the space of an hour, three incredible speakers summarised strategic, tactical and operational aspects of approaching FP&A analytical transformation. 

FP&A has the potential to be the strategic advisory unit and the bedrock of business decisions, and I hope by reading this, you have an idea of what was discussed and a reason to attend our next FP&A meeting.

Our Sponsors

We are very grateful to our global sponsors and partners Unit4 Prevero and Michael Page for their great support.

Related articles

Unlocking the Value in FP&A Data Science & Analytics
August 31, 2018

This is the second part of a three-part series that focuses on the business value that...

Read more
FP&A Transformation: What to Consider
April 17, 2017

For quite some time CFOs and the finance community have been talking about transforming the finance...

Read more
Transforming FP&A in a Decentralized Environment
October 29, 2018

Recent trends in FP&A have been to focus on data analytics and driver-based planning to provide...

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

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 Amsterdam FP&A Board
The Face-to-Face Amsterdam FP&A Board Transforming FP&A Together: Human & AI Synergy

May 15, 2025

The Face-to-Face Milan FP&A Board
The Face-to-Face Milan FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)

May 20, 2025

The Face-to-Face Frankfurt FP&A Board
The Face-to-Face Frankfurt FP&A Board Five Critical Roles for Building a World-Class FP&A Team

May 22, 2025

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

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