The attendance codes

Codes in the tracker. Each is counted per person for the month.
CodeMeaningUse it when
WWorked as scheduledStarted within your grace period and worked the shift
LLateStarted after the grace period you set, such as 7 minutes
AAbsent, no noticeDidn't arrive and didn't tell anyone
CCalled outTold you before the shift they couldn't work
TApproved time offA request you approved in advance
-Not scheduledA day off
Codes in the tracker. Each is counted per person for the month.

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

  1. Fill it in from the time records each week, not from memory at the end of the month.
  2. Decide your grace period once and write it at the top of the sheet.
  3. Look for patterns rather than single days: the same weekday, the shift after a close, the week after a schedule change.
  4. Talk about a pattern early and privately, and record what you agreed.
  5. 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.