The auto-enrolment solution for Northern Ireland

What is the pension contribution upload file format for salary sacrifice?

The following information is required for the pension contribution upload file:

Column Field Content Data Type (max characters) Example
A NINO Alphanumeric (9) XX111111X
B Employee Name (this field will not be validated and is purely for information purposes) Alphanumeric (200) Peter Wilson
C Date PRP Start Date (dd/MM/yyyy) 01/10/2020
D Date PRP End Date (dd/MM/yyyy) 31/10/2020
E Salary for PRP Numeric (5,2) 1400.00
F Employer Pension Contribution (including Salary Sacrifice Contribution) Numeric (5,2) 70.40
G Employee Pension Contribution Blank  
H Group Life Assurance (if appropriate) Numeric (5,2) 00000.00
I Employer Lump Sum Numeric (5,2) 00000.00
J Employee Lump Sum Numeric (5,2) 00000.00
K Use PRP Boolean Yes/No

NB When saving the .csv file for upload there should be no titles or totals.

If your company uses Salary Sacrifice instead of employee contributions, all contributions should be entered into column F.  Column G should be blank.

This information should be extracted from your payroll software. Please refer to your payroll software guidance for information on how to do this.

Once extracted, the information should be arranged in the same column order as in the table above.

  • PRP: This refers to the Payment Reference Period. For example, employees may be paid weekly, monthly, four weekly or fortnightly.
    • Date PRP Start – the date on which the relative contribution period started.
    • Date PRP End – the date on which the relative contribution period ends.
    • Salary for PRP – gross earnings for the contribution period before salary thresholds are applied.
  • Employer and Employee Lump Sum: If the employer or the employee would like to make an additional payment into the fund, enter the value into the corresponding column. This is not validated but cannot be a negative value. This can also be used if extra amounts need to be paid in for previous periods.
  • Use PRP: This field will normally be left blank. It is only required if the PRP (Payment Reference Period) is different from the normal payment frequency.
    • If you normally pay staff weekly but at Christmas you combine 3 weeks together, you should select Yes so that the validation allows for the unusual 3 week period.
    • If an employee is normally paid monthly but they have only worked a portion of this month (new start, leaver) you may want to treat this as a full month for the pension calculation. In this situation select No so that the normal payment frequency is used for the validation.

Example

Contribution file format if using Group Life Assurance

If your company also uses Group Life Assurance, column F should be completed as appropriate, column G should be blank and column H should be completed with the premium amounts.

Example