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

PERANCANGAN SISTEM LAPORAN KEUANGAN DAN PAJAK BERBASIS MISCROSOFT EXCEL SEBAGAI UPAYA OPTIMALISASI ADMINISTRASI KEUANGAN UMKM CORNDOG MOZA

Nanda, dea pratama (Unknown)



Article Info

Publish Date
12 May 2026

Abstract

UMKM Corndog Moza still faces challenges in managing financial administration and taxation due to manual and unstructured transaction recording, which results in suboptimal financial reporting and tax calculation. This study aims to design a Microsoft Excel–based financial and tax reporting system as an effort to optimize the financial administration of UMKM Corndog Moza. The research method used is descriptive qualitative with a system design approach, employing observation, interviews, and documentation techniques. The results show that the designed Microsoft Excel–based system is able to facilitate more organized, automated, and accurate financial transaction recording, as well as generate income statements, statements of financial position, and Final Income Tax (PPh Final) calculations for UMKM in accordance with applicable tax regulations. Therefore, the implementation of a Microsoft Excel–based financial and tax reporting system can improve the efficiency of financial administration and support tax compliance for UMKM Corndog Moza.

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 ...