Price: $5 (USD) - digital download (.xlsx + .ods)

Track your vacation, sick and personal time without an app or subscription. Built for people who asked for a simple yearly PTO tracker that handles partial days in hours, accrual, and carry-over.

What's inside

• Log leave as full days, half days, or hours (e.g. 2.5 hours at the dentist). Set hours per day per person.

• Leave the amount blank and it counts working days for you (Mon-Fri, minus your public holidays).

• Allowance per year + carry-over + accrual: lump sum, monthly, or per pay period.

• Balances per leave type: accrued, taken, planned, available now (days and hours), projected year-end.

• Whole-year calendar view: letter codes per leave type (V, S, P...), holidays and weekends shaded.

• Personal by default; optional team summary for up to 25 people.

• Leave types are editable (up to 10).

• Built-in checks flag mistakes in green/red: missing or text dates, end before start, text amounts, unknown names, using more than you have, overlapping entries, full-day leave on a weekend/holiday, more hours in a day than the working day, full tables or data typed below them, cleared formula cells. It also cross-checks that three formula columns have not been typed over (Log Status and Year, Allowances Available now); other formula cells are not cross-checked.

• Start Here sheet with step-by-step instructions. Example rows are marked SAMPLE DATA and are easy to clear.

Compatibility (honest)

• Needs Excel 2010 or later, or LibreOffice Calc.

• Tested in LibreOffice Calc. Excel and Google Sheets not yet tested.

Limits

1,000 leave entries, 25 people, 10 leave types, 30 holidays. Weekends fixed as Sat-Sun. Entries can't cross 31 Dec (one row per year). Only the selected year is counted. Carry-over is entered by you. Pay-period accrual approximates payroll dates. Mid-year start or leaving dates are not prorated (enter the allowance you are entitled to). Leave counts as taken once it starts (a multi-day entry counts in full from its start date). Partial-hour entries on the same day for different types are allowed. Previews show sample data as of 2026-10-16.

This is a personal record-keeping template, not HR, payroll or legal advice; your employer's policy and records apply.

Made by our small team - this is our own product.