Pembuatan Laporan Keuangan Berbasis Excel dan Edukasi Pajak Terhadap UMKM Florist Rend Florist
DOI:
https://doi.org/10.37338/2ngzak86Keywords:
MSMEs, Financial Reports, Tax Education.Abstract
This study aims to analyze the condition of financial recording and tax practices in Rend Florist MSMEs in West Tanjung Jabung Regency, as well as to design and implement a simple financial reporting system based on Microsoft Excel which refers to the Indonesian Institute of Accountants through SAK EMKM. The methods which are used include observation, interviews, and direct assistance in the preparation of income statements and financial position statements. The results of the study showed that before mentoring and recording were done manually and unstructured, making it difficult to evaluate business performance and calculate taxes. The implementation of an Excel-based system helps to improve administrative order, calculation accuracy, and the separation between business and personal finance. In addition, the tax education given is able to increase understanding of Final Income Tax obligations and independent tax reporting. Thus, digitizing recording and improving financial and tax literacy contributes to professionalism, accountability, and business sustainability.
References
Adila, R., Ulupui, I. G. K. A., & Utaminingtyas, T. H. (2021). Implementasi SAK EMKM dalam meningkatkan akuntabilitas laporan keuangan: Studi kasus UMKM Mawar. Jurnal Akuntansi dan Keuangan, 2(2), 176–195.
Aprieni, Meilantika, F. R., Sihotang, L., & Rachma, F. V. (2024). UMKM memiliki peran penting dalam perekonomian Indonesia. Jurnal Ekonomi Bisnis dan Manajemen, 2(4), 188–193.
Khafid, I., Miftakhur, R., & Pratama Diah, P. A. (2023). Peranan UMKM dalam penguatan ekonomi Indonesia. Jurnal Pendidikan dan Ilmu Ekonomi Akuntansi, 7(2), 208–217. https://doi.org/10.31851/neraca.v7i2.14344
Pratiwi, S. R., Nainggolan, Y. T., Charitin, D., & Meylin, R. (2021). Edukasi perpajakan bagi UMKM di Kota Tarakan Sulistya. ARSY: Aplikasi Riset kepada Masyarakat, 2(2), 14–22.
Rahmanita, V., & Febriyan. (2022). Komputerisasi pencatatan akuntansi dan pelaporan keuangan berbasis Microsoft Excel pada UMKM Umita Food and Drink. Jurnal Akuntansi, Keuangan dan Perbankan, 9(1), 1655–1663.
Sari, I. A., Rahmatika, D. N., Fajri, A., & Muttaqin, I. (2020). Quality of financial statements and its effects on received credits for small medium enterprise (SMEs) Indonesia. Journal of Business Management Research, 5(1–6).
Syamsul. (2024). Investigasi pencatatan dan pelaporan keuangan UMKM: Apakah disusun berdasarkan standar akuntansi. Jurnal Akuntansi dan Ekonomi, 14(1), 53–62. https://doi.org/10.37859/jae.v14i1.5765
Wardani, P. P., & Sari, I. (2025). Kepatuhan wajib pajak UMKM: Peran sosialisasi perpajakan, pemahaman perpajakan, dan kepercayaan publik kepada pemerintah. Gorontalo Accounting Journal, 8(2), 342–355. https://doi.org/10.32662/gaj.v8i2.3898
Wardiningsih, R., Dewi, R. Y., Khaerul, U., Nila, R., & Nuril, F. N. (2024). Penerapan Excel akuntansi dalam penyusunan laporan keuangan UMKM. Abdimas Musi Charitas, 8(2), 122–133.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 sandi saputra, Johandri Iqbal, Junaidi
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
