A free timesheet template
for billable teams
Track hours by project and task, mark what is billable, and keep your weekly totals straight. Built for agencies and consultants. When the spreadsheet starts costing more than it saves, swap it for a timer.
What a good timesheet captures
Capture these and invoicing, reporting and approvals all fall out of the same data.
Date
The day the work happened. Keep entries on the right date so weekly and monthly totals are accurate.
Project and client
Tie every entry to a project so you can bill it and see where time goes.
Task description
A short, specific note on what you did. This becomes the invoice line description later.
Start and end times
When you started and stopped. The difference gives you the hours, and a record you can defend.
Hours
The billable duration for the entry. Sum these per project to invoice.
Billable flag
Mark each entry billable or not, so internal time does not slip onto a client invoice.
Download the template
The CSV has columns for Date, Project, Task/Description, Start, End, Hours and Billable, with example rows and a total. Open it in Excel, Google Sheets or Numbers.
Make it work for your team
For agencies
Give each person a tab or a copy, then consolidate weekly. Keep project names consistent so totals roll up cleanly. Use the Billable column to separate client work from internal time before you invoice.
For consultants
Log time as you go rather than reconstructing it on Friday. Write task descriptions a client would understand, since they become your invoice lines. Track non-billable admin too, so you know your true effective rate.
Or replace the spreadsheet with a timer
Spreadsheets drift. People forget to fill them in, totals get re-summed by hand, and work that runs past midnight lands on the wrong day.
Hour Cap replaces the spreadsheet with a timer you start and stop, and it auto-splits entries across midnight so the hours land on the correct dates without manual fixing.
Prefer to type durations? Enter them however you think: 1h30m, 1:30, 8h or 1.5 all work. On the Business plan, an approval workflow lets managers review and lock timesheets before they are invoiced.
Common questions
What should a timesheet include?
A useful timesheet captures the date, the project, a description of the task, the start and end times, the hours worked, and whether the time is billable. That is enough to invoice accurately and review utilisation.
What format is the timesheet template?
It is a CSV file with columns for Date, Project, Task/Description, Start, End, Hours and Billable, plus example rows and a total. Open it in Excel, Google Sheets or Numbers.
How do I calculate the hours?
Hours is the end time minus the start time. Add a row per task per day, then sum the billable hours when it is time to invoice.
How do I handle work that runs past midnight?
In a spreadsheet you split the entry into two rows, one for each day, so the hours land on the right date. Hour Cap does this automatically: its timer splits across midnight for you.
When should I move off the spreadsheet?
Once chasing timesheets and re-summing hours each week eats your time, switch to a timer. Hour Cap replaces the spreadsheet with one-click tracking, flexible duration input and an approval workflow.
More templates
Stop chasing timesheets
Track time with a timer that splits across midnight, then bill from it. The Free plan covers a single user. Approvals are on the Business plan.