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
Finding the A in FP&A from Robotic Process Automation
August 10, 2023

By Simone da Silva Collins, Senior Financial Controller at Sony

FP&A Tags
FP&A RPA
Digital FP&A

Simone-da-Silva-Collins-RPA-Main

The disruption brought on by the COVID pandemic in 2020 highlighted two key financial weaknesses in some organisations:

  • The gaps in their finance capabilities to support organisational agility, and
  • The underinvestment in finance digital transformation that created this gap

These two points usher the urgency to accelerate finance’s digital transformation. Finance teams behind in their digital transformation journey have found themselves on the back foot within uncertain environments when attempting to support the delivery of a company’s competitive advantage. This is because they lack the capability to provide insightful decision support analytics in an agile way.

 

The Need for Modern Robotic Process Automation

The use of Artificial Intelligence (AI), such as Robotic Process Automation (RPA), is one area that can help finance teams transform their analytical capacity and capability. Traditionally RPA was about weeding out manual processes and achieving cost savings through reducing headcount. It originated from the necessity of reaching the “low-hanging fruit” rather than any particular vision. In addition to cost savings, modern-day RPA also focuses on how automation can help generate greater insight and enable finance teams to carry out value-adding tasks.

Advantages of automating the budgeting, planning and forecasting (BPF) processes include time savings, cost efficiencies, increased visibility and, in some cases, improved planning accuracy. Despite these obvious advantages, FP&A and BPF do not always receive the same level of attention and focus when it comes to digital transformation. Customer-facing segments of finance tend to progress more quickly, e.g., purchase to pay (P2P) and order to cash (OTC). This is because finance teams fail to demonstrate to management the connection between process change and the advantages of automation and how process changes can impact profitability.

Automation is no longer the replacement of humans with robots or the digitisation of all documents. It is now streamlining processes that enable businesses to operate more efficiently through insightful analytics.

 

Four Ways in Which RPA Helps to Find the “A” in FP&A

  • Fact-finding

As with any business transformation project, the first step is to find out the current process. This allows us to examine each step of the process, any dependencies and interdependencies. With clear data and a process plan, efficiencies and redundancies can be identified. This may seem like a time-consuming exercise, but the value from this first step paves the way for successful finance automation:

  1. It generates a clear sense of direction for the project.
  2. It clears out the clutter and encourages process harmonisation.
  3. It allows stakeholders to voice “the good, the bad and the ugly” of the current processes to help identify where improvements are feasible and practical.

At this point, finance digital transformation should not be seen as an IT project but a finance project.

  • Harmonisation

One way RPA brings about efficiency is through process harmonisation. The finance team can take the lead and gather information to arrive at a consolidated view of the current planning process. Through fact-finding, the finance team can find out why there are differences in processes used by different business groups. The finance team can then work with the stakeholders to harmonise the process while delivering the required insights. Harmonisation encourages collaboration and best practices in BPF to be followed throughout the organisation.

  • Instant review

RPA removes the manual tasks involved in preparing and generating a base case plan, such as data collection, template distribution and pre-population of inputs. This means FP&A teams can focus on review and analysis. With increased visibility, standardisation and faster processing speed, the business receives an instant view of the financial impact of their potential change course. It, in turn, helps with Scenario Planning which is key to improving responses to crises.

  • Agile planning

During COVID, uncertainty has been one of the biggest challenges that FP&A has faced in forecasting. Time is of the essence. RPA harmonises processes and collects data in a standardised fashion, and FP&A teams have already worked with the business to identify drivers. These tools allow FP&A teams to be in a stronger position to advise the business of the potential financial impact of their strategy. They also allow FP&A teams to transform from reactive to proactive in search of opportunities.

 

There Are Several Benefits in RPA for FP&A

One of the most complained about areas in BPF is data collection and cleaning, as it is time-consuming. RPA takes care of this by automating data collection and standardising data formats. With RPA and specialised BPF tools, FP&A teams can move away from overreliance on spreadsheets.

Finance automation also changes the way finance analytics are conducted. FP&A teams are no longer tied to fixed reporting cycles and historical comparisons. BPF is now part of continuous improvement for the business rather than an arbitrary fixed horizon exercise. A Rolling Forecast becomes second nature in forecasting, and finance teams become more engaged in decision-making. These changes help to transform finance from the traditional bean counter, in the Dickensian days, to a modern-day influencer.

 

How RPA Can Help Your Business Evolve from FP&A to xP&A

AI and Machine Learning (ML) are yet to evolve to make autonomous decisions. AI and ML weigh out the risks and opportunities within the confines set by the organisation. Therefore, they can only deliver speed and efficiency benefits in the BPF processes. If FP&A teams rely solely on AI and ML to improve BPF, they risk turning BPF into a purely mathematical exercise. To enrich BPF processes and provide insightful decision support, FP&A teams need to engage non-financial stakeholders to help understand the data and its analysis. With this additional qualitative information, FP&A teams can work with the business to deliver an integrated BPF approach that covers all three key financial statements rather than simply focusing on the profit and loss.

As FP&A teams evolve towards Extended Planning and Analysis (xP&A), they may become more native, in other words, become part of the operational team. This may cause a more matrix-like FP&A organisation. The benefit of this is enhanced collaboration and enriched analytics.

 

In Summary

Finally, analysis is only as good as the data on which it was based. No amount of RPA can replace good-quality data. However, RPA can help improve the data quality and the speed at which it can be accessed. Therefore, it is up to FP&A teams to take the reins and deliver the best out of the digital transformation process for BPF.

Disclaimer: 

Any views or opinions expressed in this article are solely those of the author and do not necessarily represent those of any companies that the author has or is working for.

This article was first published on the SAP Blog.

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

Related articles

A Case from Sandoz: Analytical Transformation of FP&A using AI/ML and RPA
A Case from Sandoz: Analytical Transformation of FP&A using AI/ML and RPA
December 1, 2022

Watch this video to learn a Case Study from Sandoz about the Analytical Transformation of FP&A...

Read more
Avoid the Most Common Pitfalls of FP&A RPA Initiatives
October 30, 2019

Is your most fancied FP&A RPA initiative not delivering the anticipated benefits? You are not alone. So...

Read more
When to Apply RPA in Finance?
November 6, 2018

According to research conducted by the Hackett Group, the market for robotic process automation (RPA) is...

Read more
The Triple A of Art, Artificial Intelligence & Actuals vs Budget
February 26, 2018

Future coordination is a brainer - not a no-brainer. Combining the Now and the Future requires...

Read more
When to Apply RPA in Finance?
November 6, 2018

According to research conducted by the Hackett Group, the market for robotic process automation (RPA) is...

Read more
fp&a
What Is Holding You Back From Embracing Digital Transformation?
May 12, 2022

So why are we as finance professionals so slow to adopt digital transformation when there are...

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 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

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 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