Description
See it in action
Keep holiday and sickness under control in one workbook. Log each absence with its start and end date and the tracker counts working days (excluding weekends and bank holidays), updates every holiday balance, and calculates each person’s Bradford Factor with trigger levels. A colour-coded calendar shows who’s off in any month.
What it does
- Absence log – 600 entries for holidays, sickness, training, appointments and more, with half days
- Holiday balances – entitlement (allowance + carry-over), taken, booked and remaining for every employee
- Bradford Factor – spells² × days for each person, with Monitor / Formal / Final review triggers you set
- Absence calendar – pick any month for a colour-coded view of who’s off, with weekends and bank holidays shaded
- Absence dashboard – holiday taken, sick days, spells, absence by type and by month, and the highest Bradford scores
- Department filter – focus the dashboard on one team
- Protected formulas – calculations are locked and hidden so nothing breaks by accident
Who it’s for
HR teams, line managers and small business owners who need a simple, reliable way to track leave and manage absence fairly.
What’s included
- 1 Excel workbook (.xlsx): How to Use, Dashboard, Calendar, Absence Log, Employees and Settings
- Built-in How to Use guide and sample data you can clear in one step
Requirements
Microsoft Excel 2010 or later, including Excel 2019, 2021 and Microsoft 365 (Windows or Mac). Not designed for Google Sheets.
This is a digital download. No physical item will be shipped. Your file is available to download immediately after purchase.
Reviews
There are no reviews yet.