Keywords
VBA for Excel
finance
How to Cite
Abstract
Prambontergayang Village, located in Soko District, Tuban Regency, is a village that is well known for the production of Rengginang snacks in the Soko sub-district. has the Urnika brand, the IRT has been established since 2015 and received PIRT (Household Industry Food) legality in 2018. The problems that occur with these IRTs are financial and bookkeeping management which are still carried out by recording in books or manually, repair solutions that offered is VBA Macro excel-based bookkeeping and finance training. The implementation method carried out in community service first examines the problems found in IRT by means of surveys to IRT locations, then examines solutions to these problems and is implemented with training. The results of community service are proven to be able to increase the productivity of IRT rengginang craftsmen in Prambonterga village, which is in Soko District, Tuban Regency, and IRT are able to independently manage finances well and improve time efficiency when reporting finances.
References
Dewi, J., Ningtyas, A., Pd, S., Si, M., & Pusmanu, P. (n.d.). Penyusunan Laporan Keuangan UMKM Berdasarkan Standar Akuntansi Keuangan Entitas Mikro, Kecil dan Menengah (SAK-EMKM) (Study Kasus Di UMKM Bintang Malam Pekalongan).
Kania, E., Akuntansi, J., & Bandung, P. N. (2021). Penyusunan_Laporan_Keuangan_Berdasarkan_SAK_EMKM Berbantuan Microsoft Excel Pada_UMKM Uncal.Co Arrangement of_Financial Statement Based on_SAK_EMKM Assisted by Microsoft Excel at MSMEs Uncal.Co Arry Irawan. Indonesian Accounting Literacy Journal, 1(2), 338–352.
Kementrian Koperasi dan Usaha Kecil dan Menengah Republik Indonesia. (2018). Dipetik Maret 21, 2020, dari Kementrian Koperasi dan UKM RI: http://www/depkop.go.id/uploads/laporan/1580223129PERKEMBANGAN%20DAT A%USAHA%20MIKRO.%20KECIL,%20MENENGAH%20(UMKM)%20DAN%US AHA%20BESAR%20(UB)%20TAHUN%20217%20-%202018.pdf
Nababan, R., Darma, J., Saleh, K., & Nurman, A. (2020). Pemberdayaan Kelompok Masyarakat Desa Karang Anyar untuk Meningkatkan Pendapatan dalam Produksi Usaha Rengginang. Pelita Masyarakat, 1(2), 76–82. https://doi.org/10.31289/pelitamasyarakat.v1i2.3220
Roy, R.M, 2005. Operation Management, Ansari road, Daryoganj, Newdelhi
Rasmossen, S. 2011. Production Economic, Institute of Food and Resource Economic, Denmark
PusDikLat Kemenkeu. 2018. Pembuatan Fungsi Excel Sendiri (VBA Macro). Materi DikLat VBA Macro. https://klc.kemenkeu .go.id/course/diklat-microsoft-exceltingkat-tinggi/curriculum/ Diakses terakhir 12 Maret 2020.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Copyright (c) 2023 The copyright of published articles belongs to the author(s)