Article Per Year (5 Year)
p-Index From 2021 - 2026
0.408
P-Index
This Author published in this journals
All Journal AMALIAH: JURNAL PENGABDIAN KEPADA MASYARAKAT
Sumaryanto
Universitas Ahmad Dahlan Yogyakarta

Published : 2 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 2 Documents
Search

 1 
Optimalisasi Keuangan UMKM Batako Simbah Melalui Penerapan Laporan Sederhana Dan Digitalisasi Excel Fiqih Kirana Dwi Murti; Rosati Wahdana; Sumaryanto
Amaliah: Jurnal Pengabdian Kepada Masyarakat Vol 9 No 1 (2025): Amaliah Jurnal: Pengabdian kepada Masyarakat
Publisher : LPPI UMN AL WASHLIYAH

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.32696/ajpkm.v9i1.5065

Abstract

MSMEs contribute significantly to the growth of the national economy, although many still face challenges in managing their finances in an orderly and structured manner. Batako Simbah MSME is one example of a business actor that has not yet implemented an adequate financial recording system. This activity aims to optimize financial management through training in basic financial reporting and digitalization using Microsoft Excel. The methods used include observation, material presentation, technical training, and intensive mentoring. The results show that business owners have begun to understand the importance of financial recording, are able to prepare income statements, and calculate the cost of goods manufactured independently. The use of Excel for digital financial records has proven to improve the efficiency, accuracy, and accountability of financial information. This activity is expected to be the first step toward more professional financial management practices within MSMEs, with a long-term focus on sustainability.
Pemberdayaan UMKM Warung Kelontong Mbak Lia Dalam Pengelolaan Stok Barang Melalui Penerapan Sistem Pencatatan Sederhana Berbasis Excel Amrullah Mahardika; Diah Septya Rini; Sumaryanto
Amaliah: Jurnal Pengabdian Kepada Masyarakat Vol 9 No 1 (2025): Amaliah Jurnal: Pengabdian kepada Masyarakat
Publisher : LPPI UMN AL WASHLIYAH

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.32696/ajpkm.v9i1.5081

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.
Co-Authors Amrullah Mahardika Diah Septya Rini Fiqih Kirana Dwi Murti Rosati Wahdana