If you run a construction site with daily-wage workers, payroll day is probably the most stressful day of the week. You're cross-checking attendance registers, punching numbers into Excel, second-guessing half-day entries, and hoping nobody disputes the final figure.
The problem isn't that you're doing it wrong — it's that the process is fragile. Manual entry means human error. Shared spreadsheets mean version conflicts. And when a worker challenges his wages, you have no audit trail to fall back on. This article walks through the right formula for daily wage payroll and explains how to remove the risk entirely.
The Daily Wage Payroll Formula
At its core, calculating daily labour payroll comes down to four components:
The Formula
Basic Wage = Daily Rate × Days Worked
Half-Day = Daily Rate × 0.5 (per half-day present)
OT Amount = (Daily Rate ÷ 8) × 1.5 × OT Hours
Gross Pay = Basic Wage + OT Amount + Bonuses + Allowances
Net Pay = Gross Pay − Advances − Loans − Other Deductions
Simple in theory. But across 20–50 workers, with varying attendance every single day, doing this manually in Excel becomes error-prone very quickly — especially when you're managing more than one site.
Where Excel Goes Wrong
Excel is a powerful tool — but it wasn't designed for daily labour management on a construction site. Here's where things break down:
Attendance entered separately, payroll done separately
Attendance is recorded in one sheet, payroll is calculated in another. A copy-paste mistake or a missed row means someone gets underpaid or overpaid — and you won't catch it until payday.
No half-day or overtime logic built in
Excel doesn't know that "H" means half-day, or that overtime is 1.5× the hourly rate. You have to build and maintain custom formulas — and every formula is a potential point of failure.
No approval workflow
Anyone with file access can edit the sheet. There's no record of who changed what or when. If a dispute arises, you have no audit trail to show the worker.
Multi-site management is nearly impossible
If you have workers across two or more sites, you're maintaining separate Excel files, reconciling them manually, and spending hours doing something a well-designed system can do in seconds.
The Better Way: Attendance-Linked Payroll
The fix is to connect attendance and payroll — so that when you mark a worker Present, Half-Day, or Overtime, the payroll is calculated automatically. No copy-paste. No formula maintenance. No disputes.
This is how SiteSmartly handles it:
Set the daily wage once per worker
Each employee profile stores a daily rate (or fixed monthly salary). You set it once — you never recalculate it manually again.
Mark attendance daily — Present, Absent, Half-Day, Leave
Your site supervisor marks attendance from their phone each day. Half-day and overtime hours are recorded at the same time. No paper register, no end-of-month data entry rush.
Approve attendance — then generate payroll in one click
Once attendance is approved, payroll is generated automatically. Days worked, half-days, overtime, deductions — all computed from the attendance records. You review and approve, not calculate.
Pay weekly or monthly — and record every payment
Many construction workers expect weekly wages. SiteSmartly supports both weekly (Sun–Sat) and monthly payroll cycles. Partial payments are tracked too — so if you pay an advance mid-week, the balance is always clear.
"When a worker questions his wages, I open the app and show him: these are the days you worked, here's your rate, this is your total. The conversation ends in 30 seconds."
Weekly vs. Monthly Payroll — Which Is Right for Your Site?
In India, most daily-wage construction workers expect to be paid weekly — especially migrant labour. A monthly pay cycle can cause cash-flow stress for workers and high turnover for you. Here's a quick guide:
| Factor | Weekly Payroll | Monthly Payroll |
|---|---|---|
| Best for | Daily-wage, migrant labour | Salaried staff, supervisors |
| Worker retention | Higher — cash in hand regularly | Works for committed employees |
| Advance payments | Handled as partial payment within the week | Deducted from monthly net pay |
| Accounting effort | More frequent — needs automation | One run per month |
A Checklist Before Payroll Day
Whether you're using Excel or a construction app, run through this checklist before generating payroll:
-
All attendance marked — No blank days for any active worker on the site. Absent is still a valid entry; missing is a data gap.
-
Overtime hours verified — OT is expensive at 1.5× rate. Make sure overtime claims are backed by a supervisor sign-off, not just a worker's self-report.
-
Advances recorded — Any cash given to a worker during the period should be logged as an advance so it's deducted automatically from net pay.
-
Daily rates up to date — Worker rates can change mid-project. Make sure any rate revisions are applied from the correct date, not backdated incorrectly.
-
Attendance approved by a manager — Don't generate payroll from unapproved attendance. An approval step ensures a second set of eyes catches errors before money goes out.
Stop calculating payroll by hand
SiteSmartly automates daily wage payroll from attendance — with approval workflows, weekly or monthly cycles, and a full audit trail. Free to start.
Try SiteSmartly FreeSummary
Daily labour payroll doesn't have to be painful. The formula is simple — daily rate × days worked + overtime − deductions. The hard part is collecting accurate attendance data every day and converting it into payroll without introducing errors.
The solution is to link your attendance and payroll systems. When attendance is marked digitally, approved by a manager, and fed directly into a payroll calculation, the risk of error drops to near zero — and payday becomes the easy part.