"This project involved preparing a structured payroll summary using Microsoft Excel to support monthly salary processing and overtime calculation. I designed the sheet to capture employee details, basic salary, overtime hours, overtime amount, and gross salary in a clear and organized format. The goal was to ensure payroll accuracy, reduce manual errors, and make salary review easier for management. This type of payroll summary is commonly used by HR and finance teams for internal payroll verification and reporting before final salary disbursement."
An automated Excel-based Payroll & OT Management system designed to streamline monthly salary disbursement. This project features dynamic formulas for Overtime (OT) calculation, basic salary structuring, and comprehensive gross salary reporting. It reduces manual entry errors by 40% and ensures full transparency for HR and Finance audits, providing management with a one-click summary of workforce costs.