Monthly attendance sheet (Excel muster roll)
A monthly attendance sheet (also called a muster roll) has one row per staff member and one column for each day of the month, with a code such as P, A or HALF in every cell. This free Excel sheet counts present, late, half-day, leave, overtime and absent days for you, then works out paid days and net payable after advances.
Part of our guide: Contract staff attendance: the complete guide for labour contractors
By HaazriPro Team · Last updated
Monthly attendance sheet, 30 staff × 31 days
Excel (.xlsx) · free · no sign-up · opens in Excel, Google Sheets and WPS
Skip the sheet: HaazriPro fills it from attendance marked by tapping each face. Start 30-day free trial
What columns does it have?
| Column | What goes in it |
|---|---|
| Sr, Code, Name | Row number, your staff code (if you use codes) and the full name. Write the full name every month, the same way. |
| Shift | DAY or NIGHT, or leave blank for a single-shift site. |
| 1 to 31 | One code per day from the drop-down. Leave 29–31 blank in a shorter month. |
| Present, Late, Half-days, Leave, OT days, Absent | Counted for you from the day columns. |
| Paid days | Worked out: present + late + OT days + paid leave + half-days × ½. |
| Daily rate, Advance | Optional: the staff member's daily rate and any advance to recover this month. |
| Net payable | Worked out: paid days × daily rate − advance. |
Which codes go in the cells?
The sheet uses the same seven statuses and colours as HaazriPro, plus WO for a weekly off.
| Code | Meaning | Counts as |
|---|---|---|
| P | Present for the full day | 1 paid day |
| LATE | Came late but worked the day | 1 paid day |
| A | Absent | Not paid |
| HALF | Worked half the day | ½ paid day |
| LEAVE | Paid leave | 1 paid day |
| OT | Present and did overtime | 1 paid day (overtime hours paid separately) |
| TRANSFER | Moved to another site that day | Counted at the other site |
| WO | Weekly off | Not counted |
How do I fill it in?
- Write the site and the month at the top. Use one sheet per site.
- Enter each staff member once: code, full name and shift. Keep the same spelling every month.
- Every day, pick one code for each person from the drop-down. Do not type names or notes into the day cells.
- At month end, check the totals on the right. Add the daily rate and any advance to see net payable.
- Get the sheet signed by the site supervisor before you work out salary or bill the client.
Already using this sheet? Bring it to HaazriPro
The layout matches what our team's import reads: a code and name per row, one column per day, and the codes above. Send us a filled month and our team loads it into your HaazriPro account. Every name is matched to exactly one staff record by code, or by name only when it is unique. If a name could be two people, we send it back to you to decide. We never guess.
Frequently asked questions
Is this the same as the statutory muster roll?
It records the same day-by-day attendance, but the official format is set by the rules that apply to you. For central-sphere establishments, the 2026 central rules under the Labour Codes prescribe an attendance register-cum-muster roll in Form XIV (it replaced the old Form XVI). Others follow their state's rules. Use this sheet as your working record and check the statutory format with your labour consultant. Our guide to contractor registers explains which registers apply.
How are half-days and late days counted?
A half-day counts as half a paid day. A late day still counts as a full day present. If your policy cuts pay for coming late, mark that day HALF instead.
Does it work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. The drop-downs, colours and totals keep working.
Why do staff get mixed up on paper sheets?
Many staff share similar names, and on a printed grid a tick in the wrong row is easy to miss. In HaazriPro the supervisor taps each person's face photo instead of finding a name, so the mark lands on the right person.
Stop filling the grid by hand. Tap faces instead.
Supervisors mark attendance by tapping each staff member's face photo, even offline. The salary sheet and the client bill are ready at month end.
Start 30-day free trial