Designing Designing Financial and Taxation Reports Based On Microsoft Excel To Support Efficiency Production Costs In UMKM Ayam Geprek Miss Deppy
Designing Financial and Taxation Reports Based On Microsoft Excel To Support Efficiency Production Costs In UMKM Ayam Geprek Miss Deppy
DOI:
https://doi.org/10.37338/njbb1x81Keywords:
Keywords: Financial Statements, Taxation, Microsoft Excel.Abstract
Ayam Geprek Miss Deppy MSMEs do not have a structured financial and tax recording system, making it difficult for business owners to know their financial condition and control production costs. This research aims to design financial and taxation reports based on Microsoft Excel in accordance with the Financial Accounting Standards for Micro, Small, and Medium Entities (SAK EMKM) to support production cost efficiency. The research method used is a descriptive qualitative method with data collection techniques through observation, interviews, and documentation. The data obtained was analyzed by designing a Microsoft Excel-based financial recording system which includes recording transactions, income statements, calculation of cost of production, and tax calculations. The results of the study show that the application of Microsoft Excel-based financial statements helps MSMEs in compiling financial statements more systematically and makes it easier to control production costs, thereby supporting business decision-making.
Keywords: Financial Statements, Taxation, Microsoft Excel.
References
Adi Rachmanto, & Utami, E. R. (2024). Pemanfaatan Microsoft Excel dalam penyusunan laporan keuangan UMKM. Jurnal Akuntansi dan Keuangan, 9(1), 45–56.
Apandi, A., et al. (2024). Tantangan pengelolaan keuangan pada usaha kuliner ayam geprek. Jurnal Manajemen UMKM, 6(2), 112–121.
Ginting, R., & Ruzikna. (2024). Analisis pencatatan keuangan dan kepatuhan pajak pada UMKM kuliner. Jurnal Akuntansi Terapan, 5(1), 33–41.
Hapsari, D., et al. (2024). Peran UMKM dalam pertumbuhan ekonomi nasional. Jurnal Ekonomi Pembangunan, 12(1), 1–10.
Kieso, D. E., Weygandt, J. J., & Warfield, T. D. (2020). Intermediate Accounting (17th ed.). Hoboken: John Wiley & Sons.
Moleong, L. J. (2021). Metodologi Penelitian Kualitatif. Bandung: PT Remaja Rosdakarya.
Mulyadi. (2020). Akuntansi Biaya. Yogyakarta: STIE YKPN.
Riyani, E., et al. (2024). Implementasi Microsoft Excel dalam sistem pencatatan keuangan UMKM. Jurnal Sistem Informasi Akuntansi, 4(2), 88–97.
Septiani, R., Ferdiansyah, A., & Sunarto. (2021). Penggunaan Microsoft Excel sebagai alat bantu penyusunan laporan keuangan UMKM. Jurnal Akuntansi dan Bisnis, 7(1), 25–34.
Sugiyono. (2021). Metode Penelitian Kualitatif, Kuantitatif, dan R&D. Bandung: Alfabeta.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Hadryah Febriyanti, Eri Bestary Al Haitamy, Dwi Novrian Yuliansyah
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
