Understanding the Salary Equalization Utility Report

The Salary Equalization utility, accessed from TimeCard Utilities, is used to process salaried employees through TimeCard or to pay hourly employees for a fixed number of hours per pay period when their TimeCard hours do not equal their autopay hours. As the Salary Equalization utility is running, a report is generated.

Each employee in the selected range of employee numbers that has the indicated pay cycle is included on the Salary Equalization Utility Report. If an employee has no TimeCard entries in the selected date range, a message prints to this effect and no processing takes place for that employee. If entries do exist, but either all entries have been posted to Job Cost or Payroll, or the unposted TimeCard hours (UTH) equal zero, a message prints indicating that no adjustment is possible.

For all other employees, each eligible TimeCard entry is processed and adjusted, if possible. To be eligible for adjustment, an entry must have nonzero hours worked and have not been posted to either Job Cost or Payroll and not be an excluded entry. The adjustment that is made is calculated by multiplying the wage adjustment needed (WAN) by the ratio of the hours worked on that entry to the UTH. Depending on the options selected, the wage rate can then be recalculated and the approval status can be set to Y.

The following descriptions of each column on the Salary Equalization Utility Report explain what processing takes place.

Pay Period Wages

For salaried employees, this is the rate entered in the Pay Rate 1 field on the Payroll Employee Maintenance Wages tab; for hourly employees, this is the rate entered in the Pay Rate 1 field multiplied by autopay hours.

Target Amount

This is the pay period wages multiplied by the equalization percentage. The total pay amount of all TimeCard entries in the selected date range equals the target amount.

Total T/C Wages

This is the total pay amount of all TimeCard entries in the selected date range before any adjustments are made. It includes pay amounts from excluded entries.

Unposted T/C Hours (UTH)

This is the total hours worked of all TimeCard entries in the selected date range that have a Payroll and Job Cost posting status of N (that is, they have not been selected for processing nor posted to these modules). It does not include hours from excluded entries.

Wage Adj. Needed (WAN)

This is the difference between the target amount and the total T/C wages.

Number of T/C Records Adjusted

This is the number of TimeCard records that were adjusted by the utility.