Agile Development of Point of Sale Applications with Real Time Inventory and Dashboard Integration

Abstract

Micro, Small, and Medium Enterprises (MSMEs) increasingly need integrated digital systems to support transaction recording, inventory visibility, and managerial decision-making. Geprek BEJO, a culinary MSME in North Jakarta, previously relied on manual sales and stock recording, which created risks of incomplete transaction documentation, delayed report preparation, and inconsistencies between sales records and raw-material availability. This study aims to design and implement an Android-based Point of Sale (POS) application integrated with a web dashboard for transaction-triggered, API-based inventory and sales-data synchronization rather than empirically measured real-time performance latency. The system was developed using Agile Scrum through observation, interviews, literature review, requirement analysis, UML modelling, sprint-based development, implementation, and evaluation. Flutter and Dart were used for the Android cashier application, while Laravel and MySQL supported backend services, centralized data storage, and API-based data exchange. The system provides authentication, product and menu management, sales transactions, automatic inventory updates after completed transactions, receipt printing, branch management, and report export features. Functional validation using Black Box Testing covered 42 scenarios across the Android application and web dashboard; all scenarios were successfully executed, yielding a 100% functional success rate within the tested feature scope. Usability testing with Geprek BEJO users produced a score of 90.5%, indicating high perceived user acceptance. These results demonstrate the system’s functional feasibility for MSME operational digitalization, while not yet proving transaction latency, long-term operational impact, data security, synchronization reliability under load, or scalability across multiple branches.