📥 Free download: Labour attendance sheet / muster roll in Excel
- 31 day columns with a P / A / H drop-down for 25 workers
- Days present = P + ½ × H; wages, overtime (wage ÷ 8 × 2 per hour), gross, advance and net payable as formulas
- Monthly totals for the whole gang
- A 'How to use' sheet, printable on one landscape page
No email or sign-up needed. Opens in Excel, Google Sheets and WPS Office. Free to use, copy and share.
What is a muster roll?
Muster roll format: example (first 7 days)
| Worker | Trade | Wage (₹/day) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Days | Wages (₹) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Ramesh Kumar | Mason | 900 | P | P | P | P | P | P | A | 6.0 | 5,400 |
| Mohan Lal | Helper | 600 | P | P | P | P | H | P | A | 5.5 | 3,300 |
| Abdul Rahim | Bar bender | 850 | P | P | A | P | P | P | A | 5.0 | 4,250 |
P = present, A = absent, H = half day. Days present = P + ½ × H.
How wages are calculated
Wages = days present × daily wage
OT amount = OT hours × (daily wage ÷ 8) × 2
Net payable = wages + OT − advances
Overtime at twice the ordinary rate follows the Code on Wages; check your state notification and contract. Pay wages by the due dates: see Labour Codes for contractors.
Check attendance against work done
Before paying, compare the gang's attendance with the quantity done. A large gap is the most common wage leak. Use the free labour productivity calculator.
Frequently asked questions
What is the format of a muster roll?
One row per worker with name, trade and daily wage, a column for each day of the month marked P, A or H, then days present, wages, overtime, advances and net payable.
How do I calculate days present with half days?
Days present = number of P days + 0.5 × number of H (half) days. For example, 26 P and 2 H = 27 days.
How is overtime calculated for construction labour?
Overtime is paid at twice the ordinary rate under the Code on Wages: OT amount = OT hours × (daily wage ÷ 8) × 2. Check your state notification and contract.
Is a muster roll mandatory for contractors?
Yes. Contractors and employers must keep attendance and wage records under the Labour Codes and produce them on inspection.
Is there a free attendance sheet format in Excel?
Yes. Download the free True Site Sync muster roll above. It has P/A/H drop-downs and wage formulas for 25 workers. No sign-up needed.
Attendance in one tap, wages automatically
Mark attendance on the phone, offline, and get muster card PDFs.
Start free 6-day trialOr book a demo.