Optimalisasi Pengelolaan Keuangan UMKM Melalui Sistem Pembukuan Terintegrasi Dan Edukasi Perpajakan: Studi Kasus Pada Toko Varietas Mandiri
DOI:
https://doi.org/10.37338/g2wvcb88Keywords:
MSMEs, Integrated Excel, Tax EducationAbstract
This research aims to optimize the financial management of MSMEs through the application of a Microsoft Excel-based bookkeeping system that is integrated with tax education, with a case study on the Independent Variety Store in Bungo Regency. The main problems studied are manual transaction recording that is prone to errors, low tax understanding, and the lack of use of simple digital tools. The research method uses a case study descriptive approach through observation, interviews, and the development of bookkeeping models in accordance with the Financial Accounting Standards for Micro, Small, and Medium Entities (SAK EMKM). The results of the study show that the integrated Excel system is able to improve the efficiency of recording transactions, make it easier to monitor stock, and produce more accurate financial reports. Tax education assistance also increases understanding of NPWP registration procedures and simple tax obligations. The conclusion of this study is that the integration of digital bookkeeping with tax education can be a practical solution for rural areas to improve business sustainability while supporting tax administration compliance.
References
Amalia, F. (2021). Penerapan Penyusunan Laporan Keuangan Berdasarkan Standar Akuntansi Keuangan Entitas Mikro, Kecil, Dan Menengah (SAK EMKM) Pada UMKM Iki Laundry. Politeknik Harapan Bersama.
Antara. (2025). Afirmasi Kebijakan Penghapusan Pajak Usaha Kecil Bagi UMKM. UMKM.Go.Id. https://umkm.go.id/news/trujm0bu4rptb9nde9a8b09h
Astuty, H. S. (2019). Pengelolaan Keuangan. In Praktik Pengelolaan Keuangan Wirausaha Pemula (1st ed., pp. 01–03). Deepublish.
Gahagho, Y. D., Rotinsulu, T. O., & Mandeij, D. (2021). Pengaruh Literasi Keuangan Sikap Keuangan Dan Sumber Pendapatan Terhadap Perilaku Pengelolaan Keuangan Mahasiswa Fakultas Ekonomi Dan Bisnis Unsrat Dengan Niat Sebagai Variabel Intervening. EMBA, 9(1), 543–555.
Indonesia, P. R. (2007). Undang-Undang Republik Indonesia Nomor 28 Tahun 2007 Tentang Perubahan Ketiga Atas Undang-Undang Nomor 6 Tahun 1983 Tentang Ketentuan Umum Dan Tata Cara Perpajakan.
Indonesia, P. R. (2021). Undang-Undang Republik Indonesia Nomor 7 Tahun 2021 Tentang Harmonisasi Peraturan Perpajakan.
Nino, I. J., Manafe, J. D., & Setyorini, T. (2019). Simple Bookkeeping Model Using Microsoft Excel for Culinary Micro-Business in East Nusa Tenggara Indonesia. International Research Journal of Engineering, IT & Scientific Research, 5(2), 29–41.
Nurdiansyah, H., & Rahman, R. S. (2019). Manajemen Keuangan. In Pengantar Manajemen (1st ed., pp. 71–75). Diandra Kreatif.
Pajak, D. J. (2021). Peraturan Direktur Jenderal Pajak Nomor PER-12/PJ/2021.
Pajak, D. J. (2022). Panduan Registrasi. Pajak.Go.Id. https://www.pajak.go.id/id/panduan-registrasi
Prasetyo, B. F. I. (2021). Penyusunan Laporan Keuangan Dengan MS Excel Pada Toko Kelontong Bu Datun Temanggung. Universitas Tidar: Magelang.
Septiani, D., Ferdiansyah, & Sunarto. (2025). Desain Laporan Keuangan UMKM Berbasis Microsoft Excel. Jurnal Keuangan Umum Dan Akuntansi Terapan, 7(1), 52–56.
Sholikhah, S. M., Sugiono, & Tukasno. (2022). Desain Laporan Keuangan Berbasis Microsoft Excel pada UMKM. Peduli: Jurnal Pengabdian Kepada Masyarakat, 2(1), 10–17.
Sitompul, B. R. Y., & Herian, A. (2023). Analisis Penerimaan Aplikasi Kopi Kenangan Menggunakan Metode Technology Acceptance Model. Koloni, 2(2), 116–130. https://doi.org/10.31004/koloni.v2i2.468
Utami, E. R., & Rachmanto, A. (2024). Optimizing Financial Reporting in Small Businesses: Leveraging Microsoft Excel for Efficiency and Accuracy. The 7th International Conference on Business, Economics, Social Sciences, and Humanities (ICOBEST), 284–294.
Vinatra, S. (2023). Peran Usaha Mikro, Kecil, dan Menengah (UMKM) dalam Kesejahteraan Perekonomian Negara dan Masyarakat. Akuntan Publik, 1(3), 01–08.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 linda, Johandri Iqbal, Junaidi
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
