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.

Newsletter emails are optional. Privacy · Terms

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.

TaskTimer minutesPossible issueDecisionApproved minutesReason
Research review45NoneBill45Matched work notes and scope
Draft revisions840Timer left running overnightCorrect95Work notes and calendar show work stopped at 6:35 pm
Internal proposal planning30Scope unclearHold0Ask whether this work is billable before invoicing

How to use it

  1. Copy your timer entries into the sheet once a week, or before every invoice.
  2. Match each entry to a record of the work, like a calendar event, a document, or an email.
  3. Check the client agreement to see whether that work is in scope and billable.
  4. Decide to bill, correct, or hold each entry, and write down why.
  5. 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.

Get the free guide