The auto-enrolment solution for Northern Ireland

What is the pension contribution upload file format?

The upload file format for the WPT-E plan is not affected by changes in October 2020.

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 Credit Week Date Date (dd/mm/yyyy) 06/08/2018
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 Additional Voluntary Contributions (AVC) Numeric (5,2) 00000.00
H Death Benefit 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 weekly paid 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 employees do not contribute Additional Voluntary Contributions, then leave that column blank.