FREE Leave Tracker Template 2026 — Singapore

Yes. ClockIt publishes a free PTO tracking template for Google Sheets and Excel with no account, email address or download gate. It tracks vacation, sick leave and other time-off types with running balances per employee.

Set up one row per employee and one column per leave type, then record the days taken against each. Add an entitlement column and subtract the days taken to produce a remaining balance, using SUM and COUNTIF so the totals update themselves. ClockIt's free PTO tracking template has these formulas already built in, so you can start from it rather than build the sheet from scratch.

Small teams typically start with a spreadsheet, which works until accruals, carryover caps and part-year joiners make the formulas hard to maintain. Larger teams move to software that accrues balances automatically from a policy and lets employees request time off and check their own balance, removing the manual re-entry a spreadsheet needs.

The template is a spreadsheet you maintain by hand: you enter each absence and the formulas total it. ClockIt applies your accrual policy automatically, updates balances as time is approved, handles carryover and caps, and gives employees self-service access to their own balance and requests. Both are free to start.

The template holds an entitlement figure and subtracts days taken, so it shows a remaining balance but does not accrue time automatically or roll balances into the next year for you. For accrual by hours worked or at fixed intervals, plus carryover rules and caps, use ClockIt's PTO features or the free PTO accrual calculator.