OPTIMALISASI PENGELOLAAN KAS RT BERBASIS DIGITAL MELALUI PELATIHAN DAN PENDAMPINGAN MICROSOFT EXCEL PADA RT 04/RW 04 BAMBU KUNING BATAM
DOI:
https://doi.org/10.37296/jpi.v8i1.551Keywords:
Digital Financial Management, Microsoft Excel, Community Service Program, Neighborhood Association (RT), Financial AccountabilityAbstract
Orderly and transparent financial management of Neighborhood Associations (Rukun Tetangga/RT) is an essential factor in supporting accountability in community fund management. One of the common challenges faced by RT administrators is the continued use of manual cash-book recording systems, which may lead to recording errors, data loss, and delays in preparing financial reports. This Community Service Program (PKM) aimed to optimize digital-based RT cash management through training and mentoring on the use of Microsoft Excel for the administrators of RT 04/RW 04, Bambu Kuning, Batam. The implementation methods included initial observation, socialization, training sessions, hands-on practice, and continuous mentoring. The training materials covered the creation of digital cash books, recording of cash inflows and outflows, the application of basic Microsoft Excel formulas, and the preparation of automated cash reports. The results demonstrated an improvement in participants’ knowledge and skills in managing RT finances digitally. After participating in the program, the participants were able to record financial transactions and independently generate cash reports using Microsoft Excel. This activity had a positive impact on enhancing the efficiency of financial administration, simplifying report preparation, and promoting transparency and accountability in the management of RT funds.
References
Anugrah, P., & Dewi, C. (2025). PELATIHAN LITERASI KEUANGAN GUNA MENINGKATKAN. 9(1), 900–911.
Article, O. (2024). The Impact of Financial Literacy , Social Capital , and Financial Technology on Financial Inclusion of Indonesian Students. 3(4), 308–315. https://doi.org/10.56472/25835238/IRJEMS-V3I4P140
Azizah, I. U., Nuril, H., Rochmah, A., & Syarifudin, M. I. (2025). Upaya Peningkatan Literasi Keuangan Pelaku Usaha Mikro Melalui Pelatihan Pembukuan Dasar Dengan Metode Service Learning. 5(1), 37–46.
Csernoch, M., & Biró, P. (2017). Edu-Edition Spreadsheet Competency Framework. 1.
Dewi, C. S., Iskandar, Y., Matari, C., Mala, F., & Alam, P. (2025). Peningkatan Literasi Keuangan di Era Digital?: Edukasi dan Pendampingan Warga Kelurahan Sawah Baru. 4(02), 343–353. https://doi.org/10.58812/ejecs.v4i02
Kumiega, A. (2024). Excel?: Automated Ledger or Analytics IDE??
Nay, Y. A., Magdalena, C., Panie, A. A., Baso, P., Malut, M. G., Indrawati, A. S., Seran, M. I., Betu, K. W., & Suninono, A. R. (2025). Peningkatan Kapasitas Pengelolaan Keuangan UMKM melalui Pelatihan Akuntansi Keuangan Tersistematis. 5, 1068–1075.
Nirmala, V., Krisna, R., & Nasri, I. (2025). Jurnal Pengabdian Masyarakat Bidang Sosial dan Humaniora Pelatihan Manajemen Keuangan Pribadi Menggunakan Microsoft Excel. 4(2), 269–275. https://doi.org/10.55123/abdisoshum.v4i2.5645
Rofi, M., Huda, N., Gani, A. N., & Maulana, A. Y. (2025). Peningkatan Literasi Tata Kelola Administrasi Keuangan Masjid. 6, 1691–1699.
Trenggalek, K., & Cahyono, T. A. (2025). Penguatan Tata Kelola Keuangan Karang Taruna melalui Pelatihan Sistem Pencatatan Kas Digital Berbasis Microsoft Excel di Dusun. 3(6), 2780–2786.
Tuwohingide, D., Sakur, S., Sinsu, N., Negeri, P., Utara, N., Desa, M. U., & Rivan, M. (2025). PEMANFAATAN MICROSOFT EXCEL UNTUK PERENCANAAN. 3(2), 413–418.
Ulansari, R., Hartanto, S. R., Kuramadan, T., & Prayogo, A. (n.d.). Pelatihan Pembuatan Laporan Keuangan menggunakan Microsoft Excel Bagi Generasi Milenial. 1–8.
