The Schedule Audit report is complex; we put together this article to explain the columns, logic (business rules) and parameters used.

Role

Role is the security role assigned to the employee’s user account; it is not derived from schedule entries or work position.

Days Sch

The count of distinct calendar dates in the report period where the employee has at least one scheduled shift at the selected store(s), excluding days marked "OFF" on the schedule.

Notes:

• Multiple scheduled shifts on the same date count as 1 scheduled day.

Days Wkd

The count of distinct scheduled calendar dates in the report period where the employee had at least one Clock-In segment on that date, and was scheduled that day, subject to Count Work Across Stores (see below).

• If Count Work Across Stores is True (if enabled):
  “Worked” = any Clock-In on that date at any store.
• If Count Work Across Stores is False:
  “Worked” = any Clock-In on that date at one of the selected store(s).

Important: The report displays worked days only for dates that exist as scheduled dates (because the report is schedule-driven). This means:

• It counts “scheduled dates that had at least one Clock-In” (the Clock-In can be at any store if Count Work Across Stores = True). It does not include days with at least one Clock-In where the employee was NOT scheduled.

The system may have punches on unscheduled days, but those dates don’t appear in this schedule-driven report.

Days late

The count of scheduled dates where the employee was scheduled (non-OFF) and was late by tolerance (Number of minutes considered late) for at least one scheduled shift that day.

Late by tolerance for a shift means:

• Find the First Clock-In matched to that scheduled shift (see “Matching rule” below)
• If First Clock-In > Scheduled Start + Number of minutes considered late, then that shift is late by tolerance
• If any shift is late by tolerance on that date → the day is late

% Late

Number of Late Days/Number of Days Scheduled

Missed Days

Scheduled dates (non-OFF) where the employee had no Clock-In at all on that calendar date (based on Count Work Across Stores rule).
Formula: Number of Days Scheduled - Number of Days Worked (computed per scheduled date)

% Missed

Number of Missed Days/Number of Days Scheduled

Total Minutes Late

The sum, over all scheduled shifts in the report period, of lateness minutes (positive only) based on the matched First Clock-In:

Important: This is independent of Number of minutes considered late.
If someone is 3 minutes late and Number of minutes late is 5, those 3 minutes still count toward Total Minutes Late.

Avg Minutes Late

Total Minutes Late / Number of Late Days

It’s the average lateness minutes per late day, not per late shift.

Late/Miss %

(Number of Late Days + Number of Missed Days) / Number of Days Scheduled

Gain/Loss Start (not shown)

Sum over scheduled shifts of:

• The difference in minutes between the Scheduled Start time and the First Clock-In time
  • early Clock-In ⇒ positive (gain)
  • late Clock-In ⇒ negative (loss)

If no matched Clock-In exists for the shift, contributes 0.

Gain/Loss End (not shown)

Sum over scheduled shifts of:

• The difference in minutes between the Scheduled End time and the Last Clock-Out time
  • early Clock-Out ⇒ negative (loss)
  • late Clock-Out ⇒ positive (gain)

Where the Last Clock-Out is the maximum Clock-Out across all punch segments matched to the shift window.

If no matched Clock-Out exists, contributes 0.

Gain/Loss

Gain/Loss Start + Gain/Loss End

This produces:

• Negative net = overall loss against schedule
• Positive net = overall gain against schedule

Count Edited Time

Total number of punch segments that are marked edited (Clock-In or Clock-Out edited) that fall inside the matching windows for scheduled shifts.

• If an employee has 3 edited segments on one shift day and 2 on another shift day within the report period, Count Edited Time = 5.

Number of Minutes Considered Late (parameter, default = 5)

This provides a tolerance for employees clocking in late (after their scheduled time). See above where this is used in calculations.

Early Grace Minutes (parameter, default = 120)

In order to match schedules with Clock-Ins, the report creates a "window" of time that begins with the Scheduled Start time minus Early Grace Minutes (for each scheduled shift). This allows the report to detect early Clock-Ins up to the Early Grace Minutes before the Scheduled Start time.

After Shift Minutes (parameter, default = 240)

This is similar to Early Grace Minutes but is applied to the shift's Scheduled End time. This allows the report to detect late Clock-Outs up to the After Shift Minutes beyond the shift's Scheduled End time OR the next scheduled start time on that day. That is the "window" ends at the next scheduled start time (same day) if another scheduled shift exists; otherwise, it is the scheduled end time plus After Shift Minutes.

Shift Matching Window (logic)

For each scheduled shift:

• Window Start = Scheduled Start - Early Grace Minutes (for that shift)
• Window End =
  • Next Scheduled Start time (same day) if there is another scheduled shift that day, otherwise
  • Scheduled End time + After Shift Minutes (for that shift)

This prevents overlap between two scheduled shifts on the same day.

Which punch segments are included?

A punch segment is included in the shift match if:

• Punch Clock-In date equals scheduled date, AND
• Clock-In >= Window Start, AND
• Clock-In < Window End

Matched punch time for calculations

Within the included punch segments:

• First Clock-In = minimum Clock-In among punch segments that fall inside the shift's matching window.
• Last Clock-Out = maximum Clock-Out among punch segments that fall inside the shift's matching window.

This correctly handles lunch breaks / job switching (multiple segments) because:

• First Clock-In reflects the day’s arrival for that shift window
• Last Clock-Out reflects final departure for that shift window

Count Work Across Stores (parameter, default false)

Some entities prefer a “worked day” to mean worked at the selected store(s), not anywhere. If you want to calculate a worked day no matter which store the employee worked at (e.g. not count a day as missed if they worked at a store outside the selected store(s), set this to True. Normally the rules filter punches to the selected store(s). If this is set to True, the rules remain identical except punches are NOT filtered by store at all.

False = punches are limited to the selected store(s)
True = punches are allowed from any store (a cross-store punch can prevent a "missed" day).

Examples