Leave Settlement Calculator (Demo)

Demo version: names, dates and hours are fictional, and the Bonus Leave rules are an example policy.

LOAD EXAMPLE

EMPLOYEE Name

Start Date Resignation Date

LEAVE OF ABSENCE (NOT COUNTED TOWARD SENIORITY) Only enter Leave of Absence that does not count toward seniority by law, such as leave for personal reasons. Do not enter Leave of Absence that the law requires to count toward seniority, such as parental leave or military service. Leave blank if there is none.

Period 1 Start End

Period 2 Start End

DEFERRED LEAVE CARRIED IN (HOURS) Hours carried over from the previous year. Enter the full amount carried in, without subtracting anything used this year. Leave blank if there is none. Statutory Leave (deferred) Bonus Leave (deferred)

USED THIS YEAR (HOURS) Enter the hours used for each leave type as shown in the HR system. The current year is the year of the resignation date, currently 2026. For a resignation in 2027, for example, enter the (2027) hours. Statutory Leave (current year) Statutory Leave (deferred) Bonus Leave (current year) Bonus Leave (deferred) Data as of

ADVANCED Hours per day Statutory Leave granted at start of year (days)Optional. Leave blank to calculate on the calendar-year basis. If the HR system granted a different amount, enter the actual figure. Bonus Leave granted at start of year (days)Optional. Leave blank to calculate from the seniority rules.