Digitalisasi Keuangan UMKM : Pelatihan Pembuatan Laporan Keuangan Praktis dengan Microsoft Excel untuk Daya Saing yang Lebih Baik
DOI:
https://doi.org/10.61754/jurdiasra.v2i1.59Keywords:
Financial Digitalization; Financial Reports; Microsoft Excel; MSMEsAbstract
One of the tri dharma obligations of lecturers is to carry out Community Service (PKM) activities. The PKM activity carried out this time by the LP3I Pekanbaru Polytechnic PKM Team for the Accounting Computerization Study Program was Digitalization of MSME finances, namely providing training in making practical financial reports using Microsoft Excel to 15 MSMEs who are members of the Bertuah MSME Community in the city of Pekanbaru. The aim of holding this training is so that in this digital era, all MSMEs must also develop to keep up with the times, one of which is making MSME financial reports no longer manual, at least MSME financial reports already use computerization in the form of Microsoft Excel. By using Microsoft Excel, it is hoped that all MSMEs will have recorded financial reports, which can be made faster and save time compared to manually. Apart from that, MSME owners can also see the condition of their business from the financial reports prepared. Apart from that, what is no less important is that with financial reports, MSMEs will easily report taxes and can use them to apply for credit/loan funds to banks. if you want to increase capital for MSMEs so that they can develop further.
Keywords: MSMEs, Financial Digitalization, Microsoft Excel, Financial Reports
References
Azzari, V. et al. (2021). Accounting services quality: a systematic literature review and bibliometric analysis. Asian Journal of Accounting Research, 6(1), 16. https://doi.org/http://dx.doi.org/10.1108/AJAR-07-2020-0056
Dewi, et al. (2022). Faktor-faktor yang Memengaruhi Digitalisasi Informasi Akuntansi pada UMKM di Kota Mataram. Riset, Ekonomi, Akuntansi Dan Perpajakan (Rekan), 3(2), 121–136. https://doi.org/https://doi.org/10.30812/rekan.v3i2.2377
Fauzi, Leni Rahmayana, Ika Wulandari, & Bagus Hari Sugiharto. (2023). Mengapa Digitalisasi Akuntasi Harus di Lakukan Pada Perusahaan UMKM : Sebuah Tinajaun Pustaka. Jurnal Aktiva : Riset Akuntansi Dan Keuangan, 5(1), 43–56. https://doi.org/10.52005/aktiva.v5i1.179
Julianto, I. P. et al. (2022). Analysis of the Digitalization of Accounting Information Systems in Supporting the Sustainability of MSMEs During the Pandemic (Study on MSMEs in Buleleng Regency). Jurnal Ilmiah Mahasiswa Akuntansi, 13(04), 8. https://doi.org/https://doi.org/10.23887/jimat.v13i04.54335
Menne, et al. (2022). Inovasi Digitalisasi Ekonomi dan Literasi Keuangan; Menuju Kebangkitan Ekonomi Syariah dan Peningkatan Kinerja Keuangan Usaha Kecil Menengah (UKM). Prosiding SNA XXV Kendari. http://localhost:8080/xmlui/handle/123456789/949
Moegiarso. S. (2023). Pertumbuhan Ekonomi tahun 2022 capai 5,31%, Tertinggi Sejak 2014. https://www.ekon.go.id/Publikasi/Detail/4904/Pertumbuhan-Ekonomi-Tahun-2022-Capai-5,31%25-Tertinggi-Sejak -2014
Putra, S. Y. (2023, September). Sudah Terdata 277 Ribu, Disperindag Riau Ajak Pelaku Usaha Mendaftar di Database Mata UMKM. CAKAPLAH.Com. https://www.cakaplah.com/berita/baca/102139/2023/09/04/sudah-terdata-277-ribu-disperindag-riau-ajak-pelaku-usaha-mendaftar-di-database-mata-umkm#sthash.RmwuSd4i.dpbs
Santi Rahmawati, Raden Roro; Wafa, Z. (2023). Digitalisasi Pembukuan Keuangan pada UMKM di Bantul. Jurnal Pengabdian Kepada Masyarakat Nusantara, 4(4), 6. https://doi.org/http://doi.org/10.55338/jpkmn.v4i4.1981
Wulandari, I., Rahmayana, L., Zaman, D., & Kurniawan, M. (2023). Pelatihan Praktek Akuntansi Perusahaan Dagang Pada Siswa Smk Muhammadyah 3 Terpadu Pekanbaru. Communnity Development Journal, 4(2), 1227–1233. https://journal.universitaspahlawan.ac.id/index.php/cdj/article/view/13038
Wulandari, I., & Rambe, S. (2022). Analisis Pemahaman dan Kepatuhan Wajib Pajak UMKM Tentang Kewajiban Perpajakan di Kecamatan Marpoyan Damai Pekanbaru. Jurnal IAKP: Jurnal Inovasi Akuntansi Keuangan & Perpajakan, 3(2), 115. https://doi.org/10.35314/iakp.v3i2.2933
Zuliarni, S. (2017). Entrepreneurship dalam Peningkatan Kinerja Usaha Pada UMKM Makanan Khas Riau. Jurnal Aplikasi Bisnis, 8(1), 6. https://doi.org/http://dx.doi.org/10.31258/jab.8.1.69-74