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

ColumnWhat goes in it
DateThe day you did the work.
ClientWho you’ll bill.
ProjectKeeps totals apart when a client has more than one.
TaskWhat you did, in words your client will recognise.
Start / EndOptional, but useful if a client asks.
HoursDecimal hours: 1.5 for an hour and a half.
BillableYes or No.
RateYour hourly rate for this work.
AmountHours × Rate for billable rows, 0 for the rest.

How to fill it in

  1. Add a row each time you finish a block of work, not at the end of the week.
  2. Write the task the way your client would describe it. “Homepage hero, second round” beats “design”.
  3. Mark each row billable or not, and keep the non-billable ones.
  4. At the end of the period, filter by client and total the Hours and Amount columns.
  5. 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.

DateProjectTaskTimeHoursBillableAmount
2026-11-03Brand guidelinesMoodboard research16:00–16:300.5No$0.00
2026-11-04Brand guidelinesTypography section14:00–15:301.5Yes$112.50
2026-11-06Website redesignNavigation and footer10:00–12:152.25Yes$168.75
2026-11-10Brand guidelinesLogo spacing and colour rules13:00–15:002Yes$150.00
2026-11-12Website redesignProduct page layouts09:30–13:003.5Yes$262.50
2026-11-13Website redesignCall: feedback on product pages15:00–15:450.75Yes$56.25
2026-11-14Website redesignHomepage hero, second round10:00–12:302.5Yes$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.

The same two weeks as a Jottaware time summary. Open it to see every entry.

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