Ivan Ramadhan
Politeknik Jambi

Published : 2 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 2 Documents
Search

IMPLEMENTASI SISTEM LAPORAN KEUANGAN DAN PERHITUNGAN PPH FINAL BERBASIS MICROSOFT EXCEL SEBAGAI UPAYA PENENTUAN LABA PADA UMKM KUE MAMA FADIL Pemas Hamonangan Sinaga; Johandri Iqbal; Ivan Ramadhan
Journal of Applied Accounting And Business Vol. 8 No. 1 (2026): JAAB Juni 2026
Publisher : LP2M Politeknik Jambi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.37338/sntnqj72

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.
Penerapan SAK EMKM dan PP No.55/2022 Berbasis Excel Untuk Peningkatan Laporan Keuangan dan Perhitungan PPh Final Pada UMKM Brownmix Factory Evi Andari; Johandri Iqbal; Ivan Ramadhan
Journal of Applied Accounting And Business Vol. 8 No. 1 (2026): JAAB Juni 2026
Publisher : LP2M Politeknik Jambi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.37338/h6wkaj34

Abstract

This study aims to determine how the Financial Accounting Standards for Micro, Small, and Medium Entities (SAK EMKM) and Government Regulation No. 55 of 2022 implemented through excel can improve the quality of financial reports and final income tax calculations at Brownmix Factory MSMEs. The research method used is descriptive qualitative with the type of applied research. Data collection techniques are carried out through observation, interviews and documentation. The results of the study indicate that Brownmix Factory does not yet have systematic financial reports in accordance with SAK EMKM and has not calculated final income tax because it only focuses on recording incoming and outgoing cash and production operational activities. Brownmix Factory has structured, accurate and standardized financial reports and calculates final income tax according to applicable tax regulations after implementing an excel template integrated with SAK EMKM and PP No. 55 of 2022 in its financial recording process.