Success Stories

Automating Accounting Tasks with RPA

Global communications company implemented robotic process automation to increase productive and efficiency

A man working overtime at night

Project Overview

A global communications company implemented RPA to cut down on the manual work their accounting team was spending on sifting through data from multiple sources to create journal entries each month. The automation complied with Sarbanes-Oxley regulations and utilized existing enterprise software and technology.

Client Challenge

The client had a significant number of manual processes due to outdated technology and disparate systems. This delayed the financial close process as accountants spent excess time collecting data, reformatting this data, and creating manual monthly entries. This not only contributed to an inefficient month end, but the process was prone to errors and took valuable time away from reviewing and analyzing financial data.

Prior to implementing the automation:

  • The accounting department was spending a significant number of hours during their monthly financial close process on manual, repetitive tasks involving multiple systems
  • The existing swivel chair processes contributed to data quality concerns

Approach

RevGen sought to identify a simple, inexpensive solution to improve efficiency while saving costs. In addition, support from hesitant business users was needed as implementing Artificial Intelligence can sound like a scary proposition – collaboration was key. Using automation, or “bots”, was new to the accounting organization, and there was resistance to use it for critical financial processes.

The approach included:

  • Identifying potential areas to optimize, specifically around repeating journal entries determined to be inefficient
  • Stepping through several examples of how repeating journal entries were booked to capture all possible scenarios
  • Identifying critical users to the process, including auditors and approvers
  • Determining needed controls to ensure accuracy and completeness of any automations implemented, including all necessary variables for input and output

Solution

The solution was built using an existing organizational RPA software package, so that any developed automations could be easily supported by client resources. RevGen was able to develop a successful automation to open files, enrich data in those files, and create the journal entry in the client ERP system. The solution included a control flow and focused on low-code development. This unassisted RPA bot was implemented to run on a schedule without human intervention.

Results

The implementation of this RPA solution demonstrated the value of automation – reducing low value-add manual work to streamline a critical organizational financial process. Not only reducing a task that typically took a full business day down to a matter of minutes, the solution also contributed to:

  • Higher accuracy of journal entry data
  • Freeing up valuable accounting time to focus on higher value close activities
  • Establishing the necessary auditability for regulatory compliance

Success Stories

A young white man presents data on a large TV to a board meeting.

Crafting a Data & Analytics Strategy and Proof-of-Concept Dashboard

Analytics & Insights

Our client needed a clear, detailed path to resolving their data availability, quality and reporting confidence issues. RevGen stepped in to craft a holistic Data & Analytics Strategy to give them a way forward.

Read More About Crafting a Data & Analytics Strategy and Proof-of-Concept Dashboard
A woman gives a presentation to her colleagues while a report is displayed on the monitor behind her.

Streamlining Tableau Reporting for Cloud Migration

Analytics & Insights

We helped a Fortune 500 telecom client improve their data and analytics capabilities by enhancing and streamlining their Tableau environment in preparation for a migration to the cloud.

Read More About Streamlining Tableau Reporting for Cloud Migration
Holographic images of data visualization float over a tablet that a person is drawing on with a stylus

Using Data Science to Improve Revenues and Demand Forecasting

Artificial IntelligenceAnalytics & Insights

Through data science, we helped our client uncover a potential $2 million revenue uplift and better understand demand seasonality.

Read More About Using Data Science to Improve Revenues and Demand Forecasting

Subscribe to our Newsletter

Get the latest updates and Insights from RevGen delivered straight to your inbox.