CPP2 Balancing Process
The CPP2 Balancing Process is used to verify and/or correct the distribution of total CPP between CPP1 and CPP2 for all payrolls combined, for a given taxation year. The full CPP amount
or taken amount for the year is the correct total, so this process does not affect the employee’s actual pay or CPP deduction amount. This process ensures the values reported from the full CPP that is
CPP1 and CPP2 is correct, taking all history entries for the year, across all payrolls for an employee.
When multiple payrolls are run simultaneously, or pay periods run out of sequence occur, the reporting the CPP2 can be skewed.
This process should be run from any payroll but before the T4 processing starts for a given year.
This process can be run anytime throughout the year, as needed.
This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The export file is generated where the logical SRB$OPSWRK is defined. All fields within
the export file have any extra spaces removed from the front and back of the fields and all fields are separated by a comma.
The export file includes the following fields:
Employee number
Employee name
Payroll ID
CPP deduction code
Pay Period
CPP To date for given period, including current period values
CPP Taken for given period
Current CPP2 distribution for given period
Fix amount to be applied to CPP2
Adjusted CPP2 amount
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.
BATCH AND PRINT QUEUE SCREEN
Enter CPP Report Year
Enter the taxation year to review the CPP1 and CPP2. The maximum CPP1 and CPP2 is taken from the Provincial Tax Parameters base on this year value.
Report By Employee Number Or Employee Name
Enter ‘N’ to report based on employee name.
Enter ‘E’ to report based on employee number.
Produce Report Only Or Process
Enter ‘R’ to only generate a report of any findings. No changes will be made.
Enter ‘P’ to generate a report and to update the history CPP2 values as reported.
Include Generation OF CSV Export File
Enter 'N' to omit generation of the CSV export file.
Enter 'Y’ to include the generation of the CSV export file.
The report lists the following:
Employee number and name and status
Full CPP Amount from all payrolls for given year
Full current CPP1
Full current CPP2
Second line, CPP1 and CPP2 corrections
Third line, total CPP1 and CPP2 with adjustments
Detail lines define:
Pay Id
CPP deduction code
Pay period
CPP total to date up to and including this pay period
CPP taken for given period and payroll
CPP2 allocation of total taken
Fix amount to be applied to CPP2
CPP2 now value is final CPP2 after adjustment, per period
Final CPP2 total should match that of adjusted total
** will indicate the Final CPP2 does not match the Adjusted CPP2 total, this should be reviewed.