Free Comp Time Tracking Spreadsheet (Excel)
What's in the free comp time tracker
The template is a single log with 200 rows: date, a short description, and the hours in two separate columns - comp time earned and comp time used. A running balance column adds earned hours and subtracts used hours automatically as you log each entry.
It's built as one continuous log rather than separate earned and used sheets, so the balance reflects every entry in date order without you reconciling two tabs against each other.
FLSA comp time context
Under the Fair Labor Standards Act, some public-sector employers can offer compensatory time off instead of overtime pay, typically credited at 1.5 hours of comp time for each hour of overtime worked. This context matters for how many hours actually go into the log.
This spreadsheet doesn't calculate that 1.5x multiplier for you — if your policy credits comp time at time-and-a-half, you work out the credited hours yourself and enter that already-multiplied figure into the log. Whether comp time is available to your organization at all is a policy and legal question worth checking with HR or counsel, since it's not standard for most private employers.
Balance and negative alerts
The running balance updates automatically with every row you add, so you always see the current comp time balance without adding up earned and used entries by hand. If the balance goes negative — more hours used than earned — the cell flags red.
That's the same negative-balance check used across our leave trackers: catching an overdrawn balance the moment it happens, not weeks later.
How to use it
- Log each comp time event: date, the hours earned and the hours used in their own columns.
- If your policy credits comp time at 1.5x for overtime, calculate that multiplier yourself and enter the credited hours.
- Let the running balance calculate automatically as you add rows.
- Watch for the red alert if the balance goes negative.
Download the free Free Comp Time Tracking Spreadsheet (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
PTO & Leave Tracker — with Automatic Accrual
For standard PTO, sick and personal leave with accrual calculated automatically, the paid PTO & Leave Tracker ($19) runs three policies for up to 30 employees, separate from comp time tracking.
See the full versionTracking PTO for a whole team?
For everyday PTO and sick leave tracked across your whole team, LeaveSheet runs it as a web app at $1.50 per employee per month, alongside a dedicated log like this one for comp time.
See LeaveSheet — $1.50/employee/moFrequently asked questions
Does it calculate the 1.5x FLSA multiplier automatically?
No. You calculate the credited hours yourself (for example, 1.5 hours of comp time per hour of overtime) and enter that figure — the sheet only tracks the running balance from what you log.
Who typically uses comp time?
Comp time in lieu of overtime pay is most common among public-sector employers under FLSA rules. Whether it applies to your organization is a policy question worth confirming with HR or legal counsel.
Can I use this in Google Sheets?
Yes. Upload it to Google Drive and open it with File > Save as Google Sheets. The running balance keeps calculating.
Is this template really free?
Yes. You give an email address to download it, and then it's yours to use with no further cost.
Is 200 rows enough?
It covers a team's comp time activity over an extended period. Copy the formulas down into new rows if you need more.