Penerapan Dashboard Keuangan Berbasis Spreadsheet untuk Monitoring Kinerja UMKM: Konveksi Eva-Evi

Muhammad Rizqi Fahriza, Sherena Wahyutari, Dika Puspitaningrum, Nadhia Citra

Abstract


This community service activity aims to help the Eva-Evi Convection MSME improve its financial management capabilities through the implementation of a spreadsheet-based financial dashboard. The main problems faced by partners are manual, unstructured financial records, and the mixing of business and personal finances, making it difficult to monitor business conditions. The method used is a needs-based participatory approach through the stages of problem identification, designing a Google Sheets-based financial dashboard, training in spreadsheet usage, implementation assistance, and monitoring and evaluation. The results of the activity show that partners are able to understand the basic concepts of financial management, record transactions more systematically, and utilize the dashboard to integrate income, expenses, and business profits. The implementation of this dashboard is considered effective in supporting more appropriate business decision-making and has the potential to become a simple digitalization model for other MSMEs.


Keywords


MSMEs, financial dashboards, spreadsheets, financial literacy, business digitalization.

Full Text:

PDF

References


Asih, F., & Anton, A. (2026). Akuntansi Digital Berbasis Spreadsheet Dalam Proses Pencatatan Keuangan Untuk Meningkatkan Pengendalian Internal. Balance : Jurnal Akuntansi Dan Manajemen, 5(1), 315–324. https://doi.org/https://doi.org/10.59086/jam.v5i1.1374

Fikriadi, I., & Herawansyah. (2025). Pengaruh Literasi Keuangan, Sikap Keuangan, dan Penggunaan Software Sistem Informasi Akuntansi Terhadap Kinerja UMKM. Ekonomi, Keuangan, Investasi Dan Syariah (EKUITAS), 7(2), 503–512. https://doi.org/10.47065/ekuitas.v7i2.8307

Halwa, J. B. W., Verdiansyah, N. M., Andarini, S., & Kusumasari, I. R. (2025). Penerapan Spreadsheet Otomatis dalam Transformasi Digital pada Usaha Persewaan Alat Outdoor: Say Equipment’s. Journal Pemberdayaan Ekonomi Dan Masyarakat, 2(3), 1–13. https://doi.org/https://doi.org/10.47134/jpem.v2i3.735

Hanafi, A., & Ginting, N. (2024). Pemberdayaan UMKM melalui Pelatihan Kewirausahaan dan Manajemen Keuangan. Jurnal Pengabdian Masyarakat Mentari, 1(3). https://doi.org/https://doi.org/10.59837/jpmm.v1i3.17

Inuzula, L., Ginting, E. F., & Andriyani, S. (2025). Digitalisasi Pencatatan Keuangan Berbasis Fintech: Akurasi dan Efisiensi Pelaporan Keuangan UMKM. Journal of Business and Economics Research (JBE), 6(3), 968–978. https://doi.org/10.47065/jbe.v6i3.8505

Kementerian Koperasi dan UKM. (2023). Laporan Kinerja Kementerian Koperasi dan UKM 2022. Kementerian Koperasi Dan UKM.

Otoritas Jasa Keuangan. (2022). Infografis Hasil Survei Nasional Literasi dan Inklusi Keuangan Tahun 2022. Otoritas Jasa Keuangan. https://ojk.go.id/id/berita-dan-kegiatan/info-terkini/Pages/Infografis-Survei-Nasional-Literasi-dan-Inklusi-Keuangan-Tahun-2022.aspx

Prasetianingrum, S., Pasolo, M. R., & Moewo, F. (2025). Akuntansi dalam Transisi: Adaptasi Digital dalam Penyusunan Laporan Keuangan Usaha Mikro Kecil dan Menengah. Sanskara Ekonomi Dan Kewirausahaan, 4(01), 15–25. https://doi.org/10.58812/sek.v4i01

Puspitaningrum, D., & Andaru, F. M. (2025). Pendampingan Implementasi Software Akuntansi ESB pada UMKM Minoa Coffee and Eatery, Boyolali. DIMASETA Jurnal Pengabdian Masyarakat, 04(1), 9–16. https://doi.org/https://doi.org/10.56456/dimaseta.v4i1.161

Qomariyah, N., & Gunawan, A. (2025). Sistem Akuntansi Berbasis Google Sheets Sebagai Solusi Pengelolaan Keuangan Kedai Mikaba. ENGAGEMENT: Jurnal Pengabdian Masyarakat, 4(4), 292–297. https://doi.org/https://doi.org/10.58355/engagement.v4i4.183 Vol.

Ramadhan, D. R., Ramadhani, S., & Rambe, R. (2025). UMKM: DEFINISI, KARAKTERISTIK, DAN KONTRIBUSI EKONOMI. EKONOM : JURNAL EKONOMI DAN BISNIS, 5(3).

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/146

Syamsul, Rosyada, D., & Kuswaniwati, T. (2023). Literasi Keuangan UMKM: Ditinjau Dari Aspek Pengetahuan Keuangan, Lembaga Keuangan, dan Teknologi Keuangan. Liabilities Jurnal Pendidikan Akuntansi, 2(2).

Triono, B., Hamzah, Y. S., & Shaleh, M. (2024). Peningkatan Pemahaman Masyarakat melalui Sosialisasi Teknologi Tepat Guna Berbasis Kebutuhan Lokal. FUNDAMENTUM : Jurnal Pengabdian Multidisiplin, 2(2), 42–52. https://doi.org/https://doi.org/10.62383/fundamentum.v2i2.1625

Yazid, M. H. (2025). Mengurai Hubungan Literasi Keuangan dan Pembiayaan UMKM: Studi Kasus ‎Transformasi Ekonomi Mikro. Journal of Sharia Economics, Banking and Accounting, 2(2), 79–92. https://doi.org/10.52620/jseba.v2i2.175

Yolanda, C., & Hasanah, U. (2024). Peran Usaha Mikro, Kecil Dan Menengah (UMKM) Dalam Pengembangan Ekonomi Indonesia. Jurnal Manajemen Dan Bisnis, 2(3), 170–186. https://doi.org/10.36490/jmdb.v2i3.1147




DOI: https://doi.org/10.31004/abdira.v6i3.2055

Refbacks

  • There are currently no refbacks.


Copyright (c) 2026 Sherena Wahyutari, Dika Puspitaningrum, Nadhia Citra

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.