Open navigation

Balance Your CPP Remittances

This report can provide a final check to ensure your pensionable deductions and benefits are correct before Initializing Employee Totals. This will help:

  • Ensure year-to-date totals are accurate for the 2021 payroll year

  • Avoid CRA penalties

  • Avoid PIER listing

We have provided reports for you to run that compare the employee-paid CPP to the expected CPP amounts.

CPP Reconciliation Report Overview

The CPP Reconciliation Reports compare employee CPP deductions from history to the expected amounts. It displays any discrepancies for each pay period and has a summary of the total CPP deducted for 2021. These reports account for employees that are hired or terminated part way through the year, as well as those with unpaid leaves taken mid-year.

You may need to run a different report for each pay group. For an accurate comparison, match the report to the pay frequency and the number of payments per year on the pay group.

How to Download the Reports

The import files can be found as links at the bottom of this article. Please download the file for each pay frequency you have set up in your company.

Additional Information
Are you unsure of how many pay periods are in this year? This can be found in Pay Periods/Yr in Pay Groups.

Pay Frequency

File Name

Weekly with 52 pay periods in the year

Weekly 52 pay periods 2021.ardx

Weekly with 53 pay periods in the year

Weekly 53 pay periods 2021.ardx

Biweekly with 26 pay periods in the year

Biweekly 26 pay periods 2021.ardx

Biweekly with 27 pay periods in the year

Biweekly 27 pay periods 2021.ardx


Semi Monthly 2021.ardx


Monthly 2021.ardx

Important Information
These reports must be imported each year, as they rely on Max Pensionable Earnings, Employee Rate, and Employer Factor for the current year.

How to Import the Reports

Once the reports are downloaded, you can import them into your company.

Step 1: Open Report Definitions.
By default, this can be found in Report Designer.

Step 2: Select File, then Import in Report Definitions.

Step 3: Browse to the location the import file was saved. Select the file, then select Open

Step 4: Enter a Definition Name, then update the Report Title, if desired.

Step 5: Select OK to save the Report. Once OK is selected, the Definition Name cannot be modified. 

Step 6: Repeat Steps 2-5 for each different pay frequency you run payroll for.

Update the Reports

Once the reports are imported, they will need to be updated with the pensionable earnings and benefits.

Step 1: Open Report Definitions if it is not already open.
By default, this can be found in Report Designer.

Step 2: Select the imported CPP Reconciliation Report, then select Modify.

Step 3: Select Column 8.

Step 4: Select the column beside Criteria in Column Settings, then select to open the criteria.

Step 5: Select each pensionable earning code on the Available column. This will move them to the Selected column to be used in the report.

Step 6: Ensure all the earnings in the Selected column are pensionable.

  • If any earning codes in the Selected Column are not pensionable, select them to move them back to the Available column.

Step 7: Once only pensionable earning codes are in the Selected column, select OK.