Attendance Sheet
One grid for the whole month: a row per person, a cell per day. The colour tells you whether the day was a full workday, a half day or a late start — no need to open anybody's record.
Illustration of the Attendance sheet
| Area | What it does |
|---|---|
| 1. Month picker | The arrows step back and forward a month. |
| 2. This month | Jumps to the current month. |
| 3. The two figures | Staff in the sheet, and Avg workday — the clinic's average for the month. |
| 4. Import Excel | Loads attendance data exported from the time clock. |
Reading the colours
The legend above the grid explains each one:
| Colour | Meaning |
|---|---|
| Full workday | A complete day. |
| Half workday | Only half a day counted. |
| Late/Early | Arrived late or left early. |
| Other data | Something else recorded (leave, business trip…). |
| Weekend | Weekend days, shaded so they stand out. |
The last two columns are Total (workdays in the month) and OT (approved overtime, taken from Overtime requests).
What it's for
- Checking before payroll. At month end scan the grid; open anything that looks odd before you run the pay.
- Answering staff questions. "Which day was I docked?" — the row and the day show it.
- Reconciling with the time clock. Load the file with Import Excel and compare.
Settle attendance first, pay second
The sheet feeds payroll. Changing attendance after the pay run means recalculating, so finish your checks here first.
Related
- Work schedule — the shifts these days are measured against.
- Leave requests — approved leave shows up on the sheet.
- Overtime requests — feeds the OT column.