Log in
Business Case Three

RPA Opportunity Payment Reconciliation (Insurance)


The current process for managing Travel expenses charged on various corporate cards is manually managed by the business travel team processors. Information from the banks are manually provided to the Insurance company and merged into an excel spreadsheet and manually confirmed. Once the amounts have been confirmed then it is imported into the Total Reconciliation System (TRS). The statements from the banks are manually compared to reports from the 6 regional business units of the Insurance company prior to importing into the TRS.

Proposed Solution

Apply Robotics in the following way:

  • Retrieve the credit card statements from the banks
  • Obtain the Reports from an internal system that houses all the electronic expenses
  • Confirm the banks statements with the reports from the 6 regional business units
  • Provide a report to the business on the exceptions and the successfully verified transactions

Business Area

  • Expense Reconciliation

Success Metric

  • Eliminate the manual efforts and related staff needed to process transactions and verifications
  • Increase the cycle time for the processing of each daily file
  • Reduction in count of manual entry errors


  • Lack of standardization of the reports from all 6 regional business units. This meant that all Business Units needed to agree on a standard reporting format specifically for this solution.


  • $360,000 in cost reduction through 6 FTE elimination (60k per FTE)

RPA Costs

One Time

  • Development $170,344
  • IT Governance $55,656
  • Vendor & Application Support $48500

Recurring (Annual)

  • Maintenance & Support $37,500
  • License Cost (Cost Per Bot is $13,500)
  • Total Benefits: $360,000.00/Year
  • Total Costs: $393,000
  • ROI: Year 1 -- $33,000

Georgia, US

 This email address is being protected from spambots. You need JavaScript enabled to view it.

Sales: 770-634-8567

Log in or Sign up