IMPLEMENTATION OF AN EXCEL-BASED SALES AND INVENTORY RECORDING SYSTEM TO DETERMINE GROSS TURNOVER AS THE BASIS FOR FINAL INCOME TAX FOR THE ATAN APPAREL GARMENT SME

Abstract

This study aims to analyze the sales and inventory recording system used at the Atan Apparel MSME and to evaluate its accuracy in determining gross revenue as the basis for calculating Final Income Tax. This study employs a descriptive qualitative approach with a case study design through observation, interviews, and documentation. The results show that prior to the implementation of the system, record-keeping was still conducted in a simple and non-integrated manner, making it prone to errors. The Microsoft Excel-based system developed in this study successfully integrates five worksheets, namely Dashboard, Sales, Cash Flow, Inventory, and Cost of Goods Sold (COGS), enabling the automatic and real-time generation of revenue, gross turnover, and estimated Final Income Tax information. A comparison of May 2026 revenue data between manual records and the system's output revealed a discrepancy of IDR 4,865,000, caused by differences in the selling-price calculation method rather than a system error. The system also automatically calculates the estimated Final Income Tax based on a 0.5% rate applied to gross revenue exceeding IDR 500,000,000 per tax year, thereby producing more accurate and reliable information as a reference for Atan Apparel's tax calculations. This study recommends that the system be applied on an ongoing basis and further developed using VBA-, Microsoft Access-, or cloud-based technology in future research.

Keywords: Sales and Inventory Recording, Microsoft Excel, Gross Revenue, Final Income Tax for MSMEs