Finance R2R - Reconciliations

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	Initiate process based on monthly calendar Load process variables from Reconciliations checklist Download the data from different SAP transactions and accounts Reconcile data into standard format, add extra values Inform user about process completion
Systems used	MS Excel, MS Outlook, SAP, Sharepoint
Technology used