Driving Efficiency with Intelligent Automation

RevGen helped our client implement Intelligent Automation to enable a more accurate and efficient cost reconciliation process

A man holds a laptop with the acronym RPA on the screen. Icons representing various automations float around it.

Project Overview

A Fortune 500 company faced issues reconciling offnetwork inventory assets which created delays in dispute resolution and monthend financial close. This significantly impacted their ability to accurately allocate millions of dollars of monthly costs.

These delays resulted from an inability to correctly match inventory because of missing invoice data. RevGen was engaged with the goal of leveraging emerging technologies to more intelligently identify missing data and implement supplemental feeds to improve the match rate in an automated and sustainable manner. 

 

Client Challenge

Each month a material amount of inventory items could not be automatically matched to vendor invoices. It was an unsustainable, highly manual process that left many issues unaddressed. Additionally, inventory asset classes were frequently misidentified causing confusion between fixed, shared, and capitalizable items. This created a need to hire additional resources to manually research and resolve each exception, which equated to higher costs.

Contract negotiations

The group responsible for the negotiation of vendor agreements had limited leverage with the vendors and could not always negotiate client-specific data formats to ensure an automated back-office process. Vendors also used different terminology to describe equivalent products and services, adding to complexity when normalizing and analyzing vendor-supplied data.

Legacy systems

A multitude of legacy ordering systems did not represent purchase orders in a consistent manor. Efforts to ensure consistency across systems would take considerable resources, time, and cost. For this reason, full system refactoring was not feasible for this client, so alternative technology approaches were necessary.

Lack of automation

To date, approaches to address these challenges were handled by adding more personnel. The client realized that this was unsustainable, inefficient, and costly.

Approach

RevGen worked with the client and identified the vendors responsible for most of the monthly exceptions and data needed to resolve them. Each vendor was prioritized by the client based on value and volume.

We decided Intelligent Automation technology was ideal for addressing these issues as it automated virtually any process by mimicking user interactions with applications. The automations ran on demand, required no additional staff, and was independent of the technologies used by vendors.

 

[Read More: Should you consider investing in RPA?]

Solution

The overall goal was to increase the automated match rate for vendor data, thereby reducing manual research and cutting costs while improving timelines. To do this, we leveraged the technology suite of Automation Anywhere.

Supplemental data

We determined that most of the identified vendors had supplemental data available through various reports in their portals. Using intelligent automation, we had to source that data, standardize it, and load it into the existing vendor invoicing data.

Automation Anywhere

Leading automation technology Automation Anywhere was used to build the bots that gathered this supplemental data and loaded it into Oracle. Leveraging the web recorder, database, logging, and regular expression modules, RevGen was able to deliver bots that gathered the needed data faster, more accurately, and more reliably than the old manual processes.

Regularly scheduled updates

The unattended “bots” were used to ingest the various vendor attributes needed to complete our client’s invoices regularly. We built the bots to replicate the actions staff had taken to research and resolve exceptions, automating what had once been an extremely labor-intensive process.

Results

Not only was the client able to reduce the number of monthly exceptions, but they were also able to better identify and classify expenses, leading to fewer manual adjustments. This led to improved accuracy of the monthly cost accounting in the range of millions.

Exception reduction

By acquiring supplemental descriptive data not available in invoice-based data feeds, the client was able to quickly reference the repository to address and prevent future inventory exceptions.

Fewer manual adjustments

The repository was also able to address issues identifying shared and capitalizable expenses, allowing them to book items more accurately and reducing manual adjustments.

Cross-department collaboration

The repository allowed stakeholders from other areas of the business to look at the same vendor-sourced data, which provided better visibility of the products and services utilized. Information from this repository also aided in additional contract-related adjustments, saving the client money.

Proven benefits of emerging technology

The use of Automation Anywhere proved to have significant business benefits for the implementing group and the organization overall. They realized the power of leveraging technologies like Automation Anywhere to address organizational inefficiencies and to achieve intelligent productivity gains. Intelligent Automation will no doubt continue to be a key technology used by the client to deliver additional value in the future.

Success Stories

A series of data and analytics charts arranged in a functional dashboard

Data Transformation to Enable Advanced Analytics and AI

Analytics & Insights

Our client needed a modern, transformative data architecture to reach the next level of analytics, including AI.

Read More About Data Transformation to Enable Advanced Analytics and AI
A person types on a laptop. Above the laptop hovers icons of various checklists, representing data quality controls.

The Power of Frontline Data Quality Controls

Execution as a Service

Improving data quality was key to ensuring our financial services client retained data integrity and accuracy while also reducing time and money spent on after-hours issues. 

Read More About The Power of Frontline Data Quality Controls
Three wooden blocks spelling out MQL. The "M" block tips over to reveal an "S"

Automating for Efficiency: Turning Marketing Leads into Sales Contacts

Technology ServicesAnalytics & Insights

The transfer of marketing leads to sales teams is critical for customer acquisition, however our client’s process was time consuming and heavily manual. RevGen built a proof-of-concept solution that automated the entire handoff.

Read More About Automating for Efficiency: Turning Marketing Leads into Sales Contacts

Subscribe to our Newsletter

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