Perancangan PERANCANGAN STRATEGI IMPLEMENTASI PEMBUKUAN PADA UMKM DENGAN MENGGUNAKAN SISTEM KEUANGAN DAN PAJAK SEDERHANA DENGAN MENGGUNAKAN EXCEL PADA RUMAH MAKAN Y.F SAUDARA
DOI:
https://doi.org/10.37338/kbqszh96Keywords:
MSMEs, Microsoft Excel, MSME TaxationAbstract
Micro, Small, and Medium Enterprises (MSMEs) often face difficulties in implementing structured bookkeeping and financial reporting in accordance with accounting standards. Rumah Makan Y.F Saudara still applied manual financial recording, resulting in difficulties in determining profit and tax obligations. This study aims to design and implement a simple bookkeeping and taxation system based on Microsoft Excel in accordance with the Financial Accounting Standards for MSMEs (SAK EMKM). This research uses a qualitative approach with data collection through observation, interviews, and documentation. The designed system includes cash transactions, purchases, sales, income statements, notes to financial statements, and MSME final income tax calculation. The results show that Microsoft Excel improves accuracy, organization, and ease of financial management and helps MSMEs understand their financial condition and tax responsibilities.
References
S. Sopiah, A. Nurhasanah, L. Purnamasari, and R. Octora, “Pembukuan Akuntansi Sederhana Pada UMKM,” pp. 197–202.
Edukasi, J., & Kunci, K. (2025). Optimalisasi Pembukuan UMKM melalui Aplikasi Excel dan Google Sheets. 1, 13–18.
Garry D. Carnegie dan Christopher J. Napier. (2023). Akuntansi, Akuntabilitas, dan Tata Kelola (1st ed.). Rada Naukowa SKwP.
Haikal, F., Sulistioanto, R. H., & Suryani, B. (2025). Building Entrepreneurial Intention: The Role of Education, Environment, and Self-Efficacy in Driving MSME Success. Jurnal Manajemen dan Kewirausahaan, 13(2), 214-227.
Hakiki, A., Rahmawati, M., & Novriansa, A. (2020). Penggunaan Sistem Informasi Akuntansi untuk Usaha Mikro Kecil dan Menengah ( UMKM ) di Desa Kota Daro ,. 1(1).
Ilmiah, J., & Akuntansi, R. (2023). 3 1,2,3. 12(01), 420–428.
Khodijah, S., & Syifa, N. (2025). Pelatihan Pencatatan Keuangan Sederhana Berbasis Excel Bagi Pelaku UMKM. 1(1), 8–14.
Monika, G., Prastiwi, I., Pamikatsih, T. R., Tinggi, S., Ekonomi, I., Tengah, S. J., Tinggi, S., Ekonomi, I., & Tengah, S. J. (2025). Jurnal ilmiah akuntansi. 2(1), 39–48.
Pengaruh, D., Informasi, P., Hanifah, R. U., G, M. A., & Widyakto, A. (2023). Peran Akuntansi Pada Era Society 5 . 0 Sebagai Anteseden Terhadap Pertumbuhan Kinerja Umkm. 7(April), 1732–1751.
Sak, K., Garassi, P., Di, C., & Tabalong, K. (2025). ISSN : 2723-0937 DOI. 10.35722/japb Https://jurnal.stiatabalong.ac.id/index.php/JAPB. 8, 2168–2181.
Setyawardani, L. (2019). PRAKTEK PEMBUKUAN DOUBLE ENTRY BAGI PELAKU UMKM DALAM MENYUSUN LAPORAN KEUANGAN DENGAN MICROSOFT EXCEL BERBASIS.
Setyorini, C. T., Susilowati, D., Universitas, B., Soedirman, J., Bunyamin, J. H. R., & Tengah, J. (2018). Analysis of Implementation of SMEs Tax Enforcement : The effects of tax justice dimensions , understanding of tax account- ing on SME ‟ s tax co mpliance. 21(1), 1–12. https://doi.org/10.14414/jebav.845
Sopiah, S., Nurhasanah, A., Purnamasari, L., & Octora, R. (n.d.). Pembukuan Akuntansi Sederhana Pada UMKM. 197–202.
Tarif, P., Penghasilan, P., & Dan, P. (2024). PAJAK ORANG PRIBADI PADA KARYAWAN PT EMBOSSINDO. 4(2), 318–329.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Lili Mardianasari, Johandri Iqbal, Dwi Novrian Yuliansyah
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
