Spreadsheet template
Leave tracker spreadsheet template
Start with a clean CSV that opens in Excel, Google Sheets, Numbers, and LibreOffice.
Included columns
- Employee and team
- Annual allowance and carry-over
- Taken and booked days
- Formula-calculated remaining days
- Leave year and notes
The example formula is transparent and editable. Add validation, access controls, backups, and jurisdiction-specific rules before operational use.
Transparent methodology
How this tool works
The template uses one row per employee and a transparent remaining-balance formula: allowance plus carry-over, minus taken and booked leave. It is an operational starter, not a compliance engine. Confirm statutory rules, working patterns, units, and rounding for each employee before relying on it.
Frequently asked questions
What file format is the template?
It is a UTF-8 CSV file that opens in Excel, Google Sheets, Numbers, and LibreOffice.
Does it calculate statutory entitlement?
No. You enter the correct allowance after checking contracts and applicable rules.
Why is the download email-gated?
The downloadable artifact is the lead-capture layer; the columns and formula are previewed openly on this page.
What happens if capture fails?
No file downloads. The page gives an explicit error so a failed request is never presented as a successful capture.
Leave the spreadsheet behind
Track leave for your whole team for $10/month flat.
Leave Balance handles requests, approvals, balances, public holidays, and reporting with unlimited employees.