Pemberdayaan UMKM melalui Sosialisasi Pembukuan Sederhana Berbasis Microsoft Excel di Desa Ngrapah, Kecamatan Banyubiru, Kabupaten Semarang

https://doi.org/10.59891/jpmgotava.v3i2.37

Authors

  • Diva Ayu Imanda Sari Program Studi Akuntansi Perpajakan, Universitas Diponegoro
  • Tri Nurul Khomidah Program Studi Akuntansi Perpajakan, Universitas Diponegoro
  • Eiffeliena Nur A.F.P Program Studi Akuntansi Perpajakan, Universitas Diponegoro
  • Ibnu Muttaqin Program Studi Akuntansi Perpajakan, Universitas Diponegoro
  • Lindu Aji Santoso Program Studi Akuntansi Perpajakan, Universitas Diponegoro

Keywords:

Bookkeeping, community service, financial management, Microsoft Excel, MSMEs

Abstract

Micro, Small, and Medium Enterprises (MSMEs) play a strategic role in the local economy, including in Ngrapah Village, Banyubiru District, Semarang Regency. However, most MSME actors still face limitations in financial recording and bookkeeping, particularly in utilizing simple digital technologies such as Microsoft Excel. This community service activity aimed to improve the understanding and skills of MSME actors in preparing simple bookkeeping using Microsoft Excel to support more systematic and efficient financial management. The activity was conducted using a participatory approach through socialization sessions, hands-on practice, discussions, and individual mentoring supported by a simple bookkeeping module. The participants consisted of 30 individuals in Ngrapah Village. Evaluation was carried out using a pre-test and post-test approach. The results showed a significant improvement in participants’ understanding. Before the activity, 100% of participants did not understand business bookkeeping, whereas after the activity, 96.7% became highly knowledgeable and 3.3% were knowledgeable. In addition, 93.3% of participants demonstrated a high level of understanding in using Microsoft Excel for financial recording, and 90% stated that the activity was highly beneficial for their businesses. These findings indicate that socialization and mentoring on simple Excel-based bookkeeping are effective in improving accounting literacy and strengthening the financial management capacity of MSMEs in a sustainable manner.

References

Bongalonta, M. B., & Bongalonta, M. M. (2025). Training program for MSME owners: A needs assessment. International Journal of Multidisciplinary, 6(9), 4399–4405. https://doi.org/10.11594/ijmaber.06.09.15

Bo’ribayeva, S. A. (2025). Pecific features of improving lesson effectiveness. International Journal of Pedagogics, 5(6), 75–77. https://doi.org/10.37547/ijp/volume05issue06-22

Conner, M., McEachan, R. R. C., Lawton, R., & Gardner, P. (2017). Applying the reasoned action approach to understanding health protection and health risk behaviors. Social Science & Medicine, 195, 140–148. https://doi.org/10.1016/j.socscimed.2017.10.022

Irzavica, N., Gusti, K. W., Hadi, N. T., Wiryanto, F. S., & Muslim, M. (2025). Generate financial reports for micro, small and medium enterprises (MSMEs) using Microsoft Excel. International Journal of Community Service Learning, 9(2), 292–300. https://doi.org/10.23887/ijcsl.v9i2.90698

Kazanskaia, A. N. (2025). Evaluating workshop effectiveness: Methods for continuous improvement and stakeholder engagement. https://doi.org/10.64357/neya-gjnps-ds-eng-wsh-09

Nofiyanti, N., Fajrin, A. M., Kamar, K., Winanti, W., Asbari, M., & Farhan, A. (2025). Efektivitas Microsoft Excel dalam meningkatkan akurasi laporan keuangan: Studi literatur. Journal of Communication Education, 19(2), 10–16. https://doi.org/10.58217/joceip.v19i2.67

Novitasari, A. T., Pratikto, H., & Rahayu, W. P. (2024). Pengembangan modul bahan ajar berbasis website untuk meningkatkan hasil belajar pada materi mekanisme pasar. Research and Development Journal of Education, 10(1), 528. https://doi.org/10.30998/rdje.v10i1.23379

Sholikah, F. P., Iswanto, P., & Sumarni, N. (2023). Faktor-faktor kendala dalam pencatatan keuangan pada UMKM toko sembako. Journal of Trends Economics and Accounting Research. https://doi.org/10.47065/jtear.v4i1.879

Siregar, D. K., Sari, D. P., Pangestu, I. B. A., Pangestu, A. A. F., & Wahyuningrum, R. (2022). Menumbuhkan UMKM dengan pemanfaatan potensi desa. Jurnal Pengabdian Kepada Masyarakat. https://doi.org/10.56721/mulia.v1i2.76

Susilawati, M., Hermansyah, E. N., Majid, J., Fatmasari, R. K., & Ningrum, D. (2024). Effect of financial management training program on micro, small and medium enterprises (MSMEs) in area Y. Abdimas Indonesian Journal, 4(2), 831–838. https://doi.org/10.59525/aij.v4i2.545

Susilowati, E. N., & Wahyudi, A. (2023). Analysis of the implementation of digitalization of financial statements in micro, small, and medium enterprises. Open Access Indonesia Journal of Social Sciences. https://doi.org/10.37275/oaijss.v6i4.170

Triandi, T., & Agustin, M. (2020). Penggunaan Microsoft Excel dalam penyusunan laporan keuangan untuk meningkatkan kualitas informasi laporan keuangan. https://doi.org/10.37641/JIAKES.V2I1.100

Wahrini, R., & Hasbi, H. (2024). Financial bookkeeping training with Microsoft Excel for chicken farming UMKM in Parepare. Community. https://doi.org/10.61166/community.v3i1.74

Zainal, Z. (2024). The importance of financial management for companies. International Journal of Economics and Management Research, 3(1), 300–306. https://doi.org/10.55606/ijemr.v3i1.195

Published

2026-03-27

How to Cite

Sari, D. A. I., Khomidah, T. N., Nur A.F.P, E., Muttaqin, I., & Santoso, L. A. (2026). Pemberdayaan UMKM melalui Sosialisasi Pembukuan Sederhana Berbasis Microsoft Excel di Desa Ngrapah, Kecamatan Banyubiru, Kabupaten Semarang. GOTAVA, 3(2), 55–61. https://doi.org/10.59891/jpmgotava.v3i2.37

Issue

Vol. 3 No. 2 (2025): GOTAVA Jurnal Pengadian Kepada Masyarakat

Section

Community Service
Copyright & Licensing

Copyright (c) 2026 Diva Ayu Imanda Sari, Tri Nurul Khomidah, Eiffeliena Nur A.F.P, Ibnu Muttaqin, Lindu Aji Santoso

Creative Commons License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.