How to track scheduled vs. actual employee hours.

Why the gap between scheduled and actual hours matters

A schedule tells you what was planned. Clock records tell you what happened. The difference between them—called the "scheduled vs. actual" gap—is where overtime, missed shifts, early departures, and payroll errors live.

If you hand raw clock data to payroll without reviewing this gap, you may be paying for hours that weren't worked, missing hours that need to be paid, or missing exceptions that require manager decisions (like missed clock-outs).

What to compare

For each employee and each shift, compare:

• Scheduled start time vs. actual clock-in time — Early arrivals may or may not be payable depending on your policy. Late arrivals indicate an attendance issue.
• Scheduled end time vs. actual clock-out time — Early departures may indicate a coverage gap. Late departures may be authorized extra time or unauthorized overtime.
• Scheduled total hours vs. actual total hours — The cumulative difference for the week tells you whether you're over or under your planned labour cost.

Common exceptions to review before payroll

Missed clock-out

The employee clocked in but there is no clock-out record. This is the most common exception. You need to determine the actual time the employee left and enter a corrected clock-out. Without correction, the payroll calculation is wrong (either it runs until midnight, or the system flags it for review).

Early clock-in

The employee clocked in before their scheduled start. Whether this time is payable depends on your policy. If you have a configurable early sign-in window, clock-ins before the window should be flagged.

Late clock-out / extra time worked

The employee clocked out later than scheduled. This may be authorized (e.g., the manager asked them to stay late) or unauthorized. Either way, it should be reviewed before it hits payroll.

Missing clock-in

No clock-in record for an employee who was scheduled. The employee may not have shown up, may have clocked in from an unauthorized location, or may have forgotten to clock in. Investigate before payroll.

Overtime threshold

An employee's actual hours for the day or week have exceeded a threshold you've set. Review whether the overtime was authorized and ensure it will be compensated correctly under applicable employment standards.

How to produce a reviewed payroll summary

1. Gather scheduled hours for each employee for the pay period.
2. Gather clock records (sign-in/sign-out) for the same period.
3. Flag all exceptions (missed clock-outs, early arrivals outside policy, overtime, absences).
4. Resolve each exception with a manager decision—correct the record, authorize the time, or mark as unpaid.
5. Apply wage rates to reviewed hours to calculate labour costs.
6. Lock the reviewed period so it can't be changed retroactively.
7. Export the reviewed data for your payroll provider.

How Opyris handles this

Opyris connects the schedule and the time clock in one system. Scheduled vs. actual hours are visible side by side. Exceptions (missed clock-outs, overtime flags) are surfaced automatically for manager review. When exceptions are resolved, the corrected hours flow into the payroll export. Managers lock the period when it's ready and download the CSV for their payroll provider.

The result is a reviewed, locked export—not a raw clock-data file that needs manual reconciliation.