Free tool · Human resources

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

Track holiday balances

Start with marked examples. Enter your own agreed figures; this tracker does not determine anyone’s entitlement.
1
Tracker and reporting periodUse one reporting period for all figures. Changing dates never clears or recalculates your entered allowances.
For example, the team and leave year.
Optional context for this tracker.
Who checks these figures with the team?
Use the first date covered by the figures.
Use the last date covered by the figures. Dates are labels, not a calculation rule.

Reporting dates label this tracker only. They do not calculate accrual, pro-rata allowances, public holidays or carry-over expiry.

2
People and day balancesUse one row per person. Enter days, including fractions such as 0.5.

Allowance, taken and booked may be left blank when unknown; enter 0 when confirmed as zero. Blank carry-over and adjustments assume zero. Booked days must not include days already taken.

Use up to 2 decimal places with a point or comma; no thousands separators. Allowance, carry-over, taken and booked: 0 to 1,000 days. Adjustments: −1,000 to 1,000 days.

3
Notes and reviewRecord how figures were agreed and what needs checking.
Record the agreed source, adjustments or expiry rules that need manual review.
Record missing figures and corrections to make in your HR system.

A tracker name, valid reporting dates and at least one named person are required. Missing day figures remain explicitly unknown.

Marked fields are examples. Replace them or clear examples before sharing. Edited fields are kept.

Live holiday balances

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.

Figures in a holiday tracker
FigurePurposeExample
Opening allowanceThe agreed allowance for this period, entered by you.25 days, before carry-over and adjustments.
Carry-over and adjustmentAdd carried days and agreed positive or negative corrections.2 carried days and a −1-day correction.
Taken and bookedKeep used days separate from future bookings.10 days taken and 5 future days booked.
Unallocated balanceSee what remains after both taken and booked days.25 + 2 − 1 − 10 − 5 = 11 days.
Human Resources

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 requestsApprove or reject in a click. Leave balances update automatically.
Team calendarEveryone's time off on the shared calendar.
TimesheetsHours worked each day, approved by managers.

How to track team holidays

  1. 1Set the reporting periodName the tracker and enter the dates covered by your figures. Use the same period for everyone.
  2. 2Record the agreed day figuresEnter one row per person, with allowance, carry-over, adjustments, days taken and future bookings. Leave unknown figures blank.
  3. 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

  1. Agree the opening figuresUse the allowance agreed for each person and this period. Do not include carry-over twice.
  2. Separate taken from bookedWhen booked leave is taken, move the same amount from booked to taken. Leaving it in both would deduct it twice.
  3. 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.
  4. Review negative balancesA negative result can reflect excess bookings, adjustments or a recording error. Check the figures before making a decision.
  5. 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

ROI calculatorCompare the total return with your costs and calculate return on investment.Open the toolPurchase order generatorPrepare a clear purchase order with items, prices and delivery details.Open the toolCash flow forecast calculatorPlan monthly money in and out, and spot projected cash shortfalls.Open the toolReceipt generatorRecord a payment received and create a clear, printable receipt.Open the toolClient satisfaction survey builderBuild an editable questionnaire to learn what clients value and what you can improve.Open the toolHiring plan generatorPlan roles, headcount, hiring owners and target dates in one editable document.Open the toolLeave plannerPlan time off, count working days and check overlapping entries for each person.Open the toolEmployee offboarding checklistCoordinate handover, equipment return, access changes and follow-up.Open the toolEmployee onboarding checklistPlan a new starter’s first days with clear tasks, owners and dates.Open the toolInterview scorecardRecord evidence and ratings against the same job-related criteria.Open the toolInterview questions generatorPrepare job-related questions, follow-ups and evidence to look for.Open the toolJob description generatorDescribe the role, responsibilities and skills in a clear hiring document.Open the toolBusiness day & deadline calculatorFind a deadline or count working days with your own calendar.Open the toolMeeting notes templateCapture discussions, decisions and action items in a clear, shareable record.Open the toolTask plannerOrganise tasks, set priorities and track progress in one clear plan.Open the toolProject brief generatorDefine goals, scope and deliverables before the work begins.Open the toolTimesheet calculatorAdd daily start, finish and break times to total your working week.Open the toolProject timeline generatorTurn tasks and durations into a clear project schedule.Open the toolBillable hours calculatorTotal your billable time, review utilisation and estimate work value.Open the toolBusiness health checkReview your business routines and choose your next improvements.Open the toolBusiness expense trackerRecord expenses, see category and payment totals, and export a dated CSV for your own records.Open the toolRecurring revenue calculatorTurn subscriptions and retainers into monthly and annual recurring revenue, with a clear breakdown.Open the toolClient profitability calculatorSee what a client contributes after delivery, support, expenses and overhead over the same period.Open the toolProject profitability calculatorCompare project revenue with labour, expenses and overhead to see your profit and margin.Open the toolWork order generatorCreate a clear job sheet with assignments, tasks and completion notes.Open the toolService contract generatorTurn your agreed services, fees and terms into a document for review.Open the toolClient intake form builderCreate custom intake questions and download a standalone, printable form.Open the toolPayment plan calculatorSplit a balance into dated instalments with an optional upfront payment.Open the toolLate payment interest calculatorEstimate overdue interest from your balance, rate and dates.Open the toolBusiness proposal builderPresent your approach, scope and price in a clear PDF.Open the toolFreelance day rate calculatorSet a day rate that covers your goals and time off.Open the toolService pricing calculatorTurn time, expenses and overheads into a service price.Open the toolInvoice generatorCreate a clear PDF invoice with tax lines, payment details and the balance due.Open the toolBreak-even calculatorFind the sales volume needed to cover your costs and check a forecast.Open the toolPayment reminder generatorWrite a clear invoice follow-up, from a friendly nudge to a firm reminder.Open the toolPricing & margin calculatorFind the price to charge, or check the margin on a price you already have.Open the toolQuote generatorYour business, your client, your items: a clean PDF quote in two minutes.Open the toolProject budget estimatorPlan hours, expenses and a contingency allowance before you commit.Open the tool

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.

Live holiday balances