Optimizing the Financial Management of Jamil Donuts MSMEs through Simple Microsoft Excel-Based Bookkeeping in Kota Guring Village
DOI:
https://doi.org/10.36448/jpmtb.v5i1.173Keywords:
Bookkeeping, Excel, Finance, MSMEAbstract
Micro, Small, and Medium Enterprises (MSMEs) play a strategic role in Indonesia’s economy but still face challenges in financial management, particularly in maintaining systematic financial records. This issue is experienced by Jamil Donuts MSME in Kota Guring Village, which lacks structured bookkeeping and still mixes personal and business finances. This community service activity aims to optimize financial management through the implementation of simple bookkeeping based on Microsoft Excel. The method used is a participatory approach involving observation, training, mentoring, and evaluation. The results show an improvement in the owner’s understanding and skills in recording financial transactions, preparing simple financial reports, and using Microsoft Excel. In addition, financial records become more organized, systematic, and easier to monitor. Therefore, this activity effectively improves MSME financial management capabilities and supports better business decision-making.
Downloads
References
Adriyanto, A. T., Saddewisasi, W., & Prasetyo, A. (2023). Pelatihan Pembukuan Sederhana Berbasis Microsoft Excel Pada Usaha Mikro Kecil dan Menengah (UMKM) Kota Semarang. Jurnal Pengabdian kepada Masyarakat Radisi, 3(2), 46–52. https://doi.org/10.55266/pkmradisi.v3i2.308
Delima, A. A., Rohalia, G., Kurnia, R. D., & Lestari, W. P. (2025). Penerapan Strategi Pengelolaan Keuangan Berbasis Excel Bagi Pelaku UMKM Sempol Ayam Jooz Di Kota Bekasi Untuk Meningkatkan Keberlanjutan Bisnis. 02(01).
Hendra Candra, Syarif Hidayatullah, Reko Adilani, Dian Safitri, & Aura Diana Salsabilah. (2024). IMPLEMENTASI SAK-EMKM BERBASIS MS. EXCEL TERHADAP LAPORAN KEUANGAN UMKM (STUDI KASUS PADA PETANI TOGI DI PULAU BINTAN – KEPULAUAN RIAU). JURNAL LENTERA BISNIS, 13(3), 1759–1772. https://doi.org/10.34127/jrlab.v13i3.1221
Khodijah, S., & Sitha, N. S. (2025). Pelatihan Pencatatan Keuangan Sederhana Berbasis Excel Bagi Pelaku UMKM. 1(1).
Manoppo, A. R. A., Abdullah, P. A., Naru, S., Arsad, V. R., & Mohehu, F. (2026). PEMANFAATAN SISTEM INFORMASI AKUNTANSI DALAM PENGELOLAAN KEUANGAN PADA UMKM MINUMAN DI UNIVERSITAS NEGERI GORONTALO. 8(3).
Nofiyanti, Fajrin, A., Kamar, K., Winanti, W., Asbari, M., & Farhan, A. (2025). EFEKTIVITAS MICROSOFT EXCEL DALAM MENINGKATKAN AKURASI LAPORAN KEUANGAN: STUDI LITERATUR. joce-ip, 19(2), 10–16. https://doi.org/10.58217/joceip.v19i2.67
Septiani, D., Ferdiansyah, F., & Sunarto, S. (2025). Optimalisasi Pengelolaan Keuangan UMKM melalui Digitalisasi Pencatatan Transaksi Harian. Jurnal Pengabdian UNDIKMA, 6(3), 553–561. https://doi.org/10.33394/jpu.v6i3.16219
Setyoningsih, O., & Budiantara, M. (2025). Pendampingan Penerapan dan Penataan Pencatatan Keuangan pada UMKM Laundry dan UMKM Toko Online. Jurnal Pengabdian Masyarakat Bhinneka, 4(2), 2032–2038. https://doi.org/10.58266/jpmb.v4i2.740
Swissia, P., & Marshella, O. (2025). Peningkatan literasi digital dan manajemen keuangan untuk UMKM di Desa Trimulyo. Jurnal Pengabdian Masyarakat Tapis Berseri (JPMTB), 4(1), 85-91.
Swissia, P., & Marshella, O. (2025). Optimalisasi Potensi Desa Rawi Melalui Pembuatan Website Berbasis Teknologi Digital Dan Ekonomi Kreatif. Jurnal Pengabdian Masyarakat Tapis Berseri (JPMTB), 4(2), 172-179.
Triana, D., Ishak, A. A. A., Ridwan, M., Azwar, M. A., Aris, N. A., Firman, A. F., & Ramadhan, R. (2024). OPTIMALISASI PENGELOLAAN KEUANGAN USAHA MIKRO DI KOTA MAKASSAR.
Wicaksono, A. P. N. (2026). Peningkatan Kapasitas Pengelolaan Keuangan Man Anam Bale Dahar melalui Pelatihan Laporan Keuangan Berbasis Excel. 1(2).
Magdalena, B., & Yohanson, A. K. (2022). Pelatihan pencatatan laporan keuangan secara manual dan digital kepada pemilik UMKM Omah Tahu. Jurnal Pengabdian Kepada Masyarakat, 1(10), 2785-2792.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Firmansyah F, Winda Rika Lestari
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
Most read articles by the same author(s)
- Ary Meizary, Winda Rika Lestari, Nisar N, Design And Implementation Of The Website Of State Elementary School 1, Kota Guring As An Information And Communication Media , Jurnal Pengabdian Masyarakat Tapis Berseri (JPMTB): Vol. 4 No. 2 (2025): Jurnal Pengabdian Masyarakat Tapis Berseri (JPMTB) (Edition Oktober)
- Firmansyah F, Meliyanti, Utilizing Google Business Profile to Increase Access to Nda Gemoy Snack and Snack MSMEs , Jurnal Pengabdian Masyarakat Tapis Berseri (JPMTB): Vol. 4 No. 2 (2025): Jurnal Pengabdian Masyarakat Tapis Berseri (JPMTB) (Edition Oktober)
