Pensionable & Insurable Earnings Review (PIER) Report (RPCPIEK0)
The Pensionable and Insurable Earnings Review (PIER) Report (RPCPIEK0) reviews the year-to-date Canada Pension Plan/Quebec Pension Plan (CPP/QPP) contributions and Employment Insurance (EI) premiums that employees have made to ensure that they are accurate. However, if insufficient or excess amounts are found in employees' CPP/QPP contributions or EI premiums (or both), this report displays these discrepancies in its output. To identify these discrepancies and to resolve them on a timely basis, you can execute the PIER Report (RPCPIEK0) as often as you like – at the end of every pay period, every month, every quarter, or every year.
The PIER Report (RPCPIEK0) only identifies under- or overpayments to CPP, QPP and EI to the extent that these payments have been entered in mySAP Human Resources. Amounts that have not been entered in mySAP HR cannot be identified by this report. You should therefore ensure that all CPP/QPP contributions and EI premiums are present in the SAP R/3 System, rather than legacy systems, to enable under- or overpayments to be identified.
In general, insufficient or excess payments made to CPP, QPP and EI arise from adjustments that have been entered manually in mySAP HR through the Payroll Results Adjustment infotype (0221) or through the Adjustments Workbench. These inaccuracies arise because amounts that are processed in those ways are calculated and entered manually. However, during normal payroll runs, mySAP HR Payroll correctly calculates the contributions and premiums paid by employers and employees.
In addition to the inaccuracies that manual adjustments often cause, additional discrepancies may arise from the fact that mySAP HR Payroll calculates contributions and premiums on a per-pay period basis, while the PIER Report (RPCPIEK0) calculates the contributions and premiums that should have been paid on a year-to-date basis.
As delivered, the PIER Report (RPCPIEK0) reviews the wage types defined in the following Payroll Canada Implementation Guide (IMG) step to perform its accuracy check:
® Pensionable and Insurable Earnings Reporting
® Configure wage types for Pensionable and Insurable Earnings Reporting
When you create adjustments for employees and enter their CPP/QPP contributions and EI premiums, mySAP HR performs calculations to determine whether these amounts are correct.
If an employee was terminated in the middle of a pay period and could not apply their full CPP/QPP exemption to the earnings made in that period, then mySAP HR would ignore the rest of the exemption, and an excess contribution would occur.
Upon execution, the PIER Report (RPCPIEK0) would combine all pay period exemptions for the year, then calculate the amount of CPP/QPP contributions and EI premiums owed on the entire amount earned. At this point, the PIER Report (RPCPIEK0) would note the excess contribution in its output.
The PIER Report (RPCPIEK0) should be run periodically throughout the year to determine whether deficiencies or overpayments exist in CPP/QPP contributions or EI premiums.
To access the PIER Report (RPCPIEK0), choose the following menu path from the main Payroll Canada menu:
· Subsequent activities ® Period-independent ® Reporting ® Reconciliation – P.I.E.R. report
On the report selection screen, specify the key date that the application should use to perform reporting. Then specify a personnel number or range of personnel numbers for which you would like to review the accuracy of contributions and premiums paid.
Under Restrictions, choose the corresponding radio button to specify whether the PIER Report (RPCPIEK0) should identify discrepancies in CPP/QPP contributions or in EI premiums. If desired, specify the Show under/overpayments only checkbox to instruct the report to only identify employees with discrepancies in contributions or premiums (or both) in the report output, rather than the entire employee population for whom the report was executed. Finally, if you have selected this checkbox, then you must also specify the range of discrepancies in the Hide under/overpayments from and to fields that the system may overlook as it reviews employee contributions and premiums. The default range of amounts that the PIER Report (RPCPIEK0) is instructed to overlook is from -$1 to +$1; any under- or overpayment whose absolute value is less than one dollar is therefore overlooked, unless you change the specified range of amounts. To view all discrepancies, enter the value 0 in both fields.
Once you have made selections, where appropriate, in the screen elements described above, execute the report.
For each employee in the reporting population, the PIER Report (RPCPIEK0) displays the following information in its output.
· Employee name and Social Insurance Number
· Taxable income reported in Box 14 of Form T4
· Pensionable earnings reported in Box 26 of Form T4
· Insurable earnings reported in Box 24 of Form T4
· CPP/QPP contributions reported in Box 16 of Form T4
· EI premium reported in Box 18 of Form T4
· Deficiencies in CPP/QPP contributions or EI premiums (or both), in accordance with payroll calculation rules issued by the Canadian Customs and Revenue Agency and le Ministère du Revenu du Québec