Pemahaman dan Implementasi Pencatatan Keuangan Digital pada KWT Berbasis Google Form dan Spreadsheet
DOI:
https://doi.org/10.62710/ktmcsz73Keywords:
Digital Readiness, Financial Literacy, Google Spreadsheet, Participatory Action Research, Women Farmer GroupAbstract
This community service activity aims to enhance financial literacy and digital readiness among micro, small, and medium enterprise (MSME) actors in the Women Farmer Group (KWT) Amanah, Bantul, Yogyakarta. The program focused on introducing a simple digital financial recording system using Google Form and Google Spreadsheet. The method employed was a Participatory Action Research (PAR) approach, involving 32 participants consisting of KWT members and village representatives. The implementation included three stages: preparation, execution through interactive counseling and hands-on training, and evaluation using pre-test and post-test instruments. The evaluation was based on several constructs, including financial recording behavior, digital readiness, perceived usefulness, financial self-efficacy, and user satisfaction. The results indicate that participants had a basic understanding of financial recording prior to the program but lacked consistency in practice. After the intervention, there was a significant improvement in financial self-efficacy, with an average score of 4.00, indicating increased confidence in managing financial records. However, perceived usefulness related to ease of use remained relatively low (2.00–3.00), suggesting that participants were still in the early stage of technology adoption. Overall, the program was moderately to highly successful in improving participants’ understanding and readiness toward digital financial management. The findings highlight the importance of continuous assistance to strengthen technical skills and ensure sustainable implementation of digital systems in community-based enterprises.
Downloads
References
Andari, A. T., Setianingsih, N. A., Asmoro, W. K., Cinderatama, T. A., & Putranti, E. (2022). Pengembangan pencatatan laporan keuangan umkm berbasis teknologi informasi. Jurnal Pengabdian pada Masyarakat Ilmu Pengetahuan dan Teknologi Terintegrasi, 7(1), 11–22. https://doi.org/10.33795/jindeks.v7i1.374
Bandura, A. (1990). Perceived self-efficacy in the exercise of personal agency. Journal of Applied Sport Psychology, 2(2), 128–163. https://doi.org/10.1080/10413209008406426
Barney, J. (1991). Firm resources and sustained competitive advantage. Journal of Management, 17(1), 99–120. https://doi.org/10.1177/014920639101700108
Bina, N. S., Ramadhani, R., & Sari, I. P. (2023). Implementasi google spreadsheet dalam pengelolaan matematika keuangan bagi paguyuban SD swasta Darul Ilmi Murni. Reswara: Jurnal Pengabdian Kepada Masyarakat, 4(1), 741–752. https://doi.org/10.46576/rjpkm.v4i1.2600
Dasril, O., Marsyah, F., Syukriani, L., Rosadi, F. N., & Sary, A. N. (2025). Optimalisasi peran wanita dalam meningkatkan gizi dan kesehatan masyarakat melalui pangan lokal pada kelompok wanita tani. Jurnal Kreativitas Pengabdian Kepada Masyarakat (PKM), 8(12), 6226–6242. https://doi.org/10.33024/jkpm.v8i12.23482
Davis, F. D. (1989). Perceived usefulness, perceived ease of use, and user acceptance of information technology. MIS Quarterly, 13(3), 319–340. https://doi.org/10.2307/249008
Hofstedt, T. R. (1972). Some behavioral parameters of financial analysis. The Accounting Review, 47(4), 679–692. https://www.jstor.org/stable/245331
Ihsan, O. M., Haddina, E., Sayhputra, F., & Astuti, E. (2025). Pelatihan meningkatkan efisien pengolahan data administrasi berbasis google spreadsheet pada guru SMK. Abdimas Iptek, 5(1), 84–90. https://doi.org/10.53513/abdi.v5i1.10585
Jiang, J. (2024). A study on the digital transformation trends in financial management for small and micro enterprises. International Journal of Global Economics and Management, 3(1), 355–363. https://doi.org/10.62051/IJGEM.v3n1.42
Juliana, D. K. A., Aulias, M. A., Pratiwi, A. I., & Ramadhani, S. N., (2025). Penerapan pencatatan keuangan sederhana menggunakan aplikasi digital google spreadsheet dalam meningkatkan efisiensi administrasi keuangan pada umkm pembuatan tahu 5 bersaudara di desa Bakaran Batu. Jurnal Administrasi Dan Perkantoran Modern, 14(1), 1–7. https://doi.org/10.24114/judika.v14i1.69704
Kahfi, A., Oktaviani, Y., Fadilah, N., & Mahmudi, I. (2024). Transformasi pemberdayaan ekonomi perempuan: Strategi pemberdayaan kelompok wanita tani berbasis ekonomi Islam di Desa Sri Bandung, Banyuasin. Jurnal Hukum Ekonomi Syariah : Aiconomia, 3(2), 107–121. https://doi.org/10.32939/acm.v3i2.4366
Kurniawati, S. B., Ashari, D. S., Ambarwati, R., Setiawan, F. B., & Sultan, M. (2026). Pemberdayaan kelompok wanita tani (KWT) melalui implementasi teknologi tepat guna untuk meningkatkan produktivitas pertanian dan membangun ketahanan pangan. Proficio, 7(1), 1077–1083. https://doi.org/10.36728/jpf.v7i1.6063
Larasati, K. A., Kurniawan, D., & Sumaryanto. (2025). Transformasi digital untuk meningkatkan akurasi dan efisiensi pencatatan UMKM. Jurnal Padamu Negeri, 2(2), 114–119. https://doi.org/10.69714/88xqhb57
Luthfitah, D. A. S., Nurhadi, N., & Parahita, B. N. (2023). Pemberdayaan perempuan melalui kelompok wanita tani di kecamatan Sukoharjo. Jurnal Sosiologi Agama Indonesia (JSAI), 4(3), 446–463. https://doi.org/10.22373/jsai.v4i3.3927
Muhammad, R., Hendriyana, H., & Ardimansyah, M. I. (2020). Penerapan google spreadsheet dalam pembuatan laporan keuangan untuk pengembangan usaha UMKM kota Bandung. Ikra-Ith Abdimas, 3(1), 101–106. https://journals.upi-yai.ac.id/index.php/IKRAITH-ABDIMAS/article/view/541
Nainggolan, Y. T., Farisa, A., Muti’ah, H. Al, Isnaeni, R., & Setiawan, M. (2025). Digitalisasi pencatatan keuangan dan laporan keuangan pada UMKM kopi 76 dengan microsoft excel. Jurnal Pengabdian Masyarakat Khatulistiwa, 8(1), 57–64. https://doi.org/10.31932/jpmk.v8i1.4767
Novita, W., Fitriadi, Y., Nopiana, P. R., & Gusnafitri. (2023). Pelatihan laporan keuangan dengan google spreadsheet dalam rangka meningkatkan pengetahuan UMKM. Abdisoshum: Jurnal Pengabdian Masyarakat Bidang Sosial Dan Humaniora, 2(2), 217–225. https://doi.org/10.55123/abdisoshum.v2i2.2052
Parasuraman, A. (2000). Technology readiness index (Tri). Journal of Service Research, 2(4), 307–320. https://doi.org/10.1177/109467050024001
Petras, E. M., & Porpora, D. V. (1993). Participatory research: Three models and an analysis. The American Sociologist, 24(1), 107–126. https://doi.org/10.1007/BF02691948
Przychocka, I., & Sikorski, M. (2024). Revolutionizing SME management: The digital transformation of financial operations. European Research Studies Journal, XXVII(2), 78–85. https://doi.org/10.35808/ersj/3372
Rahmat, A., & Mirnawati, M. (2020). Model participation action research dalam pemberdayaan masyarakat. Aksara: Jurnal Ilmu Pendidikan Nonformal, 6(1), 62–71. https://doi.org/10.37905/aksara.6.1.62-71.2020
Sa’idah, F., Nasruddin, & Madnasir. (2023). Peran serta kelompok wanita tani dalam meningkatkan ekonomi keluarga dengan pemanfaatan lahan pekarangan berbasis green economy. Jurnal Informatika Ekonomi Bisnis, 5(3), 937–942. https://doi.org/10.37034/infeb.v5i3.548
Sarti, Purwandari, I., & Listiyani. (2024). Peran wanita tani dalam meningkatkan perekonomian keluarga (Studi kasus kelompok wanita tani (KWT) Bumi Lestari). Agrifitia : Journal of Agribusiness Plantation, 4(2), 136–145. https://doi.org/10.55180/aft.v4i2.1070
Sayekti, A., Sastrawan, U., Kuntari, W., Wana, H., & Adila, J. Z. (2026). Peningkatan kapasitas KWT Ciharashas melalui pelatihan branding, keuangan sederhana, dan digital marketing berbasis teknologi digital. Abdi Moestopo: Jurnal Pengabdian Pada Masyarakat, 9(1), 164–174. https://doi.org/10.32509/abdimoestopo.v9i1.6287
Sianturi, F. A., & Sianturi, R. L. (2025). Optimalisasi pembukuan UMKM melalui aplikasi excel dan google sheets. Jurnal Edukasi Dan Abdi Generasi, 1(1), 13–18. https://loddosinstitute.org/journal/index.php/JEAG/article/view/219
Tezar, M., & Julianto, J. (2022). Rancangan aplikasi sistem pelaporan keuangan berbasis google spreadsheet untuk usaha mikro kecil dan menengah (UMKM) CV Wira Gemilang. JURSIMA, 10(3), 17–24. https://doi.org/10.47024/js.v10i3.507
Van Campenhout, G. (2015). Revaluing the role of parents as financial socialization agents in youth financial literacy programs. Journal of Consumer Affairs, 49(1), 186–222. https://doi.org/10.1111/joca.12064
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Yudi Siyamto, Eka Yulianta, Yuliantoharinugroho Yuliantoharinugroho, Cinthia Mutiara Hapsari, Wilis Fahlefi (Author)
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
