Design and Implementation of a VBA-Based Uniform Inventory Accounting System: A Qualitative Case Study at SMA El Fitra Bandung
Jurnal Studi Multidisiplin Ilmu · 03.09.2024 · 2 (3) · 15-31
DOI: 10.35912/jasmi.v2i3.6906 ↗Kurz gefasst
Fachartikel in der Zeitschrift Jurnal Studi Multidisiplin Ilmu, online erschienen am 03.09.2024. Verfasst von Nadiyah Nur Hasanah. Der Volltext ist frei zugänglich (Open Access, CC BY-SA 4.0).
Abstract (Originalsprache)
Purpose
Many educational institutions in Indonesia still use manual inventory recording, leading to recording errors, stock discrepancies, slow data retrieval, and weak financial control. This study develops a Visual Basic for Applications (VBA) based inventory accounting system in Microsoft Excel for SMA El Fitra Bandung to replace its handwritten school uniform inventory records.Research Methodology: A qualitative case study was conducted using unstructured interviews, direct observation, and documentation of inventory records. The system was developed using the five-stage waterfall method and implemented in Microsoft Excel with VBA Macro, featuring five modules: Main Menu, Item Data, Incoming Goods, Outgoing Goods, and Save/Exit.
Results
Five system trials resulted in three successful tests, while two coding errors were resolved during maintenance. The final system accurately managed inventory transactions, generated reports, and improved efficiency, accuracy, accessibility, and data security.
Conclusions
The VBA-based system effectively replaced manual inventory recording, with the Waterfall method ensuring structured development and implementation.
Limitations
The system is limited to inventory recording and requires staff VBA competency and proper supplier receipt management for sustainable operation.Contributions: This study offers a replicable VBA-based inventory system for small institutions, contributing to accounting system design and institutional informatics.
Zitieren
APA
Hasanah, N. N. (2024). Design and Implementation of a VBA-Based Uniform Inventory Accounting System: A Qualitative Case Study at SMA El Fitra Bandung. Jurnal Studi Multidisiplin Ilmu, 2(3), 15-31. https://doi.org/10.35912/jasmi.v2i3.6906
Vancouver
Hasanah NN. Design and Implementation of a VBA-Based Uniform Inventory Accounting System: A Qualitative Case Study at SMA El Fitra Bandung. Jurnal Studi Multidisiplin Ilmu. 2024;2(3):15-31. doi:10.35912/jasmi.v2i3.6906
BibTeX
@article{Hasanah2024,
author = {Hasanah, Nadiyah Nur},
title = {Design and Implementation of a VBA-Based Uniform Inventory Accounting System: A Qualitative Case Study at SMA El Fitra Bandung},
journal = {Jurnal Studi Multidisiplin Ilmu},
year = {2024},
volume = {2},
number = {3},
pages = {15--31},
doi = {10.35912/jasmi.v2i3.6906}
}
EUVIMED