AMALIAH: JURNAL PENGABDIAN KEPADA MASYARAKAT
Vol 9 No 1 (2025): Amaliah Jurnal: Pengabdian kepada Masyarakat

Pemberdayaan UMKM Warung Kelontong Mbak Lia Dalam Pengelolaan Stok Barang Melalui Penerapan Sistem Pencatatan Sederhana Berbasis Excel

Mahardika, Amrullah (Unknown)
Rini, Diah Septya (Unknown)
Sumaryanto (Unknown)



Article Info

Publish Date
12 Jul 2025

Abstract

Micro, Small, and Medium Enterprises (MSMEs) play a strategic role in the local economy but still face challenges in inventory management and financial recording. Warung Kelontong Mbak Lia, as one of the MSMEs in Kulon Progo, struggles due to the absence of a structured inventory recording system. This community service program aims to empower the business owner through training and assistance in implementing a simple inventory recording system using Microsoft Excel. The implementation method adopts a participatory approach, including initial surveys, basic training, guided inventory card preparation, evaluation, and follow-up monitoring. The results show that using Excel not only simplifies inventory recording but also improves the owner's understanding of inventory management and financial accountability. This system is proven to be efficient, flexible, and user-friendly without requiring additional costs. With improved inventory records, MSMEs can identify fast-moving products, avoid stockouts, and enhance business decision-making. This program is expected to become a model of empowerment for other MSMEs in adopting more professional and sustainable inventory management practices.

Copyrights © 2025






Journal Info

Abbrev

AJPKM

Publisher

Subject

Description

Amaliah: Jurnal Pengabdian Kepada Masyarakat (Indonesian Journal of Community Engagement), with registered number ISSN 2580-0337 (print), ISSN 2580-0531 (online) is a scientific multidisciplinary journal published by LP2M Universitas Muslim Nusantara Al Washliyah. It is in the national level that ...