Design DESIGN OF A SIMPLE EXCEL-BASED FINANCIAL REPORTING AND TAXATION SYSTEM FOR TIME EFFICIENCY DATA MANAGEMENT IN BAKULAN ICUY UMKM
DESIGN OF A SIMPLE EXCEL-BASED FINANCIAL REPORTING AND TAXATION SYSTEM FOR TIME EFFICIENCY DATA MANAGEMENT IN BAKULAN ICUY UMKM
DOI:
https://doi.org/10.37338/f8qs4j96Keywords:
Financial Reports, Taxation, Microsoft Excel, Time Efficiency, MSMEs.Abstract
Automation of the Microsoft Excel-based financial and tax reporting system at Bakulan Icuy MSME is designed to overcome the constraints of manual recording and time inefficiency. Using a descriptive qualitative method, this research produces an integrated system that includes General Journal modules, Income Statements, and Balance Sheets in accordance with SAK EMKM, as well as 0.5% Final Income Tax calculations. The results indicate that the implementation of this system significantly improves data accuracy and financial management time efficiency. Through this system, Bakulan Icuy MSME can generate reliable financial information to support tax compliance and more effective business decision-making.
References
C. T. Kholifah, ALif Nur & Andini, “Peran UMKM Terhadap Perekonomian Di Indonesia,” J. Ekon. Akuntansi, Manaj., vol. 2, no. 2, pp. 91–107, 2023.
S. Widati, V. Yulianti, D. S. Wulandari, and A. D. Pratama, “Pemberdayaan UMKM melalui Literasi Akuntansi dan Pajak untuk Penguatan Legalitas Usaha,” Lentera Pengabdi., vol. 3, no. 02, pp. 126–135, 2025, doi: 10.59422/lp.v3i02.863.
Syamsul, “Analisis Pencatatan dan Pelaporan Keuangan UMKM Di Kota Palu,” vol. 10, no. 1, pp. 33–42, 2022.
Y. & A. Sulistiyowati, “Pengaruh Penggunaan Teknologi Akuntansi Terhadap Efisiensi Pengelolaan Keuangan UMKM di Kota Malang,” Cross-Border J. Kaji. Perbatasan Antarnegara, Diplomasi dan Hub. Internasional., vol. 1, no. 2, pp. 66–82, 2018.
U. Nandiroh, I. Hidayati, and N. Badria, “Penyusunan Laporan Keuangan dan SPT Tahunan Wajib Pajak UMKM,” Din. J. Pengabdi. Kpd. Masy., vol. 2, no. 2, pp. 73–80, 2022, doi: 10.33752/dinamis.v2i2.599.
E. Sayogo and F. A. Deta, “Studi Efisiensi Penyusunan Laporan Keuangan di UMKM Deta Tehnik: Peran Software Akuntansi dan Indikator Pengukuran,” Pros. Natl. Semin. Accounting, Financ. Econ., vol. 4, no. 5, pp. 172–180, 2024.
YUSVANZA BRIYAN SAPUTRA, “Efektifitas dan Efisiensi Penggunaan Sistem Informasi Komputerisasi Akuntansi Pada Perumda Tirta Manuntung Balikpapan,” Kompak J. Ilm. Komputerisasi Akunt., vol. 16, no. 1, pp. 209–214, 2023, doi: 10.51903/kompak.v16i1.1149.
M. A. Al Doghan and V. P. K. Sundram, “Organization operational efficiency and Innovativeness: Exploring the role of employees’ task-based training, operational task commitment, operational engagement, and supervisor support,” Int. J. Oper. Quant. Manag., vol. 29, no. 1, pp. 108–127, 2023, doi: 10.46970/2022.29.1.7.
R. Alamsyah and A. Rahman, “Peran Penting Laporan Keuangan Dalam Upaya Meningkatkan Kinerja Usaha Mikro Kecil Menengah ( UMKM ) The Important Role of Financial Reports in Improving Micro Small Medium Enterprise ( MSME ) Performance,” pp. 308–315.
M. D. Lestari, Y. Prayoga, and M. Ritonga, “Pengaruh Digitalisasi Akuntansi Terhadap Efesiensi Dan Kualitas Laporan Keungan UMKM di Rantauprapat JURNAL MEDIA INFORMATIKA [ JUMIN ],” J. Media Inform. [Jumin], vol. 6, no. 3, pp. 2029–2036, 2025
A. S. W. Ramadhan, A. Z. Lubna, A. N. A. Safitri, I. Cahyaningrum, and W. P. C. Wardhani, “Pentingnya Pemahaman dan Penerapan Ilmu Akuntansi Terhadap Kualitas Usaha Bagi Pelaku UMKM,” J. Ekon. Manaj. dan Akunt., vol. 2, no. 1, pp. 96–104, 2024, [Online]. Available: https://jsr.lib.ums.ac.id/index.php/determinasi▪page96
Priharto, “Bab II Landasan Teori,” Pengertian Lap. Keuang., vol. 53, no. 9, pp. 1689–1699, 2019.
A. Afif, “Implementasi Pengelolaan Keuangan Pelaku UMKM berdasarkan SAK-EMKM. Jurnal Akuntansi Auditing dan Investasi,” vol. 2, no. 1, pp. 24–35, 2021, [Online]. Available: https://jurnal.upb.ac.id/index.php/jadi/article/view/195
T. Sukma et al., “Economics and Digital Business Review Standar Akuntansi Keuangan ( SAK ) di Indonesia Kajian Pustaka,” Econ. Digit. Bus. Rev., vol. 6, no. 2, 2025.
Parmono A and Zahriyah A, “Pelaporan Keuangan Pada Usaha Mikro Kecil Dan Menengah,” J. Ilm. Akunt. Indones., vol. Vol. 6, No. 2, no. Pelaporan Keuangan Pada Usaha Mikro Kecil dan Menangah, pp. 211–241, 2021.
Andina et al, “Penyusunan Laporan Keuangan Sederhana Untuk UKM (Kasus Pada Up Cool Consulting),” J. Ris. Akunt., vol. 13, no. 1, pp. 51–61, 2021.
E. Margareta and A. L. Siahaan, “Pengembangan Sistem Laporan Keuangan Berbasis Microsoft Excel pada BUMDes Desa Jaranguda Kabupaten Karo,” J. Pendidik. dan Konseling, vol. 4, no. 6, pp. 1707–1715, 2022.
Z. C. Nessa Maulidhyna, “Analisis Fungsi Pajak dalam Negara Modern Berdasarkan Perspektif Ekonomi Islam UIN Siber Syekh Nurjati Cirebon , Indonesia dan berfokus pada kesejahteraan masyarakat .,” J. Bisnis, Ekon. Syariah, dan Pajak Vol. 2, Nomor. 2 Juni 2025, 2025.
Annisa Febrianda, Rania Atikah Putri, Siti Nurhaliza, and Dini Vientiany, “Subjek dan Objek Pajak Penghasilan,” MENAWAN J. Ris. dan Publ. Ilmu Ekon., vol. 2, no. 4, pp. 291–300, 2024, doi: 10.61132/menawan.v2i4.743.
Stefani Stefani and Anggun Rohaya, “Memahami Pajak Penghasilan Final, Fokus pada PPH Pasal 4 Ayat 2,” J. Nuansa Publ. Ilmu Manaj. dan Ekon. Syariah, vol. 3, no. 3, pp. 212–215, 2025, doi: 10.61132/nuansa.v3i3.1947.
Sujawerni Wiratna V., “Metodologi Penelitian,” 2020.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Dwi Ratna Febriani
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
