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

PERANCANGAN SISTEM PENCATATAN KEUANGAN DAN PERHITUNGAN PAJAK UMKM BERBASIS EXCEL UNTUK PENENTUAN HARGA POKOK PENJUALAN PADA KUE TRADISIONAL DINA VEZA

Pandiangan, Roslita (Unknown)
Al Haitamy, Eri Bestary (Unknown)
Ramadhan, Ivan (Unknown)



Article Info

Publish Date
14 May 2026

Abstract

Micro, Small, and Medium Enterprises (MSMEs) play an important role in thenational economy; however, many MSME actors have not yet implementedsystematic and standardized financial recording practices. This condition is alsoexperienced by Dina Veza Traditional Cake MSME, which still relies on manualfinancial records, making it difficult to determine business profits, calculate theCost of Goods Sold (COGS), and fulfill tax obligations accurately. This study aimsto design a Microsoft Excel–based financial recording and tax calculation systemto support accurate COGS determination and assist in calculating the 0.5% FinalIncome Tax for MSMEs in accordance with Government Regulation Number 23 of2018. The research uses a descriptive qualitative approach, with data collectedthrough observation, interviews, and documentation. The financial recordingsystem is developed based on the Financial Accounting Standards for Micro, Small,and Medium Entities (SAK EMKM) and utilizes Microsoft Excel as a practicalrecording tool. The results indicate that the system improves the accuracy andorganization of financial records, facilitates precise COGS calculation, and assistsMSMEs in calculating and reporting Final Income Tax based on business turnovermore effectively

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