Challenge
Information in the accounting system required independent comparison with Revenue Service and bank data. Manual downloading and reconciliation made control, delayed-entry detection, and timely error identification more difficult.
Available Revenue Service and bank data collected and prepared for comparison, reconciliation, and reporting.

Information in the accounting system required independent comparison with Revenue Service and bank data. Manual downloading and reconciliation made control, delayed-entry detection, and timely error identification more difficult.
The system does not create accounting entries and does not replace the accounting software. It retrieves available information from Revenue Service electronic services and the APIs of BOG, ProCredit, and TBC, stores it in a structured format, and prepares it for comparison with accounting data.
Retrieval of available Revenue Service electronic data
Data retrieval from BOG, ProCredit, and TBC APIs
Periodic and controlled data collection
Structured SQL storage
Data prepared for comparison and reporting
Additional verification of sales reporting
Simpler reconciliation and control processes
Support for identifying delayed accounting entries
Improved information accuracy and control