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
| 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
- Type the contractor, the client, the period and your default hourly rate.
- Add a row for each piece of work with the hours as decimals (1 hour 30 minutes is 1.5).
- To bill a line at another rate, type it in the Rate column. Leave it blank to use the default.
- If you charge tax or GST, type its rate in the tax box as 10 or 10%. Leave it blank if you do not.
- 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+F5Subtotal 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.