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 (100) Peter Wilson
C Contribution Date Date (dd/mm/yyyy) 16/06/2014
D Employer Pension Contribution (including Salary Sacrifice Contribution) Numeric (5,2) 00000.00
E Employee Pension Contribution Numeric (5,2) 00000.00
F Blank Blank  
G Group Life Assurance (if appropriate) Numeric (5,2) 00000.00

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 D.  Column E should be blank. Column F should have zeroes.

Example

Contribution file format if using Group Life Assurance

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

Example