The Gross Pay Comparison Report generates a report comparing the current Earning Summary gross pay results with a prior period gross earnings and detailing the differences. This report accesses temporary files created by running the Earning Summary. This report cannot be run until the applicable Earning Summary phase has been completed.
This report details both the gross earnings, hours and number of employees paid for both the current and prior period. From this information you are then able to identify changes since the last payroll run.
The first part of Process Gross/Deduction Comparison Report, under the Users Specific Parameter Profile, supplies the option of having this report automatically generated during the Earning Summary run. When this report is generated automatically under the Earning Summary run the report can also be archived through the Pay Report Output system. The Earnings Summary run will use the prompt values from the stored prompt set called 'DEFAULT' for all prompts except for the pay period prompt values. When no prompt set called 'DEFAULT' exists, the Gross Pay Comparison report is generated using exclude no pay codes, no omit, no forgiveness factor and sorting is based on the User Specific Parameters Profile, Sort Sequence.
NOTE: This report can only be run after completing the Earning Summary run and before the Payroll Update.
This process includes the option to maintain multiple sets of stored prompts.
Name the prompt sets by defining a title up to 10 characters, with a 30-character description.
On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.
The export file includes the following fields:
-
Employee Number
-
Employee Name
-
Salary Grid
-
Prior Gross
-
Current Gross
-
Gross Difference
-
Prior Hours
-
Current Hours
-
Hours Difference
-
Current FTE
-
Current Cycle Code
-
Current Status
NOTE: This report will only run in batch.
Enter Current Pay Period
-
Enter the pay period for which the Earning Summary was run.
Enter Prior Pay Period
-
Enter the prior pay period to define which year to date earnings are to be used in the comparison.
Enter Pay Code Include/Exclude
-
Enter 'E' to indicate the following list of pay codes are to be excluded from the calculation of the employee's gross earnings.
-
Enter 'I' to indicate the following list of pay codes are the only pay codes to be included in the calculation of the employee's gross earnings.
Enter Pay Codes
-
Enter the pay codes one at a time to define a list of pay codes to be included or excluded in the calculation of the employee's gross earnings.
Omit Zero Gross Differences
-
Enter 'N' to include all employee entries on the report.
-
Enter 'Y' to omit entries where the gross difference is zero. This option gives you a listing of just changes between the two pay periods.
Enter a Forgiveness Factor
-
Enter a forgiveness factor. Gross earnings differences that are off by the amount of the forgiveness factor, will be omitted from the report. The forgiveness factor covers both positive and negative values. For example, a forgiveness factor of 1.00 will omit entries that are from –1.00 through to 1.00.
Sort by Employee #, Department, Name or Salary Grid
-
Enter 'E' to have the report sorted by employee number.
-
Enter 'D' to have the report sorted by employee number within location code.
-
Enter 'N' to have the report sorted by employee name.
-
Enter 'S' to have the report sorted by salary grid from the master function line.
Optional Selection of Employees by Pay Cycle
-
Enter 'N' when employee selection by pay cycle code is not required.
-
Enter 'Y' to define a list of pay cycles codes to be used for employee selection.
When 'Y'ES to Select by Pay Cycle was Selected:
Enter Pay Cycle Codes for Employee Selection
-
Enter 1 or up to 15 pay cycle codes to be used for employee selection.
Only employees that are currently being paid from one of the selected pay cycle codes will be included on the report.
Include Generation of CSV Export File
-
Enter 'N' to omit the generation of the export file.
-
Enter 'Y' to include the generation of the export file with this report.
The report lists the following:
-
Employee number and name
-
Salary grid from master function line
-
Gross earnings for prior period
-
Gross earnings for current period
-
Difference in gross earnings
-
Hours for prior period
-
Hours for current period
-
Difference in hours
-
Current FTE when Percentage Employed is active
-
Current pay cycle code
-
Current Status when employee is not active
-
The total number of employees paid for prior and current period
-
Total employees printed