Load Lines into the British Columbia (BC) pension report worksheet

School boards can load the British Columbia pension data that is stored in Sparkrock 365 into the British Columbia pension report worksheet, and then view the data. From the worksheet, school boards can verify the data, and then print reports. Also, school boards can use the worksheet as a register for audit purposes.

To load lines into the British Columbia pension report worksheet

  1. Choose Lightbulb that opens the Tell Me feature., enter british columbia pension report worksheet, and then choose the related link.

    The British Columbia Pension Report Worksheet page opens.

  2. On the action bar, choose Load Lines.

    If there is existing data on the British Columbia Pension Report Worksheet page, a dialog box appears that displays the following text:

    Already existing data from worksheet will be deleted. Do you want to continue?

    To continue, choose Yes.

    The British Columbia Pension Reporting Load Lines page opens.

  3. In Pay Periods, specify the one or more HR pay cycle periods for which you want data to appear in the worksheet.

  4. In British Columbia Pension Plan, specify MPP - Municipal Pension Plan or TPP - Teachers Pension Plan.

  5. (Optional) To only show pension data in the worksheet for a specific employee, in Employee No., specify the number that represents the employee.

  6. (Optional) In HR Department, specify the one or more HR department codes that Sparkrock 365 is to filter assignment entries by when loading lines into the British Columbia pension report worksheet.

  7. Choose OK.

Municipal Pension Plan (MPP) records

When determining which records to load into the British Columbia Pension Report Worksheet page for Municipal Pension Plan (MPP), Sparkrock 365 uses the following criteria:

  1. Identifies employees with HR assignments that have HR an position where the respective HR position class on the British Columbia Pension FastTab, has in Pension Employee Group, a value of 04GENERL.
  2. The Assignment Start Date and Assignment End Date match or overlap the values that you specify for Pay Periods on the British Columbia Pension Reporting Load Lines page.

Sparkrock 365 groups worksheet records and calculations by HR Emp. Assignment Entry No.. For example, when there are 2 HR employee assignments for an employee that fall within the pay periods, Sparkrock 365 displays 2 lines in the worksheet with separate calculations for each assignment.

Teachers Pension Plan (TPP) records

When determining which records to load into the British Columbia Pension Report Worksheet page for Teachers Pension Plan (MPP), Sparkrock 365 uses the following criteria:

  1. Identifies employees with HR assignments that have HR an position where the respective HR position class on the British Columbia Pension FastTab, has in Pension Employee Group, a value of 05GE10MO or 05GE12MO.
  2. The Assignment Start Date and Assignment End Date match or overlap the values that you specify for Pay Periods on the British Columbia Pension Reporting Load Lines page.

Sparkrock 365 groups worksheet records and calculations by HR Emp. Assignment Entry No.. For example, when there are 2 HR employee assignments for an employee that fall within the pay periods, Sparkrock 365 displays 2 lines in the worksheet with separate calculations for each assignment.

Retro pay records

On the British Columbia Pension Reporting Load Lines page, when you choose MPP - Municipal Pension Plan, Sparkrock 365 includes lines for retro pay in the worksheet where all the following criteria is met:

  • The employee has an assignment with an HR position that has an HR position class where the value for Pension Employee Group is 04GENERL.

  • The employee has received retro pay during the Pay Periods that were specified on the British Columbia Pension Reporting Load Lines page.

Alternatively, on the British Columbia Pension Reporting Load Lines page, when you choose TPP - Teachers Pension Plan, Sparkrock 365 includes lines for retro pay in the worksheet where all the following criteria is met:

  • The employee has an assignment with an HR position that has an HR position class where the value for Pension Employee Group is 05GE10MO or 05GE12MO.

  • The employee has received retro pay during the Pay Periods that were specified on the British Columbia Pension Reporting Load Lines page.

To determine the retro pay payroll ledger 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.

Rehab payment records

On the British Columbia Pension Reporting Load Lines page, when you choose MPP - Municipal Pension Plan, Sparkrock 365 includes lines for rehab payments in the worksheet where all the following criteria is met:

  • The employee has an assignment with an HR position that has an HR position class where the value for Pension Employee Group is 04GENERL.

  • The employee has received rehab payments during the Pay Periods that were specified on the British Columbia Pension Reporting Load Lines page.

Alternatively, on the British Columbia Pension Reporting Load Lines page, when you choose TPP - Teachers Pension Plan, Sparkrock 365 includes lines for rehab payments in the worksheet where all the following criteria is met:

  • The employee has an assignment with an HR position that has an HR position class where the value for Pension Employee Group is 05GE10MO or 05GE12MO.

  • The employee has received rehab payments during the Pay Periods that were specified on the British Columbia Pension Reporting Load Lines page.

To determine the rehab payment payroll ledger 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.

See also

British Columbia (BC) pension reporting

Feedback

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

feedback-product-docs@sparkrock.com