Some employers pay for extra hours with time off instead of money. An employee works Saturday on a stocktake, stays late for a client event or supports a system upgrade, and later takes the same time, or a multiple of it, as a day off. It is a fair idea, but only if someone keeps score. This US Letter tracker records each hour earned and each hour used, with a running balance after every line.
An Hourglass in Indigo and Orange
The indigo header carries a white hourglass at the right. Orange sand fills the lower half, and a translucent orange tint shows the sand still falling in the upper half. The title Comp Time Tracker is set in Syne, an unusual, characterful sans serif, and a line beneath says hours earned, hours used, and what is left. Albert Sans handles the table text.
Employee, Department, Year and Expiry Rule
The strip shows the employee, the department, the year, and the expiry rule. The sample is Yusuf Aziz of Facilities, for 2026, with the rule to use within 12 months. Comp time often has a time limit, and stating it on the page reminds everyone to use the hours before they lapse.
Seven Entries and a Running Balance
| Date | Type | Reason | Hours | Balance |
|---|---|---|---|---|
| 3 Mar | Earned | Weekend stocktake | +6.0 | 6.0 |
| 18 Apr | Earned | Evening client event | +3.5 | 9.5 |
| 2 May | Used | Half day off | -4.0 | 5.5 |
| 14 Jun | Earned | System upgrade, Saturday | +8.0 | 13.5 |
| 7 Aug | Used | Day off | -8.0 | 5.5 |
| 10 Sep | Earned | Audit preparation | +4.5 | 10.0 |
| 16 Oct | Used | Early finish | -2.0 | 8.0 |
Earned and Used appear as green and amber labels on the real page, and used hours carry a minus sign.
Why a Running Balance Beats a Final Total
If you only add and subtract at the end, a single slip spoils everything. A running balance lets you check each line against the previous one, so errors are found where they happen. It also shows the balance at any date, which matters when someone asks how much comp time they had in June.
Hours Earned, Hours Used and Balance Now Tiles
Under the table, tiles give the totals for the year: hours earned (22.0, in green), hours used (14.0, in orange), and balance now (8.0, in indigo). Earned minus used equals the balance, so the three numbers always agree. If they do not, one of the entries has been mistyped, and the running balance column will show which.
Approvals and Notes
A box for approvals records who agreed each entry. The sample says all earned hours were approved in advance by the facilities manager. This matters because comp time is a promise, and the employer should not be surprised by hours it never authorised. Write approvals as they happen, with the name and date, and keep the page in a safe place.
A Reminder to Check Your Own Rules
A line of italic text at the foot of the page says to check your own rules, because comp time is not allowed or is limited in some places. This is important. In some jurisdictions, particular employees must be paid overtime in cash, and comp time arrangements have strict conditions. The tracker records your agreement; it does not decide whether the agreement is lawful.
Adding Earned and Used Hours Correctly
- Write the employee, department, year, and expiry rule.
- When extra hours are approved, add an Earned row with the reason.
- When time off is taken, add a Used row with a minus sign.
- Calculate the new balance from the previous one.
- Update the three tiles at the foot.
- Record who approved each entry in the notes.
Earning at Different Rates
Some employers give one and a half hours of comp time for each overtime hour; others give one for one. Decide your ratio and apply it consistently. Write the ratio in the notes, and enter the earned hours as the final figure after multiplying. That way, the Hours column always shows the amount that actually goes into the balance.
Using Comp Time Before It Expires
Hours that lapse are a hidden cost to employees and a source of bad feeling. Look at the balance every quarter and prompt staff to plan time off. A manager who reminds the team that eight hours expire in March is doing everyone a favour. The expiry rule in the strip makes the deadline obvious.
Comp Time for Salaried and Hourly Roles
Practices differ between salaried staff, who may receive flexible time off in return for extra effort, and hourly staff, who are usually owed pay. Make sure the way you use this tracker suits the role and the rules that apply. If in doubt, ask your HR team or an adviser before starting.
Editing the Entries and Tiles
The table is a real Table object. Add rows through Edit Table Data, retype the dates and reasons, and update the labels. The tiles are text, so retype them. You can replace the hourglass with your own logo, or delete it for a plainer page.
Signatures, Printing and Storage
The employee and the manager sign at the foot of the page. Print on US Letter, keep the signed page with the employee file, and start a new sheet when the old one is full or the year ends.
Agreeing the Rules With the Employee in Writing
Before the first entry, write down what counts as earning comp time, how it is approved, how it is taken, and when it expires. Both sides sign. Having the agreement on paper prevents misunderstandings later, and the tracker then simply records what the agreement allows.
Comp Time Tracker Questions
Can I carry the balance into next year?
Only if your policy allows it. Write the carried balance on the first line of the new sheet.
Is comp time the same as flexible time?
Not always. Flexible time shifts hours within a period, whereas comp time exchanges extra hours for later time off.
Does the balance update itself?
No. Calculate each new balance and retype it.
