Attendance formats
Monthly attendance sheet template
One row per employee, one column per day, with the totals payroll actually asks for computed rather than counted by hand.
Opens in Excel, Google Sheets, Numbers and LibreOffice — no conversion needed.
Preview of the actual columns — green cells are formulas
What is in the file
These are the actual columns in the download, with a filled sample row so you can see the expected shape. Cells beginning with an equals sign are formulas and compute when the file opens.
| Column | Sample value | Notes |
|---|---|---|
| Employee ID | EMP-014 | |
| Employee name | Priya Sharma | |
| Department | Delivery | |
| Days 1-31 | P | P present, A absent, L leave, H half day, W weekly off, HO holiday |
| Present days | 20 | |
| Half days | 1 | |
| Paid leave | 1 | |
| Absent days | 0 | |
| Working days | 22 | |
| Attendance % | =ROUND((E2+F2*0.5+G2)/I2*100,1) | Formula computes on open |
How to use it
- →Open in Excel, Google Sheets, LibreOffice or Numbers — CSV needs no conversion.
- →Replace the sample row with your first employee, then fill down.
- →Expand the day columns to match the month; the marking legend is in the header notes.
- →The attendance percentage column carries a formula — check it points at your final column letters after you add day columns.
Before you rely on it
An attendance sheet is not the same thing as a statutory register. Where a register is prescribed for your establishment, it has its own required particulars and retention period.
When the spreadsheet stops scaling
A template is the right answer until the reconciliation between sheets costs more than the sheets save. Workclave records the same data as work happens, applies your policy automatically, and produces the register, the payroll input and the client hours statement from one source. Free for up to 3 users.
Votre équipe travaille. Commencez à comprendre comment.
Rejoignez les équipes qui suivent des sessions, pas seulement des heures. Gratuit jusqu’à 3 utilisateurs — sans carte bancaire, sans minimum, sans engagement.