Labour Wage & Overtime Calculator
Pay your crew by attendance: days, half days, overtime, advances and net pay, with a trade-wise summary. Keep your crew on this device and each week you only mark the days.
Free · Download as a muster roll in Excel · Signed in, every week is kept in My work
This is an example. Change anything to see how it works; it is never saved to your account.
Start your ownNot the right tool? Labour-only contract: labour bill. Paying workers by attendance: labour wages.
Keep this crew on this device?
Then next week starts with your workers and wages filled in. Nothing is sent to InstaBOQ.
How the wages are calculated
- Days worked = days present + ½ × half days.
- Basic wages = days worked × daily wage.
- Overtime wages = OT hours × (daily wage ÷ normal hours per day) × overtime multiplier.
- Net payable = basic + overtime − advance − PF/ESI − other deductions.
- A worker with no daily wage is marked RATE MISSING and left out of the totals — never paid as ₹0.
Worked example
Three workers on an 8-hour day with an overtime multiplier of 2. These figures are computed by the same code as the calculator above; the wages are illustrative.
| Worker | Days | OT hrs | Wage ₹/day | Basic ₹ | OT ₹ | Deductions ₹ | Net ₹ |
|---|---|---|---|---|---|---|---|
| Ramesh (mason) | 6 | 6 | 850 | 5,100.00 | 1,275.00 | 500.00 | 5,875.00 |
| Suresh (mason) | 5.5 | 0 | 850 | 4,675.00 | 0.00 | 0.00 | 4,675.00 |
| Sunita (helper) | 5 | 4 | 520 | 2,600.00 | 520.00 | 0.00 | 3,120.00 |
Questions
How do you calculate overtime wages for a construction worker?
Divide the daily wage by the normal working hours to get the hourly rate, then multiply by the overtime hours and by the overtime multiplier. At Rs. 850 a day for an 8-hour day and a multiplier of 2, six hours of overtime is 850 / 8 x 6 x 2 = Rs. 1,275.
Why is the overtime multiplier 2?
The statutory overtime rate for building and construction workers is twice the ordinary rate of wages, so the calculator starts at 2. Change it if your contract or the law that applies to your site says otherwise.
How is a half day counted?
As half a day worked. Five full days and one half day is 5.5 days, paid at 5.5 x the daily wage.
Does the calculator include minimum wage rates?
No. Minimum wages are notified by the Central or State government by category of worker and revised from time to time. Enter the rate in force for a worker and the calculator flags any daily wage below it.
Is my crew list saved on your server?
Only if you sign in: then each wage sheet is kept in My work, and next week starts with your crew on any phone or computer. Signed out, nothing you type is stored by InstaBOQ; if you choose to keep the crew on this device, it stays only in your own browser. Clear it any time.
Can I get this as an Excel muster roll?
Yes. "Download as muster roll" gives you the free muster roll and wage register workbook with your workers, trades, wages, overtime and deductions already filled in. Mark the daily attendance in the workbook and it calculates the same wages.