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.