📥 Free template

Labour attendance sheet & muster roll format: free Excel download

Mark each worker P, A or H for every day of the month, and the sheet works out days present, wages, overtime at twice the rate, advances and net payable. Free to download, with a filled example for a six-worker gang.

By the True Site Sync team · Last updated 11 November 2026

📥 Free download: Labour attendance sheet / muster roll in Excel

Download Excel (.xlsx, 14 KB)

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?

A muster roll is the register of workers' daily attendance for a wage period, usually a month, used to calculate wages. Under the Labour Codes, employers and contractors must keep attendance and wage records and show them to an inspector on demand.

Muster roll format: example (first 7 days)

WorkerTradeWage (₹/day)1234567DaysWages (₹)
Ramesh KumarMason900PPPPPPA6.05,400
Mohan LalHelper600PPPPHPA5.53,300
Abdul RahimBar bender850PPAPPPA5.04,250

P = present, A = absent, H = half day. Days present = P + ½ × H.

Skip the spreadsheet. In True Site Sync, attendance is one tap per worker on the phone, works without internet, and each worker gets a muster card PDF with days, wages, advances and payments. Start a free 6-day trial →

How wages are calculated

Days present = P days + 0.5 × H days
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 trial

Or book a demo.