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