- Templates
- Attendance register format
Attendance register format
A monthly sheet with one row for each person and one column for each day, so you can mark present, absent or leave and add up the month. Print it, or download it as a CSV file that opens in Excel or Google Sheets.
A working sheet, not legal advice. Formats differ by state. Check your own policy and the current rules, or ask an adviser.
Nothing is sent anywhere. To make a PDF, choose "Save as PDF" in your browser's print window.
What it is for
A monthly sheet with one row for each person and one column for each day, so you can mark present, absent or leave and add up the month. Print it, or download it as a CSV file that opens in Excel or Google Sheets.
How to use it
- Print one sheet for each month, or download the CSV and fill it in on a computer.
- Write the month and year, then each person's name and code.
- Mark each day with a short code you choose, for example P for present, A for absent, L for leave, H for holiday, W for weekly off.
- At the end of the month count each code and write the totals in the last columns.
- Keep the sheet as your own record. Check the current rules for what you must keep and for how long.
Example row (made up)
| No. | Name | 1 | 2 | 3 | 4 | 5 | Present | Absent | Leave |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Asha Rao (made up) | P | P | A | L | P | 3 | 1 | 1 |
An example with made-up names and figures.
Attendance register format
Zentaro Pulse · pulse.zentaro.cloud/in/templates/attendance-register-formatCodes: P present, A absent, L leave, H holiday, W weekly off. Use your own codes if you prefer and write them here.
| No. | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Present | Absent | Leave |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Estimate only. A working sheet, not legal advice. Formats differ by state. Check the current rules or ask an adviser.
Free tools that go with this
Questions about this register
What is an attendance register?
It is a record of who was present, absent or on leave each day. A monthly register has one row for each person and one column for each day.
Is this the format the law asks for?
No. Formats differ by state and by type of business. This is a working layout for your own team. Check the current rules or ask an adviser for what you must keep.
Can I use the CSV in Excel?
Yes. The CSV file opens in Excel and Google Sheets. Add your names, fill the days and use the sheet's own count tools for the totals.
Want this done for you?
Zentaro Pulse is attendance and workforce management for any business. It is launching in 2027. This template stays free either way.
Last updated: