The auto-enrolment solution for Northern Ireland

What is the pension contribution upload file format?

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 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 applicable) Numeric (5,2) 00000.00

Example - weekly paid employees

Example - monthly paid employees

NB When saving the .csv file for upload there should be no titles or totals.  If employees are paid weekly, then each week's contributions should be shown (see example above).

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. (Please see What is the pension contribution upload file format for salary sacrifice? if you use Salary Sacrifice.)

If there is no information to be entered in a column, eg the company does not use Group Life Assurance, then leave that column blank.

Contribution file format if using Group Life Assurance

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

Example