Perancangan Sistem Terintegrasi untuk Otomatisasi Perhitungan PPh Pasal 21
Jurnal Akuntansi, Perpajakan dan Auditing · 16.07.2026 · 7 (1) · 85-96
DOI: 10.21009/japa.0701.07 ↗Kurz gefasst
Fachartikel in der Zeitschrift Jurnal Akuntansi, Perpajakan dan Auditing, online erschienen am 16.07.2026. Verfasst von Muhammad Jeasen Allan Budy Kusuma Muhammad Jeasen Allan und 2 weiteren Autor:innen.
Abstract (Originalsprache)
This study aims to design an integrated Microsoft Excel-based system for automating Article 21 Income Tax calculations at PT XYZ. The problem addressed is the difference between internal company calculations and tax consultant calculations due to unintegrated spreadsheets, inconsistent input data, and manual reconciliation. This study applies a Research and Development method using the System Development Life Cycle with a Waterfall model. Data were collected through observation, interviews, and documentation of payroll and tax processing activities. The result is an integrated Excel system containing employee data, income components, deductions, PTKP status, effective tax rate tables, monthly calculations, annual recapitulation, 1721-A1 support, and CSV reporting output for Coretax DJP import. The system improves calculation consistency, supports annual reconciliation, reduces input errors, and prepares structured tax reporting data.
Zitieren
APA
Allan, M. J. A. B. K. M. J., Armeliza, D., & Jaya, T. E. (2026). Perancangan Sistem Terintegrasi untuk Otomatisasi Perhitungan PPh Pasal 21. Jurnal Akuntansi, Perpajakan dan Auditing, 7(1), 85-96. https://doi.org/10.21009/japa.0701.07
Vancouver
Allan MJABKMJ, Armeliza D, Jaya TE. Perancangan Sistem Terintegrasi untuk Otomatisasi Perhitungan PPh Pasal 21. Jurnal Akuntansi, Perpajakan dan Auditing. 2026;7(1):85-96. doi:10.21009/japa.0701.07
BibTeX
@article{Allan2026,
author = {Allan, Muhammad Jeasen Allan Budy Kusuma Muhammad Jeasen and Armeliza, Diah and Jaya, Tresno Eka},
title = {Perancangan Sistem Terintegrasi untuk Otomatisasi Perhitungan PPh Pasal 21},
journal = {Jurnal Akuntansi, Perpajakan dan Auditing},
year = {2026},
volume = {7},
number = {1},
pages = {85--96},
doi = {10.21009/japa.0701.07}
}
EUVIMED