TEKIBA : Jurnal Teknologi dan Pengabdian Masyarakat
Vol. 6 No. 2 (2026): TEKIBA : Jurnal Teknologi dan Pengabdian Masyarakat (Mei)

Penerapan Digitalisasi Sederhana Berbasis Google Sheets Sebagai Solusi Pencatatan Stok Dan Distribusi UMKM Tienz

Denny Kurniawati (Program Studi Magister Teknik Industri, Fakultas Teknologi Industri, Institut Adhi Tama Surabaya,)
Eko Endi Priyatmoko (Program Studi Magister Teknik Industri, Fakultas Teknologi Industri, Institut Adhi Tama Surabaya)
Muhammad Habibi Hanny Irawan (Program Studi Magister Teknik Industri, Fakultas Teknologi Industri, Institut Adhi Tama Surabaya)
Fitria Rachmawaty (Program Studi Magister Teknik Industri, Fakultas Teknologi Industri, Institut Adhi Tama Surabaya)
Mohamad Ferdaus Noor  Aulady (Program Studi Magister Teknik Industri, Fakultas Teknologi Industri, Institut Adhi Tama Surabaya)



Article Info

Publish Date
31 May 2026

Abstract

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.

Copyrights © 2026






Journal Info

Abbrev

tekiba

Publisher

Subject

Computer Science & IT Control & Systems Engineering Electrical & Electronics Engineering Engineering Mechanical Engineering

Description

Jurnal Teknologi dan Pengabdian Masyarakat (TEKIBA) urnal Teknologi dan Pengabdian Masyarakat (TEKIBA) adalah jurnal ilmiah multidisiplin yang diterbitkan oleh Fakultas Teknik Universitas PGRI Banyuangi dengan nomor registrasi ISSN 2776-947X. Jurnal ini berkaitan dengan informasi tentang gagasan, ...