Free template
Freelance timesheet template, free to download.
A simple timesheet that opens in Excel, Google Sheets and Numbers. One row per block of work, with the columns a client needs to understand an invoice.
Updated
What’s in the template
| Column | What goes in it |
|---|---|
| Date | The day you did the work. |
| Client | Who you’ll bill. |
| Project | Keeps totals apart when a client has more than one. |
| Task | What you did, in words your client will recognise. |
| Start / End | Optional, but useful if a client asks. |
| Hours | Decimal hours: 1.5 for an hour and a half. |
| Billable | Yes or No. |
| Rate | Your hourly rate for this work. |
| Amount | Hours × Rate for billable rows, 0 for the rest. |
How to fill it in
- Add a row each time you finish a block of work, not at the end of the week.
- Write the task the way your client would describe it. “Homepage hero, second round” beats “design”.
- Mark each row billable or not, and keep the non-billable ones.
- At the end of the period, filter by client and total the Hours and Amount columns.
- Send the client their rows with your invoice.
A filled-in example
Two weeks of work for one client at $75 an hour. These are the rows in the download.
| Date | Project | Task | Time | Hours | Billable | Amount |
|---|---|---|---|---|---|---|
| 2026-11-03 | Brand guidelines | Moodboard research | 16:00–16:30 | 0.5 | No | $0.00 |
| 2026-11-04 | Brand guidelines | Typography section | 14:00–15:30 | 1.5 | Yes | $112.50 |
| 2026-11-06 | Website redesign | Navigation and footer | 10:00–12:15 | 2.25 | Yes | $168.75 |
| 2026-11-10 | Brand guidelines | Logo spacing and colour rules | 13:00–15:00 | 2 | Yes | $150.00 |
| 2026-11-12 | Website redesign | Product page layouts | 09:30–13:00 | 3.5 | Yes | $262.50 |
| 2026-11-13 | Website redesign | Call: feedback on product pages | 15:00–15:45 | 0.75 | Yes | $56.25 |
| 2026-11-14 | Website redesign | Homepage hero, second round | 10:00–12:30 | 2.5 | Yes | $187.50 |
When a spreadsheet stops being enough
Spreadsheets work until you have several clients, or forget to fill one in. Jottaware keeps the timesheet as you work: start a timer, and it records the time, the rate and the amount. At the end of the period, send your client a summary like this one, or export it as PDF or CSV. More in our guide to time tracking for freelancers.
Questions people ask
Does this template work in Google Sheets?
Yes. In Google Sheets, choose File, then Import, and upload the CSV. It also opens directly in Excel and Numbers.
Should I use decimal hours or hours and minutes?
Decimal hours are easier to multiply by a rate: 1 hour 30 minutes is 1.5, and 45 minutes is 0.75.
How should I round my time?
Pick a rule and stick to it. Many freelancers round to the nearest 15 minutes (0.25 hours). If you round, say so on your invoice.
Is the template really free?
Yes. Download it, change it, and share it.
Skip the spreadsheet. Track as you work.
Jottaware records your hours, rate and amount as you go. Free for 14 days, no card needed.
Start your free trial