SISTEM KASIR DI APLIKASI ANDROID YANG DAPAT MENYIMPAN DATA MENGGUNAKAN DATABASE OFFLINE

Abstract

Micro, Small, and Medium Enterprises (MSMEs) are an essential pillar of Indonesia’s economy, yet many still rely on manual record-keeping that is prone to errors, inefficiency, and difficulties in generating accurate reports. To address these limitations, this study proposes Excash, an Android-based point-of-sale application designed specifically for MSMEs. Unlike many existing cashier applications that require constant internet connectivity, Excash operates fully offline using the SQFLite database, making it more reliable in areas with unstable networks. Furthermore, Excash integrates features rarely combined in similar systems, including product and inventory management, CSV-based data export and import for cross-device use, and seamless receipt printing through a thermal printer. The user interface was developed using a User-Centered Design (UCD) approach to ensure accessibility for non-technical users. The application was tested for three days at Laila’s grocery store with an Android device and Bluetooth thermal printer. Results demonstrated 100% transaction accuracy, response times under one second, and a 97% user satisfaction score, highlighting its practicality and effectiveness. Excash proves to be an innovative solution that enhances operational efficiency, ensures precise transaction handling, and simplifies usage for MSMEs. These findings confirm its potential to significantly improve the competitiveness and sustainability of small businesses in Indonesia.