Schedule Variance Report

Description:

This report compares your employees' scheduled hours to the actual hours calculated from their punches and displays the variance between the two.

Report Criteria:

The Report Criteria screen opens when you click on the report name from the main "Reports" section of the software.  This screen is where you tell the system what data you would like it to report on.

  • The Schedule Reports field allows you to select a different report from the drop-down menu.

  • Put a check mark in the Launch Report in Separate Window box if you would like the report to open in a new web browser window.  With this option de-selected the report is displayed directly below the Report Criteria section of the screen.

  • Use the Start Date fields to enter the range of days that you would like the report to include.  Click on the [CALENDAR] icon at the end of each field to select the dates from a calendar.

  • The Employees field allows you to select which employees will be included in this report.  Click on the down arrow icon located to the right of the Show Employees header to select employees.

    1. To view employees from a specific department only, select the desired department from the Department drop-down menu.

    2. All of your employees are listed in the Unused Employees box.  The Viewed Employees box lists the employees that will be reported on.  Select the desired employees from the Unused Employees box and click on the [>>] icon to assign them to the report.   The selected employee names are moved to the Viewed Employees box.  If you leave the Viewed Employees box empty, the report will display all employees.
      Note:        The Viewed Employees box is empty by default, thus including all employees in the report.

    3. To unassign employees from a report, select the desired employee names in the Viewed Employees box and click on the [<<] icon.  The selected employees are moved to the Unused Employees box.

  • If you would like to report on employees assigned to a specific supervisor only, make the desired selection from the Supervisor drop-down menu.

  • If you would like to report on employees scheduled to work a specific shift only, make the desired selection from the Shift drop-down menu.

  • Use the Sort by field to select how the information on the report will be sorted.  Two sort levels can be specified.
    Example:     "Department" is selected in the first field, and "Employee Name" is selected in the second.  The report will be sorted first by the department level that the employees are assigned to, and then alphabetically by employee name.

  • The Options section allows you to select how much information is to be displayed on this report.  Put a check mark in the box next to each type of information that you would like the report to display.

Click on the [DISPLAY REPORT] icon located directly below the Options section of the screen to generate the report.

Report Output:

The report is separated into columns.  The header at the top of the report lists the type of information that is displayed in the column below.

Note: The report output depends greatly upon what you selected in the Options section of the Report Criteria screen.  

  • The Employee column displays the employee's full name.  Click on the name in this column to bring up the selected employee's schedule.

  • The ID column displays the employee's ID.

  • The Card# column displays the card number that the employee is assigned to in the software.

  • The Department column displays the employee's default department assignment.

  • The Supervisor column displays the name of the supervisor that the employee is assigned to.

  • The Date column displays the date on which the employee was scheduled to work the specified shift.

  • The Punch Time column displays the punch time, as it appears on the employee's time card (taking rounding policies into effect).

  • The Actual Punch Time displays the actual time as the punch (before rounding policies were applied).

  • The Scheduled Hours column displays the number of hours that the employee was scheduled to work on the specified date.

  • The Actual Hours column displays the actual number of hours that the employee worked based on their time and attendance punches for that day.

  • The Variance column displays the difference between the number of hours that the employee was scheduled to work, and the number of actual hours worked.

  • The "Scheduled Hours," "Actual Hours," and "Variance" columns are totaled at the bottom of the report.

Click on the [SAVE] icon in the upper right-hand corner of the screen to save this report to a separate file.  Click on the [PRINT] icon to print the report.