1. Canadian Payroll Year-End Processing Guide
  2. Understanding Pension Records

Understanding Pension Records

This section explains how to set up pension records in the Employee Pension Maintenance table (F77230). You can use this method of creating pension records to report pension information on either T4A or T4 forms.

The system generates a T4A form in any of these situations:

  • A former employee or nonemployee (such as a contractor) has tax history type P record in the Tax History table (F0713).

  • A former employee has pension records that are flagged to print on a T4A in the F77230 table.

    Note: For the employees who do not have tax history records for the corresponding employee pension maintenance records, enter the data selection for the Canadian Year-End Work File Build - T4A program (R77130) version same as the Year-End Workfile Build program (R77100) version. The R77130 now provides data selection on the Employee Pension Maintenance table (F77230) and Employee Master Information table (F060116). Enter the R77130 version name in the R77100 processing option. In case, you do not have any employees belonging to the mentioned criteria, then you do not need to select data on the R77130 version, and you can leave the processing option blank on R77100. The R77130 will use the default version ZJDE0001 to generate the T4A form. This functionality supports the releases 9.0 and 9.1.

  • A former employee or nonemployee has had PDBA amounts linked to boxes on the T4A form through special handling.

    Note: For the employees who do not have tax history and employee pension maintenance records but have PDBA records (F06148), use the Pension Maintenance program (P77235) to add records for the T4A boxes 016 and 028 with no amounts. The T4A build (R77130) uses the amounts from F06148 based on the special handling for these boxes, and will create a T4A record during year-end. Enter the R77130 version name in the R77100 processing option. If there are no employees that belong to the mentioned criteria, then you do not need to select any data. On the R77130 version and you can leave the processing option blank on Year-End Workfile Build program (R77100). The R77130 uses the default version ZJDE0001 to generate the T4A form. This functionality supports the releases 9.0 and 9.1.

If a former employee fits more than one of the preceding situations, the system combines all applicable amounts on a single T4A form.

You can use the Pension Maintenance Report (R77402) to list the records in the F77230 table. You can use this report to verify pension information before you run the workfile build to create the year-end tables.

When you run the workfile build, the system assigns a year-end ID to the pension records that were included in the data selection for the workfile build. You can also run this report after you create the year-end tables to verify that all applicable records in the F77230 table are included in the correct year-end ID.