Attendance formats
Daily attendance report template
The end-of-day summary a manager or HR sends up the chain: who was in, who was out, and the attendance percentage — computed from the counts rather than typed in beside them.
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 |
|---|---|---|
| Date | 2026-08-03 | |
| Department / team | Engineering | |
| Total headcount | 24 | |
| Present | 19 | |
| Work from home | 2 | Counted as present for the percentage |
| On leave | 2 | |
| Absent (unplanned) | 1 | |
| Half day | 0 | |
| Late arrivals | 3 | Subset of present; does not change the percentage |
| Attendance % | =ROUND((D2+E2+H2/2)/C2*100,1) | Formula computes on open |
| Prepared by | R. Mehta | |
| Remarks | 1 absent without intimation — follow up |
How to use it
- →One row per department or team per day. For a whole-company report use a single row and the total line becomes the company figure.
- →Present + work from home + on leave + absent + half day should equal total headcount; if it does not, someone was counted twice or missed.
- →Keep the remarks column for anything a reader will ask about — an unexplained absent count generates a follow-up email either way.
- →File the daily reports by month; the monthly attendance sheet is the per-employee view of the same data.
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.