WCB Recalculation Adjustment
The WCB Recalculation Adjustment is for use when a WCB benefit deduction is used on the payroll to track the calculation and cost of WCB. This process prompts for a pay period range to recalculate the WCB with a different rate, generating Year to Date Adjustments as well as the applicable GL journal entries. This process also includes the auto-interface option.
The WCB rate can be defined two different ways.
Option 1 on the FACTOR field of the Group 5 Type 1 deduction, and then uploaded to the employee’s deduction AMOUNT field. This report will report the rate as defined on the employee's deduction master.
Option 2 is on the EXTRA line of the Group 5 Type 1 deduction. For example, 112800/WCB/.0012/ where the first value is the WCB maximum assessable earnings, the second element must be WCB and the third element is the WCB rate. The employees AMOUNT field is blank or may contain a percentage. When the WCB rate is pulled from the EXTRA line this frees up the AMOUNT field on the employee’s master to contain an optional percentage. When blank the employees WCB earnings will be based on all of the applicable eligible earnings. When a value is defined on the employee’s AMOUNT field, that determines what percentage of the eligible earnings should be used for WCB. When the payroll runs, the eligible earnings are reported as the reduced amount. This report will report the rate from the EXTRA line in the header of the report and the employee’s percentage on the report detail, when applicable.
This WCB Recalculation process can also be used to rebuild the WCB Eligible earnings based on the current Include/Exclude lists on the deduction. This recalculation option can be used to correct earnings to be added or subtracted or to add in the employer paid benefits such as the EI Rebate portion to the WCB earnings. This recalculation option will only apply when the first pay period in the range of periods selected starts at the beginning of the year (e.g.:YYYY01). This recalculation must be run for all updated pay periods for the payroll for the current year. The WCB values pull from other payrolls comes from the employee deduction master which is of the last pay period updated so the recalculation must also be for all updated pay periods.
Enter WCB Deduction Code
Enter the deduction code that is used for the calculation of WCB. This deduction must be defined as a Benefit.
Enter Start Pay Period for Recalculation
Enter the starting pay period of the range to be included in the recalculation.
Enter End Pay Period for Recalculation
Enter the ending pay period of the range to be included in the recalculation.
Enter Pay Period for YTD Adjustment
Enter the pay period in which the calculated adjustment will be applied.
When the start period is selected as YYYY01, the following prompt will appear: “Rebuild Eligible Earnings Based on I/E Lists? Must Process for Full Calendar Year”. By selecting Yes, you are selecting the WCB Eligible Earnings rebuild option. This will recalculate the WCB Eligible based on the current Include/Exclude list which can also include the EI Rebate. This recalculation pulls the year to date WCB Eligible earnings from all other applicable payrolls per employee for a full recalculation and limiting. The header of the report will reflect ‘Recalculate Eligible’ when this feature is selected.
Omit GL Account Costing
Enter 'N' to include the generation of the GL Accounting interface file.
Enter 'Y' to omit GL Account Costing. No GL entries or interface file will be created.
Report Invalid GL Accounts Only
Enter 'N' to report all GL Accounts.
Enter 'Y' to report invalid GL Accounts only. This option applies to the Report Only feature only.
Produce Report Only or Process
Enter 'R' to only produce the report. No adjustments will be made.
Enter 'P' to produce the report and generate YTD adjustment entries.
Enter GL Adjustment Document Number
Enter the GL Adjustment Document number if there is one.
When Auto Interfacing is Active:
DO Auto Interface
Enter 'Y' to have the payroll journal entries automatically interfaced. The journal entry interface will create a report #####J.LST
Enter 'N' to prevent automatic interfacing.
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.
The report lists the following:
Employee Name and Number
WCB Rate Per Employee or Individual Employee WCB Percentage
Employee’s Eligible earnings from other payrolls, when applicable
Employee's Eligible Amount, * indicates Eligible Earnings were adjusted
Difference in Eligible Earnings
New Amount
Old Amount
Difference
Cost Centre
GL Account
GL Account summary of change