01
Works out SSP due for each absence
£123.25 a week or 80% of AWE if lower, paid on qualifying days, rounded up to the penny the way HMRC tables do
For UK employers, payroll & HR, 2026 SSP rules
7 reasons to stop doing Statutory Sick Pay on a calculator
Someone is off sick again, it is payday, and you are not sure whether this absence links to the last one, how many of their 28 weeks are left, or how much SSP to put on the payslip. This calculator answers all three.
- Excel & Google Sheets, no macros
- Example + blank file
- Start-here guide
- One-off price, no subscription
Screens from the included example file. All names and figures are fictional.
£123.25a week, or 80% of AWE if lower
56days: linked absences found for you
28week count carried across spells
0macros, add-ons or subscriptions
The list
Why a ready-made calculator beats paper and a blank spreadsheet
02
Links absences 8 weeks (56 days) or less apart and carries the 28-week count across them
(the case GOV.UK's own calculator leaves to you)
Get the calculator · £10.99 Instant download · Excel & Google Sheets
03
Counts qualifying days from each employee's normal working pattern
Flags absences of more than 7 days without a fit note, and when SSP runs out
(give form SSP1)
AWE Calculator for weekly
Fortnightly, four-weekly and monthly pay, plus new starters
Printable Employee SSP Record, SSP Daily Rates table and a Dashboard
With SSP by month, days lost by reason and a "What needs your attention" list
Start Here tab with a 3-step plan and a health check
Get the calculator · £10.99 Instant download · stuck? Email us for help
Compare
Three ways to keep these records
| Feature | Paper or notes | A blank spreadsheet | This calculator |
|---|---|---|---|
| Works out SSP due for each absence | ✗No | ~ If you build it | ✓ Built in |
| AWE Calculator for weekly | ✗No | ~ If you build it | ✓ Built in |
| Start Here tab with a 3-step plan and a health check | ✗No | ~ If you build it | ✓ Built in |
| Cost | Free, plus your time | Free, plus your time | £10.99 once |
What's inside
Everything you download
3 files
- XLSX UK-SSP-Calculator.xlsxfilled with fictional example data (15 employees, 20 absences) so you can see how it works
- XLSX UK-SSP-Calculator-BLANK.xlsxan empty copy, ready for your own team
- PDF Start-here.pdfone-page quick-start guide, including how to open it in Google Sheets
Good to know
- A Health check on the Start Here tab and a Check/Status column on every log flag missing or odd entries
- Dates show as DD/MM/YYYY
Is it right for you?
Made for some, honestly not for others
A good fit if you…
- UK employers, payroll clerks and HR teams under the Statutory Sick Pay rules that started on 6 April 2026: SSP from the first qualifying day, no lower earnings limit, and £123.25 a week or 80% of average weekly earnings, whichever is lower
- use Excel or Google Sheets on a computer
- want to pay once, not another subscription
Not for you if you…
- need Apple Numbers or mobile-only editing
- want someone to do the records for you
How it works
Three steps to get going
- 1
Set up once
Business name and tax year on Settings (2026/27 rates are filled in)
- 2
Add your employees
Working days and average weekly earnings
- 3
Log each absence
First and last day off and the reason. Check the Dashboard each payday
Microsoft Excel2010 or newer (Windows & Mac) and Microsoft 365
Google SheetsFree Google account. Upload the .xlsx, then set the locale to United Kingdom
0
No macrosNothing to enable, no add-ons or subscriptions. Not designed for Apple Numbers or mobile-only editing. A computer is recommended
- Instant download
- Example + blank file
- Start-here guide
The offer
Pro UK SSP Calculator
£10.99one-off · no subscription
- Filled with fictional example data (15 employees, 20 absences) (UK-SSP-Calculator.xlsx)
- An empty copy, ready for your own team (UK-SSP-Calculator-BLANK.xlsx)
- One-page quick-start guide, including how to open it in Google Sheets (Start-here.pdf)
- Licensed for use within one business or household
Price includes VAT where applicable — calculated at checkout. Secure checkout by Payhip.
Questions? Email info@phkmedia.co.uk
Stuck after you buy? We'll help you set it up.
Digital download, nothing is posted. This calculator is a record-keeping and calculation aid, not payroll, tax or legal advice. Terms & licence.
FAQ
Questions people ask
Does it run payroll or send anything to HMRC?
No. It works out the SSP figure and keeps the record; you pay it through your payroll.
Does it cover company (occupational) sick pay?
No, statutory sick pay only.
Can several people use it?
Yes, in Google Sheets you can share it with your team.
What happens after I pay?
This is a digital product. Nothing physical will be shipped. Your download link appears straight after checkout and is also emailed to you.
Can I get help if I'm stuck?
Yes. Message us at info@phkmedia.co.uk and we'll help you set it up.