Abstract
This study addresses the operational challenges faced by Micro, Small, and Medium Enterprises (MSMEs) in managing financial records by designing a specialized sales accounting information system for Toko Utara Game. Utilizing the SAK EMKM accounting standard, the system aims to mitigate human error inherent in manual bookkeeping. The research employs a descriptive research method and a prototyping methodology for system development. The resulting web-based application, built with Java and MySQL, demonstrates improved efficiency in financial reporting and inventory management, providing a standardized framework for digital transformation in the MSME sector.
Introduction
Many MSMEs, such as Toko Utara Game in Bandung, Indonesia, continue to rely on conventional, paper-based systems for recording sales and managing inventory. This manual approach is fraught with vulnerabilities, including frequent calculation errors, data fragility, and significant delays in generating financial reports. Furthermore, the lack of alignment with formal accounting standards often prevents these businesses from assessing their true profitability or accessing formal credit. This paper details the design and implementation of a digital solution tailored to these needs, specifically integrated with the SAK EMKM (Financial Accounting Standards for Micro, Small, and Medium Entities).
Methodology
The researchers adopted a descriptive research method to analyze the existing workflows at Toko Utara Game. To develop the software, a prototyping system development life cycle (SDLC) was chosen, allowing for iterative feedback and refinement between the developers and the business owners.
The development process involved several key stages:
- Data Collection: Primary data was gathered through interviews and direct observation of the store's daily operations, while secondary data was sourced from literature regarding accounting standards.
- System Modeling: Unified Modeling Language (UML) was used to map the system's architecture, including Use Case and Activity Diagrams.
- Implementation: The system was developed using the Java programming language within the NetBeans IDE, utilizing a MySQL database and XAMPP for local server deployment.
System Design and Key Insights
A core component of the system design is the Use Case Diagram, which defines the interactions between various stakeholders and the system modules. This visualization ensures that all business requirements—from transaction entry to report generation—are accounted for in the software architecture.
Key design insights from the study include:
- Standardization as a Blueprint: By embedding SAK EMKM standards directly into the database schema and logic, the system ensures that financial reports like Income Statements and Sales Journals are professionally compliant "out of the box."
- Separation of Concerns: The system distinguishes between the 'Admin' (operational data entry) and the 'Owner' (oversight and reporting). This creates a digital audit trail and enhances internal control.
- Automated Journaling: The software automatically maps sales transactions to the appropriate debit and credit entries in the General Ledger, bridging the gap between simple point-of-sale functions and formal accounting.
Results and Discussion
The implementation resulted in a functional web-based application that provides:
- Real-time Inventory Control: Automatic updates to stock levels for consoles and accessories upon sale.
- Instant Reporting: The ability to generate filtered financial reports instantly, replacing the time-consuming manual "daily recap" process.
- Reduced Error Rates: Standardized input fields for item codes and prices prevent the common transcription errors found in manual ledgers.
The authors note that the system significantly reduces the time required for daily administrative tasks, allowing the business owner to focus on strategic growth rather than manual data entry.
Conclusion and Future Work
The designed system successfully transitions Toko Utara Game from manual to computerized sales management. While effective, future iterations could expand the scope to include modules for purchasing (supply chain) and payroll. Additionally, migrating the system to a cloud-based architecture would facilitate remote monitoring, further empowering business owners in the MSME sector to make data-driven decisions in real-time.
Reference: Najla, Supriyati, & Dewi, D. A. (2022). Design of Sales Accounting Information System Using EMKM Accounting Standard. @is The Best: Accounting Information Systems and Information Technology Business Enterprise, 7(2), 166-180.
Summary updated