Implementasi Sistem Akuntansi Berbasis Microsoft Access pada UMKM Blue Wash

Authors

  • Iskandar Itan Universitas Internasional Batam
  • Alvina Alvina Universitas Internasional Batam

DOI:

https://doi.org/10.55606/kreatif.v6i1.10128

Keywords:

Accounting System, Community Service, Financial Record, Microsoft Access, MSME

Abstract

This community service program aims to assist Blue Wash MSME in improving the quality of its financial record-keeping through the implementation of a Microsoft Access-based accounting system. Blue Wash MSME, which operates in the laundry service sector, currently relies on simple bookkeeping methods using Microsoft Excel. This practice has resulted in unstructured transaction records and difficulties in obtaining accurate financial information. The program employed a qualitative approach involving interviews and direct observation of the business partner to identify accounting-related issues faced by the business partner. Based on the identified needs, an accounting information system was designed and developed to support systematic financial recording. The system features master data management, purchase and sales transaction processing, general journal recording, inventory management, and automated financial reporting. The resulting accounting system is expected to improve the effectiveness and efficiency of financial management at Blue Wash MSME and support more structured and accountable financial reporting in compliance with applicable accounting standards.

References

Anisykurlillah, I., Mahmud, A., & Susilowati, N. (2021). Pengembangan sumber daya BUMDes Asung Daya dalam administrasi keuangan berbasis komputer. Panrita Abdi, 5(4), 600–611.

Apriyanti, R., Sosial, I. I., & Stiami, M. (2022). Dampak pandemi COVID-19 terhadap laporan laba rugi pada bank syariah. Neraca: Jurnal Akuntansi Terapan, 3(2), 114–120.

Cahyana, Y., Buana, U., & Karawang, P. (2022). Perancangan sistem informasi usaha mikro kecil dan menengah (UMKM) berbasis web di Desa Bojongsari. Jurnal Sistem Informasi, 6(2), 47–52.

Deschamps, C. (2019). Stages of management control in a large public organization: From top to frontline managers. Journal of Management Control, 30(2), 153–184. https://doi.org/10.1007/s00187-019-00282-z

Eldh, A. C., Rycroft-Malone, J., van der Zijpp, T., McMullan, C., & Hawkes, C. (2020). Using nonparticipant observation as a method to understand implementation context in evidence-based practice. Worldviews on Evidence-Based Nursing, 17(3), 185–192. https://doi.org/10.1111/wvn.12449

Farida, I., & Setiawan, D. (2022). Business strategies and competitive advantage: The role of performance and innovation. Journal of Open Innovation: Technology, Market, and Complexity, 8(3), Article 163. https://doi.org/10.3390/joitmc8030163

Hartanti, W., & Hendratmoko, C. (2021). Peran pemerintah kelurahan dalam pengembangan UMKM. Indonesian Journal of Social Management, 4(1). https://doi.org/10.25134/ijsm.v4i1.3952

Itan, I. (2024). Perancangan sistem pengendalian manajemen yang terintegrasi pada PT Hok Seng Jayaperkasa untuk meningkatkan efisiensi operasional. Jurnal Humaniora, 4(4), 766–776. https://doi.org/10.31004/jh.v4i4.1322

Luh, N., Sayang, W., Suci, N. M., & Heryanda, K. K. (2021). Implikasi kewirausahaan terhadap digitalisasi ekonomi. Jurnal Manajemen, 11(2), 228–240.

Paul, J., & Criado, A. R. (2020). The art of writing literature review: What do we know and what do we need to know? International Business Review, 29(4), Article 101717. https://doi.org/10.1016/j.ibusrev.2020.101717

Ramadana, M., & Istiqomah, N. (2024). Perancangan sistem akuntansi berbasis Microsoft Access pada Kedai Kopi Sriwangi. Jurnal Humaniora, 4(4), 651–659. https://doi.org/10.31004/jh.v4i4.1311

Sageder, M., & Durstmüller, B. F. (2019). Management control in multinational companies: A systematic literature review. Review of Managerial Science, 13(5), 875–918. https://doi.org/10.1007/s11846-018-0276-1

Saputra, S., & Rangkuti, P. W. (2023). The application of digital marketing to MSMEs Mandiri Maju Jaya Store. Gandrung: Jurnal Pengabdian Kepada Masyarakat, 4(1), 701–713. https://doi.org/10.36526/gandrung.v4i1.2384

Sinatriyo, S. S. (2019). Desain sistem informasi akuntansi berbasis komputer untuk penyusunan laporan keuangan menggunakan Microsoft Access 2010. E-Journal Ekonomi Bisnis dan Akuntansi, 6(1), 63–68. https://doi.org/10.19184/ejeba.v6i1.11080

Terapan, J. S., Mudhiah, F. D., Jannah, N. R., Maulisa, N. L., Ramadhan, A., Setiawan, P., Siregar, I. A., & Dardanella, D. (2025). Digitalisasi pengelolaan data UMKM Milkshake Pakuan melalui sistem database. Jurnal Sains Terapan Sekolah Vokasi, 3(1), 73–83. https://doi.org/10.29244/jstrsv.3.1.73-83

Downloads

Published

2026-01-18

How to Cite

Iskandar Itan, & Alvina Alvina. (2026). Implementasi Sistem Akuntansi Berbasis Microsoft Access pada UMKM Blue Wash. KREATIF: Jurnal Pengabdian Masyarakat Nusantara, 6(1), 289–300. https://doi.org/10.55606/kreatif.v6i1.10128