The auto-enrolment solution for Northern Ireland
The following information is required for the pension contribution upload file:
|Column||Field Content||Data Type (max characters)||Example|
|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)||20/04/2019|
|D||Employer Pension Contribution (including Salary Sacrifice Contribution)||Numeric (5,2)||00000.00|
|E||Employee Pension Contribution||Numeric (5,2)||00000.00|
|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.