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

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

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



Article Info

Publish Date
27 Mar 2026

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.

Copyrights © 2025






Journal Info

Abbrev

jpm

Publisher

Subject

Agriculture, Biological Sciences & Forestry Economics, Econometrics & Finance Education Languange, Linguistic, Communication & Media Public Health Social Sciences

Description

GOTAVA : Jurnal Pengabdian Kepada Masyarakat merupakan jurnal nasional yang berisi hasil kegiatan pengabdian dan pemberdayaan masyarakat berupa penerapan berbagai bidang ilmu. Tujuan publikasi dalam jurnal ini adalah untuk menyebarluaskan pemikiran atau gagasan konseptual serta hasil penelitian yang ...