Reports
Schedule vs Actual
Compare published shifts with worked time, including differences, missed shifts, and unscheduled work.
No login required. Opens in one click.
What this report shows
Schedule vs Actual compares the shifts you published on the Schedule page against the time employees actually clocked. Only published shifts count as scheduled time; drafts are not commitments.
The first table is one row per employee: Scheduled, Worked, Difference, Missed shifts, and Unscheduled. Difference is worked minus scheduled, so -2h means two hours less than scheduled and +2h means two hours more.
The By day table breaks the same numbers down per employee per day, with a Flags column that calls out missed shifts (with their times) and unscheduled work.
When the selected period has approval data, a status line above the report shows whether timesheets are approved, not approved, or partly approved.
How matching works
- A shift counts as missed when it has already ended and no completed time entry overlaps it. Future shifts and shifts still in progress are never counted as missed.
- Worked time counts as unscheduled when the entry overlaps none of that employee's published shifts, for example working a day with nothing scheduled.
- An overnight shift's scheduled minutes count on the day it starts; worked minutes count on the calendar day they occur, so a single overnight shift can show worked time on two days.
- An open entry does not count as worked time until the employee clocks out.
Filters
Use the date range and All employees controls in the toolbar.
What to do with a row
The report is read-only. For a wrong or missing time entry, open Time entries. To change the plan itself, open the Schedule page.
Exporting
Open the Export menu and choose Download CSV, Download Excel, or Download PDF. The export includes the per-employee summary and the per-day rows.
Common questions
- Why is the report empty when employees have been clocking time?
This report only compares against published shifts. If you have not built and published a schedule on the Schedule page, there is nothing to compare worked time to. For day-by-day worked and absent views, use Attendance.
- An employee worked their shift but the day still shows a negative difference.
A negative difference means the employee worked fewer minutes than scheduled. The shift is not marked missed because the employee still recorded time during it.
Related
How overtime works
How Clockspot classifies overtime hours into report tiers.
Running payroll
The path from a closed pay period to numbers you can hand to your payroll provider.
Reports
Open the report that matches the hours, payroll, job, or clock-location question you need to review.
Scheduled Reports
Email yourself recurring Clockspot report exports and saved payroll export files.
Current Status
See who is clocked in, on time off, scheduled today, or off duty right now.
Daily Summary
Review one day's clock activity, open punches, time off, pending edits, and cleanup items.
Attendance
See who worked each day, with hours, absences, and in/out times.
Breaks
Review recorded meal and rest breaks, including duration, pay, and how each break was added.
Hours Summary
See each employee's regular, overtime, and time off hours for the period.
Overtime
See who hit overtime each week, with the rule behind each tier.
Payroll Readiness
Check payroll blockers, warnings, and cleanup actions before using payroll totals.
Payroll Summary
See payroll-ready hours and pay per employee, ready to process.
Timesheet Audit
Review direct edits and edit requests with who changed what, when, and why.
Job Hours
See how employee hours break down by job and project.
Labor Cost by Job
See hours, straight-time pay, overtime premium, and labor cost by job.
Time Off Usage & Balances
Compare time off used, pending requests, current balances, and balances after pending.
Verification Exceptions
Review clock events missing expected location, kiosk-photo, or phone voice evidence.
Location Summary
See how hours and headcount break down across clock locations.
Location Activity
See the clock-in and clock-out location for every shift.
Location Compliance
Find time entries with missing or mismatched clock locations.
Location Coverage
Compare where each employee worked, by location and by day.
GPS Clock Event Map
See GPS-tagged clock events plotted on a map.
Site Overview
Scan hours, entries, and employees at each clock location.