AUTOMATED INVOICE PROCESSING USING UIPATH AND SQLITE

Abstract: The rapid growth of digital business operations has led to a significant increase in the volume of invoices that organizations must process daily. Traditional invoice handling methods rely heavily on manual data entry, which is time- consuming, prone to human errors, and inefficient when dealing with large numbers of documents. This project presents an Automated Invoice Processing System developed using UiPath Robotic Process Automation (RPA) and SQLite database technology. The system automatically processes invoice documents in PDF format by extracting relevant information using Optical Character Recognition (OCR). Key invoice details such as invoice number, invoice date, total amount, vendor type, and status are identified and validated through rule-based logic. The extracted data is then stored in a structured SQLite database for efficient management and retrieval. The system also includes mechanisms for duplicate detection, error handling, and automated file segregation. Valid invoices are stored in the processed folder, while invoices with missing or incorrect information are moved to an error folder for review. By automating repetitive tasks such as document reading, data extraction, validation, and storage, the proposed system significantly improves operational efficiency and accuracy. The implementation demonstrates how RPA combined with OCR technology can transform manual document processing into a reliable and scalable automated workflow, making it suitable for small and medium-scalebusiness-environments.

Keywords: Robotic Process Automation (RPA), UiPath, Invoice Processing, Optical Character Recognition (OCR), SQLite Database, Document Automation, Data Extraction, Workflow Automation