Guidance and Training in Digital Financial Bookkeeping for UMKM (MSME) Batik Kantil Malang

Ita Rifiani Permatasari; Lilies Nur Aini; Umi Khabibah; Fullchis Nurtjahjani; Jatrifia Ongga Sinatriya; Yulis Nurul Aini

doi:10.55047/jscs.v5i2.928

Ita Rifiani Permatasari* Department of Business Administration, Politeknik Negeri Malang, Indonesia
Lilies Nur Aini Department of Business Administration, Politeknik Negeri Malang, Indonesia
Umi Khabibah Department of Business Administration, Politeknik Negeri Malang, Indonesia
Fullchis Nurtjahjani Department of Business Administration, Politeknik Negeri Malang, Indonesia
Jatrifia Ongga Sinatriya Department of Business Administration, Politeknik Negeri Malang, Indonesia
Yulis Nurul Aini Department of Business Administration, Politeknik Negeri Malang, Indonesia

DOI: https://doi.org/10.55047/jscs.v5i2.928

Keywords: Digital Financial Bookkeeping, MSME Training, Batik Enterprise, Microsoft Excel Accounting, Small Business Financial Management

Abstract

Financial bookkeeping and accounting systems are essential for small and medium enterprises (SMEs), even at the smallest scale, despite their often-burdensome perception among many traditional business owners. With advances in technology, financial record-keeping can now be digitized. However, UMKM (MSME) Batik Kantil in Malang continues to face challenges due to its reliance on manual bookkeeping, which results in suboptimal financial records. This community engagement activity aims to provide guidance and training in financial bookkeeping using Microsoft Excel. The target participants are the employees of UMKM Batik Kantil in Malang, and the program employs lectures, tutorials, discussions, and hands-on practice as its primary methods. This initiative is designed to equip UMKM practitioners with the skills to analyze real business transactions and compile comprehensive financial reports.

References

Ac, A. M. (2014). AKUNTANSI SYARIAH; Pendekatan Normatif, Historis dan Aplikatif. IQTISHADIA Jurnal Ekonomi & Perbankan Syariah, 1(1), 59–75.

Bernstein, P. A., & Newcomer, E. (2009). Principles of transaction processing. Morgan Kaufmann.

Bullen, S., Bovey, R., & Green, J. (2005). Professional Excel development: the definitive guide to developing applications using Microsoft Excel and VBA. Addison-Wesley Professional.

Dol, S. M., Jawandhiya, P. M., & Satav, P. R. (2024). Use of Microsoft Excel for Data Collection and Processing to Predict Students’ Performance in EDM. Journal of Engineering Education Transformations, 37(Special Issue 2).

Effendi, S., & Putria, N. E. (2021). Pembinaan Pengelolaan Keuangan Dengan Aplikasi MYOB Accounting V13 Pada UKM Kube Jasmine Di Sagulung-Kota Batam. Jurnal Pengabdian Barelang, 3(02), 31–37.

Fatimah, S. E., Purdianto, A., & Firasati, A. (2022). Penggunaan Media Promosi Digital Guna Meningkatkan Penjualan Aliyah Cake. JOURNAL OF SUSTAINABLE COMMUNITY SERVICE, 2(4), 207–213. https://doi.org/10.55047/jscs.v2i4.637

Guerrero, H., Guerrero, R., & Rauscher. (2019). Excel data analysis. Springer.

Gupta, A., & Kumar Singh, R. (2023). Managing resilience of micro, small and medium enterprises (MSMEs) during COVID-19: analysis of barriers. Benchmarking: An International Journal, 30(6), 2062–2084.

Herwiyanti, E., Ulfah, P., & Pratiwi, U. (2020). Implementasi standar akuntansi keuangan di UMKM. Deepublish.

Jeppesen, S. (2005). Enhancing competitiveness and securing equitable development: Can small, micro, and medium-sized enterprises (SMEs) do the trick? Development in Practice, 15(3–4), 463–474.

Kaligis, S., Walukow, I., & Rengku, J. (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(07), 1302–1324.

Nursini, N. (2020). Micro, small, and medium enterprises (MSMEs) and poverty reduction: empirical evidence from Indonesia. Development Studies Research, 7(1), 153–166.

Rahardja, U., Aini, Q., & Hardini, M. (2018). Penerapan software akuntansi online sebagai penunjang pencatatan laporan keuangan. Sisfotenika, 8(2), 176–187.

Rissi, D. M., Hatta, E., Oliyan, F., & Herman, L. A. (2020). Pelatihan Pemanfaatan Perangkat Lunak “Mind Own Your Business”(MYOB)-For Accounting V. 25 Sebagai Media Pembukuan Pada Toko One Bangunan Kelurahan Bandar Buat Kota Padang. Akuntansi Dan Manajemen, 15(2), 97–105.

Rosnidah, I., Fatimah, S. E., & Hadyati, S. N. (2022). Pelatihan Penerapan Laporan Keuangan Berbasis Standar Akuntansi Keuangan Entitas Mikro Kecil Dan Menengah (SAK EMKM) Dan Pemasaran Digital Pada Umkm Olahan Limbah Kulit Ikan Di Kota Cirebon. JOURNAL OF SUSTAINABLE COMMUNITY SERVICE, 2(4), 223–231. https://doi.org/10.55047/jscs.v2i4.640

Salim, E. (2019). Pengaruh Penerapan Penggunaan Software Akuntansi MYOB Accounting Dalam Upaya Mempermudah Dan Mengefisienkan Kinerja Pelaporan Keuangan Pada Perusahaan. Jurnal Ekobistek, 92–101.

Suhendar. (2021). Pengantar Akuntansi. Penerbit Adab.

Suyati, S. (2020). Tata Kelola Keuangan Sekolah. Al-Idarah: Jurnal Kependidikan Islam, 10(1), 64–75.

Tambunan, T. T. H. (2023). The potential role of MSMEs in achieving SDGs in Indonesia. In Role of micro, small and medium enterprises in achieving SDGs: Perspectives from emerging economies (pp. 39–72). Springer.

Wiratama, B., Kriswanto, K., Rahayu, S., Nugraha, A. R., & Satriawan, Y. (2019). Penerapan Aplikasi Keuangan Berbasis Android â€ œSi Apikâ€ pada Penyusunan Laporan Keuangan UMKM Biofarmakaka Desa Limbangan Kendal. Rekayasa: Jurnal Penerapan Teknologi Dan Pembelajaran, 17(1), 16–24.

Yulianita, A., Marissa, F., Imelda, I., Asngari, I., Harunnurasyid, H., & Adnan, N. (2022). Pelatihan Peningkatan Kemampuan UMKM dalam Menyusun Laporan Keuangan Sektor Barang dan Sektor Jasa dengan Program MYOB di Masa Pandemi COVID 19. Sricommerce: Journal of Sriwijaya Community Services, 3(1), 81–88.

Zunaidi, R. A., Wahyuni, A. E., Prihadianto, R. D., Tajtibra, F., Septiawan, D. D. P., Nurhalissa, R., Ardianto, Y. M., & Widianto, H. (2023). Urgensi Pencatatan Keuangan Digital berbasis Ponsel UMKM di Kota Surabaya. ABDIMASKU: JURNAL PENGABDIAN MASYARAKAT, 6(1), 56–62.