Actual vs Schedule by Job

The Actual vs. Schedule by Job report shows the actual, scheduled, and projected hours and wages by job for each employee who worked that job during the selected time period. Run this report for the current pay or schedule period to see how your schedule compares with actual totals and whether the projected amounts are within your budget. It is important that the totalizer is set to guarantee totals far enough into the future to cover the time period that you plan to use with this report. .

Note:
  • This report is less meaningful when run against a past or future time period. When run against the past, the projected hours are always 0. When run against the future, the variance hours are always 0.
  • You cannot change this report, but you can copy it and modify the copy.
  1. From your Report Library, click tap Run Report
  2. In the Select Report panel, select Timekeeping > Accrual vs Schedule by Job and click tap Select
  3. In the report panel, select the parameters:
    • Click Tap Select Timeframe . Then, in the Timeframe panel, select the appropriate timeframe or click tap Select Range to select a range of dates. When finished, click tap
    • Click Tap Select Hyperfind , Then, in the Locations & Hyperfinds panel, select the appropriate location or Hyperfind. If you have the appropriate access, you can also do the following:
    • Click Tap New Hyperfind to create a new Hyperfind.
    • Click Tap Select Locations to open the Select locations glancepanel.
    • When finished, click tap
  4. Paycodes — Click Tap more . In the Paycodes panel, select the applicable paycodes, then click tap Apply
  5. Output Format — Select one of the following:
    6. (missing or bad snippet)
  6. Click Tap Run report. An In progress message displays while the report is running.

  7. Click OK when the Report is Completed message appears. If you created a PDF or Excel report, a link appears at the bottom of the Report Library. If you created an interactive report, the report opens in a new tab automatically. The report opens in a new window.

The report contains the following columns:

  • Worked Job
  • Employee Name (ID) — Last name, first name with the employee's ID
  • Paycode — The paycode that is associated with the hours and wages.
  • Actual Hours — The number of hours that the employee has worked within the specified paycode and on the specified job.
  • Scheduled Hours — The number of hours that the employee is scheduled to work within the specified paycode and on the specified job.
  • Projected Hours — The number of hours that the employee is projected to work within the specified paycode and on the specified job.
    • Note: Projected hours are the number of actual hours plus any remaining scheduled hours calculated together. This calculation includes any changes in overtime required as a result of different-than-scheduled actual hours.
  • Variance Hours — If all of the selected time period is in the past, then this column reports scheduled hours minus actual hours. If any of the selected time period is in the present or future, then this column reports scheduled hours minus projected hours.
    • Note: A negative variance is shown in parentheses and indicates that the employee is projected to work more hours than he or she was scheduled for.

ClosedExample

  • Actual, Scheduled, Projected, and Variance Wages — Same as Actual, Scheduled, Projected, and Variance Hours, but the amount of wages instead of number of hours.

If applicable, the total number of employees who are not totalized also appears as well as the employee's name (last, first) and ID.