Optimalisasi Pengelolaan Keuangan UMKM melalui Digitalisasi Pencatatan Transaksi Harian
DOI:
https://doi.org/10.33394/jpu.v6i3.16219Keywords:
MSMEs, financial digitization, financial management, daily bookkeeping, Microsoft ExcelAbstract
This community service program aims to improve financial literacy and technical skills of MSME actors in recording daily transactions using the Microsoft Excel application. The program employed a participatory approach through three main stages: preparation, implementation, and evaluation. The partner for this activity was Happy Fresh Frozen Food, Bogor Branch, an MSME that previously lacked a structured and sustainable financial recording system. The stages of the program included initial coordination and development of training materials, technical training on the use of Microsoft Excel accompanied by transaction recording simulations, and evaluation through observation, discussion, and post-tests analyzed using descriptive qualitative methods. The results of the program indicated that business owners began to understand the importance of transaction recording, are able to use the provided Microsoft Excel templates, and have demonstrated increased discipline in financial documentation. These findings suggest that simple digital tools can serve as transformative solutions for MSMEs in building effective and independent financial administration systems. Furthermore, the program contributes to fostering a culture of financial discipline and prepares MSMEs to face future business formalization challenges.
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). https://doi.org/10.55266/pkmradisi.v3i2.308
Candra, H., Hidayatullah, S., Adilani, R., Safitri, D., & Salsabilah, A. D. (2024). IMPLEMENTASI SAK-EMKM BERBASIS MS. EXCEL TERHADAP LAPORAN KEUANGAN UMKM (STUDI KASUS PADA PETANI TOGE DI PULAU BINTAN–KEPULAUAN RIAU). JURNAL LENTERA BISNIS, 13(3), 1759-1772.
Herawati, N. T., Kurniawan, P. S., Sujana, E., Dewi, P. E. D. M., & Dewi, L. G. K. (2019). Pemanfaatan Financial Technology Dalam Pengelolaan Keuangan Usaha Mikro Dan Kecil. CARADDE: Jurnal Pengabdian Kepada Masyarakat, 2(2). https://doi.org/10.31960/caradde.v2i2.281
Kania, E., & Irawan, A. (2021). Penyusunan Laporan Keuangan Berdasarkan SAK EMKM Berbantuan Microsoft Excel Pada UMKM Uncal.Co. Indonesian Accounting Literacy Journal, 1(2).
Kementerian Koperasi dan UKM. (2022). Statistik UMKM Indonesia. Jakarta: Kemenkop UKM.
Mahdi, M. I. (2022). Berapa Jumlah UMKM di Indonesia? Data Indonesia.Id. https://dataindonesia.id/sektor-riil/detail/berapa-jumlah-umkm-di-indonesia
Marheni, M., Ulyah, H., & Rizki, R. (2022). Pelatihan SIAPIK Berbasis Android untuk Mengoptimalisasi Pengelolaan Keuangan UMKM Syariah di Kabupaten Bangka. Jurnal Pengabdian UNDIKMA, 3(3), 538-545.
Martono, A., Septiani, D., & Yuwono, A. S. (2022). PENERAPAN STRATEGI PEMASARAN UNTUK MENINGKATKAN KINERJA PENJUALAN NASI KEBULI INSTAN HENAYU FOODS KHUSUSNYA DI MASA PANDEMI COVID-19. Jurnal Abdikaryasakti, 2(1), 25–44. https://www.trijurnal.trisakti.ac.id/index.php/abdisakti/article/view/9322
Novita, S. M., & Wulanditya, P. (2020). Desain Microsoft Excel For Accounting Bagi Umkm (Studi Kasus Pada Ls Farm Mojokerto). Jurnal Riset Terapan Akuntansi, 4(2).
Pantow, A., Ivoletti M. Walukow, Christony Maradesa, & Esrie A. N. Limpeleh. (2021). DESAIN LAPORAN KEUANGAN UMKM BERBASIS MICROSOFT EXCEL PADA SUNSHINE LAUNDRY. Jurnal Bisnis Terapan, 5(2). https://doi.org/10.24123/jbt.v5i2.4693
Raharja, S. J., & Natari, S. U. (2021). PENGEMBANGAN USAHA UMKM DI MASA PANDEMI MELALUI OPTIMALISASI PENGGUNAAN DAN PENGELOLAAN MEDIA DIGITAL. Kumawula: Jurnal Pengabdian Kepada Masyarakat, 4(1). https://doi.org/10.24198/kumawula.v4i1.32361
Saragih, M. R., Sutandijo, S., Septiani, D., Abidin, J., & Ferdiansyah, F. (2021, January). PENDAMPINGAN PENYUSUNAN LAPORAN KEUANGAN BERBASIS EMKM MELALUI SI-APIK. InPROSIDING SENANTIAS: Seminar Nasional Hasil Penelitian dan Pengabdian kepadaMasyarakat (Vol. 1, No. 1, pp. 1459-1464).
Septiani, D., Ferdiansyah, F., & Sunarto, S. (2025). Desain Laporan Keuangan UMKM Berbasis Microsoft Excel. KUAT: Keuangan Umum dan Akuntansi Terapan, 7(1), 51-56.
Silvita, F., Avianto, A. R., Safitri, N., Fikriyah, A., Damayanty, P., Dharma, D. A., & Noveliza, D. (2020). Pendampingan Penyusunan Laporan Keuangan Standar Akuntansi Keuangan Entitas Mikro Kecil Dan Menengah (SAK EMKM) Pada Usaha Mikro Kecil Menengah RAPIIN.CO. Jurnal Pengabdian Teratai, 1(2). https://doi.org/10.55122/teratai.v1i2.112
Vidyasari, R., & * F. (2022). Komputerisasi Pencatatan Akuntansi dan Pelaporan Keuangan berbasis Microsoft Excel pada UMKM Umita Food and Drink. Account, 9(1). https://doi.org/10.32722/acc.v9i1.4589
Downloads
Published
How to Cite
Issue
Section
Citation Check
License
Copyright (c) 2025 The Author(s)
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (CC BY-SA 4.0) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
