Free time off in lieu tracker

Record hours earned when overtime is worked and hours taken when the time off is used, and the workbook keeps a running balance with an optional expiry date.

Download editable file
  • No signup or email address
  • Editable and printable formats
  • Rebrand it for your clients, no attribution

Free to use and rebrandFull terms

Free time off in lieu tracker preview
A real preview generated from the downloadable file.

Edit it digitally or print a clean copy

Best for teams that repay overtime with time off instead of money and need the balance to stay honest on both sides.

Microsoft ExcelEditable source filePrintable PDFHigh-contrast paper layout

A useful starting point, not an empty shell

  • Running balance of hours earned minus hours taken
  • Expiry date per entry when time off must be used within a period
  • Period totals for hours earned, hours taken, and the remaining balance
  1. Enter the team, period, and whether you track hours or days.
  2. Add a row each time time off in lieu is earned or taken, with who approved it.
  3. Check the remaining balance before approving more overtime or more time off.

Keep the template until the process needs more

A shared file can be the right tool for a new or small process. Sandtime.io becomes useful when reminders, approvals, locked records, project data, reports, and Excel exports must stay dependable across a growing team.

The balance is only as good as the hours behind it

Sandtime.io does not manage leave, but it does give you a dependable record of the hours a balance is built from: tracked as they happen, reviewed, approved, and locked.

Free for unlimited users. No screenshots, keystroke logging, or activity scores.

Start Free

Build the rest of your practical toolkit

All five overtime templates

Request form, hours log, pay sheet, time off in lieu tracker, and policy on one page, in the order you use them.

Browse overtime templates

Free overtime request form template

Record the reason, requested dates, estimated hours, project impact, manager decision, approval conditions, and actual overtime in one editable form.

Free overtime log template

Record each overtime session with its date, employee, reason, hours, and approver, and the workbook totals all overtime hours for the period.

Free overtime policy template

Define what counts as overtime and how it is approved, recorded, compensated, and kept within healthy limits, in one editable policy.

Free overtime pay sheet template

Split each day into regular, overtime, and double-time hours at an hourly rate, and the workbook calculates overtime pay and total pay for the period.

Free time tracking policy template

Set clear expectations for what people record, when they submit it, who approves entries, and how corrections to locked periods are handled.

Free attendance sheet template

Choose a month, add team members, and enter a short status code for each valid day. The workbook calculates per-person and team totals automatically.

Free Timesheet Templates

Download daily, weekly, and monthly timesheets for Excel and printable PDF.

PTO Accrual Calculator

Work out how much paid time off you have accrued and how many days are left.

Questions about this free template

Is this template really free?

Yes. The editable file and the printable PDF are free and need no email address. We place them in the public domain rather than licensing them, so you may copy, edit, rebrand, redistribute, and use them commercially without asking permission.

Can I edit the template?

Yes. Open the Excel file in Microsoft Excel or import it into Google Sheets. Pale yellow cells are intended for input and grey cells contain calculated summaries.

Which format should I print?

Download the PDF when you need a clean paper copy. It uses high-contrast lines, safe print margins, and a layout designed for common A4 and US Letter printers.

Does this template guarantee compliance?

No. It is a general operational starting point and does not guarantee legal, payroll, tax, employment, record-retention, or labor-law compliance. Adapt it to the rules and contracts that apply to your organization.

Can I share or rebrand it?

Yes. Share the original file, add your own branding, publish an adapted version, or use it commercially. Nothing has to be credited back to us.

When should a team move beyond a template?

A file works well while one person owns the process and the team can keep it current. Consider Sandtime.io when reminders, approvals, locked records, project data, reports, and reliable exports need to work together.