British Columbia (BC) pension report worksheet column mappings and calculations

The following tables describes how Sparkrock 365 determines the values that appear in columns on the British Columbia 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 British Columbia 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 British Columbia 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: Result 1 = Actual Hours Worked in Pay Period / Default Hours Available in Pay Period x (Employment Duration Type / Total Pay Periods in a Year) Result 2 = Result 1 x Vacation Percentage 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 British Columbia 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 British Columbia 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 British Columbia Pension Reporting Load Lines page.
Start Date	The earliest pay period that is specified in the Pay Periods field on the British Columbia Pension Reporting Load Lines page.
End Date	The latest pay period that is specified in the Pay Periods field on the British Columbia 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 British Columbia 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 British Columbia Pension Reporting Load Lines page.
Pensionable Service	Sparkrock 365 uses different calculations depending on whether the respective HR pay cycle has a Type of Biweekly. To determine the HR pay cycle Type, Sparkrock 365 references the respective HR pay cycle based on the value that is specified for Pay Periods on the British Columbia Pension Reporting Load Lines page. When the HR pay cycle Type is not equal to Biweekly, Sparkrock 365 performs the following calculation: Pensionable Service = Days Worked in Pay Period / No. of Days in Pay Period Alternatively, when the HR pay cycle Type is equal to Biweekly, Sparkrock 365 performs the following calculation: Pensionable Service = (Days Worked in Pay Period / No. of Days in Pay Period) x (Employment Duration Type / Total Pay Periods) 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 value of Days Worked in Pay Period, Sparkrock 365 sums the Days Worked in Pay Period field for records that appear on the Compensation Ledger Entries page. To determine the value of No. of 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. To determine the value of Employment Duration Type, Sparkrock 365 references the value for Employment Duration Type that appears on the respective HR Position Class Card. To determine the value of Total Pay Periods, Sparkrock 365 uses the following logic: 10 months = 22 pay periods, 11 months = 24 pay periods, 12 months = 26 pay periods
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 British Columbia 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 British Columbia 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 British Columbia Pension Reporting Load Lines page.
Start Date	The earliest pay period that is specified in the Pay Periods field on the British Columbia Pension Reporting Load Lines page.
End Date	The latest pay period that is specified in the Pay Periods field on the British Columbia 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 British Columbia 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 British Columbia 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 British Columbia 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 British Columbia Pension Reporting Load Lines page.
End Date	The latest pay period that is specified in the Pay Periods field on the British Columbia 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 British Columbia 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 British Columbia 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 British Columbia 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 British Columbia Pension Reporting Load Lines page.
End Date	The latest pay period that is specified in the Pay Periods field on the British Columbia Pension Reporting Load Lines page.
Description	Sparkrock 365 leaves the field blank.
Date	Sparkrock 365 leaves the field blank.

See also

British Columbia (BC) pension reporting

Feedback

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

feedback-product-docs@sparkrock.com