Deduction Comparison Report

The Deduction Comparison Report generates a report comparing the current Payroll Processing deduction results with a prior period deduction results and detailing the differences. The pay period for the history deduction amounts is based on the employees pay cycle as well as the deduction frequency codes. This report accesses temporary files created by running the Payroll Processing. This report cannot be run until the applicable Payroll Processing phase has been completed.

This report details the employee and/or employer deduction amounts for both the current and prior period. From this information you are then able to identify changes since the last payroll run.

The second part of the Process Gross/Deduction Comparison Report field, under the Users Specific Parameter Profile, supplies the option of having this report automatically generated during the Payroll Processing run. When this report is generated automatically under the Payroll Processing run the report can also be archived through the Pay Report Output system. The Payroll Processing 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 Deduction Comparison report is generated including employee and employer amounts for all deduction codes with no omissions, no forgiveness factor and sorted first by deduction then based on the Sort Sequence Employee #, Department Or Name field of the User Specific Parameters Profile .

NOTE: This report can only be run after completing the Payroll Processing run and before the Payroll Update.

Default Prompt Storage & Retrieval  

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.

NOTE:  This report will only run in batch.

Batch and Print Queue Screen    

Include Employee, Employer Or Both Amounts [E/R/B] 

Enter 'B' to include both the employee and employer deduction amounts on the report.

Enter 'E' to report only the employee deduction amounts.

Enter ‘R’ to report only the employer share deduction amounts.

Enter Current Pay Period [YYYYPP] 

Enter the pay period for which the Payroll Processing was run.

Enter Deduction Code Include/Exclude  [E/I/] 

Enter 'E' to indicate the following list of deduction codes are to be excluded from the report.

Enter 'I' to indicate the following list of deduction codes are the only deduction codes to be included on the report.

Enter Deduction Codes  [##]

Enter the deduction codes one at a time to define a list of deduction codes to be included or excluded from the report.

Enter to continue when the list of deduction codes are complete.

Omit Zero Deduction Differences [Y/N]

Enter 'N' to include all employee entries on the report.

Enter 'Y' to omit entries where the 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. Deduction 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.

Report By Employee Or Deduction Number [E/D] 

Enter 'E' or to generate the report organized by employee.

Enter 'D' to generate the report organized by deduction number.

Sort Employee By Employee Number Or Name  [E/N] 

Enter 'E' to sort the entries by employee number.

Enter 'N' to sort the entries by employee name.

Include Generation Of CSV Export File [Y/N] 

Enter 'N' to omit the export file.

Enter 'Y' to include the generation of the export file. Note: An Excel button is not available as this option is a batch only process.

The CSV export file contains the following, when Both Amounts are reported:

• Employee number
• Employee name
• Deduction Code
• Deduction Description
• Current table, when applicable
• Current Taken
• Current Share
• Total Current
• Prior Taken
• Prior Share
• Total Prior
• Taken Difference
• Share Difference
• Total Difference

Exported fields vary based on report selection, employer columns is omitted report Employee only is selected and employee columns are omitted when only report Employer is selected.

The report lists the following:

• Deduction code and description
• Employee number and name
• Current pay period employee amount
• Current pay period employer share
• Total of the current pay period employee and employer amount
• Prior pay period employee amount
• Prior pay period employer share
• Total of the prior pay period employee and employer share
• Prior pay period employee amount less current pay period employee amount
• Prior pay period employer share less current pay period employer share
• Total of prior pay period values less current pay period values