← All prebuilt solutions
Payroll & HR

Sickness & Absence Tracker

Record every absence – and see days lost, Bradford scores, SSP, sick pay and the cost to your business

£20

Secure checkout. Your download link is sent as soon as payment clears.

Sickness & Absence Tracker

Overview

Sickness absence is one of the biggest hidden costs in a small business – sick pay, overtime or agency cover, missed orders and pressure on the rest of the team. This tracker turns a simple absence log into everything a manager needs: working days lost for each person based on the days they actually work, the Bradford factor and your own policy triggers, Statutory Sick Pay worked out under the correct rules for each tax year (including the big changes on 6 April 2026), company sick pay by length of service, the cost of every absence, fit notes and return-to-work interviews to chase, and monthly absence rates by department.

Price
£20
Who it’s for
Payroll & HR
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Staff

Everyone whose absence you record, with their working pattern, pay and service. What you do: add starters, record leavers.

Staff
Absence Log

Step 2

Absence Log

Every absence with days lost, SSP, company sick pay, cost, fit note and return-to-work status. What you do: enter the yellow columns for each absence.

Step 3

Employee Summary

Spells, days, Bradford score, stage, triggers, sick pay used, cost and company sick pay left for each person. What you do: nothing to enter – filter or sort to find people.

Employee Summary
Absence Actions

Step 4

Absence Actions

Up to 60 open actions: fit notes needed or expired, return-to-work interviews due or overdue, long-term absences. What you do: nothing to enter – act on it, then update the log.

Who it is for

Made for people like you

  • Example – text
  • Owners and managers – A clear view of who is off, how often and what it costs – and who needs a conversation.
  • HR and payroll staff – SSP and company sick pay for every absence, ready to enter into payroll, with linked periods handled for you.
  • Line managers – A list of fit notes to collect and return-to-work interviews to hold.
  • Directors and accountants – Absence rate and cost trends by month and department for management reports.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter your company name and report date, choose your bank holiday region, then set your absence policy: the rolling period, spells and days triggers, Bradford stages, company sick pay scheme, absence reasons and departments.
  2. Staff – Add everyone: department, line manager, start date, the days they normally work (Y), normal weekly pay and – if different – their average weekly earnings for SSP.
  3. Absence Log – Record each absence: employee, first and last day (leave the last day blank while they're still off), reason, how it's certified, fit note expiry and whether the return-to-work interview has been held.
  4. Absence Actions – Every pay day or week, check the Absence Actions sheet for fit notes to collect and return-to-work interviews to hold.
  5. Employee Summary – Look at Bradford scores, triggers and policy status before deciding whether a conversation is needed.
  6. Dashboard and Monthly Report – Review the absence rate, trends, top reasons and cost each month – and update the report date.

Key features

  • An absence log for up to 3,000 absences that counts working days lost from each person's own working pattern, skipping bank holidays.
  • Bradford factor, spells and days triggers and your own policy stages, with pregnancy and disability-related absence left out of the scores.
  • Statutory Sick Pay worked out for every absence – linked periods of incapacity (8-week rule), waiting days before April 2026, and the April 2026 reforms (paid from day 1, no earnings test, 80% of earnings cap).
  • Company sick pay by length of service with a rolling 12-month entitlement, the top-up over SSP, cover costs and the total cost of absence.
  • Fit note and return-to-work tracking, a monthly absence rate by department, days lost by reason and a one-page dashboard.

What’s included

  • Dashboard – Absence at a glance
  • Settings – Policy, sick pay scheme, reasons, bank holidays
  • Staff – Patterns, pay and service
  • Absence Log – Every absence, SSP and cost
  • Employee Summary – Bradford, triggers, sick pay used
  • Absence Actions – Fit notes, RTW and long-term
  • Monthly Report – Rates by department and reason
  • SSP Rates – Statutory Sick Pay rules by year
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions