Project Title:
Advanced PDF Invoice Processing & Reporting Automation
Project Description:
Scenario:
Avirup, the accountant of a mid-sized company, receives hundreds of PDF invoices monthly from multiple vendors. Each PDF contains Invoice Number, Date, Vendor Name, and Amount. Manually processing them is slow and error-prone.
Objective:
Build a UiPath bot that:
1. Reads all PDF invoices from a folder (both scanned and text-based PDFs).
2. Extracts key data (Invoice Number, Date, Vendor Name, Amount).
3. Validates extracted data (e.g., Amount > 0, Date in correct format).
4. Saves the data into a master Excel tracker.
5. Generates monthly summary reports with total invoices per vendor.
6. Moves processed PDFs to an Archive folder and logs errors for unprocessable files.
Problem Statement:
How can Avirup automate the invoice processing workflow to ensure speed, accuracy, and efficient reporting while handling both scanned and text-based PDFs and managing errors effectively?
