Jurasik (Jurnal Riset Sistem Informasi dan Teknik Informatika)
Vol 11, No 2 (2026): Edisi Agustus

Implementasi Business Intelligence Dashboard Melalui Integrasi API Loyverse POS untuk Optimalisasi Rekonsiliasi Keuangan UMKM (Studi Kasus: Traktir Kopi)

Dedi Dwi Saputra (Universitas Siber Indonesia, Jakarta, Indonesia)
Dicky Hariyanto (Universitas Siber Indonesia, Jakarta, Indonesia)
Windu Gata (Universitas Nusa Mandiri, Jakarta, Indonesia)
Rizki Hesananda (Universitas Siber Indonesia, Jakarta, Indonesia)
Diky Wardhani (Universitas Siber Indonesia, Jakarta, Indonesia)
Rika Astuti (Universitas Siber Indonesia, Jakarta, Indonesia)



Article Info

Publish Date
30 Aug 2026

Abstract

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






Journal Info

Abbrev

jurasik

Publisher

Subject

Computer Science & IT Decision Sciences, Operations Research & Management

Description

JURASIK adalah jurnal yang diterbitkan oleh LPPM STIKOM Tunas Bangsa Pematangsiantar yang bertujuan untuk mewadahi penelitian di bidang Sistem Informasi dan Teknik Informatika. JURASIK (Jurnal Riset Sistem Informasi dan Teknik Informatika) adalah jurnal ilmiah dalam ilmu komputer dan informasi yang ...