Contractor and freelancer timesheet with rate and amount

List each job with its hours. The amount for each line is hours times your rate, with a different rate for any line, and a subtotal and total to send to your client.

  • No email needed
  • Last reviewed 15 November 2026

For Google Sheets, download the .xlsx and open it with File > Import.

What it's for

  • Freelancers and contractors who bill by the hour.
  • Sending a client the hours behind an invoice, or having them check it first.
  • Lines at different rates in one timesheet, such as a meeting rate.

What's inside

How to use
Short instructions and the colour key.
Timesheet
Contractor, client, period, default hourly rate and an optional tax or GST percentage; 100 rows of date, job, description, hours, rate and amount; and total hours, subtotal, tax and total at the top.

Preview

Worked example: default rate 95, tax rate 10 percent (both are examples)
Date Job Hours Rate Amount
1 Mar 2027 Website build 6.5 95 (default) 617.50
2 Mar 2027 Website build 7 95 (default) 665.00
3 Mar 2027 Meetings 1.5 120 (typed) 180.00

Total hours: 15.0. Subtotal: 1,462.50. Tax at 10 percent: 146.25. Total: 1,608.75. Leave the tax box blank and the tax line is 0.00. The rates and the tax percentage are examples, not advice about what applies to you.

How to use it

  1. Type the contractor, the client, the period and your default hourly rate.
  2. Add a row for each piece of work with the hours as decimals (1 hour 30 minutes is 1.5).
  3. To bill a line at another rate, type it in the Rate column. Leave it blank to use the default.
  4. If you charge tax or GST, type its rate in the tax box as 10 or 10%. Leave it blank if you do not.
  5. Send the timesheet to the client with your invoice, or before it so they can check it.

The formulas, explained

Amount
=IF(D10="","",N(D10)*IF(E10="",N($B$6),N(E10)))

Hours times the rate typed on the line, or the default rate when the line's rate is blank. Text typed in Hours counts as 0 instead of breaking the totals.

Subtotal
=SUM(F10:F109)

Adds up every amount.

Tax or GST
=IF(N(B7)<=0,0,F4*IF(N(B7)>1,N(B7)/100,N(B7)))

The subtotal times the rate you typed. The cell is formatted as a percentage, so 10 and 10% both mean ten percent; a plain number above 1 is read as a percentage. Blank means no tax.

Total
=F4+F5

Subtotal plus tax.

Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.

Questions

Is this an invoice?

No. It is a timesheet that shows hours, rates and amounts. An invoice has numbers, dates, terms and tax details the law of your country may require, so use an invoicing tool or template for that.

What tax rate should I type?

The file does not know. Whether tax or GST applies, and at what rate, depends on your country and registration, so check with your tax office or an adviser. Leave the box blank if you do not charge it.

Can I round hours to 15 minutes?

Round the hours you type to your agreed step. The decimal hours timesheet template has a rounding step if you want the sheet to do it.

How is this different from the agency timesheet?

The agency timesheet is for a team: clients, projects, a rate on each project and billable percentages. This is one person with a rate on each line and a total.

Does it work in Google Sheets?

Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, N and SUM). It also opens in LibreOffice.

About this template

Last reviewed 15 November 2026.

Changes: 15 November 2026: first published.

Free to use and change in your own business. Please don't resell the files or publish them as your own. More free templates.

Track this in Jasper

Log hours by client and project, approve timesheets and follow retainer hours, next to your team chat.

Want this by email?

Entirely optional. Everything on this page works without an email address.

Sent by Shakewell Agency Pty Ltd, Sydney, Australia. Every email has an unsubscribe link. Privacy policy.