Accountio / Templates / Salary sacrifice / Salary sacrifice calculator

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 practices
$15
In the pack
Salary sacrifice pack
Files
4, Word and Excel
Buy the pack · $15
Global library · 110 packs

Get this pack and 109 more for $99

Salary sacrifice · this packAML complianceCharity accountsEstate administrationMTD for Income TaxP11D and payrollingUK SRS readinessReference lettersCarbon reduction plan+ 101 more

What the calculator looks like

Salary sacrifice calculator template
What the calculator coversSheet or row in the calculator
One employee's figures
✓
CalculatorSalary, where they pay income tax, the contribution given up and the share of the employer's saving paid into the pension
Three columns side by side
✓
Without salary sacrifice, With salary sacrifice now, With salary sacrifice from April 2029The same employee before and after, and under the 2029 cap
Tax and National Insurance
✓
Income tax, Employee National Insurance, Employer National InsuranceWorked out for each column, with the personal allowance taper above £100,000
What each side gains
✓
Take-home pay, Employee better off by, Employer better off byAfter any share of the employer's saving goes into the pension
What goes into the pension
✓
Total paid into the pensionThe sacrifice plus the employer's National Insurance saving you choose to pass on
Input errors flagged
✓
CheckFor example a sacrifice larger than the salary, or a share over 100%
The whole team, one row each
✓
TeamUp to 100 employees, with employee and employer National Insurance savings now and from April 2029, and totals
Pay kept above the minimum wage
✓
Team: Pay per hour after sacrifice, CheckFlags anyone whose hourly pay would fall below their minimum wage band
The rates behind it
✓
Rates2026/27 National Insurance thresholds and rates, personal allowance, minimum wage rates, and income tax bands for Scotland and the rest of the UK

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

  1. Delete the examples. Rows marked [Example] on the Team sheet show how it works. Clear them before you enter real staff.
  2. 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.
  3. 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.
  4. 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.
  5. 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

Salary sacrifice policyEmployee salary sacrifice agreement

See the whole 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.