Journal of Applied Accounting And Business (JAAB)
Vol. 8 No. 1 (2026): JAAB Juni 2026

PERANCANGAN SISTEM LAPORAN KEUANGAN BERBASIS EXCEL DAN PERHITUNGAN PPH FINAL 0,5% UNTUK MENDUKUNG PENGELOLAAN KEUANGAN PADA UMKM SUPER LONTONG

Andela, Andela (Unknown)
Eri Bestary Al Haitamy (Unknown)
Ivan Ramadhan (Unknown)



Article Info

Publish Date
12 May 2026

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.

Copyrights © 2026






Journal Info

Abbrev

jaab

Publisher

Subject

Economics, Econometrics & Finance

Description

Jurnal JAAB (Jurnal of Applied Accounting And Business) adalah jurnal peer-review yang ditujukan untuk menerbitkan penelitian-penelitian terkait penerapan akuntansi dan bisnis termasuk sistem informasi akuntansi. Jurnal ini difokuskan kepada disiplin ilmu akuntansi, bisnis, dan sistem informasi ...