6 Challenges CFOs solve with RPA

6 Challenges CFOs Could Solve with Robotic Process Automation (RPA)

Introduction

CFOs and finance executives are always looking to accelerate and increase efficiencies across finance and accounting functions so accountants can focus more on the risks and opportunities for the company.  Streamlining operations equates to greater business agility to immediately identify when market turbulences occur then effectively respond and navigate to meet customer and shareholder demands.

With systems not evolving fast enough to meet the business needs, finance and accounting functions are required to accommodate these needs with manual work-arounds or by employing more resources.  These events have opened the doors for new technology solutions to more rapidly adapt to business needs to accommodate changes without having to employ armies of staff on or off-shore.

In this article, we will explore Robotic Process Automation (RPA) and the benefits and opportunities CFOs must consider for transforming Finance and Accounting functions.

What is RPA?

In simple terms, Robotic Process Automation (RPA) is a computer software (aka “robot” or “Digital Worker”) that emulates the actions of a human interacting with a computer.  RPA is best used to perform any manual task that is repetitive, easily defined, and high volume.

With RPA, digital workers replicate the mouse and keyboard functions of an employee but can go beyond the human interaction aspect and leverage more technological solutions, like running queries, calling APIs and Web Services, and conducting advanced analytics within the robot.  Additional benefits of employing digital workers are the 24/7 work, ability to rapidly scale to meet demand, and flattening the peak demand from your financial close.

1. Streamlining business processes

According to a report published by the McKinsey Global Institute, 42% of finance activities can be fully automated and an additional 19% can be mostly automated. RPA is good for simple tasks, like checking for FX rate changes, to complex processes, like reading bank statements for bank reconciliations.  Other examples where RPA is often used are: Entry of sales orders, cash application, account reconciliations, vendor registration, purchase order creation, invoice registration, journal entry uploads, report retrieval, assembly, and preparation.

Imagine what you can do with over 50% of your finance and accounting processes automated effectively, efficiently, standardized, and with quality.

Related readings: Transforming the Finance Function with Automation 

Finance Function | Process Automation

2. Improving productivity and reducing operational costs

The intent of RPA is to automate repetitive, standard, and manual low-value work.  Employing robots streamlines business operations and returns hours to the business and enables employees to focus on higher-value tasks.  Freeing up resources also enables employees to work on high priority projects that are often tabled because resources are only able to keep up with the volume of manual work.

Poor data quality costs businesses millions of dollars each year because employees will accommodate bad data and integrate work-arounds as part of their day-to-day work.  Poor data quality will trickle through an organization, causing dependent processes to also accommodate the data issues.  For example, unstructured vendor entry can cause additional lookups in procurement, invoice registration, cash application, and vendor reporting.   RPA can be used to standardize data entry and validate data to ensure data quality at the acquisition point of the data.

Accurate and standardized data means faster processing which translates to faster report generation, which accelerates Close, Financial Analysis, Analytics, and more.

Processes automated with RPA can also be repurposed to support time-consuming system upgrade projects that tie up your most knowledgeable resources with user acceptance testing.

Related readings: RPA can fix your data quality issues

3. Reducing operational risk (aka Enable your team to excel, not Excel)

Does your organization have to certify an Excel workbook, as a system of record?  Does your F&A team specialize in complicated macros and formulas?  Are you at risk of a key-man dependency because someone on the team built a complex macro-laden, formula powered, cross-referencing data behemoth of an Excel workbook?

RPA is a great way to eliminate End User Tools (EUT/EUC) and the risk of corrupted Excel files.  RPA also ensures that the same steps are always completed the same way, which eliminates the risk of an accountant not refreshing a lookup table or retrieving the most up-to-date results.  RPA processed data will be standard, consistent, documented, and auditable.

4. Scale operations to meet growing demands

Processes automated with RPA can return a significant number of hours back to your business, which enables team members to refocus on what is important, such as identification of risks, errors, and opportunities.  Standardizing processes also enable the automated process to scale in the event of higher transaction volumes or seasonality, which reduces costs associated with hiring (FTE or temp workers).

Be aware that most RPA practitioners want to automate accounting tasks based on an individual’s user requirements, which is not scalable and cannot also automate comparable functions across Finance and Accounting teams.  Our extensive experience supporting finance and accounting functions helps us to identify automation components that can be repurposed across a multitude of processes, which not only helps to speed up automation deployment, but also establishes standards and consistency in processing.

5. Optimizing key performance indicators (KPIs)

A big challenge we often see when automating finance and accounting departments is that most companies do not have any metrics to support where employees spend their time, processing times, or volumes.  The implementation of RPA enables organizations to drill into the details on how teams are utilizing their time.  We often see a lot of inefficiencies in manual business processes, so we use the captured information to reengineer the process for automation to ensure that the processes run more efficient and effectively.

RPA also enables the tracking of processes for volume counts, average processing times, processing costs, and exceptions.  Isolating and analyzing exceptions can further improve process efficiencies, but it requires operational metrics to understand how well the processes are being executed.

Related readings: Understanding benefits realization with RPA

6. Ensuring compliance requirements are being met

RPA is effective for supporting and ensuring compliance across your organization. RPA ensures greater compliance since the defined actions within an automated process are always executed in a consistent manner with more accuracy and higher quality.  This ensures greater compliance across all business processes.

RPA also improves oversight and auditability, because a Digital Worker’s defined actions are captured during execution into an audit log for monitoring and auditing, which simplifies operations and enables compliance concerns to be addressed more quickly.  The log is also helpful in troubleshooting processing issues.

Conclusion

With the job requirements of CFOs to be more focused on the company’s viability, long-term growth strategies, short-term crisis navigation, and managerial decision-making, there is less time for focusing on the day-to-day functions.  Leveraging RPA will help free your staff from the low-value tasks and functions to create business agility by transforming and reshaping the finance function from number crunchers into data-driven, strategic partners your business needs.

Author:

Joshua Gotlieb

Intelligent Automation Practice Director, Vigilant Technologies

Finance Transformation with Automation

Transforming the Finance Function with Automation

With rapid market shifts forcing the need for business agility, CFOs are being pressured to reinvent their finance and accounting teams from number crunchers into THE competitive advantage for their company.  Before the digital revolution, finance leaders could only throw more bodies at the problem areas, but now businesses can employ armies of digital workers to execute business tasks and processes with speed, efficiency, consistency, and quality.

Digital Workers are the “Robots” in Robotic Process Automation (RPA).  With RPA, digital workers replicate the mouse and keyboard functions of an employee but can go beyond the human interaction aspect and leverage more technological solutions, like running queries, calling APIs and Web Services, and conducting advanced analytics within the robot.  Additional benefits of employing digital workers are the 24/7 work, their ability to rapidly scale to meet demand and flattening the peak demand from your financial close.

What processes and tasks can I automate?

According to a report published by the McKinsey Global Institute, 42% of finance activities can be fully automated and an additional 19% can be mostly automated. RPA is good for simple tasks, like checking for FX rate changes, to complex processes, like reading bank statements for bank reconciliations.  Other examples where RPA is often used can be: Entry of sales orders, cash application, account reconciliations, vendor registration, Purchase Order creation, invoice registration, journal entry uploads, report retrieval, assembly, and preparation.

It is also important to understand that RPA is effectively the entry point for Artificial Intelligent (AI) technologies, so RPA can engage more advanced technologies like OCR and Machine Learning for the reading of invoice documents of a supplier, extracting the information, and registering the invoice into your AP system.  RPA can also be for engaging AI to support analytic models in forecasting process.

The following is a simple way to think about where to employ RPA:

  • Rule-based
  • Easily described
  • High transaction volumes
  • Low exceptions
  • Stable and well-defined processes
  • Low system change
  • Structured data and readable electronic inputs
  • Are people passionate about the process?

Examples where we have used automation in Finance and Accounting:

Financial Control & Reporting
Credit-to-Cash (AR)
Procure-to-Pay (AP)
Financial Planning and Analysis (FP&A)
Cash & Treasury Management
Payroll
Financial Control & Reporting

  • Journal Entry Creation and Upload/Entry
  • Account Reconciliation
  • Report Assembly and Preparation

Credit-to-Cash (AR)

  • Enter Sales Orders
  • Credit Checks
  • Customer Follow-ups
  • Retrieve Cash from Bank
  • Cash Application / Allocation

Procure-to-Pay (AP)

  • Vendor Registration
  • Create Purchase Order
  • Invoice Registration
  • 2/3 way matching
  • Payment (Batch) Creation
  • Payment Issuance

Financial Planning and Analysis (FP&A)

  • Retrieving reports from internal/external sources
  • Standardizing and cleansing data
  • Consolidating datasets
  • Building standard report outputs and populating PowerPoints

Cash & Treasury Management

  • Generate Daily Cash Positions
  • Cash Forecasting
  • Bank Account Analysis

Payroll

  • Time-sheet coding validation
  • Run payroll
  • Calculating deductions
  • Auditing reported hours against schedule

When over 50% of your finance and accounting processes are automated, finance functions can focus on the risk identification, business analysis, forecasting, and analytics to accelerate data-driven decision making. With efficient process automation you can transform your finance function.

Related readings:

Author:

Joshua Gotlieb

Intelligent Automation Practice Director, Vigilant Technologies

RPA Can Fix Your Data Quality Issues

Robotic Process Automation (RPA)
can fix your data quality issues

According to Gartner, “the average financial impact of poor data quality on organizations is $9.7 million per year.”  In 2016, IBM estimated  the yearly cost of poor data quality in the US alone, to be $3.1 trillion.  Anyone that works with data that has completed its processing journey understands the impacts, but why are we not talking more about the issue with data quality?

While there are many possible explanations for organizations not addressing data quality, there is no identifiable relationship between data quality and business results (i.e. it cannot be quantified) and most business functions do not have awareness of the impacts that poor data has on downstream processes.

The reality is that executives, managers, employees, accountants, et al, just accommodate the bad data and integrate work-arounds as part of their day-to-day work.  Employees accept bad data since there is little/no incentive and it is easier to accept than trying to figure out where bad data originates then work with the upstream teams to correct the behaviors/actions resulting in the bad data.

These bad data accommodations cost organizations in both employee’s time and their expense since a large portion of their time is focused on the low-value tasks associated with data correction and standardization, rather than the higher value tasks of analysis for insights, risks, and opportunities.  Even non-reporting tasks cost business processes efficiency, since simple tasks like selecting a vendor or supplier could result in a series of try/fails until the right entry is found, because of undisciplined data creation practices.

We use RPA to standardize data entry and validate data to ensure data quality.  We look for the root cause of the data issues to correct bad data practices before we apply RPA to business processes to ensure we do not harden accommodations for bad data, since fixing at the root ensures we do not have to automate bad data accommodations at every related downstream process that utilizes the data.  Also, accurate and standardized data means faster processing which translates to faster report generation, which accelerates Close, Financial Analysis, Analytics, and more.

For more information about how hardening bad data practices adds data debt to your organization, read our Process Automation Approach blog

Author:

Joshua Gotlieb

Intelligent Automation Practice Director, Vigilant Technologies