DIGITALIZATION OF A REAL-TIME BUSINESS INTELLIGENCE (BI) DASHBOARD BASED ON THE LOYVERSE POS API FOR OPTIMIZING THE FINANCIAL AUDIT SYSTEM OF TRAKTIR KOPI MSME
DOI:
https://doi.org/10.31849/qgygtg21Keywords:
Traktir Kopi, Business Intelligence, Loyverse POS, API integration, Digital Financial AuditAbstract
This community service activity aimed to improve the financial and operational governance of MSME Traktir Kopi through the digitalization of a real-time Business Intelligence (BI) dashboard based on Loyverse POS API integration. The partner still faced problems with manual recording, time-consuming cash reconciliation, human error risks, and lack of data visualization for decision making. The method used was a participatory approach including needs analysis, development of the T-KODE application using Python, Gradio, and Plotly, socialization, installation, hands-on training, and technical mentoring. The results show that the partner is now able to automatically retrieve transaction data, perform real-time cash reconciliation audits, visualize product contributions and peak hours, and export standardized audit reports. This program contributes to increased efficiency of financial audits, transparency, and data-driven decision-making capabilities in Food and Beverage sector MSMEs.
References
Abdillah, S. A. S., Syam, S., Syafaruddin, A. R. A., Gunawang, S. N., & Alfarauq, S. (2024). Improving digital literacy and digital marketing skills of MSMEs in Bonto Manurung Village. Dinamisia: Jurnal Pengabdian Kepada Masyarakat, 8(5), 1552-1565. https://doi.org/10.31849/dinamisia.v8i5.22985
Demu, Y. (2023). The influence of product quality, financial literacy, digital literacy, financial management, and digital marketing on the profitability of MSME businesses. INJURITY: Interdisciplinary Journal and Humanity, 2(7), 91. https://doi.org/10.58631/injurity.v2i7.91
Hiu, A. (2025). Strategi peningkatan efisiensi operasional UMKM di era digital: Pendekatan kualitatif dengan Business Intelligence dalam implementasi e-commerce. Jurnal Bisnis dan Teknologi, 12(2), 145-158.
Luz, A. (2025). Integrating AI with POS systems for real-time inventory management. Journal of Retail Technology, 7(1), 78-92.
McKinney, W. (2022). Python for data analysis: Data wrangling with pandas, NumPy, and Jupyter (3rd ed.). O'Reilly Media.
Pratama, A. R., & Hendini, A. (2020). Implementasi REST API pada sistem informasi akuntansi UMKM berbasis web. Jurnal Informatika dan Rekayasa Perangkat Lunak, 2(1), 45-52.
Saputri, N. D. M., Malinda, S., Nazaruddin, H. A., & Listya, A. (2023). Pendampingan pemanfaatan dompet digital guna meningkatkan daya jual bagi UMKM. JMM (Jurnal Masyarakat Mandiri), 7(1), 11788. https://doi.org/10.31764/jmm.v7i1.11788
Tjhin, V., & Setyowati, E. (2024). Business Intelligence adoption for small and medium enterprises: Conceptual framework. International Journal of Information Systems and Management, 5(3), 112-125.
Wibowo, A., & Santoso, B. (2025). Design and development of a web-based point of sale system for small-scale retail management. Jurnal Teknologi Informasi, 15(1), 67-82.
Yulianto, D., & Prasetyo, A. (2026). Python-based analytics integration with Business Intelligence dashboards for MSME operational optimization. TIN: Terapan Informatika Nusantara, 7(1), 45-56.
