Salary sacrifice calculator (Excel) for UK employers
See what an employee and the employer save when pension contributions go through salary sacrifice, now and once the £2,000 National Insurance cap starts in April 2029. This salary sacrifice calculator is one Excel workbook with a sheet for one employee, a sheet for the whole team and the 2026/27 rates.
UK practicesGet this pack and 109 more for $99
What the calculator looks like

When you need it
Salary sacrifice is an agreement to reduce an employee's cash pay in return for a non-cash benefit, such as a pension contribution. Income tax is the same as under a net pay arrangement, so the saving is National Insurance: 8% for the employee (2% above the upper earnings limit) and 15% for the employer in 2026/27. Use the calculator when:
- An employer is deciding whether to offer pension salary sacrifice
- You need to show staff what they would take home before they sign
- The employer wants to pass some of its National Insurance saving into employees' pensions
- You are planning for the £2,000 cap on National Insurance-free pension sacrifice from April 2029
- A lower-paid employee wants to join and you need to check their pay stays above the minimum wage
How to use the salary sacrifice calculator
- Delete the examples. Rows marked [Example] on the Team sheet show how it works. Clear them before you enter real staff.
- Run one employee on Calculator. Enter the salary, pick England, Wales or NI, or Scotland, and enter the contribution given up. Set the share of the employer's saving that goes into the pension.
- Read the three columns. Compare take-home pay, National Insurance and the pension total now and from April 2029. The Check cell shows OK when the inputs make sense.
- Add the team. One row per employee on Team, with salary, sacrifice, weekly hours and minimum wage band. The totals give the employer's yearly saving.
- Keep the rates current. The Rates sheet holds the 2026/27 figures. Type the new ones in when they change.
Questions
How much does salary sacrifice save?
On a pension contribution, the National Insurance on the amount given up. For an employee on £40,000 who sacrifices £2,000 a year, that is £160 for the employee at 8% and £300 for the employer at 15%, at 2026/27 rates.
Does salary sacrifice reduce income tax?
Not compared with paying the same contribution through a net pay arrangement, where it already comes out before tax. The extra saving from salary sacrifice is National Insurance, for both the employee and the employer.
What changes for salary sacrifice in April 2029?
From April 2029, only the first £2,000 a year of employee pension contributions through salary sacrifice is free of National Insurance. Employer and employee National Insurance are due above that. Income tax relief stays, and employer pension contributions stay free of National Insurance.
Can salary sacrifice take pay below the minimum wage?
No. A salary sacrifice arrangement must not reduce an employee's cash earnings below the National Minimum Wage. The Team sheet flags anyone it would push below their rate.
Does the calculator work for Scottish taxpayers?
Yes. Pick Scotland and it uses the six Scottish income tax bands, from 19% to 48%. National Insurance is the same across the UK.
Does salary sacrifice affect statutory pay?
It can. Statutory pay such as maternity or sick pay is based on earnings, so a lower salary can reduce it, and some employees can lose the entitlement altogether.
Also in the salary sacrifice pack
Who it's for
UK practices that advise employer clients or run their payroll, and employers setting up or reviewing pension salary sacrifice.
Last checked
Checked against HMRC's 2026/27 rates and thresholds for employers, its salary sacrifice guidance and the April 2029 pension salary sacrifice changes in November 2026.
