Login

PENDAMPINGAN PENGELOLAAN PERSEDIAAN BARANG KELUAR DAN MASUK BERBASIS MICROSOFT EXCEL PADA UMKM PECI BATIK DI JOGOKARIYAN

Vol. 5 No. 01 (2026): Jurnal Pengabdian Masyarakat Sabangka:

Ayu Nadilla Astuti (1), Zaenal Wafa (2)

(1) Universitas Mercu Buana Yogyakarta, Indonesia
(2) Universitas Mercu Buana Yogyakarta, Indonesia
Fulltext View | Download

Abstract:

Micro, Small, and Medium Enterprises (MSMEs) play a vital role in the economy, but in practice, many MSMEs do not fully record their inventory. This problem occurred at the Jogokariyan Batik Peci MSME, where stock recordng was only done on outgoing goods, while incoming goods were not recorded. This activity aims to help the Jogokariyan Batik Peci MSME in improving the system of recording incoming and outgoing inventory to make it more organized and easier to understand. The methods used include observation, training and mentoring, and evaluation. Observations were conducted to determine the initial condition of inventory recording, followed by training and mentoring in preparing incoming and outgoing stock recording formats using Microsoft Excel. The evaluation stage was conducted to see the understanding of MSME owners in implementing independent stock recording. The results of the activity showed that this mentoring helped MSME owners in recording inventory more completely, thus making stock management more organized.

References

Mahardika, A., & Rini, D. S. (2025). PEMBERDAYAAN UMKM WARUNG KELONTONG MBAK LIA DALAM PENGELOLAAN STOK BARANG MELALUI PENERAPAN SISTEM PENCATATAN SEDERHANA BERBASIS EXCEL. Amaliah: Jurnal Pengabdian Kepada Masyarakat, 9(1), 541–547. https://doi.org/10.32696/ajpkm.v9i1.5081

Pamikatsih, T. R., & Octavia, D. I. (2025). OPTIMALISASI MANAJEMEN PERSEDIAAN BERBASIS KEUANGAN PADA TOKO NOVI (BU ATUN) DI KLATEN. Proficio, 6(2), 968–973. https://doi.org/10.30630/japepam.v2i2.29

Octavia, D. I., Susanti, A., Saputra, E. T., & Partini, S. (2025). PENDAMPINGAN PENCATATAN KARTU PERSEDIAAN DALAM MENINGKATKAN KINERJA UMKM PADA DJAN ECO BAKERY. Bengawan: Jurnal Pengabdian Masyarakat, 5(1), 43–51. https://doi.org/10.46808/jurnal_bengawan.v5i1.182

Farida, A., & Mazidah, N. (2025). PENDAMPINGAN DIGITALISASI SISTEM PENGARSIPAN DAN PENGADAAN BARANG DAGANG PADA UMKM FASHION ALYA. Proficio, 6(2), 558–562. https://doi.org/10.36728/jpf.v6i2.4976

Fitriyani, L., & Nugraha, F. (2025). PENDAMPINGAN RANCANG BANGUN SISTEM INFORMASI INVENTORY BAHAN BAKU PRODUKSI UNTUK MENINGKATKAN EFEKTIVITAS PRODUK ROTI DI RAHAYU BAKERY. Bhakti Nagori (Jurnal Pengabdian kepada Masyarakat), 5(2), 883–894. https://doi.org/10.36378/bhakti_nagori.v5i2.5054

Aji, G., Shafira, H., Khofifatuz Zahro, S., & Juliyanti, A. (2023). ANALISIS MANAJEMEN PERSEDIAAN BAHAN BAKU PADA UMKM RISOL KEKASIH PEKALONGAN. JUMBIWIRA: Jurnal Manajemen Bisnis Kewirausahaan, 2(3), 43–54. https://doi.org/10.56910/jumbiwira.v2i3.1077

Rahmadanty, A. N., Putri, D. R., Siddiq, F., Purbayaksa, P., & Suherman, U. (2024). ANALISIS MANAJEMEN PERSEDIAAN PADA UMKM WARKOP PANCONG LUMER FARIZ DI KARAWANG. Neraca: Jurnal Ekonomi, Manajemen dan Akuntansi, 2(1), 138–145. https://doi.org/10.572349/neraca.v2i1.700

Trisnawati, N. D. E., & Suryaningsih, K. (2025). SISTEM PENGELOLAAN PERSEDIAAN BARANG DAGANG PADA UMKM. Jurnal Akuntansi, Ekonomi dan Manajemen Bisnis, 5(3), 365–374. https://doi.org/10.55606/jaemb.v5i3.7651

Wijaya, B., & Handayani, S. (2023). EVALUASI MANAJEMEN PERSEDIAAN MENGGUNAKAN METODE FIFO PADA UMKM INDUSTRI KECIL. Management & Accounting Review, 9(2), 210–223.