Muster Roll Format in Excel & CSV
Statutory Form D Attendance Register
Standardized, ready-to-use muster roll spreadsheet for Indian construction contractors, builders, and site supervisors. Free download in CSV and Excel compatible formats.
Muster Roll Register Preview
Form D / Form XVI Compliant Layout for Construction Labour
| Emp ID | Worker Name | Trade / Category | Daily Rate (₹) | D1 | D2 | D3 | ... | D30 | D31 | P Days | HD Days | OT Hrs | Gross Wage (₹) | Kharchi (₹) | Net Pay (₹) | Signature |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HB-001 | Ramesh Kumar | Head Mason | ₹850 | P | P | HD | ... | P | A | 25 | 2 | 12 | ₹22,950 | ₹3,000 | ₹19,950 | Signed |
| HB-002 | Suresh Yadav | Carpenter | ₹750 | P | P | P | ... | P | P | 27 | 0 | 8 | ₹21,000 | ₹2,500 | ₹18,500 | Signed |
| HB-003 | Mohammed Ali | Bar Bender | ₹750 | P | A | P | ... | HD | P | 24 | 1 | 16 | ₹19,875 | ₹2,000 | ₹17,875 | Signed |
| HB-004 | Santosh Patil | General Helper | ₹550 | P | P | P | ... | P | P | 26 | 2 | 10 | ₹15,537 | ₹1,500 | ₹14,037 | Thumb |
Complete Guide to Maintaining Construction Muster Rolls in India
1. What is a Construction Muster Roll?
A muster roll is the official register used by contractors, site supervisors, and builders to record the daily physical presence or absence of workers employed on a job site. Under the Minimum Wages Act (1948) and the Building and Other Construction Workers (BOCW) Act, maintaining an accurate attendance register is a statutory requirement for all contractor firms.
2. Essential Columns Required in a Valid Muster Register
- Worker Identification: Full Name, Father's Name, unique worker code, and trade classification (Mason, Helper, Bar Bender, Shuttering Carpenter).
- Daily Attendance Slots: Daily blocks (Day 1 through Day 31) clearly marked as P (Present), A (Absent), HD (Half Day), or 2P (Double Shift).
- Overtime Record: Number of overtime hours worked per day or totaled per pay cycle.
- Financial Ledger: Applicable daily wage rate, gross earnings, cash advances (kharchi) deducted, and final net payable.
- Acknowledgment: Worker signature or thumb impression acknowledging receipt of wages.
3. Challenges with Physical Paper Muster Rolls
Physical registers often get lost, damaged by water or cement on construction sites, or suffer from manipulated entries and proxy markings. When client bill audits happen, reconciling crumpled notebooks is a major bottleneck for contractors.
Switch from Paper & Excel to HajariBook Digital App
HajariBook automates daily attendance on site supervisors' mobile phones, tracks geofencing & selfies, and exports statutory Form D muster rolls directly to formatted PDFs and Excel files in seconds.