Pengembangan Pembuatan Laporan Keuangan Dengan Ms. Excel Pada UMKM: Menuju Manajemen Keuangan Yang Profesional
DOI:
https://doi.org/10.29408/jpek.v7i2.24058Keywords:
Financial Statements, Ms. Excel, MSMEsAbstract
The weakness of MSMEs in managing finances is characterized by unsystematic recording of business transactions. The development of financial reports using Ms Excel aims to make it easier for MSMEs to make financial reports to make decisions. The development design used is ADDIE. The research sample was taken from 15 MSMEs engaged in production, so the sampling technique used purposive sampling technique. The results showed an average overall item score of 0.876 (88%), meaning that the use of Ms Excel for financial reports is included in the criteria for very practical use. The effectiveness score of 0.864 (86%) means that the use of Ms. Excel for financial reports is included in the criteria very effective
References
Akhtar, S., & Liu, Y. (2018). SMEs’ Use Of Financial Statements For Decision Making: Evidence From Pakistan. The Journal of Applied Business Research –, 34(2), 381–392.
Das, S., & Mohiuddin, K. M. (2015). Motivational Factors and the Constraints of Women Entrepreneurship Development in Bangladesh. International Journal of Information, Business and Management, 7(3), 377–395.
Dhewy, R. C. (2018). PELATIHAN DASAR-DASAR STATISTIKA DENGAN MENGGUNAKAN APLIKASI MICROSOFT EXCEL DI SDN PAMOTAN II KECAMATAN PORONG. Jurnal PADI – Pengabdian MAsyarakat Dosen Indonesia, 1(1), 36–40.
Dunford, R. (2000). Key challenges in the search for the effective management of knowledge in management consulting firms. Journal of Knowledge Management, 4(4), 295–302.
Fachrunnisa, O., Mutamimah, & Gunawan. (2012). A Framework of Digital Collaboration Networks for SME ’ s Sustainability. IPEDR, 52(5), 20–25. https://doi.org/10.7763/IPEDR.
Fatwitawati, R. (2018). PENGELOLAAN KEUANGAN BAGI USAHA MIKRO KECIL MENENGAH (UMKM) DI KELURAHAN AIRPUTIH KECAMATAN TAMPAN KOTA PEKANBARU. Seminar Hasil Pengabdian Kepada Masyarakat, 225–229.
Hikmah, R., Astuti, L. S., & Wulandari, S. (2022). PENGGUNAAN MICROSOFT EXCEL DALAM MEMBUAT LAPORAN KEUANGAN. Jurnal PKM: Pengabdian Kepada Masyarakat, 05(05), 494–501.
Holmes, P., Hunt, A., & Stone, I. (2010). An analysis of new firm survival using a hazard function. Applied Economics, 42(2), 185–195. https://doi.org/10.1080/00036840701579234
International Labour Office. (2019). Financing Small Businesses in Indonesia Challenges and Opportunities. ILO.
Kim, S., & Lee, H. (2006). Th e Impact of Organizational Context and Information Technology on Employee Knowledge-Sharing Capabilities. In Public Administration Review (Issue June, pp. 370–385).
Midgley, J. (2008). Microenterprise, global poverty and social development. International Social Work, 51(4), 467–479. https://doi.org/10.1177/0020872808090240
Ogearti, R. (2020). IDENTIFIKASI KENDALA PEMANFAATAN MICROSOFT EXCEL DALAM PENYUSUNAN LAPORAN KEUANGAN. Jurnal Akuntansi Profesi, 11(2), 339–350.
Pakpahan, Y. E. (2020). Pengaruh kualitas laporan keuangan terhadap kinerja usaha umkm. Akuntabel, 17(2), 261–269.
Popescu, A. I. (2012). Lifelong Learning in the Knowledge Economy : Considerations on the Lifelong Learning System in Romania from a European Perspective. Revista De Cercetare Si Interventie Sociala, 37, 49–76.
Pramana, Y. A., Supraptono, E., & Pribadi, F. S. (2013). Aplikasi Microsoft Excel 2010 Untuk Menganalisis Butirsoal Pilihan Ganda. Jurnal Teknik Elektro Unnes, 5(2), 93–95.
Putra, H. A. (2012). PENYUSUNAN LAPORAN KEUANGAN UNTUK USAHA KECIL DAN MENENGAH ( UKM ) BERBASIS STANDAR AKUNTANSI KEUANGAN ENTITAS TANPA AKUNTABILITAS PUBLIK ( SAK ETAP ). Pekan Ilmiah Dosen FEB, 547–580.
Raghuvanshi, J., Agrawal, R., & Ghosh, P. K. (2017). Analysis of Barriers to Women Entrepreneurship: The DEMATEL Approach. Journal of Entrepreneurship, 26(2), 220–238. https://doi.org/10.1177/0971355717708848
Rosenfeld, S. A. (1996). Does cooperation enhance competitiveness.pdf. 25, 247–263.
Sari, P. N., Oktaria, E. T., Yusda, D. D., Wengrum, T. D., Indonesia, M., & Lampung, B. (2022). UMKM DIDESA MEKAR SARI KABUPATEN MESUJI. 1, 2018–2019.
Saunders, M. N. K., Gray, D. E., & Goregaokar, H. (2014). SME innovation and learning: The role of networks and crisis events. European Journal of Training and Development, 38(1–2), 136–149. https://doi.org/10.1108/EJTD-07-2013-0073
Tambunan, T. (2019). Recent evidence of the development of micro, small and medium enterprises in Indonesia. Journal of Global Entrepreneurship Research, 9(18), 1–15. https://doi.org/10.1186/s40497-018-0140-4
Widjaja, Y. R., Fajar, C. M., Bernardin, D. E. Y., Mulyanti, D., & Nurdin, S. (2018). Penyusunan Laporan Keuangan Sederhana Untuk UMKM Industri Konveksi. Jurnal Pengabdian Kepada Masyarakat, 1(1), 163–179.
