This study discusses the development of a real-time Business Intelligence (BI) dashboard called T-KODE (Traktir Kopi Operational Dashboard Engine) for MSMEs in the Food and Beverage sector, specifically at Traktir Kopi Jagakarsa, South Jakarta. The system was developed to address issues in manual transaction recording and cash reconciliation processes that often cause inefficiency, human error, delayed audits, and limited access to real-time business information. T-KODE integrates with the Loyverse POS API to automatically retrieve transaction data and provide features such as cash reconciliation, sales visualization, product contribution analysis, peak hour monitoring, risk transaction detection, and audit report generation. The system was developed using the Waterfall method and implemented with Python, Gradio, Plotly, and Pandas. Based on Black Box Testing results, all system features functioned properly according to requirements. The implementation of T-KODE improved the efficiency, accuracy, and transparency of financial auditing processes. This study can serve as a reference for the digital transformation of similar MSMEs in Indonesia
Copyrights © 2026