Objective: To Reconsolidate invoices automatically by reading the invoices data available in Pdf Documents and calculate the values of Amount summary, verifying the same with the values which is scraped and send soft copy of the same via email to the concerned person.

 

Solutions: BOT needs to fetch the data from PDF such as Monthly rentals, Usage, Time Charges, Taxes, etc. Then it will Open Invoice Scrape the required data, calculates the Total values, and verify with the Total in the Invoice. The status will be updated back to Excel. It is Done Using RE Framework, which can handle errors and feasible.

 

Benefits: Sales team used to take a minimum of 10 min to consolidate one invoice, verify, authorize and send an email, after implementing BOT we can generate the same within 1 minute and sent it via email automatically to the customer.