Excel-Based Financial Report Preparation Training for Pharmacy Entrepreneurs Who Are Members of HISFARMA in the Special Region of Yogyakarta

Nugraeni; Rochmad Bayu Utomo; Ni Luh Gde Ana Pertiwi

doi:10.32815/jpm.v6i1.2488

Authors

Nugraeni Universitas Mercu Buana Yogyakarta
Rochmad Bayu Utomo Universitas Mercu Buana Yogyakarta
Ni Luh Gde Ana Pertiwi Universitas Mercu Buana Yogyakarta

DOI:

https://doi.org/10.32815/jpm.v6i1.2488

Keywords:

Financial Reporting, Excel Training, Pharmacy Management

Abstract

Purpose: This activity aimed to assist pharmacy owners, members of HISFARMA in Yogyakarta, who struggled with manual financial reporting. The goal was to improve their skills in preparing financial reports using Excel.

Method: A training program was conducted involving 30 HISFARMA member pharmacies. Participants were taught to prepare financial reports using Excel through practical exercises and direct mentoring.

Practical Application: The training provided pharmacy owners with practical skills to organize financial data efficiently, streamline reporting processes, and enhance cost classification, leading to better financial management.

Conclusion: After the training, participants showed significant improvement, particularly in the classification of the expenses. Using Excel contributed to more accurate and professional financial reporting among HISFARMA pharmacy owners.

References

Amaliyah, F., Hasan, I., Ardhi, K. F., & Sari, Y. P. (2021). Peningkatan Pengetahuan Tentang Pencatatan Keuangan Sederhana Menuju Tertib Pembukuan Bagi Pelaku UMKM Nasabah Pantas Ulamm PT. PNM Cabang Tegal. Jurnal Abdimas Sangkabira, 2(1), 23–30. https://doi.org/10.29303/abdimassangkabira.v2i1.69

Hilendri, B. A., Sapto Hendri BS, L. Takdir Jumaidi, & D. Tialurra Della Nabila. (2020). Akuntansi Perspektif Usaha Mikro Kecil Menengah (Survei Pada Umkm Di Kota Mataram). Jurnal Aplikasi Akuntansi, 4(2), 147–154. https://doi.org/10.29303/jaa.v4i2.78

IAI, (2016). Standar Akuntansi Keuangan Entitas Mikro, Kecil dan Menengah. Jakarta: Dewan Standar Akuntansi Keuangan.

Isnawan, G. (2012). Akuntansi Praktis untuk UMKM. Jakarta: Laskar Aksara Jaya.

Jaya, A., dan Hidayaturrohman. (2016). Perancangan Sistem Akuntansi Berdsaarkan SAK ETAP pada UMK Kopi Sahabat Kota Libuk Linggan. Jurnal EMBA

Meiryani, Warganegara, D. L., Deniswara, K., & Dewi, K. (2020). Accounting information systems evaluation of medicines management. Systematic Reviews in Pharmacy, 11(8), 83–87. https://doi.org/10.31838/srp.2020.8.12

Mustofa, A., Ekasari, K., & Kusmintarti, A. (2021). Implementation Of Inventory Accounting Information Systems At Pharmacy (Case Study at Tirta Pharmacy). Business and Accounting Research (IJEBAR) Peer Reviewed-International Journal, 5(2), 153 160. https://jurnal.stie-aas.ac.id/index.php/IJEBAR

Muthmainnah, M., Jayengsari, R., & Rachmawati, S. (2023). Pelatihan Penyusunan Laporan Keuangan Sesuai Standar Akuntansi Bagi Pelaku UMKM di Kecamatan Ujung Berung Bandung. PADMA, 3(2), 160–171. https://doi.org/10.56689/padma.v3i2.1159

Ponisciakova, O., Gogolova, M., & Ivankova, K. (2015). The Use of Accounting Information System for the Management of Business Costs. Procedia Economics and Finance, 26(15), 418–422. https://doi.org/10.1016/s2212-5671(15)00822-9

Prabasari, B., Amaliyah, E. D. E., Rohmawati, L., & Sari, R. P. (2024). Pelatihan Pencatatan Keuangan Pada Warung Makan Di Kawasan Celosia Bandungan. Jurnal Inovasi Penelitian Dan Pengabdian Masyarakat, 4(1), 143–151. https://doi.org/10.53621/jippmas.v4i1.302

Romadona, F. A., & Wijayanti, F. F. (2024). Optimalisasi Kinerja Keuangan Dengan Penerapan Laporan Keuangan Yang Efektif pada Warteg Ayunis. Jurnal Pengabdian Sosial, 1(8), 784–790. https://doi.org/10.59837/mms7jt14

Syahrenny, N., Kusmaeni, E., Widiarma, I., & Tegowati, T. (2022). Pelatihan Perhitungan Harga Pokok Dan Penyusunan Laporan Keuangan Sesuai SAK EMKM. Jurnal Kreativitas Dan Inovasi (Jurnal Kreanova), 2(3), 88–92. https://doi.org/10.24034/kreanova.v2i3.5311

Vinuri, E. D., Bukhori, I., & Kartikawati, Y. (2024). Pengaruh Literasi Keuangan Dan Etika Bisnis Islam Terhadap Kinerja Bisnis UMKM (Studi Kasus Pada Pelaku UMKM di Sekitar Pondok Pesantren Zainul Hasan Genggong). Ekono Insentif, 18(1), 1–12. https://doi.org/10.36787/jei.v18i1.1405