Sistem Informasi Akuntansi Berbasis Microsoft Access Utama Motor

Views icon

486

Views

Downloads icon

149

Downloads

Altmetrics icon

Altmetrics

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

  1. Digitalization in management accounting systems for urban SMEs in Indonesia. (2023). Cogent Business & Management, 10(1). https://doi.org/10.1080/23322039.2023.2269773
  2. 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
  3. 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.
  4. 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.
  5. 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
  6. 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
  7. 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).
  8. 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
  9. 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
  10. Rahman, A., & Anwar, S. (2022). Participatory approach in developing accounting information systems for small enterprises. International Journal of Contemporary Accounting, 4(2), 112–125.
  11. 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).
  12. 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.
  13. 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
  14. 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
  15. 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

How to Cite

Hendi, H., & Novi, N. (2025). Sistem Informasi Akuntansi Berbasis Microsoft Access Utama Motor. Kawanad : Jurnal Pengabdian Kepada Masyarakat, 4(2), 185-194. https://doi.org/10.56347/kjpkm.v4i2.368

Article Details

  • Volume: 4
  • Issue: 2
  • Pages: 185-194
  • Published:
  • Section: Article
  • Copyright: 2025
  • ISSN: 2830-0041

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).

Similar Articles

Similar Articles

Discover other articles with topics similar to what you're currently reading. Find more references and expand your knowledge base.

Related Articles You May Be Interested In

More Similar Articles

Pelatihan Internet of Things Berbasis Embedded System...

Yuwaldi Away, Andri Novandri, Isyatur Raziah

Vol. 5 No. 1 (2026): March
Program Tahfidzul Qur’an untuk Membentuk Karakter...

Muhammad Yusron Maulana El Yunusi, Kharisma Syifanaya Firdaus, Sirojuddin Abror

Vol. 4 No. 2 (2025): October
Penguatan Gotong Royong Sebagai Wujud Pengabdian...

Muhammad Imam Hambali

Vol. 5 No. 1 (2026): March
Kegiatan LDKO (Latihan Dasar Kepemimpinan OSIS) untuk...

Kharisma Syifanaya Firdausi, Muhammad Yusron Maulana El Yunusi, Sirojuddin Abror

Vol. 4 No. 2 (2025): October
Most read articles by the same author(s)

Related Articles