Manufacturing Finance & Accounting

Completely automating a balance sheet reconciliation process

In this use case we extract financial balance sheets from SAP with our RPA technology. We make use of Pandas to perform data transformations at a rapid speed to reduce employee idle times, increasing work satisfaction while ensuring all SLA's are met.

Use case

Every month employees at the finance and accounting department of a global car manufacturer have to export last month’s balance sheet and banking statement from SAP. Then, these two exported files have to be reconciled into different account categories split over 30 Excel sheets. These final Excel sheets serve as a check whether all financial data adds up and is correctly filled out in SAP.

The creation of this complete template happens every month and is done by hand. Think about long-running Excel calculations including V-Lookup and if-statements. This is a very mundane and repetitive task which is prone to errors. The employees only have a single day to complete this process next to other end-of-the month related processes. Therefore SLA’s are not always met. Building an RPA solution which automates this extraction process helps the employees to focus on work that matters, decrease throughput times and reduce errors.

Applied technologies
4 weeks implementation time

6

Months to ROI

100%

Of effort automated

500

Hours saved annually

100%

Of SLA's met

Our solution

We created a digital workforce using RPA technology to automate the complete process of balance sheet reconciliations. Our goal was to significantly increase the speed this process, while reducing idle time and errors. The robot is triggered each month and is build to perform the following steps:

  • Log into SAP
  • Navigate to and download the right data
  • Transform data within a split second
  • Send output to stakeholders involved

Our robot is able to fully automate this process and save over 500 hours on a yearly basis. Our solution is effective, efficient and reliable. Workers can stop wasting time on manually creating and checking the balance sheets and refocus on work that matters.

Integrated applications

Contact

Want to know more about our cases?

We'll gladly answer your questions on workdays between 09:00 and 18:00.

sales@ciphix.io
+31 10 307 05 93