See how much vacation, sick and personal time you have left, in days and in hours, without an app or subscription. Log a 2.5-hour dentist visit or a full week off, and your balances, year calendar and year-end projection update for you.

• Full days, half days or hours: set the hours per day for each person

• Accrual your way: yearly allowance as a lump sum, monthly, or per pay period, plus carry-over

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

• Whole-year calendar: letter codes per leave type, with holidays and weekends shaded

• Personal or team: personal by default, with an optional team summary for up to 25 people

Price: $4 (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).

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

Compatibility (honest)

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

Details and limits

• 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.

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.