Time audit worksheet you can fill in privately
Updated 5 min read By David from TimeRetain
Copy the worksheet below into a note, or download the CSV. Write start when you begin, and write end when you stop or pause. When you begin again, use a new row.
- Day 1:
- Date:
- Log:
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- Day 2:
- Date:
- Log:
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- Day 3:
- Date:
- Log:
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- [start] | [end] | [note]
- Review:
- Where the hours went:
- What surprised you:
- Hours vs value:
- Keep watching:
- Let go:
Day 1: Date: Log: - - - - - - Day 2: Date: Log: - - - - - - Day 3: Date: Log: - - - - - - Review: Where the hours went: What surprised you: Hours vs value: Keep watching: - - Let go: - -
This page shows how to fill that worksheet. For the method, see what a time audit is. It isn’t a timesheet to submit.
What’s on the worksheet
The log has three tables, one per day, with start, end, and note. One row each time you begin. Rough times are fine.
Choose days that represent the routine you want to examine. If you are looking at travel time, log the trip. Three days are a snapshot. Three weekdays won’t show a weekend, and three days may not show a reliable Monday-versus-Friday pattern.
The review covers where the hours went, what surprised you, hours vs value. Under that, two lists: keep watching, and let go.
There’s no rate column or client field. The rows follow your activity changes rather than a half-hour grid.
How to fill each line
When you begin, write the start time. When you stop or pause, write the end. When you begin again, use a new row.
- Start and end. Use the time you would tell a friend. 09:10 to 09:55 is close enough.
- Note. Name the work. “Inbox and Slack” tells you something; “Busy” doesn’t. A few words beat a blank.
Write the times at each switch. If you keep forgetting, try a reminder at a natural break; change its timing if it interrupts your work. If you estimate a missed block later, mark it as approximate.
Leave unused rows blank. A blank row does not need a task to fill it. If a busy day needs more than six rows, add more.
A filled day
A made-up sample day:
| Start | End | Note |
|---|---|---|
| 09:10 | 09:55 | Inbox and Slack, reactive |
| 09:55 | 11:20 | First pass on the proposal |
| 11:20 | 12:00 | Weekly catch-up, ran long |
| 13:00 | 13:40 | Receipts and calendar cleanup |
Inbox took the first 45 minutes. The proposal gets 85 minutes, from 09:55 to 11:20. The weekly catch-up fills the last 40 minutes before noon.
The gap after 12:00 is a pause. The next row starts when work begins again.
Keep the notes for yourself, including blunt ones like “ran long.”
After three days, fill the review
Fill the review after you have three days of rows.
Before you reread the days, use a separate note to guess where you think the hours went.
Read the days once and add up rough minutes for each kind of note. Write:
- Where the hours went. Which kind of work took the most clock time. One sentence.
- What surprised you. Where the rows differ from your guess, or a block that felt short and wasn’t.
- Hours vs value. The work that ate the day, next to the work that actually moved something.
Then split what you found. Keep watching is for a habit you’re changing, or hours you have to report. Let go is for the rest.
Choose one change within your control. If messages kept interrupting a project, try a separate block for nonurgent replies and see whether the project gets more time. If you cannot move those demands, use the notes to discuss priorities with whoever sets them.
A daily work log answers a different question: what finished, and what got in the way. Fill that at the end of the day if you want a handoff to tomorrow-you. Keep longer reflections separate so the time entries stay easy to scan.
Keep the file on your own device
Save the finished worksheet on your device. Don’t drop it in a shared drive “for later.” If you print it, don’t leave it in a stack someone else can read.
Use a local-first timer for the lines you keep watching. The audit can stay on paper.
If Keep watching includes inbox time, TimeRetain lets you see how much of each morning it takes after the audit ends. The primary record stays on your device. Optional Sync stores an encrypted copy on TimeRetain’s servers.
Keep a private timer for the few things the worksheet said to watch.
Put the file away
When the three tables and the review are filled, close the file. Leave Keep watching for the few lines that still need a timer.
Questions and answers
What is on this worksheet?
This worksheet is a three-day log plus a review. Each day has start, end, and note rows. The review covers where the hours went, what surprised you, hours vs value, then keep watching and let go.
How do you fill it out?
Write start when you begin, and write end when you stop or pause. When you begin again, use a new row. Add a short note and leave unused rows blank.
How many days does it cover?
This worksheet has three day tables. Choose days that represent the routine you want to examine. Three days are a snapshot, not a full week.
Is it the same as a timesheet?
No. This worksheet is a private three-day audit, not a timesheet to submit for payroll or a client.
Can I type into the template?
Yes. Copy the template into a note app or spreadsheet, or download the CSV. Keep the finished file on your own device.