Enhancing Students' Hard Skills in Preparing Financial Statements in Accordance with Financial Accounting Standards for Micro, Small, and Medium Enterprises Using Excel Applications
Peningkatan Hard Skill Siswa Dalam Menyusun Laporan Keuangan Sesuai Standar Akuntansi Keuangan Entitas Mikro Kecil Menengah Dengan Aplikasi Excel
DOI:
https://doi.org/10.31849/dinamisia.v9i1.21810Keywords:
financial statements, FAS for MSME, vocational students, excelAbstract
Preparation of financial statements must be in accordance with applicable financial accounting standards. Financial Accounting Standards for Micro, Small, and Medium Entities (FAS for MSME) is one of the financial accounting standards that is simple and easy to implement by MSMEs. Graduates of Vocational Accounting Department who later work in MSMEs are expected to be able to assist MSMEs in making financial reports according to standards. Community service aims to build students' awareness of the importance of FAS for MSME, to provide knowledge about the rules in FAS for MSME, to prepare financial reports, and to utilize and use excel-based technology to make financial reports according to FAS for MSME. This training starts from the preparation stage, namely a preliminary survey, determining the schedule, and preparing the training. The implementation stage is the implementation of training activities in the form of material and practice as well as participant evaluation in the form of pre-test post-test assessment and practice results. Furthermore, the final stage is the evaluation of training and the preparation of reports and outcomes. The training was conducted using training and mentoring methods for students majoring in accounting to prepare financial reports according to FAS for MSME with excel applications. This training activity was held in the hall and computer laboratory of SMKN 44 Jakarta. The training was attended by 34 students. This community service activity runs smoothly and has achieved its goals. This is indicated by the results that 100% of students have obtained an increase in hardskill competencies, namely being able to prepare financial reports according to FAS for MSME using the excel application
References
Anggraeni, S. N., Marlina, T., & Suwarno, S. (2021). Penyusunan Laporan Keuangan Pada UMKM Berdasarkan SAK EMKM: Studi Kasus pada Pabrik Tempe Pak Kasmono. Jurnal Aplikasi Bisnis Kesatuan, 1(2), 253–270.
Anggraini, L. R., Faradillah, & Rosalina, W. (2022). Pelatihan Penyusunan Laporan Keuangan Berbasis SAK EMKM Pada Pelaku Usaha Clothing Line. Dinamisia : Jurnal Pengabdian Kepada Masyarakat, 6(2), 540–546.
Bakdiyanto, R., & Ismunawan, I. (2022). Faktor - Faktor Yang Mempengaruhi Penerapan SAK EMKM Pada UMKM Di Desa Kebak. SENTRI: Jurnal Riset Ilmiah, 1(2), 570–586.
Bintari, W. C., Rawi, R. D., & Harisa, S. (2019). Pelatihan Penyusunan Laporan Keuangan Secara Sederhana Pada Mahasiswa Fakultas Ekonomi Universitas Muhammadiyah Sorong. Abdimas: Papua Journal of Community Service, 1(2), 6–13.
Diyani, L. A., Kusumawati, R. D., & Meita, I. (2021). Peningkatan Kemampuan Penyusunan Laporan Keuangan Sesuai SAK-EMKM (Pelatihan untuk Pelaku UMKM Binaan Pemkot Bekasi). Aksiologiya: Jurnal Pengabdian Kepada Masyarakat, 5(2), 222–232.
Fadlilah, A., Mulyadi, M., Mustika, I., Khadijah, K., & Richmayati, M. (2023). Pelatihan Penyusunan Laporan Keuangan bagi Siswa Paket C Pusat Kegiatan Belajar Masyarakat (PKBM) Sahabat Cendekia Batam. Amalee: Indonesian Journal of Community Research and Engagement, 4(1), 249–257.
Hariyani, R., Retnoningrum, E., & Prasetio, T. (2021). Pelatihan Penyusunan Laporan Keuangan Dengan Pemanfaatan Microsoft Excel Untuk Siswa SMK Muhammadiyah 9 Jakarta. Jurnal Abdimas Ekonomi Dan Bisnis, 1(1), 19–25.
IAI. (2018). Standar Akuntansi Keuangan Entitas Mikro, Kecil, dan Menengah.
Maharani, Y., Novika, & lestari, D. S. (2024). Sosialisasi Dan Pelatihan Pelaporan SAK EMKM PADA Pelajar SMK BAKTI Pangkalpinang. Jurnal Gembira: Pengabdian Kepada Masyarakat, 2(4), 1400–1409.
Marlindawati, M., Agustina, M., Meriana, C. I., & Ariantoro, T. R. (2023). Pemanfaatan Microsoft Excel Dalam Penyusunan Laporan Keuangan Di SMK Bina Jaya Palembang. Jurnal Pengabdian Mandiri, 2(7), 1599–1602.
Nuris, D. M. (2018). Pelatihan Penyusunan Perangkat Pembelajaran Berbasis TIK Bagi Guru Akuntansi SMK. Dinamisia : Jurnal Pengabdian Kepada Masyarakat, 2(2), 256–260.
Pandanwangi, A., Sukapura Dewi, B., Juli Rianingrum, C., & Wilastrina, A. (2023). Pelatihan Membuat Batik Diatas Kayu Dengan Menggunakan Metode Service Learning Di Sma Kebangsaan-Tanggerang Selatan. Jurnal Abdimas Ilmiah Citra Bakti, 4(1), 1–16.
Salmiah, N., Nanda, S. T., & Adino, I. (2021). Pelatihan SAK EMKM bagi Guru Program Keahlian Akuntansi Smk Negeri 6 Pekanbaru. KUAT: Keuangan Umum Dan Akuntansi Terapan, 3(2), 70–76.
Soemaryono, P. R., & Ismangil. (2021). Pelatihan Akuntansi Keuangan Bagi Siswa SMK Kartini Surabaya. Jurnal Pengabdian Dharma Masyarakat (PADMA), 1(4), 261–264.
Sriyunianti, F., Gustati, G., Ferdawati, F., Yentifa, A., & Sulastri, R. E. (2022). Efforts to Improve Vocational Students’ Understanding of SAK-EMKM through Socialization and Training Activities. KANGMAS: Karya Ilmiah Pengabdian Masyarakat, 3(3), 141–145.
Sulistyani, L., Lathifah, I., & Marsono, S. (2020). Pelatihan Akuntansi Dan Penyusunan Laporan Keuangan Usaha Kecil Bagi Siswa Sekolah Menengah Kejuruan (SMK) PGRI DI Surakarta. Wasana Nyata, 4(1), 23–28.
Utami, T., Irawati, W., Rosharlianti, Z., Annisa, D., & Angraini, D. (2020). Penerapan Sak-Emkm Pada Umkm Scale Up Tangerang Selatan Melalui Aplikasi Pencatatan Informasi Keuangan Mikro Dan Kecil (SI APIK). Abdimisi, 1(2), 136.
Yani, P., Susila, M. R., Nugroho, W. C., Pradhania, F. A., & Widiarto, H. (2023). Pelatihan Pelaporan Keuangan Sesuai Dengan SAK EMKM Bagi UMKM IWAPI Jawa Timur. Jurnal KeDayMas: Kemitraan Dan Pemberdayaan Masyarakat, 3(1), 88–96.
Yunus, F. H., Monoarfa, R., & Husain, S. P. (2022). Penerapan Aplikasi Keuangan SI APIK dalam Penyusunan Laporan Keuangan Zoellen Sagela Berdasarkan SAK EMKM. Economics and Digital Business Review, 3(1), 172–196.
Zahra, E. P., & Atmini, S. (2023). Pengaruh Pemahaman Akuntansi, Kesiapan, Tingkat Pendidikan, Dan Skala Usaha Terhadap Implementasi SAK EMKM. Reviu Akuntansi, Keuangan, Dan Sistem Informasi, 2(4), 986–999.
