Free holiday tracker
Keep your team’s holiday balances clear. Record allowances, days taken and future bookings, then see what remains.
- Free, no account
- Stays in your browser
What is a holiday tracker?
A holiday tracker records each person’s allowance, days taken and future bookings so their remaining balance is easy to review. Use it as a local record of agreed figures for one reporting period. Unlike the Leave Planner, it works with day totals rather than dated absences. It does not determine statutory entitlements or verify requests.
| Figure | Purpose | Example |
|---|---|---|
| Opening allowance | The agreed allowance for this period, entered by you. | 25 days, before carry-over and adjustments. |
| Carry-over and adjustment | Add carried days and agreed positive or negative corrections. | 2 carried days and a −1-day correction. |
| Taken and booked | Keep used days separate from future bookings. | 10 days taken and 5 future days booked. |
| Unallocated balance | See what remains after both taken and booked days. | 25 + 2 − 1 − 10 − 5 = 11 days. |
Keep leave balances connected to requests
See who's away and approve requests on one calendar. Your spreadsheets can take some time off too.
Time off · November
Design and product · 6 peopleHow to track team holidays
- 1Set the reporting periodName the tracker and enter the dates covered by your figures. Use the same period for everyone.
- 2Record the agreed day figuresEnter one row per person, with allowance, carry-over, adjustments, days taken and future bookings. Leave unknown figures blank.
- 3Check and share the balancesReview missing and negative balances, then copy, download or print the tracker. Update your HR records separately.
Keep holiday balances reliable
- Agree the opening figuresUse the allowance agreed for each person and this period. Do not include carry-over twice.
- Separate taken from bookedWhen booked leave is taken, move the same amount from booked to taken. Leaving it in both would deduct it twice.
- Keep unknown values visibleLeave allowance, taken or booked blank if you have not checked the figure. Enter 0 when you have confirmed there are none.
- Review negative balancesA negative result can reflect excess bookings, adjustments or a recording error. Check the figures before making a decision.
- Review period changes manuallyChanging dates keeps all entered figures. Review new allowances, carry-over and expiry rules yourself, then export a backup.
Free tools for your business
Holiday tracker questions
Is this holiday tracker free?
Yes. Record balances, copy or download text and print to PDF without an account or payment. The draft stays in this browser on this device.
How is the remaining holiday balance calculated?
Opening allowance plus carry-over plus adjustment gives available days. Subtract days taken, then subtract future days booked to get unallocated days. Booked days must exclude days already taken.
What happens when a figure is blank?
Blank opening allowance, taken or booked days stay unknown; the affected balance is unavailable. Blank carry-over and adjustments assume zero, stated in the output. Enter explicit 0 for a known zero. Team totals require every relevant figure.
Can I use half days or negative adjustments?
Yes. Enter up to two decimal places with a point or comma, such as 0.5 or 0,5. Adjustments can be positive or negative. Other day figures must be zero or positive. Thousands separators are not accepted.
Can I export a tracker with missing figures?
Yes, when the tracker name, reporting dates and person references are valid. Unknown figures and unavailable balances remain clearly labelled in the preview and exports. Invalid values or duplicate person references must be corrected first.
Will language or reporting-period changes overwrite my figures?
No. Text, figures, dates and row order survive reloads and language changes. Changing the period never resets the rows. Clearing examples preserves edited fields; clearing and removal offer Undo until the next edit.
Does this calculate legal entitlement or approve holiday?
No. Enter agreed figures yourself. The tracker does not calculate statutory allowances, accrual, pro-rata entitlement, carry-over expiry or pay, and it does not approve leave. Use your organisation’s HR process for those decisions.
Have a question? Talk to us.
Keep leave requests and balances together
Manage your team’s time off with Skileo Human Resources.
No credit card needed ✦ No time limit on the Free plan.
Cookies
We use Google Analytics cookies to see how this site is used, so we can improve it. Cookie policy