Monthly attendance register and downloads
See a month of attendance for everyone in one grid, read the codes and download it as Excel, PDF or CSV.
The Monthly register is an employee-by-day grid for a whole month, with totals. It is the quickest way to check attendance before running payroll, and you can download it as Excel, PDF or CSV.
Steps
- Go to Time & Attendance → Attendance ( open Attendance).
- Click the Monthly register tab.
- Choose the Month and Year, and optionally a Department, Location or Search.
- Click Apply.
- Download the register shown on screen:
- Download Excel — a colour-coded grid (green present, amber half day / missing punch, red absent, purple leave, blue holiday, grey week off) with names frozen on the left and the totals.
- PDF — a landscape printable version with the same colours.
- CSV — plain codes for any spreadsheet.
Reading the grid
Each cell shows a code. A * after a code means the person was late that day.
| Code | Meaning |
|---|---|
| P | Present |
| HD | Half day |
| MP | Missing punch |
| SH | Short hours |
| A | Absent |
| WO | Week off |
| H | Holiday |
| Leave code (for example CL) | On leave |
The totals at the end of each row are P, HD, L (leave), A, MP (missing punch / short hours), WO, H, late count, early count, worked hours and overtime hours.
Missing punch, short hours and absent days are unpaid. Ask employees to send a regularization request, or correct the day yourself — see View and correct daily attendance.
Click an employee's name to open their calendar for the month.