Revisión y automatización del procedimiento de conciliación de caja en una terminal terrestre

Abstract

CONDITION FOR PUBLICATION OF PROJECT. This project aims to improve the efficiency and reliability of financial control in a public bus terminal. The objective is to automate and validate the cash-reconciliation process in real time, reducing errors and closing times; the working hypothesis states that integrating business-intelligence tools increases traceability and information timeliness; the proposal is justified by the institutional need for agile and transparent decision-making. The project developed a Power BI dashboard connected to institutional forms and spreadsheets; data-entry validations were defined; and a simulation based on real operational data from one typical month (three shifts, all collection points) was carried out, centralizing records and enabling historical queries by date, shift, point, and responsible staff. Results showed a decrease in manual errors, the identification of actionable patterns (higher discrepancies in the afternoon shift), and an approximate reduction in daily operational time from one day, without additional software licensing costs; date-specific values were retrieved instantly through filters. It is concluded that the solution is economically viable, technologically feasible, and replicable to other processes, strengthening internal control by enabling visual supervision and data-driven decisions. Keywords: business intelligence, internal control, data visualization, operational efficiency, traceability.