Manufacturing Finance & Accounting

RPA creates monthly sales report

The monthly close involves repetitive and manual tasks that recur every month. A business controller creates a report on all realized monthly sales. The long throughput time and strict deadline make it a stressful task. Our RPA solution is able to collect sales data from multiple systems and generates a report that meets all stakeholders' requirements. It fully automates this part of the monthly close process and reduces the monotonous work of business controllers significantly.

Use case

During the monthly close, the finance department of an industrial engineering company generates a sales report. Our client reached out to us to automate this manual and repetitive process of creating these sales reports. Before, the business controller had to manually collect all sales numbers from two ERP software applications, SAP and EveryAngle. Once all data was collected, it was combined into an Excel File. After that, the controller compiled the extracted data in an Excel macro to create a consolidated report. Finally, the report was saved and sent by email to all involved departments.

Since this process recurs every month, it was a very monotonous dissatisfying task. Creating the report took a lot of hours and was often performed in a time crunch. This caused stress and anxiety for controllers which in turn increased the risk of human errors.

Applied technologies
2 weeks delivery time

12

Months Return on Investment

360

Hours saved annually

100 %

Of effort automated

100%

Error reduction

Our solution

A digital colleague was developed using RPA technology to automate this part of the Month End Closing process. Our goal was to build a robot that can execute the process unattended and thereby save valuable time; it does the following tasks on a scheduled time:

  • Extracts week report from SAP Business Warehouse
  • Extracts week report from EveryAngle
  • Inserts extracted data into Excel
  • Runs Excel Macro to generate final weekly report
  • Sends email with final weekly report to stakeholders

This robot fully automates (100%) the process and saves over 360 hours yearly. The workload is reduced, and business controllers are relieved from the associated work pressure. We offer a solution that is effective, efficient, and reliable. Workers can stop wasting time on manually creating sales reports 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