Pengembangan Sistem Pencatatan Keuangan Otomatis Kelompok Sadar Wisata (Pokdarwis) Berbasis Microsoft Excel
DOI:
https://doi.org/10.32487/jshp.v10i1.2895Keywords:
Participatory Action Research, bookkeeping , accounting information systems , digitalizationAbstract
While transactions continue to flow as operations progress, digitalization continues to be encouraged in Tourism Group operational activities, including accounting processes. However, many Toursm Group still rely on manual recording, and accounting information disclosure remains largely unstandardized. This research aims to design and develop a spreadsheet-based automated financial recording system with Microsoft Excel for Tourism Group (pokdarwis). This research is a Research and Development (R&D) study with a Participatory Action Research (PAR) approach. The results give the understanding that flexibility in recording, coupled with features that automatically process financial transactions to produce digital financial reports, provides beneficial benefits due to the ease of use and accelerated data processing. Pokdarwis fosters a sense of ownership as the system is implemented. The desire to learn about the system also becomes a factor for human resources adopting the system, regardless of its usefulness and ease of use. However, device availability is a limitation in system implementation, and accounting skills have also become a hindering factor in digital financial bookkeeping transformation.
References
Abdullah, A., & Kurniawan, R. (2021). Perancangan Sistem Informasi Akuntansi Desa Wisata Pentingsari Menggunakan Metode Prototyping. Automata, 7. https://journal.uii.ac.id/AUTOMATA/article/view/17340
Achadiyah, B. N. (2019). Otomatisasi Pencatatan Akuntansi Pada Umkm. Jurnal Akuntansi Multiparadigma, 10(1). https://doi.org/10.18202/jamal.2019.04.10011
Agus Salim, H., & Halim, A. (2025). Inovasi Pembukuan Digital UMKM Dengan Integrasi Appsheet Dan Google Spreadsheet. JATI (Jurnal Mahasiswa Teknik Informatika), 9(2), 2497–2505.
Ajzen I. & Fishbein M. (1980). Understanding Attitudes and Predicting Social Behavior. Prentice-Hall.
Andi Candra, Y. T., & Paramitalaksmi, R. (2024). Pelatihan Pembuatan Laporan Keuangan Sederhana Untuk Pokdarwis Jonge Raya Dengan Aplikasi SIAPIK. Jurnal Pengabdian Kepada Masyarakat Nusantara, 5(1), 551–557. https://doi.org/10.55338/jpkmn.v5i1.2656
Aris, V. (2015). Pengaruh Persepsi Kegunaan Dan Ketersediaan Teknologi Informasi Terhadap Penerimaan Penggunaan Internet Pada STISIP Veteran Palopo. 02(01), 51–62.
Badan Pusat Statistik Indonesia. (2023). Tren Kontribusi Industri Pariwisata Indonesia terhadap Produk Domestik Bruto (PDB) Nasional Tahun 2016-2023. https://kemenpar.go.id/direktori-statistik/perkembangan-tourism-satellite-account-indonesia-tahun-2023
Cookson, M. D., & Stirk, P. M. R. (2019). Has Excel Become a “Golden Hammer”: The Paradox of Data Analytics in SME Clusters. 2018, 2021.
Fauzi, Rahmayana, L., Wulandari, I., & Sugiharto, B. H. (2023). Mengapa Digitalisasi Akuntasi Harus di Lakukan Pada Perusahaan UMKM : Sebuah Tinajaun Pustaka. JURNAL AKTIVA : RISET AKUNTANSI DAN KEUANGAN, 5(1), 43–56.
Fred D. Davis, J. (1980). A Technology Acceptance Model For Empirically Testing New End-User Information Systems: Theory And Results. Science, 146(3652), 1648–1655. https://doi.org/10.1126/science.146.3652.1648
Hamzah, A. A. (2012). Pengaruh Tampilan Visual Terhadap Motivasi Belajar Berdasarkan Kategori Website E-Learning. Seminar Nasional Aplikasi Teknologi Informasi 2012 (SNATI 2012), 2(10), 40132.
Hapsari, A. D., Wasiyanti, S., & Widiastuti, L. (2024). Implementasi Pencatatan Laporan Keuangan Menggunakan Zahir Accounting Versi 6 Pada Toko Yeni Cibareno. Artikel Ilmiah Sistem Informasi Akuntansi (AKASIA), 4(2), 33–37. https://doi.org/https://doi.org/10.31294/akasia.v4i2.5765
Hidayatullah, S., Rachmawati, I. K., & Khouroh, U. (2017). The Effectivity of “ Pokdarwis ” Role on Successfully Marketing of Tourism Village Towards “ Mega Tourism : Batu City For The World .” International Conference “Sustainable Development Goals 2030 Challenges and Its Solutions", August, 978–979. http://jurnal.unmer.ac.id/index.php/sdgs/article/view/1849
Iksan, C., Amran, Abdi, M. N., & Burhanuddin. (2022). Urgensi Digitalisasi Terhadap Stabilitas Sistem Keuangan Di Indonesia. 19(1), 91–100.
Kamil, I. (2020). Pengaruh Kemampuan Financial , Kemudahan Dan Keamanan Terhadap Perilaku Sistem Penggunaan Financial Technology. Al-Mal: JurnalAkuntansi Dan Keuangan Islam, 01(02), 185–209.
Lune, H., & Berg, B. L. (2017). Methods for the Social Sciences Global Edition.
Maharani, T. S., Hidayati, A. N., & Habib, M. A. F. (2022). Peran Pokdarwis Dewi Arum Pulosari Dalam Peningkatan Ekonomi Masyarakat Desa Wisata Pandean Berbasis Bisnis Kreatif. Fair Value : Jurnal Ilmiah Akuntansi Dan Keuangan, 4(10), 4581–4587.
Makuta, V. P., & Saridawati. (2025). Evaluasi Penerapan Sistem Pembukuan Manual dalam Penyusunan Laporan Keuangan pada PT Javindo Utama Tahun 2022-2024. Jurnal Ekonomi, Manajemen Pariwisata Dan Perhotelan, 4(2), 676–691.
Miftah, M., & Febri Sukmawati. (2020). Digitalisasi Akuntansi Pengelolaan Keuangan Dengan Metode Accrual Basis Pada Klinik As Shifa Kendal. Kompak :Jurnal Ilmiah Komputerisasi Akuntansi, 13(1), 47–62. https://doi.org/10.51903/kompak.v13i1.156
Mutmainah, M., Nadiar, R., & Alfikri, R. (2025). The Role of Digital Transformation in Managerial Accounting Practices: Empirical Study of Indonesian Companies. EL MUHASABA: Jurnal Akuntansi (e-Journal), 16(2), 185–198. https://doi.org/10.18860/em.v16i2.33221
Pardede, J. F., Nugroho, L., & Hidayah, N. (2024). Analisa Urgensi Digitalisasi Dan Laporan Keuangan Bagi UMKM. Jurnal Cakrawala Ilmiah, 2(4), 1531–1542.
Pemerintah Indonesia. (2021). Peraturan Pemerintah Republik Indonesia Nomor 07 Tahun 2021 tentang Kemudahan, Pelindungan, dan Pemberdayaan Koperasi dan Usaha Mikro, Kecil, dan Menengah. 086507, 1–121.
Pratiwi, O. A., & Putranto, R. S. (2025). Analisis Pencatatan Penjualan pada Toko WJS Berbasis Microsoft Excel. Journal of Artificial Intelligence and Digital Business (RIGGS), 4(2), 1726–1730. https://doi.org/https://doi.org/10.31004/riggs.v4i2.728
Purnamawati, I. G. A., Herliyani, E., Permana, A. A. J., Nugraha, I. G. B. B., & Sudhana, I. G. P. F. P. (2024). Peningkatan Value Added Sentra Kerajinan Tenun Ikat Endek dengan Penerapan Smart Ecodigital. Jurnal Pengabdian Kepada Masyarakat Nusantara (JPkMN), 5(4), 5246–5252.
Ramadani, Y. D. (2024). Analisis Penerapan Akuntansi Berdasarkan SAK EMKM dengan Bantuan Penggunaaan Microsoft Excel (Studi Kasus Pada CV Etik Farm di Desa Purwoasri Kecamatan Gumukmas). Jurnal Ekonomi Dan Kewirausahaan West Science, 2(02), 240–272. https://doi.org/10.58812/jekws.v2i02.1123
Satria, M. R., & Fatmawati, A. P. (2021). Penyusunan Laporan Keuangan Perusahaan Menggunakan Aplikasi Spreadsheet. Fair Value: Jurnal Ilmiah Akuntansi Dan Keuangan, 3(2), 320–338. https://doi.org/10.32670/fairvalue.v3i2.146
Setiawan, E. (2021). Pemahaman Masyarakat Tentang Penerapan Akuntansi Pada Usaha Mikro Kecil dan Menengah (UMKM). JIMAT (Jurnal Ilmiah Mahasiswa Akuntansi), 12(02), 580–590.
Sholikudin, M., Nikmah, A. L., & Kustiwi, I. A. (2024). Peran Sistem Informasi Akuntansi Dalam Pemanfaatan Teknologi Terhadap Pembukuan Digital Pada UMKM Kampung Kue. MUQADDIMAH: Jurna Ekonomi, Manajemen, Akuntansi Dan Bisnis, 2(2), 61–72. https://doi.org/https://doi.org/10.59246/muqaddimah.v2i2.703
Suci, R. G., Azmi, Z., Marlina, E., Putri, A. A., Rodiah, S., & Azhari, I. P. (2021). Edukasi Akuntansi Dan Peningkatan Efektifitas Pelaporan Keuangan Bumdes Berbasis Excel For Accounting (EFA). COMSEP: Jurnal Pengabdian Kepada Masyarakat, 2(1), 72–77. https://doi.org/10.54951/comsep.v2i1.58
Suryaman, M., & Kusniadi, E. (2021). Pelatihan dan Pendampingan Digitalisasi Ekonomi Pada Usaha Mikro Kecil Menengah (UMKM) di Desa Cinunuk Kecamatan Cileunyi Kabupaten Bandung. Comserva …, 1(8), 1–11. https://doi.org/10.36418/comserva.v1i1.90
Suyudi, M., & Kusumah, A. (2025). Implementasi Sistem Informasi : Peran Microsoft Excel Dalam Praktik Akuntansi Pada SMK Negeri Tenggarong Kutai Kartanegara. JURNAL PENGABDIAN SOSIAL, 2(8), 3960–3978. https://doi.org/https://doi.org/10.59837/1xswym52
Ulfah, Y., Rahmawati, R., Arifin, Z., & Darma, D. C. (2024). Mengoptimalkan Bisnis Homestay melalui Pengelolaan Keuangan yang Inklusif—Lingkup POKDARWIS Desa Pela. Prima Abdika: Jurnal Pengabdian Masyarakat, 4(4), 648–658. https://doi.org/10.37478/abdika.v4i4.4617
Vidyasari, R., & Febriyan. (2022). Komputerisasi Pencatatan Akuntansi dan Pelaporan Keuangan berbasis Microsoft Excel pada UMKM Umita Food and Drink. Account, 9(1), 1655–1663. https://doi.org/10.32722/acc.v9i1.4589
Yahyasari, S. D., & As’ari, H. (2024). Pendampingan Pembukuan Keuangan Digital Dengan Aplikasi BukuWarung Bagi Para UMKM Di Teras Malioboro 1. Jurnal Pengabdian Kepada Masyarakat Nusantara (JPkMN), 5(2), 2801–2807. https://doi.org/http://doi.org/10.55338/jpkmn.v5i2.3383
Zulfah, I., Wahyuni, S., & Nurfaza, A. (2017). Pengaruh Sistem Informasi Akuntansi Terhadap Kualitas Laporan Keuangan Pada SKPD Kabupaten Aceh Utara. Jurnal Akuntansi Dan Pembangunan, 3(November), 46–57.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 JSHP : Jurnal Sosial Humaniora dan Pendidikan
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 of JSHP right of first publication with the work simultaneously licensed under Creative Commons Attribution License (CC BY-SA 4.0) that allows others to scopy and redistribute the material in any medium or format for any purpose, even commercially.
- 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).
