Download the manual calculator for Annual Leave and Bank Holidays below to work out your annual leave entitlement.
You can read the quick guide to using the calculator below, and don't forget to read the full Annual Leave and Bank Holiday policy.
Barnardo's colleagues, TUPE colleagues, and As-and-when colleagues can use this tool. Colleagues with access to the HR and Finance system, Dynamics 365, should use Dynamics 365 to calculate entitlements, but can use this tool if there are any technical problems.
How to use the Annual Leave and Bank Holiday calculator
- The first worksheet (tab) is for full time employees and the second tab is for part time employees and those working compressed hours.
- For part time/compressed hours employees, a days leave must be deducted from the total at the number of hours normally worked on that particular day (e.g. if they work 9 hrs Tues and 3 hrs Thurs then leave is to be taken at same hourly rates, not an average of the total weekly hours).
- Similarly, the hours for any bank holiday falling on a working day need to be deducted from the total entitlement at the same rate as normally worked on that day.
- When calculating bank holiday entitlement for part year, only enter number of bank holidays that actually fall during that period.
- When calculating annual leave/bank holiday entitlement for a new starter, the ‘part year’ section of the spreadsheet should be used. The employee’s start date should be entered as the leave year start date and this will calculate annual leave/bank holiday entitlement for the remainder of the leave year.
- When calculating annual leave/bank holiday entitlement for an employee who is leaving, the ‘part year’ section of the spreadsheet should be used. By entering the end date as the day after the employees leaving date this will calculate annual leave/bank holiday entitlement according to the number of completed days worked during the leave year. For example, a leaving date of 30 Nov should be entered as end date of 1 Dec. Any entitlement already taken during the leave year would then need to be deducted. A positive or negative balance will represent the amount of pro-rated annual leave/bank holiday entitlement owing to the employee/Barnardo’s respectively.