Hours Exception Report

The Hours Exception Report provides hourly timecard details and includes exception messages for regular hours over 8 in a day or 40 in a week, overtime exceptions for more than 4 OT in a day, and an exception for working 7 days in a row.

As the current proofing register will only take timesheets within the same batch into consideration, this allows for reviewing totals for the entire period, even if they are on different timecards.

  1. Access Reporting > Reporting & Analytics > System Reports > Payroll.
  2. Select Hours Exception Report to enter report criteria.
  3. After selecting the report, the Workers Compensation Report workflow will open for selection criteria input.
    • Click on the buttons to the right of certain fields to open a new window which will allow you to search and select options related to that specific field or choose a date.
    • Select a Corporation and a Work End Date.
    • Branch Name and Worksite State are both optional processing criteria and can be used to further define the information you want to see on the report.
  4. After entering the criteria, click Okay to generate the report.
  5. The report opens in a new window.
    • If no data matches the input parameters, an error message will be displayed:
    • The report’s header indicates Title, chosen Corporation, and the Work End Date.
  6. Returned data is grouped by Candidate, Regular or Overtime hours, and is then listed by Client and Assignment with totals provided.

Calculations in Report

  • A Weighted Average (Blended) Rate calculation is used for candidates with multiple timesheets with at least 2 different assignment regular pay rates and over 40 hours.

Weighted Overtime Calculations

You can follow these steps for calculating overtime with multiple different pay rates:

  1. Determine the employee’s Total Base Pay.
    1. For each timecard with different rates, multiply the number of hours worked by the regular hourly rate from the assignment.
    2. Add all wages as calculated in 1a to determine the Total Base Pay.
  2. Calculate the Weighted Average Rate.
    1. Divide the Total Base Pay by the Total Worked Hours.
  3. Calculate the Weighted Overtime Total.
    1. Multiply the Weighted Average Rate by 0.5 to determine the rate to be used to calculate blended overtime.
    2. Multiply the blended overtime rate by the total overtime hours for all timecards.
  4. Calculate the total earnings.
    1. Add the Total Base Pay and the weighted overtime total.

Example:

Employee works:

20 hours @ $20

20 hours @ $15

10 hours @ $10

50 hours worked total.

  1. Calculate Total Base Pay:
    • 20 x $20 + 20 x $15 + 10 x $10 = $800
  2. Calculate Weighted Average Rate:
    • $800 / 50 = $16
  3. Calculate Weighted Overtime Total:
    1. $16 x 0.5 = $8
    2. $8 x 10 = $80
  4. Calculate Total Earnings:
    1. $800 + $80 = $880

Full Report