Manufacturing Finance & Accounting

RPA creates monthly sales report

The closing of the month involves repetitive and manual tasks that recur every month. A business controller has to create a report on all sales of that month. The long throughput time and strict deadline make it a stressful task. Our RPA solution is able to collect all sales numbers and creates a report that meets all requirements. It fully automates the monthly process and reduces the monotonous work of the business controllers significantly.

Use case

At the end of every month, a sales report has to be generated at an industrial engineering company. This engineering company reached out to us to automate this process of creating these monthly sales reports. In the old situation, business controllers at the Finance & Accounting department had created reports that contained all sales of that calendar month. The business controller had to 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 a macro to create an overall report. Finally, the report was saved and sent 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 the controllers which in turn increased the risk of errors.

Applied technologies
2 weeks delivery time

93%

Automation potential

360

Hours saved annually

100 %

Of effort automated

95%

Error reduction

Our solution

A digital workforce was created using RPA technology to automate the Month End Closing process. Our goal was to create a robot that is able to automate the process and thereby save valuable time. Our robot was built to perform the following steps:

  • 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 is able to fully automate (100%) the process and save over 360 hours on a yearly basis. The workload is reduced and business controllers are relieved from the associated work pressure. Our solution reduces the throughput time and costs while increasing the user satisfaction.

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

More information?

Leave your number


Don't feel like filling in a form? Email or call us directly at