.png)
To ensure smooth payroll management and transparent reporting at construction sites, I created a dynamic Excel-based salary tracking system.
This sheet automates and organises the entire worker payment process — from daily attendance to monthly salary summaries.
🔹 Key Features:
- Daily work tracking for each worker (Name, Title, Days, Pay Rate, Total Pay).
- Automatic total calculation for daily, weekly, and monthly payments.
- Colour-coded cells to identify issues, pending wages, and worker categories.
- Separate sections for monthly totals, weekly reports, and old/new worker records.
- Real-time updating of payment status and overall site expenditure.
🧮 Tools Used:
- Microsoft Excel (Formulas, Conditional Formatting, Table Design)
- Data Validation for consistency and error-free entry
📊 Outcome:
This system simplified salary management, reduced calculation errors, and provided clear, organised financial visibility for site operations.
