How to process National Insurance (NI) savings into an employee's pension scheme in Sage 50 Payroll.
Description
A salary sacrifice pension scheme deducts the pension contribution from the employee's gross pay, before tax or national insurance (NI) are calculated. This means that both you as the employer, and your employee could pay a lower amount of NI with this type of pension scheme.
Some pension providers allow the re-investment of the NI saving for employee and/or employer into the employee's pension scheme.
Resolution
Your software can't calculate this automatically, and you must calculate the contributions and amend this manually each period.
The steps you need to take depend on whether you're reinvesting the employee NI savings only, or both the employee and employer NI savings. Click the option you need below for a breakdown of the steps to follow.
TIP: Ensure you keep clear notes of each value and what it is while you complete the relevant steps below.
- Re-invest employee NI savings only >
Calculate the NI Saving
Your first step is to calculate the NI saving, so you can add it to the normal pension contribution. Note the NI due with their normal pension contribution, and with no pension contribution. The difference between these values is the NI saving you need to add to the employee's pension contribution.
Let's run through that step by step.
- Select the required employee then click Payroll.
- Click Change Process Date, set the pay date you're processing next and click OK.
- Click Enter Payments and check the payments are correct.
- Click the Summary tab.
- Make a note of the Employee's National Insurance value under the Current column.
- Click the Employee button in the top left of Enter Payments to open the employee's record.
- Click the Pension tab then click Manage Schemes.
- Select the relevant pension scheme and click Edit.
- Next to Employee Contributions, take note of the value entered then set it to 0.00.
- Click OK, then Close.
- Click Save, then Close.
- This takes you back to the Summary tab of Enter Payments
- Make a note of the National Insurance value now due. Deduct the value noted in Step 5 from this the value to calculate the Employee NI saving.
- Open the employees record then click the Pension tab.
- Click Manage Schemes, select the relevant scheme and click Edit.
- Set the employee contribution back to the normal amount that you noted in Step 9.
- Click OK, then Close.
- Click Save then Close.
Note the normal pension contributions
Next, note the employee's pension contribution for the period.
- Open Enter Payments and check the payments are correct.
- In the Payments tab, note the Employee pension contribution amount under the heading Salary Sacrifice.
Calculate the contributions including the NI savings
You've now calculated how much Employee NI the employee saves by being on the salary sacrifice pension scheme, and their normal pension contribution.
Add the employee NI saving to the employee contribution. This is the new employee contribution for this period, keep note of this value.
Process the updated contribution
You're now ready to process the contributions including the NI savings.
- Double click the relevant employee.
- Click the Pension tab then Manage Schemes.
- Select the relevant pension scheme and click Edit.
- On the pension details tab, click the drop-down menu and select Fixed Amount for Employee contributions.
- Enter the new contribution amount in the field to the right of Fixed Amount.
- Click OK, then click Close.
- Click Save, then Click Close.
You can now continue to process Payroll as normal.
You must recalculate the NI saving each period that you process this arrangement, to ensure it remains correct.
- Re-invest employee and employer NI savings >
Calculate the NI Saving
To calculate the NI saving, enter the employee's payments then note the employee and employer National Insurance due. Then set the employee pension contribution rate to zero and note the new NI contributions.
The difference between these values is the saving to add to their pension contribution.
Let's run through that step by step.
- Select the required employee then click Payroll.
- Click Change Process Date, set the pay date you're processing next and click OK.
- Click Enter Payments and check the payments are correct.
- Click the Summary tab.
- Make a note of the Employee's National Insurance value under the Current column.
- Click the Employer's button and note the National Insurance (Current) value.
- Click the Employee button in the top left of Enter Payments to open the employee record.
- Click the Pension tab then click Manage Schemes.
- Select the required pension scheme and click Edit.
- Next to Employee Contributions, take note of the value entered then set it to 0.00.
- Click OK, then Close.
- Click Save, then Close.
- This takes you to the Summary tab of Enter Payments
- Make a note of the National Insurance value. Deduct the value you noted in Step 5 from this the value to calculate the Employee NI saving.
- Click the Employer's button and note the National Insurance (Current) value. Deduct the value you noted in Step 6 from this the value to calculate the Employer NI saving.
- Open the employees record then click the Pension tab.
- Click Manage Schemes, select the relevant scheme and click Edit.
- Set the employee contribution back to the correct amount that you noted in step 10.
- Click OK, then Close.
- Click Save then Close.
Note the normal pension contributions
Next, note the actual employee and employer contributions for the period.
- Open Enter Payments and check the payments are correct.
- In the Payments tab, note down the Employee pension contribution amount under the heading Salary Sacrifice.
- Click the Employers button.
TIP: In a salary sacrifice pension scheme, the Pension current value here is the total of both employee and employer contributions. - Deduct the employee contribution you noted in Step 2, from the total contributions you noted in Step 3. This is the employer pension contribution value, take note of this.
Calculate the contributions including the NI savings
You've now noted the value of the employee and employer contributions not including the NI savings. The next step is to combine the two.
- Add the employee NI saving to the employee contribution. This is the new employee contribution, keep note of this value
- Add the employer NI saving to the employer contribution. This is the new employer contribution, keep note of this value
Process the updated contribution
You're now ready to process the contributions including the NI savings.
- Double click the relevant employee.
- Click the Pension tab then Manage Schemes.
- Select the relevant pension scheme and click Edit.
- On the pension details tab, click the Employee Contributions drop-down menu and select Fixed Amount then enter the new total employee contribution.
- Click the Employer Contributions drop-down menu and select Fixed Amount, then enter the new total employer contribution.
- Click OK, then click Close.
- Click Save, then Click Close.
You can now continue to process payroll as normal.
You must recalculate the NI saving each period that you process this arrangement, to ensure it remains correct.
- Re-invest employer NI savings only >
Calculate the NI Saving
To calculate the NI saving, enter the employee's payments then note the employee and employer National Insurance due. Then set the employee pension contribution rate to zero and note the new NI contributions.
The difference between these values is the saving to add to their pension contribution.
Let's run through that step by step.
- Select the required employee then click Payroll.
- Click Change Process Date, set the pay date you're processing next and click OK.
- Click Enter Payments and check the payments are correct.
- Click the Employer's button and note the National Insurance (Current) value.
- Click the Employee button in the top left of Enter Payments to open the employee record.
- Click the Pension tab then click Manage Schemes.
- Select the required pension scheme and click Edit.
- Next to Employee Contributions, take note of the value entered then set it to 0.00.
- Click OK, then Close.
- Click Save, then Close.
- This takes you back to Enter Payments
- Click the Employer's button and note the National Insurance (Current) value. Deduct the value you noted in Step 4 from this the value to calculate the Employer NI saving.
- Open the employees record then click the Pension tab.
- Click Manage Schemes, select the relevant scheme and click Edit.
- Set the employee contribution back to the correct amount that you noted in step 8.
- Click OK, then Close.
- Click Save then Close.
Note the normal employer pension contribution
Next, note the employer contribution for the period without the NI saving.
- Open Enter Payments and check the payments are correct.
- In the Payments tab, note down the Employee pension contribution amount under the heading Salary Sacrifice.
- Click the Employers button.
TIP: In a salary sacrifice pension scheme, the Pension current value here is the total of both employee and employer contributions. - Deduct the employee contribution you noted in Step 2, from the total contributions you noted in Step 3. This is the employer pension contribution value, take note of this.
Calculate the contributions including the NI savings
You've now noted the value of the employer contributions not including the NI savings. The next step is to combine the two.
- Add the employer NI saving to the employer contribution. This is the new employer contribution, keep note of this value
Process the updated contribution
You're now ready to process the contributions including the NI savings.
- Double click the relevant employee.
- Click the Pension tab then Manage Schemes.
- Select the relevant pension scheme and click Edit.
- On the pension details tab, click the Employer Contributions drop-down menu and select Fixed Amount, then enter the new total employer contribution.
- Click OK, then click Close.
- Click Save, then Click Close.
You can now continue to process payroll as normal.
You must recalculate the NI saving each period that you process this arrangement, to ensure it remains correct.
Example
If you'd like to see how this may look for an employee, you can view an example of the calculation >
Let's look at an example where both the employee NI and employer NI savings are reinvested into the employee's pension scheme.
In this example:
- The employee's gross pay is £2000, with 5% employee pension contribution and 3% employer contribution
- The employee's normal pension contribution for the period is £100, and the employer pension contribution is £60
- With the salary sacrifice pension contribution deducted, the employee's NI is £102.24, and the employers NI is £157.60
- With no salary sacrifice pension contribution, the employee's NI is £114.24, and the employers NI is £171.40
Calculate NI saving
First, calculate how much NI the employee saves due to their salary sacrifice pension scheme.
Employee NI:
£114.24 - £102.24 = £12.00 saving.
Employer NI:
£171.40 - £157.60 = £13.80 saving.
Calculate new pension contribution
Next, calculate the new pension contributions including the NI savings:
Employee contribution £100 + Employee NI saving £12.00 = £112.00 total employee contribution this period including NI savings.
Employer contribution £60 + Employer NI saving £13.80 = £73.80 total employer contribution this period including NI savings.
In this example, the contributions to process in this pay run are £112.00 employee contribution, and £73.80 contribution.