WEB-BASED PAYROLL SYSTEM DEVELOPMENT USING THE PROTOTYPING METHOD AND STRUCTURED DATABASE DESIGN
DOI:
https://doi.org/10.33480/jitk.v11i3.7044Keywords:
Database Design, Payroll System, Prototyping Method, User Acceptance Testing, Web-Based ApplicationAbstract
Effective payroll management is essential for accurate salary calculations and efficient financial operations. Many companies, including beverage distribution firms, still rely on spreadsheet-based payroll systems using Microsoft Excel. While Excel provides computational flexibility, it requires extensive human intervention, making it a semi-manual process prone to errors, data inconsistency, and limited scalability. This study develops a web-based payroll information system using a structured workflow that combines the Prototyping method and the Database System Development Life Cycle (DSDLC). Methodology includes business process analysis with the 5W+1H approach, database design using UML, normalization, SQL implementation, and user interface development based on the KISS principle. The system was implemented with MySQL and PHP/Laravel. Evaluation through User Acceptance Testing (UAT) with payroll administrators and HR staff yielded a satisfaction score of 90.8% (Highly Eligible). The successful implementation demonstrates enhanced payroll efficiency, data integrity, and user accessibility. The system shows potential for scalability and future improvements, including cloud integration, advanced security, and financial system connectivity.
Downloads
References
[1] J. Ribeiro, R. Lima, T. Eckhardt, and S. Paiva, “Robotic Process Automation and Artificial Intelligence in Industry 4.0 – A Literature review,” Procedia Comput. Sci., vol. 181, pp. 51–58, 2021, doi: https://doi.org/10.1016/j.procs.2021.01.104.
[2] C. Flechsig, F. Anslinger, and R. Lasch, “Robotic Process Automation in purchasing and supply management: A multiple case study on potentials, barriers, and implementation,” Journal of Purchasing and Supply Management, vol. 28, no. 1, p. 100718, 2022, doi: https://doi.org/10.1016/j.pursup.2021.100718.
[3] Z. Yu, X. Cao, L. Tang, T. Yan, and Z. Wang, “Does digitalization improve supply chain efficiency?,” Financ. Res. Lett., vol. 67, p. 105822, 2024, doi: https://doi.org/10.1016/j.frl.2024.105822.
[4] X. Liu, F. Cheng, R. Zhang, and Z. Li, “Impact of employee compensation structure on company performance: Moderating effects of ownership concentration,” Financ. Res. Lett., vol. 74, p. 106702, 2025, doi: https://doi.org/10.1016/j.frl.2024.106702.
[5] F. Ohunakin and O. A. Olugbade, “Do employees’ perceived compensation system influence turnover intentions and job performance? The role of communication satisfaction as a moderator,” Tour. Manag. Perspect., vol. 42, p. 100970, 2022, doi: https://doi.org/10.1016/j.tmp.2022.100970.
[6] K. A. Obayes and A. Hamzah, “Using of prototyping in develop an employee information management,” Measurement: Sensors, vol. 24, p. 100557, 2022, doi: https://doi.org/10.1016/j.measen.2022.100557.
[7] J. Tang and J. Feng, “Collecting system and payroll tax compliance: Evidence from Chinese firm-level data,” China Economic Quarterly International, vol. 1, no. 2, pp. 135–147, 2021, doi: https://doi.org/10.1016/j.ceqi.2021.04.001.
[8] N. F. Mosha and P. Ngulube, “Metadata Standard for Continuous Preservation, Discovery, and Reuse of Research Data in Repositories by Higher Education Institutions: A Systematic Review,” Aug. 01, 2023, Multidisciplinary Digital Publishing Institute (MDPI). doi: 10.3390/info14080427.
[9] B.-T. Nguyen-Tat, M.-Q. Bui, and V. M. Ngo, “Automating attendance management in human resources: A design science approach using computer vision and facial recognition,” International Journal of Information Management Data Insights, vol. 4, no. 2, p. 100253, 2024, doi: https://doi.org/10.1016/j.jjimei.2024.100253.
[10] I. G. N. K. Bramastha, S. A. Wicaksono, and A. D. Herlambang, “Pengembangan Database E-Learning PT XYZ menggunakan Metode Database System Development Life Cycle,” Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, vol. 7, no. 5, pp. 2469–2474, Aug. 2023, [Online]. Available: https://j-ptiik.ub.ac.id/index.php/j-ptiik/article/view/12685
[11] A. M. Ahmed, C. N. Mohammed, and A. M. Ahmad, “Web-based payroll management system: design, implementation, and evaluation,” Journal of Electrical Systems and Information Technology, vol. 10, no. 1, Mar. 2023, doi: 10.1186/s43067-023-00082-5.
[12] A. I. Irawan and Komarudin Tasdik, “Web Based Payroll Information System Using CodeIgniter at the Regional Secretariat Tasikmalaya Regency,” Journal of Artificial Intelligence and Engineering Applications (JAIEA), vol. 4, no. 1, pp. 10–16, Oct. 2024, doi: 10.59934/jaiea.v4i1.538.
[13] D. Firmansyah and A. Voutama, “Desain Ui/Ux Aplikasi Mobile Pemesanan Makanan Online: Prototyping Menggunakan Figma Dengan Metode Kiss,” Jurnal Informatika dan Teknik Elektro Terapan, vol. 13, no. 2, Apr. 2025, doi: 10.23960/jitet.v13i2.6419.
[14] N. Hiu and Y. Erlyana, “Redesigning User Interface of Datascripmall Mobile Apps Using User Centered Design Method,” Teknika, vol. 13, no. 2, pp. 283–292, Jul. 2024, doi: 10.34148/teknika.v13i2.854.
[15] M. Susanto, M. E. Johan, A. Sulaiman, and M. I. Fianty, “Web-Based Assignment Information System Serves to Improve Economic Research at Universities and Public Services,” Jurnal Informatika Ekonomi Bisnis, pp. 171–176, Feb. 2024, doi: 10.37034/infeb.v6i1.824.
[16] D. Chapela-Campa, I. Benchekroun, O. Baron, M. Dumas, D. Krass, and A. Senderovich, “A framework for measuring the quality of business process simulation models,” Inf. Syst., vol. 127, p. 102447, 2025, doi: https://doi.org/10.1016/j.is.2024.102447.
[17] F. Taymouri, M. La Rosa, M. Dumas, and F. M. Maggi, “Business process variant analysis: Survey and classification,” Knowl. Based. Syst., vol. 211, p. 106557, 2021, doi: https://doi.org/10.1016/j.knosys.2020.106557.
[18] K. Lashkevich, F. Milani, D. Chapela-Campa, I. Suvorau, and M. Dumas, “Unveiling the causes of waiting time in business processes from event logs,” Inf. Syst., vol. 126, p. 102434, 2024, doi: https://doi.org/10.1016/j.is.2024.102434.
[19] J. V. G. de Oliveira, E. A. Portela Santos, and S. P. Detro, “Uncovering the potential and pitfalls of Process Mining in manufacturing,” Procedia CIRP, vol. 132, pp. 19–24, 2025, doi: https://doi.org/10.1016/j.procir.2025.01.004.
[20] N. Nawaz, H. Arunachalam, B. K. Pathi, and V. Gajenderan, “The adoption of artificial intelligence in human resources management practices,” International Journal of Information Management Data Insights, vol. 4, no. 1, p. 100208, 2024, doi: https://doi.org/10.1016/j.jjimei.2023.100208.
[21] W. M. P. van der Aalst, H. A. Reijers, and L. Maruster, “Process mining beyond workflows,” Comput. Ind., vol. 161, p. 104126, 2024, doi: https://doi.org/10.1016/j.compind.2024.104126.
[22] U. Murugesan, P. Subramanian, S. Srivastava, and A. Dwivedi, “A study of Artificial Intelligence impacts on Human Resource Digitalization in Industry 4.0,” Decision Analytics Journal, vol. 7, p. 100249, 2023, doi: https://doi.org/10.1016/j.dajour.2023.100249.
[23] S.-H. Wang, “Enhancing Control of Engineering Worker-hours Using Semantic Analysis Model,” Results in Engineering, vol. 15, p. 100505, 2022, doi: https://doi.org/10.1016/j.rineng.2022.100505.
[24] Y. Mothanna, W. ElMedany, M. Hammad, R. Ksantini, and M. S. Sharif, “Adopting security practices in software development process: Security testing framework for sustainable smart cities,” Comput. Secur., vol. 144, p. 103985, 2024, doi: https://doi.org/10.1016/j.cose.2024.103985.
[25] D. Tissen, I. Wiederkehr, C. Koldewey, and R. Dumitrescu, “Data from start to finish: A System Life Cycle Data Map,” Procedia CIRP, vol. 122, pp. 413–418, 2024, doi: https://doi.org/10.1016/j.procir.2024.01.060.
[26] C. Wohner, J. Peterseil, and H. Klug, “Designing and implementing a data model for describing environmental monitoring and research sites,” Ecol. Inform., vol. 70, p. 101708, 2022, doi: https://doi.org/10.1016/j.ecoinf.2022.101708.
[27] M. G. Guillemette, S. Frechette, and A. Moïse, “Comparing Requirements Analysis Techniques in Business Intelligence and Transactional Contexts:,” International Journal of Business Intelligence Research, vol. 12, no. 2, 2021, doi: https://doi.org/10.4018/IJBIR.294569.
[28] P. Yin and J. Cheng, “A MySQL-Based Software System of Urban Land Planning Database of Shanghai in China,” CMES - Computer Modeling in Engineering and Sciences, vol. 135, no. 3, pp. 2387–2405, 2022, doi: https://doi.org/10.32604/cmes.2023.023666.
[29] R. Kamal, E. E.-D. Hemdan, and N. El-Fishway, “Care4U: Integrated healthcare systems based on blockchain,” Blockchain: Research and Applications, vol. 4, no. 4, p. 100151, 2023, doi: https://doi.org/10.1016/j.bcra.2023.100151.
[30] V. B. Hadikin and J. Wiratama, “Web-Based ERP System Prototype for Enhanced Inventory and Supply Chain Management in the Logistics Industry,” Ultima Infosys : Jurnal Ilmu Sistem Informasi, vol. 15, no. 2, 2024.
[31] T. Taipalus, “Database management system performance comparisons: A systematic literature review,” Journal of Systems and Software, vol. 208, p. 111872, 2024, doi: https://doi.org/10.1016/j.jss.2023.111872.
[32] M. Fotache, M.-I. Cluci, T. Taipalus, and G. Talaba, “The effects of database normalization on decision support system performance,” Inf. Syst., vol. 136, p. 102636, 2026, doi: https://doi.org/10.1016/j.is.2025.102636.
[33] D. Octavian and M. Shoily, “Using Databases in Decision Systems for Businesses Original Article Using Databases in Decision Systems for Businesses: A Review,” International Journal of Data Science and Analysis, vol. Volume 2, pp. 15–20, Jul. 2025.
[34] E. Bjarnason, F. Lang, and A. Mjöberg, “An empirically based model of software prototyping: a mapping study and a multi-case study,” Empir. Softw. Eng., vol. 28, no. 5, Sep. 2023, doi: 10.1007/s10664-023-10331-w.
[35] A. A. Yunanto et al., “Design and Implementation the Prayer Reminder Application using KISS Principle based on User Centered Design,” Procedia Comput. Sci., vol. 234, pp. 1484–1491, 2024, doi: https://doi.org/10.1016/j.procs.2024.03.149.
[36] M. C. Neff et al., “Development and expert inspections of the user interface for a primary care decision support system,” Int. J. Med. Inform., vol. 192, p. 105651, 2024, doi: https://doi.org/10.1016/j.ijmedinf.2024.105651.
[37] T. B. dos Santos, C. Campese, R. M. Marcacini, R. A. Sinoara, S. O. Rezende, and J. Mascarenhas, “Prototyping for user involvement activities: How to achieve major benefits,” CIRP J. Manuf. Sci. Technol., vol. 33, pp. 465–472, 2021, doi: https://doi.org/10.1016/j.cirpj.2021.04.013.
[38] S. Astfalk, J. Silberer, P. Planing, and P. Müller, “The effect of a functional prototype on user acceptance in transportation: Assessing the level of acceptance before and after the first demonstration flight of an air taxi,” Transp. Res. Interdiscip. Perspect., vol. 11, p. 100444, 2021, doi: https://doi.org/10.1016/j.trip.2021.100444.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Felix Tandrio, Melissa Indah Fianty
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
-a.jpg)
-b.jpg)
