Guide
Monthly Attendance Register Format (Free Excel Template)
Download a ready-to-use register, and see what a good monthly register should track.
Short answer: A monthly attendance register lists each employee in a row and each day of the month in a column, with one code per day — P present, L late, HD half day, A absent, LV leave, WO week off, H holiday — and totals per employee at the end of the row. The free Excel template below does the totals automatically.
Download the Excel template .xlsx · free · no sign-up
What the template includes
- Month, branch and prepared-by fields
- Rows for 30 employees with name and employee code
- Days 1–31 with a dropdown of status codes, colour-coded
- Automatic totals: present, late, half day, absent, leave, week off, holiday, and days worked (half days count as half)
Status codes
| Code | Meaning | Counts as worked |
|---|---|---|
| P | Present | 1 day |
| L | Late (present, after grace time) | 1 day |
| HD | Half day | ½ day |
| A | Absent | 0 |
| LV | Leave | Per your leave policy |
| WO | Weekly off | — |
| H | Holiday | — |
Where a spreadsheet register falls short
- It records what someone typed, not who was actually at the branch.
- Someone has to fill it in every day, at every branch.
- Corrections leave no trail.
Preez fills in the same codes automatically from verified check-ins and exports the month to Excel. See how to replace a paper register with an app.
Frequently asked questions
What is the format of a monthly attendance register?
One row per employee and one column per day of the month, with a status code per day and totals per employee at the end of the row.
What codes are used in an attendance register?
Common codes are P (present), A (absent), L (late), HD (half day), LV (leave), WO (weekly off) and H (holiday).
Is the template free?
Yes. Download the Excel file with no sign-up.