Abstract
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.
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.
Author Biographies
Hendi Hendi
Jurusan Akuntansi, Fakultas Ekonomi, Universitas Internasional Batam, Kota Batam, Provinsi Kepulauan Riau, Indonesia.
Novi Novi
Universitas Internasional Batam
Jurusan Akuntansi, Fakultas Ekonomi, Universitas Internasional Batam, Kota Batam, Provinsi Kepulauan Riau, Indonesia.