Rounding of Prorated Hours

When you use the hours proration feature, you must specify how prorated hours will be rounded.

You can round hours as follows:

  • Enabled (Hours) — Hour proration is enabled. Prorated hours are rounded based on the Hours Increment setting for the employee timesheet class, entered on the Timesheet Classes screen.
  • Enabled (2 decimals) — Hour proration is enabled. Prorated hours are always rounded to two decimals.

You can also specify whether you want to prorate hours up when an employee works fewer than the adjusted standard number of hours.

For example, if you use this option and an employee enters only 20 hours, all of which are proratable, for a timesheet for which the adjusted standard number of hours is 40, the proration percentage is 200. The proration process increases the hours to 40.

Do not select this option if you only want hours prorated when employees work more than their standard hours.

Examples

For the purpose of these examples, assume that:

  • All UDT1 account types are prorated, except those for leave.
  • Salaried employees can use pay types of R and OS1 where R is prorated and OS1 is not.
  • Salaried employees have eight standard hours a day, Monday through Friday, and no standard hours for Saturday and Sunday (based on their work schedules), for a total of 40 standard hours.
  • Salaried employees have an Hours Increment of Tenths, meaning that hours will be rounded to one decimal point.

Example 1

The employee charges these hours in a week:

UDT1 UDT10 Mon Tue Wed Thu Fri Sat Sun
Leave R 8            
Non Leave R   10 10 9 11    
  • Adjusted Standard Hours = 32, calculated as 40 (standard hours) - 8 (hours charged to leave, which is not prorated)
  • Prorate-able Hours = 40, calculated as 10 + 10 + 9 +11 (the sum of the hours charged to UDT1 account types and UDT10 pay types that are prorated)
  • Proration Percentage = 32/40 or 80%

The results are:

UDT1 UDT10 Mon Tue Wed Thu Fri Sat Sun
Leave R 8            
Non Leave R   8 8 7.2 8.8    

Example 2

The employee charges these hours in a week:

UDT1 UDT10 Mon Tue Wed Thu Fri Sat Sun
Leave R 8            
Non Leave R   10 10 9 11    
Non Leave OS1           4  
  • Adjusted Standard Hours = 32, calculated as 40 (standard hours) - 8 (hours charged to leave, which is not prorated)
  • Prorate-able Hours = 40, calculated as  10 + 10 + 9 +11 (the sum of the hours charged to UDT1 account types and UDT10 pay types that are prorated)
  • Proration Percentage = 32/40 or 80%

The results are:

UDT1 UDT10 Mon Tue Wed Thu Fri Sat Sun
Leave R 8            
Non Leave R   8 8 7.2 8.8    
Non Leave OS1           4  
Parent Topic: Hour Proration