Overtime Hours & Time Off Tracker Spreadsheet

Log overtime, comp days and vacation balance by month in one simple sheet.

Stop losing track of who worked extra and who is owed time off. Log extra hours as they happen and see each person's balance of hours and days to take, kept apart from their official annual leave.

What's inside:

• Log: one row per event (e.g. "3 extra hours on Tuesday") with drop-downs for person and type

• Profile: pick a person to see their balance in hours and days, plus every entry with the running balance

• Official leave tracked separately: entitlement, used this year, days left

• Team summary with a chart: who has time off to take, who took it in advance

• Optional credit rate (e.g. 1.5x for holiday work), per-person working-day length and opening balances

• Room for 25 people and 1,500 entries

Works in Excel and Google Sheets. No macros, no subscriptions, instant download. Includes English and Spanish versions. A record-keeping tool: it does not apply any law or company policy and is not legal or HR advice.