Design and Development of a VBA Macro-Based Sales Accounting System For MSMEs:  A Case Study of Reglow By Bundami Distributor

Micro, Small, and Medium Enterprises (MSMEs) often rely on traditional accounting methods, which are not only inefficient but also prone to errors in recording and reporting. These shortcomings can adversely impact the financial health of MSMEs, particularly when their accounting systems fail to comply with SAK EMKM standards. This study aims to design and develop a sales accounting system application for Reglow by Bundami Distributor to address these challenges. Utilizing the Research and Development (R&D) approach, data were gathered through observation, interviews, and questionnaires. The software development process followed the sequential waterfall model, while system functionality was evaluated using Blackbox testing, expert validation, and practical trials at the distributor. The results demonstrate that the developed VBA macro-based accounting system effectively generates comprehensive sales reports, including total net sales, product quantities sold, and the availability of various product types. This system offers a practical solution to longstanding sales-related inefficiencies, streamlining administrative processes and enhancing operational productivity within MSMEs.