Understanding the Salary Equalization Utility Listing

Home | FAQs & Troubleshooting

 

Expand/Collapse all Show/Hide All

The Salary Equalization utility is used to adjust salaried employees' pay amounts in Time Track Entry records so that the pay matches the employees' salary for the pay period. For hourly employees, the utility adjusts the employees' pay amounts in Time Track Entry records so that they match the employees' expected earnings based on their pay rate and auto-pay hours.

The Salary Equalization Utility Listing includes all employees within the selected range of employee numbers who are assigned the selected pay cycle. If an employee has no Time Track Entry records in the selected date range, this is indicated on the listing.

If an employee's only existing records cannot be adjusted, either because they have already been transferred to Payroll Data Entry or Job Cost, or because the hours worked equal zero, the listing indicates that no adjustment is possible.

For all other employees, each eligible Time Track Entry record is adjusted. The adjustment is calculated by multiplying the wage adjustment needed (WAN) by the ratio of the hours worked for that record to the unposted Time Track Hours. Depending on the options selected, the wage rate can then be recalculated and the Approval check box can be automatically selected.

The following descriptions of each column on the Salary Equalization Utility Listing explain what takes place when you run the utility.

Expand/Collapse item  Pay Period Wages

For salaried employees, this is the rate entered in the Pay Rate 1 field in Employee Maintenance. For hourly employees, this is the rate entered in the Pay Rate 1 field multiplied by autopay hours.

 

Expand/Collapse item  Target Amount

This is the pay period wages multiplied by the equalization percentage. The total pay amount of all Time Track Entry records in the selected date range equals the target amount.

 

Expand/Collapse item  Total Wages

This is the total pay amount of all Time Track Entry wages in the selected date range before any adjustments are made. It includes pay amounts from records that cannot be adjusted.

 

Expand/Collapse item  Unposted Hours

This is the total hours worked for all Time Track Entry records in the selected date range that have a status of Not Transferred (in other words, they have not been transferred to Payroll Data Entry or Job Cost). It does not include hours from entries that cannot be adjusted.

 

Expand/Collapse item  Wage Adj. Needed (WAN)

This is the difference between the target amount and the total wages.

 

Expand/Collapse item  Number of Records Adjusted

This is the number of Time Track Entry records that were adjusted by the utility. If no records were adjusted, either Not Possible or Not Required appears in this column.