• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Calculating the CPP Exemption

Does anyone know the best way to calculate the CPP Exemption?

I am trying to extract the data from E1 for a conversion to Oracle HCM and the Exemption isn't stored in E1

I know that to calculate the CPP Exemption, it should be 134.62 * Number of Pays the employee has received (what is the best way to get this number)

I have an employee that hasn't maxed out and should be calculated normally
If I used the above method
(3500/26)*14 (Number of pays) = 1884.62

I have tried calculating it by doing the following
1) Taxable Earnings * 4.95% = Total Taxable
2) Total Taxable - Total Withheld = Total
3) Total/4.95% = Exemption

If I use this method:
1) 46386.74 * 0.0495 = 2296.14363
2) 2296.14363 - 2202.82 (CPP Withheld) = 93.32363
3) 93.32363/0.0495 = 1885.3258

As you can see the 2 methods generate different amounts

I need to get this calculation figured soon as we are in the middle of a data conversion.


For the most part this calculation works EXCEPT if the person was on leave during the year; turned 70 in the year or filled out the CPT30 form in the year

Is there any where in JDE that I can validate that my calculation is correct?

Last edited: