The Pension Adjustment Import Process Upload option is used to load PA entries into Payroll from a comma or tab delimited file. This process can be used to add to or override existing PA Amount from the imported values. For regular PA imports, this process will create a new PA record for the tax year and deduction code when one does not yet exist.
This process can also be used to import Amended Pension Adjustments (APA). The file for APA adjustments is usually supplied by the provincial pension board and as such the upload for this data uses the employee’s SIN to identify the employees. You would run your APA file from each payroll that is applicable for the file. For example, for a TPP file you would run the PA Import process under each applicable payroll for TPP members. Only payrolls where the employee’s SIN is found and a PA record already exists for the defined year, will be used to update the PA amounts.
An option to create an Excel output file containing all processed or accepted entries is available. These entries also include the record reference number that relates back to the original import file. The intent of this export file is to facilitate balancing the total imported entries when multiple payrolls are involved. The combined exported entries will give a full picture of all entries processed and any missing reference numbers will indicate a missing employee entry.
Note: the T4 Statement Regeneration and the T4 Amended Statement Process, both allow for the reloading of PA amounts onto the employee’s T4s. That feature facilitates the amending or correcting of PA without the need for recreation of T4s.
Any rejected entries will be listed on a separate error/rejection listing along with the reason for the rejection. Each rejected entry includes a record number of the error. This number refers to the record number of the import file, providing a way for you to identifying the invalid record. This rejection report is listed following the regular report.
The regular import file must contain the following fields:
-
Employee number
-
Employee name
-
Taxation year, override to default entered at run time
-
Income Tax Code for PA Amount, will default to employee's first income tax deduction if empty
-
Employee's PA Amount
The APA import file must contain the following fields:
-
Employee’s SIN
-
Employee’s last name
-
Employee’s first name
-
Employee’s birthdate
-
Employee’s number, may be blank
-
Employee’s APA – Full Amended Pension Adjustment amount for the year
-
Taxation year, override to default entered at run time
-
Reason for change (Amend)
-
Reporting date
This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The export file is generated where the logical SRB$OPSWRK is defined. All fields within the export file have any extra spaces removed from the front and back of the fields and all fields are separated by a comma.
The export file includes the following fields:
-
Payroll ID code
-
Employee’s SIN
-
Employee number
-
Employee name
-
Employee’s status code
-
Import record number for reference
-
Taxation year of PA
-
Income Tax Deduction code
-
Employee’s Original PA amount
-
Employee’s Imported PA amount
-
Employee’s final PA amount
Enter Taxation Year
Enter a 4-digit year to identify the default taxation year to be used when a taxation year is not included on the import record.
Enter Location of File to Be Imported
Enter up to 35 characters of a logical or exact directory location where your import file can be found.
If 'File Upload' was used, select 'File Upload' to locate the file to be imported.
Enter Name of The File to Be Imported
Name will auto populate via the 'File Upload' process.
Fields Tab or Comma Delimited
-
Enter 'C' when the fields in your file are separated by a comma.
-
Enter 'T' when the fields in your file are separated by a tab.
Process Amended PA Format File
-
Enter 'N' to import PA values using the regular PA import file amount.
-
Enter 'Y' to import APA values using the APA Import file format.
Add to Or Override Existing Pa Amounts
-
Enter 'A' to indicate the imported PA Amount should be added to any existing PA record for the same taxation year and income tax deduction.
-
Enter 'O' to override the any existing PA Amount with the import amount.
An employee will have a new PA record created should one not yet exist.
Report Only Or Process
-
Enter 'R' to indicate a report only run. This option only generates the report and error listings. It is recommended that a report only is run first so you are aware of any rejected entries.
-
Enter 'P' for a Process Run. The process will update or create Pension Adjustment entries for the given taxation year.
Sort By Employee Number Or Employee Name
-
Enter 'N' to generate the report in employee name order.
-
Enter 'E' to generate the report in employee number order.
Include Generation of CSV Export File
-
Enter 'Y' to include the generation of the export file.
-
Enter 'N' to omit the generation of the export file.
The report lists the following:
-
Employee number and name
-
Employee's status code if not active. T-Terminated, O-On Leave, B-On Leave With Benefits
-
The physical record number
-
Tax year used
-
Tax deduction number and description
-
Existing PA amount for same year and tax code, when Add was selected
-
PA amount to be added or applied
-
Total of PA record for year and tax code
-
Total number of entries processed
The rejection report lists the following:
-
Employee number or SIN if APA import
-
Employee name
-
The physical record number
-
The PA amount
-
The reason the entry was rejected
-
The total number of rejections