IMPLEMENTASI SISTEM LAPORAN KEUANGAN DAN PERHITUNGAN PPH FINAL BERBASIS MICROSOFT EXCEL SEBAGAI UPAYA PENENTUAN LABA PADA UMKM KUE MAMA FADIL
DOI:
https://doi.org/10.37338/sntnqj72Keywords:
MSMEs, Financial Statements, Final Income Tax.Abstract
This study aims to implement a Microsoft Excel–based financial reporting system and Final Income Tax (PPh Final) calculation as an effort to determine profit at UMKM Kue Mama Fadil. The main problems identified include manual financial recording, non-compliance with the Financial Accounting Standards for Micro, Small, and Medium Entities (SAK EMKM), and the absence of Final Income Tax calculation in accordance with Government Regulation Number 55 of 2022. This research applies an applied research method with a descriptive qualitative approach through observation, interviews, and documentation. The results indicate that the implementation of a Microsoft Excel–based financial reporting system enables the UMKM to record transactions systematically, prepare financial statements in accordance with SAK EMKM, determine business profit more accurately, and calculate Final Income Tax automatically and in an integrated manner. The system also improves the owner’s understanding of the business’s financial condition and tax obligations. Therefore, the Microsoft Excel–based financial reporting and Final Income Tax calculation system is considered effective and sustainable in supporting UMKM financial management. Keywords: MSMEs, Financial Statements, Final Income Tax.
References
Azkiya, Siti Rahmatul, and Labibah Labibah. (2023). “Analisis Penerimaan Aplikasi Ikalsel Menggunakan Teori Technology Acceptance Model (TAM).” UNILIB : Jurnal Perpustakaan 14(1):21–31.
Izzah, Tasya Reviana Nurul, Vinata Dyah Ayu Pratiwi, and Erna Chotidjah Suhatmi. (2025). “Efektivitas Digitalisasi Perpajakan Dalam Meningkatkan Kepatuhan Pajak UMKM : Peluang Dan Hambatan.” Jurnal Bengawan Solo 4(1):1–9.
Kania, Euis, and Arry Irawan. (2021). “Penyusunan Laporan Keuangan Berdasarkan SAK EMKM Berbantuan Microsoft Excel Pada UMKM Uncal.Co.” Indonesian Accounting Literacy Journal 1(2):338–52.
Laksana, Angga, Sugianto Sugianto, and Rahmat Daim Harahap. (2024). “Implementasi Standar Akuntansi Keuangan Entitas Mikro Kecil Dan Menengah (SAK-EMKM) Dalam Penyusunan Laporan Keuangan Pada Toko Sinar Berkah Kabupaten Deli Serdang.” Inisiatif: Jurnal Ekonomi, Akuntansi Dan Manajemen 3(2):346–57.
Pantow, Andreuw K., Ivoletti M. Walukow, Christony Maradesa, and Esrie A. N. Limpeleh. (2021). “Desain Laporan Keuangan Umkm Berbasis Microroft Excel Pada Sunshine Laundry.” Jurnal Bisnis Terapan 05:271–86.
Pratama, Muhammad Yudha, and Lili Indrawati. (2021). “Perancangan Model Laporan Keuangan Berdasarkan SAK EMKM Berbasis Microsoft Excel (Studi Kasus Pada Kelompok Usaha Menengah Jasa Ekspedisi Pupuk Kujang-Kab. Karawang).” Indonesian Accounting Literacy Journal 1(2):314–27.
Putri, Ajeng Aditya, and Herbirowo Nugroho. (2024). “Perancangan Sistem Pencatatan Transaksi Dan Pelaporan Keuangan Menggunakan Google Spreadsheet Studi Kasus Pada UMKM Percetakan Tunas Karya.” Prosiding Seminar Nasional Akuntansi Dan Manajemen 5(2).
Rofiq, Muhammad Husnur, and Rahma Nazila Muhammad. (2022). “Penyusunan Laporan Keuangan Berdasarkan SAK EMKM Berbantuan Microsoft Excel 2016 (Studi Kasus UMKM Laila Collection.” Indonesian Accounting Literacy Journal 02(02):317–36.
Tezar, Muhammad, and Julianto. (2022). “Rancangan Aplikasi Sistem Pelaporan Keuangan Berbasis Google Spreadsheet Untuk Usaha Mikro Kecil Dan Menengah (Umkm) CV Wira Gemilang.” Jurnal Sistem Informasi Dan Manajemen 10(3).
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Pemas Hamonangan Sinaga, Johandri Iqbal, Ivan Ramadhan
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
