Skip to Content
avatar image
Former Member

PCR for calculating Employee and Employer contribution in Saving Plan - Canada Payroll

Hello Experts,

Client is transitioning from existing to a new Saving Plan.This does not have to be set up in Benefit as it is a non-registered plan.

Existing Plan Deduction WT to IT0014 calculates the Employee Contribution only. Custom Rule is defined to calculate the Emp. contribution based on the deduction WT 88xx.

In the New plan both Employee and Employer contributions have to be calculated however Employer contribution is calculated only to include in the interface file.

Two Deduction WT is defined:

88xx - EE Contribution (between 0 to 12%)

88xx - ER Contribution to be determined as follows.

If EE Contri. % is between 0 to 6% --> ER contribution would be 1/3(EE Contribution %)

If EE Contri. % > 7 to 12 --> ER contribution would be flat 2%

Questions:

1. Should I define a z-processing class to work out this above scenario?

2. How to define the custom PCR for the above calculation?

I am pasting the logic that I thought through however this being my first payroll implementation and writing custom PCR need help.

Employee Contribution Logic:

If AMT/ NUM is between 1 to 12 %

Employee Contribution (0 to 12%) --> NUM*0.01

Read the EE Basic Salary = AMT (Regular/ Part Time)

Multi RNA (Multiplying the contribution % and the Basic Salary)

ADDWT to Output Table --> EE Deduction to be show in Payroll Result

Employer Contribution Logic:

If

Employee Contribution NUM is between 1 to 6 %

Employer Contribution % (NUM*0.01)/3

Read the EE Basic Salary = AMT (Regular/ Part Time)

Multi RNA (Multiplying the contribution % and the Basic Salary)

ADDWT to Output Table --> ER Contribution AMT to be included in Interface file

Else if

EE Contribution % NUM is > 6%

Employer Contribution % (is flat 2%) NUM*0.02

Read the EE Basic Salary = AMT (Regular/ Part Time)

Multi RNA (Multiplying the contribution % and the Basic Salary)

ADDWT to Output Table --> ER Contribution AMT to be included in Interface file

Logic Defined for the current plan:

Please explain the below logic to get a better understanding.

  • -ADDWT&R827 VAR Variable table
  • -NUM*0.01 Multiplication
  • -AMT=& R190 Set
  • -MULTI NAA Multipl. Amt/no/rate
  • -AMT+& R827 Addition
  • -ELIMI * ????
  • -ADDWT * OT Output Table
  • -ZERO=&R827 VVVV Set Zero

I am working on a small time line. Immediate help with defining the custom rule and PCR for the above scenario is highly appreciated.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 21, 2017 at 08:43 PM

    What Function will call that pcr?

    What will be a typical Input being processed?

    Operation ELIMI * will eliminate all splits of the WT being processed. What are the expected splits of the WT being processed in that pcr, and are you sure that you want to eliminate all splits ?

    Are you sure that temporary variable & R190 will exist when the pcr is called?

    Because of rounding, I've learned that it is usually preferable to make the multiplications before the divisions (and AMT*0.01 is the same as AMT/100). Therefore, I would suggest the following sequence: ADDWT&R827 AMT=& R190 MULTI NAA AMT/100 AMT+& R827 ELIMI *....

    Add comment
    10|10000 characters needed characters exceeded