The Detailed Adjustments Report module provides a method to obtain a listing of all adjustments that have been done between two points in time. The report was designed to provide the ability for users to obtain a listing with totals of transactions that affected various deductions between two remittances to external suppliers of service. The report is designed to be a companion to the year-to-date adjustment and manual cheque process. Each manual cheque and year-to-date adjustment create a record in a work file. This work file is held until deleted by this process. The intention is to run an accumulation of these entries starting with the point in time where remittances are made to the CRA and other external suppliers of services and accumulated until the next remittance is due. You would then take the deduction reports that have been produced in the payrolls in the intervening time period and adjust the totals by the amount of the adjustments maintained in the work file as evidenced by the report produced in this process. The files should be deleted during this process so that it is reset to an empty file to start the process again for the next period.
Delete the Work File
-
Enter 'N' to produce the report without deleting the work file. This should only be done if an interim report is required between the 2 remittance periods.
-
Enter 'Y' if you want to delete the work file after the report has been produced.
When DELETING the Shadow file was selected:
Backup Shadow File
-
Enter 'N' to omit the shadow file backup prior to deletion.
-
Enter 'Y' to have the shadow file backed up prior to being deleted. The backup file name will be SRB$OPSWRK:PRYDWK.YYMMDD where YYMMDD is the current date.
The report lists the following:
-
Period - Indicates the period number and type of record
-
Employee number and name
-
The pay code, hours and amount for each pay code in each adjustment record
-
Deduction code, share, eligible amount and benefit for each deduction code
-
A gross pay and deduction total and a net pay total
-
This is replicated for each adjustment record contained in the file.
-
The final two pages of the report include a pay code and deduction code summary.
-
The pay code summary summarizes the total hours and amount for each pay code from the adjustment file.
-
The deduction summary provides a summary for each deduction code, the total share, eligible and deduction amount.
-
The report presents the total gross pay, total deductions and total net.