Key metrics

Payback period: 5 months

Effort saved: 1,68 FTEs

Processed cases yearly: 2100

Challenge description

  • Client needs to monthly reconcile large amount of GL accounts for 20+ entities and in two ledgers and also other non-GL financials.
  • Process is time critical due to Month-end closing activities

Solution

  • Standardised reconciliation checklist sheet „orchestrating“ scope of each month’s reconciliations (type / accounts / entities) created
  • Each robotic process is then triggered based on checklist, with robot operating Excel, Sharepoint, SAP and Outlook applications

Process steps

  1. Initiate process based on monthly calendar
  2. Load process variables from Reconciliations checklist
  3. Download the data from different SAP transactions and accounts
  4. Reconcile data into standard format, add extra values
  5. Inform user about process completion

Systems used

MS Excel, MS Outlook, SAP, Sharepoint

Technology used

Uipath rpa