Penerapan Digitalisasi Sederhana Berbasis Google Sheets Sebagai Solusi Pencatatan Stok Dan Distribusi UMKM Tienz
DOI:
https://doi.org/10.36526/tekiba.v6i2.8199Keywords:
Digitalization, MSMEs, Google Sheets, Stock Recording, DistributionAbstract
Tienz Nganjuk MSMEs face the challenge of managing distribution due to the absence of a stock and sales recording system, both manually and digitally. This condition causes owners to be unable to monitor stock in real-time, dificully identifyinh best-selling products, and unable to make data-driven decisions. This community service activity aims to implement a simple digital distribution recording system based on Google Sheets for Tienz MSMEs. The Participatory Action Research (PAR) method was applied through eight stages: observation, needs analysis, system design, development, socialization, training, mentoring, and evaluation. The developed system consists of three integrated modules: warehouse stock recording, sales orders, and sales reports. Implementation results show significant improvements: stock data is available in real-time through a dashboard, per-product sales reports are generated automatically, monthly recap time has been reduced to under 30 minutes, and data loss risk has decreased from high to low owing to cloud-based storage. User satisfaction reached a score of 4.2 out of 5. This activity demonstrates that SMEs with limited digital literacy are capable of effectively adopting digital recording technology, provided the platform is selected in accordance with users' capabilities and training is conducted in a practical and participatory manner.
References
[1] A. Anastasya, “Data UMKM, Jumlah dan Pertumbuhan Usaha Mikro, Kecil, dan Menengah di Indonesia,” UKMINDONESIA.ID. [Online]. Available: https://ukmindonesia.id/baca-deskripsi-posts/data-umkm-jumlah-dan-pertumbuhan-usaha-mikro-kecil-dan-menengah-di-indonesia
[2] Kadin Indonesia, Indonesian Chamber of Commerce and Industry, “UMKM Indonesia.” [Online]. Available: https://kadin.id/data-dan-statistik/umkm-indonesia/
[3] Pemerintah Kabupaten Nganjuk, “Dinkes Nganjuk Perkuat Pembinaan UMKM Pangan Lewat FGD P-IRT,” Nganjuk Smart City. [Online]. Available: https://api-nsc.nganjukkab.go.id/detail_berita/NjI1MA==
[4] M. P. Hakim, “Evaluasi Kinerja Keuangan UMKM Pasca-Pandemi: Studi Kasus pada Sektor Kuliner di Kota Bandung,” AKUA J. Akunt. dan Keuang., vol. 4, no. 2, pp. 181–188, 2025, doi: 10.54259/akua.v4i2.4288.
[5] E. Noviriani, L. Mukaromah, and S. Mulyati, “Naik Kelas Dengan Digitalisasi: Penyusunan Laporan Keuangan Umkm Menggunakan Aplikasi ‘SI APIK,’” JMM (Jurnal Masy. Mandiri), vol. 8, no. 1, pp. 65–75, 2024, doi: 10.31764/jmm.v8i1.19584.
[6] S. A. Ghiffari and J. Aryanto, “Digital Transformation of MSME Stock Management Through the Implementation of a Real-Time Mobile E-Inventory System Transformasi Digital Manajemen Stok UMKM Melalui Implementasi Sistem E-Inventory Mobile Real-Time,” MALCOM Indones. J. Mach. Learn. Comput. Sci., vol. 6, no. 1, pp. 11–22, 2026, doi: 10.57152/malcom.v6i1.2334.
[7] N. L. D. E. Trisnawati and K. Suryaningsih, “Sistem Pengelolaan Persediaan Barang Dagang Pada UMKM,” Akuntansi, Ekon. dan Manaj. Bisnis, vol. 5, no. 3, pp. 365–374, 2025, doi: 10.55606/jaemb.v5i3.7651.
[8] E. P. Pane and Afriansyah, “Analisis Dan Pengembangan Sistem Informasi Monitoring Penjualan Outlet Pada UMKM Melur Laris,” Zo. J. Sist. Inf., vol. 6, no. 3, pp. 584–593, 2024, doi: 10.31849/zn.v6i3.
[9] R. Ilyas and R. Hartono, Digitalisasi UMKM dan Pertumbuhan Ekonomi, Pertama. Bangka: Shiddiq Press: Gedung Terpadu IAIN SAS Bangka Belitung, 2023.
[10] B. Morisson and A. A. H. S. Fikri, “Digitalisasi UMKM sebagai Strategi Meningkatkan Daya Saing di Era Ekonomi Digital,” EBISNIS J. Ilm. Ekon. dan Bisnis, vol. 18, no. 1, pp. 289–299, 2025, doi: 10.51903/e-bisnis.v18i1.2215.
[11] G. Prabantoro, R. G. Mais, E. Lovita, A. Apandi, and I. Aprileny, “Digitalisasi UMKM Untuk Mendongkrak Produk Lokal dan Ekonomi Daerah Kepulauan Sangihe Sulawesi Utara,” J. Entrep. Community Innov., vol. 4, no. 2, pp. 40–46, 2026, doi: 10.33476/jeci.v4i2.430.
[12] E. Jayanti and N. B. Karnowati, “Digitalisasi Umkm Dan Literasi Keuangan Untuk Keberlanjutan Umkm Di Kabupaten Cilacap,” Kaji. Bisnis Sekol. Tinggi Ilmu Ekon. Widya Wiwaha, vol. 31, no. 1, pp. 51–64, 2023, doi: 10.32477/jkb.v31i1.504.
[13] A. Prayogi and M. I. Kirom, “Pendampingan Pengembangan Digitalisasi Umkm Masyarakat Desa Wonoyoso Pekalongan Menghadapi Era New Normal,” J. Pengabdi. Pendidik. Masy., vol. 3, no. 1, pp. 14–24, 2022, doi: 10.52060/jppm.v3i1.652.
[14] C. F. Tjandra et al., “Pendampingan Digitalisasi Pencatatan Keuangan UMKM Morojoyo Mesin Jahit Melalui Pemanfaatan Google Spreadsheets,” Abdimas Kartika Wijayakusuma, vol. 6, no. 4, pp. 1839–1853, 2025, doi: 10.26874/jakw.v6i4.1187.
[15] B. S. Metkono, M. G. Manikin, Y. Kehi, H. P. Putra, A. J. Raga, and Y. P. Bria, “Pemanfaatan Google Sheets untuk Peningkatan Akurasi Pengelolaan Keuangan pada UMKM Chocolate Banana di Kecamatan Oebobo , Nusa Tenggara Timur,” Pengabdi. Kpd. Masy. Nusant., vol. 5, no. 4, pp. 4596–4601, 2024, doi: 10.55338/jpkmn.v5i4.4221.
[16] Rachmad, A. Mayusa, M. Amijaya, Y. Pramudika, and D. Haryono, “Sosialisasi Program Pemberdayaan UMKM Dengan Sistem Digital Guna Meningkatkan Daya Saing Di Desa Kotarindau,” J. Akad. Pengabdi. Masy., vol. 3, no. 6, pp. 73–78, 2025, doi: 10.61722/japm.v3i6.6817.
[17] R. T. M. Caroline and D. Murtiningsih, “Digitalisasi UMKM,” Kreat. Pengabdi. Kpd. Masy., vol. 7, no. 3, pp. 1387–1400, 2024, doi: 10.33024/jkpm.v7i3.13861.
[18] M. Rahel et al., “Model Pemberdayaan Masyarakat Kolaboratif Berbasis Participatory Action Research (PAR): Sinergi Revitalisasi Spiritualitas Keagamaan dan Penguatan Ekonomi Lokal di,” JPMD J. Pengabdi. Kpd. Masy. Desa, vol. 6, no. 2, pp. 569–586, 2025, doi: 10.58401/jpmd.v6i2.2613.
[19] W. Novita, Y. Fitriadi, P. R. Nopiana, and Gusnafitri, “Pelatihan Laporan Keuangan dengan Google Spreadsheet dalam Rangka Meningkatkan Pengetahuan UMKM,” ABDISOSHUM Pengabdi. Masy. Bid. Sos. dan Hum., vol. 2, no. 2, pp. 217–225, 2023, doi: 10.55123/abdisoshum.v2i2.2052.
[20] Y. Affandi, M. M. Ridhwan, I. Trinugroho, and D. Hermawan, “Digital Adoption, Business Performance, and Financial Literacy in Ultra-Micro, Micro, and Small Enterprises in Indonesia,” Res. Int. Bus. Financ., vol. 70, 2024, doi: 10.2139/ssrn.4719935.
[21] J. Kobi, “Developing Dashboard Analytics and Visualization Tools for Effective Performance Management and Continuous Process Improvement,” Int. J. Innov. Sci. Res. Technol., vol. 9, no. 5, pp. 1697–1709, 2024, doi: 10.38124/ijisrt/IJISRT24MAY1147.
[22] M. Batara and V. S. Yosephine, “Alat Pendeteksi Stok Barang Berbasis IoT untuk UMKM dengan Sensor Ultrasonik dan Inframerah,” J. Integr. Syst., vol. 7, no. 1, pp. 63–74, 2024, doi: 10.28932/jis.v7i1.8525.
[23] R. Mariana, B. Wadu, and K. Kraugusteeliana, “Mengakselerasi Daya Saing UMKM melalui Inovasi Teknologi: Peran Strategis Literasi Digital Masyarakat dalam Mewujudkan Ekosistem Ekonomi Berbasis Platform,” Minfo Polgan, vol. 14, no. 2, pp. 1608–1618, 2025, doi: 10.33395/jmp.v14i2.15190 e-ISSN.
[24] N. Laziva and M. Q. Atieq, “Studi Literatur Digitalisasi UMKM (Usaha Mikro, Kecil, dan Menengah) di EraMasyarakat 5.0: Strategi dan Faktor,” Pros. Manag. Bus. Innov. Conf., vol. 7, no. 1, pp. 1050–1079, 2024.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Denny Kurniawati, Eko Endi Priyatmoko, Muhammad Habibi Hanny Irawan, Fitria Rachmawaty, Mohamad Ferdaus Noor Aulady
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
