Article Per Year (5 Year)
p-Index From 2020 - 2025
0.23
P-Index
This Author published in this journals
All Journal Jurnal Pemberdayaan: Publikasi Hasil Pengabdian kepada Masyarakat (JPM ITTC )
Angelene, Deana Putri
Unknown Affiliation
Education Social Sciences

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

Found 1 Documents
Search

 1 
Penerapan Dashboard Excel Otomatis untuk Meningkatkan Tata Kelola dan Konsistensi Pencatatan Keuangan UMKM Angelene, Deana Putri; Hartati, Hartati; Stephanus, Daniel Sugama; Suganda, Tarsisius Renald; Cahyadi, Rino Tam; Pratama, Bagas Brian
Jurnal Pemberdayaan: Publikasi Hasil Pengabdian Kepada Masyarakat Vol. 4 No. 2 (2025): Juli-Desember
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jpmittc.v4i2.3359

Abstract

Yan’s Keramik is a micro, small, and medium enterprise (MSME) engaged in ceramic handicrafts since the early 2000s. In its operations, Yan’s Keramik still faces challenges in implementing a structured financial recording system that aligns with fundamental accounting principles. Therefore, this community service activity aims to assist Yan’s Keramik in improving the quality of its financial recording and reporting, enabling it to accurately reflect the business’s actual financial condition. Through this initiative, it is expected that the MSME will be able to prepare simple yet well-organized financial statements that support more precise, data-driven decision-making.  The implementation method used is qualitative, employing interviews and direct observation of the MSME’s financial activities. During the mentoring process, the service team collected data directly from the business owner and identified financial recording needs tailored to the characteristics of the enterprise. To enhance the effectiveness of the program, a participatory approach was also applied by involving the business owner in each stage of the process, ensuring that the resulting solutions genuinely reflect real needs in the field. The outcome of this activity was the development of a financial recording template using Microsoft Excel, equipped with formulas and automated reporting formats. This template is expected to help Yan’s Keramik manage its finances in a more organized manner and prepare income statements and cash flow reports on both a monthly and annual basis. One of the main challenges identified was the lack of separation between personal and business finances, which has made it difficult to objectively assess the performance of the business.
Co-Authors Daniel Sugama Stephanus Hartati Hartati Pratama, Bagas Brian Rino Tam Cahyadi, Rino Tam Tarsisius Renald Suganda