Sistem Informasi Akuntansi Berbasis Microsoft Access Utama Motor
DOI:
https://doi.org/10.56347/kjpkm.v4i2.368Keywords:
Accounting Information System, Smes, Microsoft Access, Participatory Action Research, Financial EfficiencyAbstract
This study aims to develop a Microsoft Access-based accounting information system for Utama Motor, a small and medium enterprise (SME) in Batam, Indonesia, to improve the efficiency and accuracy of financial recording. Previously, financial transactions were recorded manually using Microsoft Excel, often resulting in input errors, data duplication, and delays in preparing financial statements. The system was designed using a relational database structure, comprising main tables such as msChartofAccount, msInventory, msSupplier, and trSalesHeader to integrate financial transactions. The research employed a Participatory Action Research (PAR) approach, emphasizing active collaboration between researchers and the business owner throughout the design, testing, and evaluation stages. The implementation results show a 42% reduction in financial report preparation time, improved recording accuracy, and higher user acceptance levels. Furthermore, the system produces financial statements that comply with the Indonesian Financial Accounting Standards for Micro, Small, and Medium Entities (SAK EMKM). Overall, the Microsoft Access-based system offers an effective and affordable solution for SMEs to enhance financial management professionalism and support digital transformation in small enterprises.
Downloads
References
Digitalization in management accounting systems for urban SMEs in Indonesia. (2023). Cogent Business & Management, 10(1). https://doi.org/10.1080/23322039.2023.2269773
Firdhaus, A., & Akbar, F. S. (2022). Pengaruh penerapan sistem informasi akuntansi dan pemanfaatan teknologi informasi terhadap kinerja UMKM. Jurnal Proaksi, 9(2), 173–187. https://doi.org/10.32534/jpk.v9i2.2632
Fitriani, D., & Nurlaela, S. (2023). Adoption of accounting information systems and digital transformation in Indonesian SMEs. Journal of Business and Accounting Research, 5(2), 145–158.
Gravitt, P. E., et al. (2020). Integrative systems praxis for implementation research: A framework combining participatory action research and systems thinking. Cancer Epidemiology, Biomarkers & Prevention, 29(9), 1710–1718.
He, J., & King, W. R. (2008). The role of user participation in information systems development: Implications from a meta-analysis. Journal of Management Information Systems, 25(1), 301–331. https://doi.org/10.2753/MIS0742-1222250111
Impact of accounting information system on the financial performances of micro, small, and medium sized enterprises in Bengkulu City. (2021). JEMA: Journal of Economics and Management Analysis, 18(2). https://doi.org/10.31106/jema.v18i2.12530
Kareem, H. M., et al. (2024). The mediating role of accounting information systems in SMEs’ strategies and performance. Humanities and Social Sciences Communications, 11(1).
Lopung, T. M., & Rulindo, R. (2023). Accounting information system and SMEs’ financial performance in Indonesia. Jurnal Akuntansi, 15(2), 200–214. https://doi.org/10.28932/jam.v15i2.6607
Mediaty, M., Indrijawati, A., Palureng, R. Z., Surisman, S., & Hariana, H. (2025). Implementation of accounting information systems in SMEs: A systematic literature review. Golden Ratio of Finance Management, 5(1), 52–65. https://doi.org/10.52970/grfm.v5i1.923
Rahman, A., & Anwar, S. (2022). Participatory approach in developing accounting information systems for small enterprises. International Journal of Contemporary Accounting, 4(2), 112–125.
Rosalina, R., Suratman, S., Herlianti, E., Surahman, B., & Kalsum, U. (2024). The relationship between accounting information systems and operational efficiency in small and medium enterprises. Jurnal COSTING: Journal of Economic, Business and Accounting, 7(6).
Setiawan, A., & Widodo, R. (2024). The impact of digital financial systems on small business performance in Indonesia. International Journal of Economics and Business Applications, 8(1), 33–45.
Suhendi, C., Ifada, L. M., & Istanti, S. L. W. (2022). The role of accounting information systems in improving SMEs’ success. Jurnal Akuntansi Multiparadigma, 13(2), 253–262. http://dx.doi.org/10.21776/ub.jamal.2022.13.2.19
Wahyuni, T. (2023). Accounting information systems for SMEs: A systematic literature review. In Proceedings of the International Conference on Vocational Education Applied Science and Technology (ICVEAST 2023). 10.2991/978-2-38476-132-6_61
Yusoff, Y. M., Rasid, S. Z. A., & Nordin, N. A. (2021). The influence of accounting information system quality on SME performance. Asian Journal of Accounting and Governance, 16, 21–30.
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Novi Novi, Hendi Hendi
This work is licensed under a Creative Commons Attribution 4.0 International License.
Articles in this journal are published under the Creative Commons Attribution Licence (CC-BY 4.0). This means that users may share and adapt the articles published on this website in a reasonable manner, but they must give appropriate credit to the creator and indicate the changes they have made. Users must not apply additional restrictions, but must publish the work under the same license (CC-BY 4.0).
