The reconciliation of open accounts receivable and customer payments was done manually by the finance colleagues based on Excel reports received from a co-department. The task was simple to do according to the rules, but processing the large number of items took a considerable amount of time for the team.
Based on the data read from the incoming Excel reports, the robot tries to match the items in SAP according to the rules provided. If the matching is successful, it books the payment to the invoice and records the transaction number in a report; failed matchings are also registered in the report. The result of the processing is sent by email to the appropriate mailing list.
By automating the processing of items, we have freed up approximately 5 hours per day for the Finance department. The number of customer complaints has been reduced as the quality of the overall reconciliation has improved.
