Automatización del proceso de conciliaciones diarias de depósitos y recaudaciones en una terminal terrestre

Abstract

CONDITION FOR PUBLICATION OF PROJECT. This project focuses on the need to improve the daily reconciliation process of deposits and collections at a bus terminal. Currently, daily closing reports are manually transcribed in order to prepare monthly income records, which often leads to operational mistakes. The main objective is to automate the extraction and consolidation of financial information from daily PDF reports, reducing the time required and strengthening internal control. The project assumes that automation using free and open-source software can reduce transcription errors and improve reliability of the data for financial supervision. Design Thinking methodology was used to better understand the user's needs. The solution was developed through a prototype built in Python, using libraries to process PDF files and generate Excel documents. The system validates amounts and automatically structures a monthly master file. The results showed that the average reconciliation time was reduced to 2-5 minutes per execution, and manual errors decreased to less than 1%. In conclusion, the solution improves traceability, efficiency, and consistency of financial information, supporting auditing and internal control processes. Keywords: automation, traceability, financial reconciliation, internal control, operational efficiency.