Design of Sales Accounting Information System Using EMKM Accounting Standard

Najla Najla, Supriyati Supriyati, Deshinta Arrova DewiIs 2023 · DOI

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 Prototyping Model used for iterative system development.

The development process involved several key stages:

  1. 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.
  2. System Modeling: Unified Modeling Language (UML) was used to map the system's architecture, including Use Case and Activity Diagrams.
  3. 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.

Use Case Diagram illustrating the interactions between actors (Customer, Salesman, Admin, Owner) and the system modules.

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

Abstract

This study intends to design a sales accounting information system for UMKM Toko Utara Game. The purpose of this study is to design a sales information system with EMKM standards at Toko Utara Game that can be implemented as one of the human error risk management that might occur if the system is run conventionally and not computerized. The research method used in this study is a descriptive research method, in which the author analyzes and describes events that occur in the present with the intention of overcoming problems that occur at Toko Utara Game. The types of data used in this research are primary data and secondary data. Data collection techniques used in this study were interviews, observation and literature studies. The results of interviews and observations are used as primary data and the results of literature studies are used as secondary data. The system development methodology used in this study is the prototyping method with an object-oriented system design method using UML (Unified Modeling Language). The system design made in this study is a Use Case Diagram, an Activity Diagram, and uses an Entity Relationship Diagram (ERD). At the stage of creating the program code, researchers used the Java and MYSQL programming languages which were poured into the NetBeans IDE8.1 software using XAMPP as a web server. The result of this implementation is the design of a web-based sales application so that Toko Utara Game sales management can be computerized properly.
BibTeX
@inproceedings{najla2023design,
  author = {Najla Najla and Supriyati Supriyati and Deshinta Arrova Dewi},
  title = {{Design of Sales Accounting Information System Using EMKM Accounting Standard}},
  booktitle = {Is},
  year = {2023},
  doi = {10.34010/aisthebest.v7i2.9125},
}
Figure