BC Pension Report Worksheet Column Mappings and Calculations

The following tables describes how Sparkrock 365 determines the values that appear in columns on the BC Pension Report Worksheet page based on the report specification criteria and the type of record.

Municipal Pension Plan (MPP)

The following table describes how Sparkrock 365 determines the values that appear in columns on the BC Pension Report Worksheet page for Municipal Pension Plan (MPP) records.

Column Name Source of Data and Calculations
Employee SIN The Social Insurance No. field on the respective Employee Card page.
Employee Name A combination of the Last Name and First Name fields on the respective Employee Card page. For example, for an employee with the First Name of Steven and the Last Name of Smith, the Employee Name field displays Smith, Steven.
Employee No. The No. field on the respective Employee Card page.
EE Group The Pension Employee Group field on the respective HR Position Class Card page.
Type Set to RG.
Pensionable Salary Sum of the Base Taxable Amount field on the Payroll Ledger Entries page for the specified pay periods and employee, grouped by the HR Emp. Assignment Entry No..
To determine the pay periods, Sparkrock 365 uses the Pay Periods field on the BC Pension Reporting Load Lines page.
Pensionable Service The calculation differs depending on the value of Pension Position Class on the respective HR Position Class Card page.
When the value of Pension Position Class is Exempt or CUPE, Sparkrock 365 uses the following calculation:
Pensionable Service = Actual Hours Worked in Pay Period / Default Hours Available in Pay Period x (Employment Duration Type / Total Pay Periods in a Year)
When the value of Pension Position Class is CAS, CUPE10, or STUSUP, Sparkrock 365 uses the following 3 step calculation:
  1. Result 1 = Actual Hours Worked in Pay Period / Default Hours Available in Pay Period x (Employment Duration Type / Total Pay Periods in a Year)
  2. Result 2 = Result 1 x Vacation Percentage
  3. Pensionable Service = Result 1 + Result 2
When performing a calculation for multiple pay periods, Sparkrock 365 performs a calculation for each pay period that was specified, and then sums the amounts for all pay periods to determine the final pensionable service value.
To determine the Actual Hours Worked, Sparkrock 365 uses the records that appear on the Compensation Ledger Entries page.
To determine the Default Hours Available, Sparkrock 365 uses the value of the Hours/Week field on the respective HR Employee Assignment Card multiplied by 2.
To determine the Employment Duration Type, Sparkrock 365 uses the value in the Employment Duration Type field on the respective HR Position Class Card page, for example, 6 Month = 13, 8 Month = 17, 10 Month = 22, 11 Month = 24, 12 Month = 24.
To determine the vacation percentage, Sparkrock 365 uses the value in the Vacation Percentage field on the respective HR Position Class Card page.
Contributory Service To determine the value, Sparkrock 365 checks for contributions in each month for the specified pay periods. For each month that has a contribution, Sparkrock 365 counts 1 month.
To determine the pay periods, Sparkrock 365 uses the Pay Periods field on the BC Pension Reporting Load Lines page.
In situations where the pay period overlaps to the next month, for example, June 22, 2024 to July 7, 2024, to determine the month to count, Sparkrock 365 uses the value of Posting Date on the HR Pay Cycle Periods page.
Contributions Divide the value of Pensionable Salary by the EE Pension Rate field on the respective HR Position Class Card page.
Employee Contributions Sum of the Total Amount field for the one or more MPP payroll codes on the Payroll Ledger Entries page for the specified Pay Periods, displayed as a positive value.
To determine the one or more MPP pay codes, Sparkrock 365 uses the values that are set up in MPP Pay Codes on the Advanced HR Setup page.
To determine the pay periods, Sparkrock 365 uses the Pay Periods field on the BC Pension Reporting Load Lines page.
Employer Contributions Sum of the Total Amount field for the one or more MPP employer contribution payroll codes on the Payroll Ledger Entries page for the specified Pay Periods, displayed as a positive value.
To determine the one or more MPP employer contribution pay codes, Sparkrock 365 uses the values that are set up in MPP Employer Contribution Pay Codes on the Advanced HR Setup page.
To determine the pay periods, Sparkrock 365 uses the Pay Periods field on the BC Pension Reporting Load Lines page.
Start Date The earliest pay period that is specified in the Pay Periods field on the BC Pension Reporting Load Lines page.
End Date The latest pay period that is specified in the Pay Periods field on the BC Pension Reporting Load Lines page.
Description Sparkrock 365 leaves the field blank.
Date Sparkrock 365 leaves the field blank.

Teachers Pension Plan (TPP)

The following table describes how Sparkrock 365 determines the values that appear in columns on the BC Pension Report Worksheet page for Teachers Pension Plan (TPP) records.

Column Name Source of Data and Calculations
Employee SIN The Social Insurance No. field on the respective Employee Card page.
Employee Name A combination of the Last Name and First Name fields on the respective Employee Card page. For example, for an employee with the First Name of Steven and the Last Name of Smith, the Employee Name field displays Smith, Steven.
Employee No. The No. field on the respective Employee Card page.
EE Group The Pension Employee Group field on the respective HR Position Class Card page.
Type Set to RG.
Pensionable Salary Sum of the Base Taxable Amount field on the Payroll Ledger Entries page for the specified pay periods and employee, grouped by the HR Emp. Assignment Entry No..
To determine the pay periods, Sparkrock 365 uses the Pay Periods field on the BC Pension Reporting Load Lines page.
Pensionable Service Sparkrock 365 uses the following calculation:
Pensionable Service = Actual Days Worked / Total Days In Pay Period
When performing a calculation for multiple pay periods, Sparkrock 365 performs a calculation for each pay period that was specified, and then sums the amounts for all pay periods to determine the final pensionable service value.
To determine the Actual Days Worked, Sparkrock 365 sums the Days Worked in Pay Period field for records that appear on the Compensation Ledger Entries page. To determine the Total Days in Pay Period, Sparkrock 365 sums the No. of Days in Pay Periods field for records that appear on the Compensation Ledger Entries page.
Contributory Service To determine the value, Sparkrock 365 checks for contributions in each month for the specified pay periods. For each month that has a contribution, Sparkrock 365 counts 1 month.
To determine the pay periods, Sparkrock 365 uses the Pay Periods field on the BC Pension Reporting Load Lines page.
Contributions Divide the value of Pensionable Salary by the EE Pension Rate field on the respective HR Position Class Card page.
Employee Contributions Sum of the Total Amount field for the one or more TPP payroll codes on the Payroll Ledger Entries page for the specified Pay Periods, displayed as a positive value.
To determine the one or more TPP pay codes, Sparkrock 365 uses the values that are set up in TPP Pay Codes on the Advanced HR Setup page.
To determine the pay periods, Sparkrock 365 uses the Pay Periods field on the BC Pension Reporting Load Lines page.
Employer Contributions Sum of the Total Amount field for the one or more TPP employer contribution payroll codes on the Payroll Ledger Entries page for the specified Pay Periods, displayed as a positive value.
To determine the one or more TPP employer contribution pay codes, Sparkrock 365 uses the values that are set up in TPP Employer Contribution Pay Codes on the Advanced HR Setup page.
To determine the pay periods, Sparkrock 365 uses the Pay Periods field on the BC Pension Reporting Load Lines page.
Start Date The earliest pay period that is specified in the Pay Periods field on the BC Pension Reporting Load Lines page.
End Date The latest pay period that is specified in the Pay Periods field on the BC Pension Reporting Load Lines page.
Description Sparkrock 365 leaves the field blank.
Date Sparkrock 365 leaves the field blank.

Retro pay

The following table describes how Sparkrock 365 determines the values that appear in columns on the BC Pension Report Worksheet page for retro pay records.

Column Name Source of Data and Calculations
Employee SIN The Social Insurance No. field on the respective Employee Card page.
Employee Name A combination of the Last Name and First Name fields on the respective Employee Card page. For example, for an employee with the First Name of Steven and the Last Name of Smith, the Employee Name field displays Smith, Steven.
Employee No. The No. field on the respective Employee Card page.
EE Group Sparkrock 365 leaves the field blank.
Type Set to RT.
Pensionable Salary Sum of the Total Amount field for the retro pay entries on the Payroll Ledger Entries page for the specified pay periods.
To determine the pay periods, Sparkrock 365 uses the Pay Periods field on the BC Pension Reporting Load Lines page.
To determine the retro pay entries to use in the worksheet calculations, Sparkrock 365 uses the one or more values that are set up on the Advanced HR Setup page, on the BC Pension Setup FastTab, in the Retro Pay Codes field.
Pensionable Service Sparkrock 365 leaves the field blank.
Contributory Service Sparkrock 365 leaves the field blank.
Contributions Divide the value of Pensionable Salary by the EE Pension Rate field on the respective HR Position Class Card page.
Employee Contributions Sparkrock 365 leaves the field blank.
Employer Contributions Sparkrock 365 leaves the field blank.
Start Date The earliest pay period that is specified in the Pay Periods field on the BC Pension Reporting Load Lines page.
End Date The latest pay period that is specified in the Pay Periods field on the BC Pension Reporting Load Lines page.
Description Sparkrock 365 leaves the field blank.
Date Sparkrock 365 leaves the field blank.

Rehab Payments

The following table describes how Sparkrock 365 determines the values that appear in columns on the BC Pension Report Worksheet page for rehab payment records.

Column Name Source of Data and Calculations
Employee SIN The Social Insurance No. field on the respective Employee Card page.
Employee Name A combination of the Last Name and First Name fields on the respective Employee Card page. For example, for an employee with the First Name of Steven and the Last Name of Smith, the Employee Name field displays Smith, Steven.
Employee No. The No. field on the respective Employee Card page.
EE Group Sparkrock 365 leaves the field blank.
Type Set to RH.
Pensionable Salary Sum of the Total Amount field for the rehab payment entries on the Payroll Ledger Entries page for the specified pay periods.
To determine the pay periods, Sparkrock 365 uses the Pay Periods field on the BC Pension Reporting Load Lines page.
To determine the rehab payment entries to use in the worksheet calculations, Sparkrock 365 uses the one or more values that are set up on the Advanced HR Setup page, on the BC Pension Setup FastTab, in the Rehab Pay Codes field.
Pensionable Service Sparkrock 365 leaves the field blank.
Contributory Service Sparkrock 365 leaves the field blank.
Contributions Divide the value of Pensionable Salary by the EE Pension Rate field on the respective HR Position Class Card page.
Employee Contributions Sparkrock 365 leaves the field blank.
Employer Contributions Sparkrock 365 leaves the field blank.
Start Date The earliest pay period that is specified in the Pay Periods field on the BC Pension Reporting Load Lines page.
End Date The latest pay period that is specified in the Pay Periods field on the BC Pension Reporting Load Lines page.
Description Sparkrock 365 leaves the field blank.
Date Sparkrock 365 leaves the field blank.

See also

BC Pension Reporting

Feedback

To send feedback about this page, select the following link:

feedback-product-docs@sparkrock.com