putri
Politeknik Jambi

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

Found 1 Documents
Search

Perancangan Sistem Laporan Keuangan Dan Perpajakan Sederhana Berbasis Microsoft Excel Guna Meningkatkan Akurasi Perhitungan Laba Pada UMKM Griya Perabot putri
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/h041mc44

Abstract

Griya Perabot MSMEs still face challenges in managing financial and tax records due to manual and poorly organized transaction recording, resulting in inaccurate calculations of operating profit and Final Income Tax obligations. This study aims to design a simple financial and taxation reporting system based on Microsoft Excel to improve the accuracy of profit calculation at Griya Perabot MSMEs. This research employs a qualitative method with a case study approach through observation, interviews, and documentation. The system is developed in accordance with the Financial Accounting Standards for Micro, Small, and Medium Entities (SAK EMKM) and adjusted to the capabilities of business owners, covering transaction recording, preparation of simple financial statements, Notes to Financial Statements, and automated calculation of Final Income Tax at a rate of 0.5% of turnover. System testing was conducted through transaction simulations for the November 2025 period. The results indicate that the proposed system improves the organization of financial records, enhances the accuracy of profit calculation, and supports MSMEs in monitoring and preparing for future tax obligations.