Enter Annual Leave Inputs
Example Data Table
| Scenario | Entitlement | FTE | Carryover | Used | Planned | Projected Balance |
|---|---|---|---|---|---|---|
| Full-time standard policy | 24 days | 1.00 | 3 days | 5 days | 2 days | 20 days |
| Part-time employee | 24 days | 0.60 | 1 day | 3 days | 1 day | 11.4 days |
| Mid-year joiner | 24 days | 1.00 | 0 days | 2 days | 1 day | 9 days |
Formula Used
Base Entitlement = Annual Entitlement × FTE Ratio × Employment Year Ratio
Adjusted Entitlement = Base Entitlement + Bonus Leave + Purchased Leave − Unpaid Leave Adjustment
Carryover Applied = Lesser of Carried Over Leave and Carryover Cap
Accrued Leave = (Adjusted Entitlement + Allowed Carryover) × Service Ratio
Remaining Balance = Accrued Leave − Used Leave − Planned Leave
Balance Hours = Remaining Balance × Hours per Day
Daily Leave Value = Weekly Salary ÷ Workdays per Week
Estimated Balance Value = Positive Remaining Balance × Daily Leave Value
The tool also supports monthly and semi-monthly accrual models for policy testing.
How to Use This Calculator
- Enter the leave year dates and the date you want to measure.
- Add the employee start date to pro-rate entitlement correctly.
- Input annual entitlement, carryover, and any bonus or purchased leave.
- Enter leave already taken, future approved leave, and unpaid leave adjustments.
- Set FTE ratio, work schedule, and hours per day.
- Choose the salary basis to estimate leave payout value.
- Select the accrual method and rounding rule used by your policy.
- Press the calculate button to show the result summary above the form.
- Use the CSV and PDF buttons to export the displayed results.
FAQs
1. What does this annual leave calculator estimate?
It estimates accrued leave, remaining balance, projected year-end balance, hours available, carryover status, and approximate payout value using your policy inputs.
2. Can it handle part-time employees?
Yes. Use the FTE ratio field to reduce entitlement proportionally. For example, 0.50 represents half-time work and halves the base allocation.
3. How is carryover applied?
The tool compares carried-over leave with your cap and only applies the lower amount when calculating the available balance.
4. What is the difference between used and planned leave?
Used leave reduces the current balance based on time already taken. Planned leave helps forecast future availability and year-end exposure.
5. Which accrual method should I choose?
Choose daily pro rata for precise service-based accrual, monthly for standard monthly policies, or semi-monthly for twice-per-month accrual structures.
6. How is leave payout value estimated?
The calculator converts annual, monthly, or weekly salary into a daily rate using workdays per week, then multiplies that by the positive balance.
7. Does this replace HR policy or payroll advice?
No. It is a planning tool. Always confirm final balances, legal requirements, and payout rules against your company policy and local labor law.
8. Can I export the results?
Yes. After calculating, use the CSV button for spreadsheet-friendly output or the PDF button for a shareable summary document.