PENERAPAN EXCEL AKUNTANSI DALAM PENYUSUNAN LAPORAN KEUANGAN UMKM TRIJAYA FURNITURE
DOI:
https://doi.org/10.32524/jamc.v8i2.1276Keywords:
UMKM, Laporan Keuangan, Excel Akuntansi, Transparansi, AkuntabilitasAbstract
Micro, Small and Medium Enterprises (MSMEs) have an important role in economic development in Indonesia. Trijaya Furniture, a manufacturing MSME producing finished goods since 2008, faces challenges in preparing well-structured financial statements. This issue impacts trust and accessibility for external parties, such as financial institutions and investors. This community service activity aims to implement Excel Accounting as a tool for preparing financial statements to enhance financial management quality. The implementation method consists of three stages: Observation, to understand needs and challenges, Intensive training, focusing on creating Excel-based financial statements aligned with standards, and Evaluation and monitoring of training outcomes. The results show an improvement in MSME practitioners' ability to prepare accurate and organized financial statements, along with increased trust from external partners.
References
Effendy, Lukman, Zuhrotul Isnaini, and Isnawati Isnawati. 2023. “Pemanfaatan Excel Dalam Penyusunan Laporan Keuangan Sederhana Pada Usaha Sablon Di Desa Santong Kecamatan Kayangan Kabupaten Lombok Utara.” Jurnal Abdimas Independen 4(2): 95–102.
Handayani, Emi Siti Et Al. 2020. “Analysis Of Production Cost Calculation Based On Order ( Job Order Costing ) In Rafi Jaya Mebel ( Rjm ) Suak Temenggung Analisis Perhitungan Biaya Produksi Berdasarkan Pesanan ( Job Order Costing ) Pada Rafi Jaya Mebel ( Rjm ) Suak Temenggung Perusahaan M.” Xx(X): 187–95.
Hariyani, Reni et al. 2021. “Pelatihan Penyusunan Laporan Keuangan Dengan Pemanfaatan Microsoft Excel Untuk Siswa SMK Muhammadiyah 9 Jakarta.” Jurnal Abdimas Ekonomi dan Bisnis 1(Mei): 19–25.
Hasanah, Nurul, and Jouzar Farouq Ishak. 2022. “Penyusunan Laporan Keuangan Berdasarkan PSAK 109 Menggunakan Microsoft Excel 2019 Pada Program Sedekah Berjamaah BMKA Salman ITB.” Indonesian Accounting Literacy Journal 2(2): 436–45.
Hasmawati Hasmawati, Chrestiana Aponno, Septina Louisa Siahaya, and Rendy Usmany. 2023. “Preparation Of Simple Financial Statements For MSME Using Microsoft Excel Accounting Application.” Brilliant International Journal Of Management And Tourism 3(3): 52–62.
Kaligis, Stevie, Ivollety Walukow, and Jefrry Rengku. 2023. “Development of Computer Accounting Applications with Microsoft Excel VBA (Macro) in The Preparation of Financial Statements of Micro, Small and Medium Enterprises (MSMES) Coconut Wood Furniture.” Journal Research of Social Science, Economics, and Management 2(7): 1302–24.
Monarasi, Selfia, and Hariadi Yutanto. 2022. “Rancang Bangun Penyusunan Laporan Keuangan Bagi UMKM Somano Berbasis EFA (Excel For Accounting).” Wahana 73(2): 103–18.
Nikmatuniayah, Nikmatuniayah, Marliyati Marliyati, Jati Handayani, and Lilis Mardiana Anugrahwati. 2023. “Analysis of the Implementation of Micro, Small, and Medium Entity Financial Accounting Standards and Its Impacts on the Financial Report Quality of Small and Medium-Sized Enterprises.” Keunis 11(2): 177.
Noviato, Dwi Fajar, and Nanik Lestari. 2022. “Preparation of Financial Statement Using the Microsoft Excel on PT Dehong Paper Industry.” Journal of Applied Accounting and Taxation 7(1): 9–15.
Nurbaeti, Novi, Sudrajat, and Jouzar Farouq Ishak. 2023. “Penyusunan Laporan Keuangan Koperasi Rimbawan Sejahtera Bersama Menggunakan Microsoft Excel Berdasarkan SAK ETAP.” Indonesian Accounting Literacy Journal 3(2): 167–79.
Nurhayati, Nurhayati, Magnas Lestira Oktaroza, Nurleli Nurleli, and Nining Koesdiningsih. 2020. “Training of Making Financial Statements Using Microsoft Excel to Bankable Financial Statement at Small and Medium Enterprises in Bandung City.” 409(SoRes 2019): 251–52.
Pratiwi, Ririh Dian. 2012. “Menyusun Laporan Keuangan Sederhana Dengan Microsoft Excel.” Media Ekonomi & Teknologi Informasi 19(1): 64–70.
Rayyani, Wa Ode, Muhammad Nur Abdi, Endang Winarsi, and Warda. 2020. “Peningkatan Daya Saing Umkm Melalui Optimalisasi.” Dedikasi Masyarakat 3(2): 97–105.
Do Rego, Julia Valentim, Sutrisno T., and Zaki Baridwan. 2023. “Transparency, Accountability, and Community Participation in Village Fund Management: A Case Study in Liquica District.” Journal of Digitainability, Realism & Mastery (DREAM) 2(12): 60–89.
Sari, Rika Purnama, and Nurlela. 2021. “Penerapan Excel For Accounting Dalam Penyusunan Laporan Keuangan Pada CV. Karya Pratama.” Seminar Nasional Ilmu Sosial dan Teknologi (SANISTEK): 1–7.
Triandi, Triandi, and Marina Agustin. 2020. “Penggunaan Microsoft Excel Dalam Penyusunan Laporan Keuangan Untuk Meningkatkan Kualitas Informasi Laporan Keuangan.” Jurnal Ilmiah Akuntansi Kesatuan 4(1): 035–047.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2024 Jurnal Abdimas Musi Charitas
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
_1.png)
