The attendance codes
| Code | Meaning | Use it when |
|---|---|---|
| W | Worked as scheduled | Started within your grace period and worked the shift |
| L | Late | Started after the grace period you set, such as 7 minutes |
| A | Absent, no notice | Didn't arrive and didn't tell anyone |
| C | Called out | Told you before the shift they couldn't work |
| T | Approved time off | A request you approved in advance |
| - | Not scheduled | A day off |
Reading the example month
The example tab tracks March 2027 for six people. Jordan is scheduled 22 days and has 3 L codes, all on Mondays; Sam has 1 A and 2 C. The summary columns count each code and work out an on-time rate: worked on time ÷ (worked on time + late). Jordan's 19 W and 3 L give 19 ÷ 22 = 86%.
Using the tracker well
- Fill it in from the time records each week, not from memory at the end of the month.
- Decide your grace period once and write it at the top of the sheet.
- Look for patterns rather than single days: the same weekday, the shift after a close, the week after a schedule change.
- Talk about a pattern early and privately, and record what you agreed.
- Leave protected leave out of performance conversations. Rules on sick and family leave differ by place; check what applies before you count it against anyone.
A weekly routine for checking these numbers takes about 15 minutes: see the weekly attendance review. When someone doesn't arrive, the no-show workflow covers the first hour.