Excel-Based Severance Package Calculator UK 2026
Excel-Based Severance Package Calculator UK 2026
Effortlessly calculate comprehensive severance packages with this user-friendly Excel-based tool, designed specifically for UK businesses. Whether you’re handling redundancy for one employee or hundreds, this calculator ensures accuracy, compliance, and clarity by covering all key components of a severance package:
1️⃣ Statutory Redundancy Payments
2️⃣ Unused Holiday Reimbursement (taxable)
3️⃣ Payment in Lieu of Notice (taxable)
This calculator has been trusted by organisations such s P&O Ferries, Coventry University, and Go South Coast Buses. to handle severance package calculations with confidence.
Video Demo
Features
🌟 Statutory Redundancy Payments
Automatically calculates redundancy pay based on the employee’s age categories (under 22, 22–40, 41 and over), weekly pay, and years of service, ensuring compliance with the 2025/226 statutory redundancy payment caps and rules.
🏖️ Unused Holiday Reimbursement
Quickly determines holiday pay owed to employees for untaken statutory holiday entitlement up to their leaving date. This component is taxable and seamlessly integrates with other payout calculations.
📅 Payment in Lieu of Notice (PILON)
Accurately computes the payment owed to employees for notice periods not worked. Payment in lieu of notice is also subject to tax and National Insurance contributions.
🚀 Scalable and Flexible
Designed to handle calculations for a single employee or hundreds of staff members at once, saving time while reducing errors.
💰 Comprehensive Severance Breakdown
Provides an itemised breakdown of each employee’s total severance package, clearly separating statutory redundancy payments, unused holiday reimbursement, and PILON.
📊 Up-to-Date Statutory Rules
Reflects the most recent statutory redundancy rates and tax regulations for the 2025/2026 financial year.
Previous Customers
1.P&O Ferries
2.Go South Coast Buses
3.Coventry University
4.Rainbow Casinos
5.H E Simm Group
Screenshot
Instructions
Getting Started:
- Download the UK Severance Package Calculator 2026 Excel template.
- Save a backup copy for your records.
Input Employee Data:
- Refer to the “Instructions” sheet for a detailed guide.
- Organise your data with the following headings: Name, Date of Birth, Weekly Pay, Years of Service, Annual Salary, Last Day Worked, and Notice Period (in weeks).
- Copy and paste your data into the input fields or use Excel’s import tool to populate the spreadsheet.
Calculation Parameters:
- Statutory redundancy payments are calculated automatically based on age and service, reflecting statutory weekly caps.
- Holiday reimbursement is prorated based on unused statutory entitlement.
- Payment in lieu of notice is determined by weekly pay and the notice period owed.
Outputs:
The final severance package includes:
- Total statutory redundancy pay (non-taxable within limits).
- Taxable holiday reimbursement.
- Taxable payment in lieu of notice.
Excel-Based Severance Package Calculator UK 2026
Effortlessly calculate comprehensive severance packages with this user-friendly Excel-based tool, designed specifically for UK businesses. Whether you’re handling redundancy for one employee or hundreds, this calculator ensures accuracy, compliance, and clarity by covering all key components of a severance package:
1️⃣ Statutory Redundancy Payments
2️⃣ Unused Holiday Reimbursement (taxable)
3️⃣ Payment in Lieu of Notice (taxable)
This calculator has been trusted by organisations such s P&O Ferries, Coventry University, and Go South Coast Buses. to handle severance package calculations with confidence.
