The auto-enrolment solution for Northern Ireland

How do I complete an annual update of salaries and pension contribution levels?

Each year all WPT employers are required to confirm that the salary and contribution levels recorded by the Scheme are correct.

This information is required because both the member's salary and employer and employee pension percentages are used by the Scheme:

1.   to monitor the contributions received on behalf of each member, and

2.   to prepare the member's Annual Benefit Statement

When employees were first added to the Scheme, we asked you to provide their normal salary or average wage and the employer and employee percentages.

On an annual basis, we will ask you to confirm:

  • The actual earnings received for each member during the last tax year for the pay frequency used, eg average weekly salary if weekly paid, and
  • The current employer and employee pension contribution percentages

This information is uploaded through your online account.

How do I update the salaries and pension contributions?

Select the Account Login option at the top right hand corner of the screen.

Enter your username and password in the Existing Users section.

Select Confirm or update salaries on your My Profile page, then select the relevant option:

  • Upload file - If the salary information or pension contribution percentages need to be updated for a number of employees, please upload a file. The format of the file is shown below.
  • No change required - Please select this option if the salary information and pension contribution percentage recorded for all employees are correct.

How can I check what information is currently held for my employees?

You can download a report to check the current salary information and pension contribution percentages by clicking on the link provided and exporting to Excel.

You can use the downloaded report file as a template to change the details if required.  Before you upload the file, you should delete Row 1 (containing the headings - do not leave a blank row) and save the file in .csv (Comma Delimited) format.

You do not need to update all employees at the same time so after uploading a file you can either confirm that all changes are complete or you can choose to upload another file at another time.

When all updates have been confirmed as complete, the option to make changes in this way will no longer be available on your home page.

Upload file format

The following information is required for the annual update upload file:

Column Field Content Data Type (max characters) Example
A* NINO Alphanumeric (9) XZ140548D
B* Employee name (this field will not be validated and is purely for information purposes) Alphanumeric (50) Gary White
C* Effective date Date (dd/MM/yyyy) 16/06/2017
D* Payment frequency Char (2) W = Weekly
M = Monthly
FN = Fortnightly
FW = Four Weekly
E* Salary per payment frequency Numeric (5,2) 1250.45 (no commas)
F* Employer pension contribution level (including Salary Sacrifice Contribution, if used) (%)3   3.00
G* Employer pension contribution calculation basis Char (1) P = First Pound
B = Qualifying Earnings
H Employee pension contribution level (%) (if applicable) Numeric (5,2) 5.00
I Employee pension contribution calculation basis Char (1) P = First Pound
B = Qualifying Earnings
J Blank Blank Blank
K Blank Blank Blank
L Group Life Assurance (£) (if applicable) Numeric (5,2) 1.00
M Group Life Assurance calculation basis Char (1) F = Fixed value
N* Employer code Alphanumeric (8) 100000/2

Columns marked with an * are required otherwise they can be left blank.

If your company uses Group Life Assurance, columns L and M should be completed with the premium amount and calculation basis.

What effective date should I use?

If your employee earns a fixed salary then the effective date should be the date that the last increase was applied or their start date with the Scheme.

My employees do not have a regular wage. What should I do?

The salary provided should be an average of the gross salary used for pension purposes over the previous tax year. If the employee's salary is variable, the effective date entered should be 06/04/2019 unless the employee joined the Scheme after this date.