Key Challenges
The main issue was the high FTE contribution in the reconciliation of invoices and the E-way Bills process. Regular human involvement in the process eventually led to failures, inefficiencies, unnecessary delays, and high cost.
Some of the key challenges were:
- Reading the invoices and E-Way Bill of various sellers in PDF formats and manually copying and pasting the data in Excel was a laborious and time-consuming task.
- Also, I was finding it difficult to keep track of missing E-Way bills and duplicate invoices.
- Manually doing the invoice and E-Way Bill data for reconciliation was very time-wasting.
Our Solution
The RPA bot was designed to perform the task in the same order without human intervention that made no errors.
- The Bot reads the relevant emails and downloads invoices and E-Way bills as an attachment.
- The Bot identifies the invoice format alone and fetches the data from it, and updates the data in an Excel sheet in the required format.
- Post fetching the data and carrying out the reconciliation process creates a report and sends mail.
Automation Benefits
The impact can be seen below that gave some tangible benefits to the company by automating with RPA.
- Degree of robotization: Automated initiative by 95%
- The failure rate decreased to 0%
- Manual workload reduced by 10%
- 150 hours of effort saved monthly
- Made process faster
- Increased business morality