-
Excel workbook preview
Onboarding, Probation and Offboarding
Final Pay and Leaving Entitlements Calculator (notice and accrued holiday)
3 downloads per free account, no card needed.
Who this is for
A payroll or HR administrator running a leaver's final pay this week who must get the notice and holiday figures right and explain them if challenged.
What is inside
- 10 sample leavers (7 UK, 3 US) plus 16 blank rows, one row per leaver
- UK statutory minimum notice from ERA 1996 s.86 at the notice date, compared with the contract (amber when the law is longer)
- Leave year elapsed from the later of start date and leave year start, accrued and balance in days
- Holiday pay or overtaken amount from a day rate (salary / 52 / days per week), negatives in red
- Action column: pay in final pay, or recover overtaken leave only if agreed in writing beforehand (UK)
- Rules tab with 8 rules and their sources, including US final pay and PTO payout under state law
How to use it: Enter one row per leaver, check the Action column and have a second person in payroll check the figures before final pay is run.
Files & formats
- XLSXfinal-pay-leaving-entitlements-calculator.xlsx16 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves. These templates are original working documents built on the public law or guidance named here. They are not legal advice and are not endorsed by the government body or publisher.



