Andela, Andela
Unknown Affiliation

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

Found 1 Documents
Search

PERANCANGAN SISTEM LAPORAN KEUANGAN BERBASIS EXCEL DAN PERHITUNGAN PPH FINAL 0,5% UNTUK MENDUKUNG PENGELOLAAN KEUANGAN PADA UMKM SUPER LONTONG Andela, Andela; Eri Bestary Al Haitamy; 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/58csks18

Abstract

UMKM play an important role in the economy; however, many business owners still do not have structured financial records and lack sufficient understanding of tax obligations. This study aims to design a simple financial reporting system using Microsoft Excel in accordance with the Financial Accounting Standards for Micro, Small, and Medium Entities (SAK EMKM) and to provide a simulation of the 0.5% Final Income Tax based on Government Regulation Number 23 of 2018 at Super Lontong UMKM in Jambi City. This research uses a descriptive qualitative method with data collected through observation, interviews, and documentation. The results indicate that the Excel-based system helps UMKM record transactions more neatly, prepare simple financial statements, and understand their financial condition. In addition, the tax calculation simulation improves business owners’ understanding of tax obligations. Overall, this system is expected to support better financial management and increase tax awareness among UMM.