PIER report amounts inaccurate in Sage 300 Canadian Payroll 7.2A / CT 7.2D

Is anyone else experiencing discrepancies in the calculation of CPP in the P.I.E.R. Report?  Every one of our clients whom I have contacted re the report since upgrading to the current version are showing outages.  When we take the report and do the calculation (CPP earnings less Pension Exemption x 4.95%) the Amount Expected column is correct, however the contributions are out in EVERY employee's calculation.  The percentage of contribution ranges from 4.33 % to about 4.7%, none are 4.95%.  On our own payroll, I printed the Tax calculation analysis and the amounts match those in the CPP Contributions column on the PIER report and none are 4.95%.  Many of our clients are ready to file their T4's and I anticipate we will have a lot of unhappy campers.  Clients are in all provinces ranging from NFLD to BC and YT and I am certain that most of them did all payroll tax table updates on time since we assist most of them.  Is their a glitch in the calculation, and if so #1 has it been corrected and #2 how do we assist our clients in fixing this prior to filing T4's?

  • 0
    I think I have this partially figured out. The "CPP expected" column is calculating the deductions based on the full CPP Earnings amount instead of the CPP earnings less the basic exemption of $3,500. Once we make that adjustment, there are still discrepancies but a few cents instead of a couple hundred dollars.
  • 0 in reply to abenaki
    I have just spoken with CRA. The calculation should be CPP Insurable Earnings minus the Basic Exemption of $3,500 times 4.95%. On one of my client's payrolls only one out of approx 90 employees are calculating the CPP deductions correctly. The amounts in the "expected" columns would be correct if the $3,500 were deducted by the program prior to calculating the expected amount so I am not sure why the CPP contributions for the employees are not calculating properly.