This project aims to automate the submission, validation, monthly&quarterly reporting and accounting of fee enforcement financial returns at Liberata. The current manual process is slow, error-prone, and lacks a clear audit trail. The new system is designed to improve efficiency, ensure accuracy, and provide greater transparency through automation and structured data management. The overall project is divided into two main components: a back-end application that handles automated data processing and reporting, and a web application that provides user access, searching, and interaction. The two components work together to form an integrated solution for managing financial returns.

Scope of this dissertation: This dissertation focuses on the back-end application. It delivers a robust automation pipeline for extracting returns from emails, validating file formats and transaction data, and storing clean results in a secure SQL database. It also generates consolidated monthly and quarterly reports. Beyond its automated monthly runs, the back-end solution provides the essential data services that support the front-end web application.