Optimization of Financial Recording Practices in Micro, Small, and Medium Enterprises Through Excel-Based Community Assistance Program
Comparative Study at Boncu Dimsum, Papa Laundry, dan Rizqi Qua
DOI:
https://doi.org/10.37278/bhaktikaryadaninovatif.v6i1.1424Keywords:
MSMEs, Financial Recording, Microsoft Excel, Financial Literacy, Community ServiceAbstract
Micro, Small, and Medium Enterprises (MSMEs) contribute significantly to Indonesia’s economic growth; however, weak financial recording practices remain a persistent challenge. This Community Service Program aimed to optimize financial record-keeping in three MSMEs in Bandung City: Papa Laundry, Boncu Dimsum, and Rizqi Qua. The main issues identified included irregular transaction recording, incomplete financial documentation, limited accounting literacy, and minimal adoption of digital tools. The program was implemented through four stages: preliminary survey, memorandum of understanding, Excel-based financial mentoring, and reporting and evaluation. A standardized financial recording template was developed using Microsoft Excel with automated revenue, expense, and profit calculations. The results indicate improved discipline in daily transaction recording, enhanced financial awareness, and better understanding of profitability among business owners. Comparative analysis before and after mentoring demonstrates significant improvement in reporting structure and calculation accuracy. In addition to strengthening MSME financial management, the program also enhanced students’ practical competencies. The findings confirm that affordable and user-friendly technological tools can effectively improve financial management capacity and support MSME sustainability.
References
U. Tamansiswa, “Determinants of MSME Workers ’ Well-Being : A Structural Equation Modeling Approach,” vol. 14, no. 1, pp. 165–178, 2026, doi: 10.37641/jimkes.v14i1.4546.
A. Kurniadi, Sudarmiatin, and L. W. Wardana, “The Role of MSMEs in Local Economic Improvement and Labor Absorption in Indonesia,” Nusantara Economics and Entrepreneurships Journals, vol. 2, no. 3, pp. 333–341, 2024.
S. Banerjee, “Business, Management and Economics Engineering,” SSRN Electronic Journal, vol. 21, no. 02, pp. 819–835, 2024, doi: 10.2139/ssrn.4940597.
V. Adela et al., “Bookkeeping practices and SME performance: The intervening role of owners’ accounting skills,” Heliyon, vol. 10, no. 1, p. e23911, 2024, doi: 10.1016/j.heliyon.2023.e23911.
H. M. Al-Hattami, “The Impact of Digital Accounting Systems on Financial Performance in the Banking Sector: Advancements in the Digital Era,” International Journal of Intelligent Information Technologies, vol. 21, no. 1, pp. 1–19, 2025, doi: 10.4018/IJIIT.377599.
P. Padriyansyah and T. S. Pratiwi, “Analisis Penggunaan Microsoft Excel dalam Pembukuan Keuangan Perusahaan: Sebuah Kajian Literatur,” Jurnal Riset Manajemen dan Akuntansi, vol. 5, no. 1, pp. 256–268, 2025, doi: 10.55606/jurima.v5i1.5159.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Nabila Laila Dewi, Anike Putri, Faridah Kamila, Cahya Frassetiati, Desiana Dwi Setiana, Dina Azhari, Galuh Syawalu Zidan, Lulu Alifahsyahri, Putri Salsabila, Rudi Lesmana, Zahra Yuliyanti, Zihadi Dikri Muhlisin, Bagas Dwi Nugroho, Dimas Sukma Ardiansyah, Mitsal Abhan Paqih, Nabila Safitri Nurrahmah, Risma Handayani, Salma Auliyyah Yuliana, Tia Nuraeni, Zaleikha Nurkhansa Hazima
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
<
