Timesheet formats
Weekly timesheet template
Project down the side, days across the top, totals computed both ways — the layout most delivery teams end up rebuilding by hand every quarter.
Opens in Excel, Google Sheets, Numbers and LibreOffice — no conversion needed.
Preview of the actual columns — green cells are formulas
What is in the file
These are the actual columns in the download, with a filled sample row so you can see the expected shape. Cells beginning with an equals sign are formulas and compute when the file opens.
| Column | Sample value | Notes |
|---|---|---|
| Project / client | Acme Corp Redesign | |
| Task | Frontend build | |
| Billable | Yes | |
| Mon | 6.5 | |
| Tue | 7 | |
| Wed | 4 | |
| Thu | 8 | |
| Fri | 5.5 | |
| Sat | 0 | |
| Sun | 0 | |
| Total hours | =SUM(D2:J2) | Formula computes on open |
How to use it
- →Enter hours in decimal — 7 hours 30 minutes is 7.5, not 7.30. Entering 7.30 silently underbills.
- →Keep the billable column filled; the billable-versus-total split is the number that matters at month end.
- →The week total row assumes 12 project rows. Adjust the ranges if you add more.
When the spreadsheet stops scaling
A template is the right answer until the reconciliation between sheets costs more than the sheets save. Workclave records the same data as work happens, applies your policy automatically, and produces the register, the payroll input and the client hours statement from one source. Free for up to 3 users.
Votre équipe travaille. Commencez à comprendre comment.
Rejoignez les équipes qui suivent des sessions, pas seulement des heures. Gratuit jusqu’à 3 utilisateurs — sans carte bancaire, sans minimum, sans engagement.