HR Payroll System — Data

HR Payroll System — Data Cleaning, Merge, Auto Refresh & Summary Dashboard

Client had two separate sheets — employee information and monthly payroll records that needed to be cleaned and combined into one master table.

Cleaned both sheets independently, fixed the inconsistencies department and location names, unified date formats, handled all missing values and calculated correctly Net Pay for every employee.

Merged both sheets using Employee ID as the common key. Built an Input Sheet so the client adds new monthly payroll data and clicks Refresh to update everything automatically. Delivered a Summary Dashboard showing total monthly payroll, highest earner, average salary, and the HR Payroll System — Data Cleaning, Merge, Auto Refresh & Summary Dashboard