Billable Hours Tracker Template
A spreadsheet for checking your time before it turns into an invoice. Each entry gets matched to a record of the work and the client agreement, so you catch the timer left running and the work you forgot to log.
Download the billable hours tracker template
Free. Add your name and email and the files appear right here. They come as Excel (.xlsx) and CSV, and both open in Google Sheets.
Here you go. Save the files somewhere you’ll find them again.
What’s in the template
One row per time entry, with ten columns for the date, client or project, task, timer minutes, the source record, the agreement rule that applies, any possible issue, your decision, approved billable minutes, and the reason or follow-up. The Excel file has a second tab with a filled-in fictional example.
A fictional example
These entries are made up to show how the columns work together.
| Task | Timer minutes | Possible issue | Decision | Approved minutes | Reason |
|---|---|---|---|---|---|
| Research review | 45 | None | Bill | 45 | Matched work notes and scope |
| Draft revisions | 840 | Timer left running overnight | Correct | 95 | Work notes and calendar show work stopped at 6:35 pm |
| Internal proposal planning | 30 | Scope unclear | Hold | 0 | Ask whether this work is billable before invoicing |
How to use it
- Copy your timer entries into the sheet once a week, or before every invoice.
- Match each entry to a record of the work, like a calendar event, a document, or an email.
- Check the client agreement to see whether that work is in scope and billable.
- Decide to bill, correct, or hold each entry, and write down why.
- Build the invoice from the approved minutes column, not from the raw timer.
To open it in Google Sheets, upload the .xlsx file to Google Drive, or use File, then Import, with the CSV.
Automate it with Claude Code or Codex
If you use Claude Code or Codex, the time tracker I use runs on your own computer and logs each client’s hours to a CSV file you can open in any spreadsheet. You can ask it to start or stop a timer, and if you forget one, it closes the timer at the time you actually stopped working instead of when you noticed.
In Claude Code, it also tells you which timers are running and flags any timer that’s been on for more than eight hours. Those reminders are built for Claude Code, and the tracker runs on macOS.
View the time tracker on GitHub
Next, see the client brief template or the four routines.
Get all four templates and the field guide.
A free nine-page guide that walks through the routines behind these templates, with two filled-in fictional examples.
