Redundancy Calculator UK 2026 – Calculate Payments For Hundreds of Staff In One Go

Excel-based Redundancy Calculator UK 2026

Input staff data into this Excel-based Redundancy Calculator UK and it will instantly calculate the statutory redundancy payments for multiple staff, based on their weekly pay, age, and length of service. This spreadsheet has been used by companies such as P&O Ferries, Coventry University, and Go South Coast Buses. Incorporates 2025/2026 weekly and total payout statutory caps.

Demo

Features

🌟 Calculates the 2026 statutory redundancy payment for UK staff (furloughed and non-furloughed), based on age categories (under 22, 22-40, 41 and over), weekly pay, and years of service.

🚀 Automatically computes redundancy pay for 1 or hundreds of staff, as needed.

💰 Provides a capped redundancy payment figure, accounting for the statutory weekly cap and the total payout cap.

⏱️ Automatically considers the 2-year qualifying period for redundancy eligibility.

📊 Includes up-to-date statutory payment caps for weekly (£719) and total payout (£21,570) applicable for the year 2025/2026.

Previous customers

1.P&O Ferries
2.Go South Coast Buses
3.Coventry University
4.Rainbow Casinos
5.H E Simm Group

Instructions:

• Getting Started:
  • Download the UK Statutory Redundancy Pay Calculator 2026 Excel template.
  • Save an extra copy of the file for backup purposes.
• Preparing Your Data Ready for Import:
  • Organize your data file with the following headings: Name, Date of Birth, Age in Years, Annual Pay, Employee Start Date, Date of Redundancy, and Location (UK or Northern Ireland).
• Importing Your Data:
  • If your data file layout exactly matches the redundancy calculator input fields, cut and paste your data into the calculator.
  • Only enter data into the green input cells.
• Statutory Redundancy Payment Calculations:
  • Column P represents the weekly statutory redundancy pay entitlement.
  • Column Q displays the Final UK Statutory Redundancy Payment.

Screenshot

Disclaimer: While thecareercafe.co.uk has taken every precaution to ensure the correctness of the analytical calculations used in our 2026 UK Statutory Redundancy Pay Excel Calculator Tool, we do not guarantee the results will be error-free.