Create Retroactive Timesheet Adjustments

Use the Create Retroactive Timesheet Adjustments screen to create retroactive pay timesheets.

Create timesheets that will compensate employees for calculated labor cost differences in posted timesheets, where the labor cost was not initially based on the correct hourly amount, payroll salary amount, fringe rate, auto adjust rate, and others. This can happen due to various reasons, such as administrative errors, late submissions, or adjustments in pay rates.

Purpose: Ensure employees are paid accurately for all hours worked, including any overtime or adjustments to their pay rate.

Process: Typically, these timesheets are created by comparing the original hourly rate used for timesheet entry against the new hourly or salary rate. Any differences in labor costs are calculated and recorded on a new timesheet.

Adjustments: The system evaluates each timesheet line and generates new lines to reflect any labor cost differences

Warning: Before weighted average rates can be applied on this screen, the employee's timesheet cycle must first be configured in the Configure Weighted Average Overtime Settings screen.

If you have not posted timesheets, use the Manage Timesheets program to perform pay rate modifications; however, if you have posted timesheets, you must use this process to generate retroactive pay timesheets for the records in question.

The following timesheet types are selected for processing:
  • R-Regular timesheets that have not been reversed through the Create Reversing Timesheets screen or corrected through the Manage Correcting Timesheets screen.
  • C-Correcting
  • D-Correcting
  • L-Labor Only

Only timesheets that have been posted through the Post Timesheets screen will be selected for processing. The system will recalculate the labor cost for each timesheet line from the selected timesheets. The new labor cost will be compared to the original labor cost and any differences will result in the generation of a retroactive pay timesheet line. Differences may be due to changes in hourly rate, payroll salary amount, auto adjust %, wage determination rates, union rates, union fringe rates, and pay type setup.

You can have this application determine the retroactive rate for posted timesheet lines that have been recalculated using a weighted average rate.

You can also use this application to determine the retroactive rate for posted timesheet lines that have been recasted. It applies the percent of increase between the original hourly rate and the new hourly rate to the recasted overtime premium. Overtime premium recast refers to the ability to reassign the premium portion of overtime charges to a specific recast project, account, and/or pay type that is different from the charge accounts noted on the original timesheets.

This application populates permanent reporting tables that you can use as sources for the timesheet adjustments made in this screen. You can cancel this process at any time; however, if you are satisfied with your record specifications, you must click to execute this process.