Employee balance inputs
Space for 20 employees and 100 requests for one leave type and tracking period. Enter checked allocations and adjustments.
Free ✳Editable templateA little time off.
A little time off.
A clearer leave tracker.
Download a free Excel leave tracker for a small team. Enter the opening allocation, record requests and keep approved days separate from those still awaiting a decision.
Free Excel workbook · Manual entitlement and request-day inputs · Approved-request totals · No automatic entitlement calculation
FREE LEAVE TRACKER TEMPLATE
A clear request log and a balance you can follow.
The workbook brings entered employee balances and leave requests into one manual process. You enter the allocation or entitlement and any adjustment, then record request dates, checked days and a status. Formulas total approved requests and calculate what remains.
You stay in control of the policy figures and the request duration. The workbook does not calculate statutory leave entitlement, public holidays or working days between dates. Keep one controlled master file and agree who can change it.
A useful file.
Ready to make your own.
Excel-compatible .xlsx · Editable blank sheet and fictional example · No YavaHR app account needed
Download leave trackerGet the simpler CSV CSV files are manual tables. They do not include the workbook’s formulas or formatting.
WHAT’S INSIDE
A clearer place
for the details.
Request log with status
Record dates and manually checked days, with a clear approval status.
Approved days and remaining balance
Only valid Approved requests reduce the balance. Pending, rejected and cancelled requests are excluded; fix any rows flagged for review.
HOW TO USE IT
A little preparation.
A clearer result.
Choose the tracking period
Choose one leave type and tracking period, then enter checked balances and adjustments. Use a separate copy for another type or period.
Add the request details
Record the employee, dates, manually checked days and the decision status. Use consistent employee identifiers and status labels.
Review the balance
Confirm that approved requests are included and pending requests stay separate. Investigate any negative balance before relying on it.
A few practical
questions.
Does this work as a free leave tracker in Excel?
Yes. The main file is an Excel-compatible .xlsx workbook with balance formulas. A separate CSV request log is available if you only need a simple table; the CSV does not include those formulas.
How are half days handled?
Enter the checked duration as a decimal, such as 0.5 for a half day, following your policy. The workbook totals the numbers entered; it does not decide which days are working days or eligible leave.
Can employees submit and approve requests inside it?
The workbook records the outcome of your manual process. It does not provide employee accounts, access controls, notifications or enforced approvals.
Does it calculate annual leave entitlement?
No. Enter figures you have already checked against the applicable terms and rules. The formulas calculate used and remaining days from those inputs.
How many records does the workbook support?
The file has space for 20 employees and 100 requests for one leave type and period. Review flagged inputs before relying on balances. Use a separate copy for another leave type or period.