BillCanvas
USUnited States

Home/Templates/Excel

Templates · Excel

Free timesheet template for Excel

Log the hours by date and task, and let the workbook total the hours and the amount due. Built for a one-week period.

Timesheet template (.xlsx)

US Letter · 14 rows · total hours and total due formulas

Excel 2016+ / Microsoft 365 / LibreOffice / Google Sheets. No macros.

What the workbook includes

  • Client, contractor, week ending and timesheet number
  • Fourteen rows of date, work performed, hours and rate
  • Amount formula: hours × rate
  • Total hours and total due formulas
  • A client approval line at the bottom
Free timesheet template for Excel preview
Timesheet template (.xlsx) · Excel · open full size

How the formulas work

Each row’s amount is hours multiplied by rate. The total hours cell adds the hours column, and the total due cell adds the amounts. Enter 0.25 for 15 minutes and 0.5 for 30 minutes; do not enter “1h 15m” in a numeric cell.

What to write in each row

One row per task or per day. “Homepage build, 3 hours” is checkable; “website work, 24 hours” is not. If you round hours, say the rule on the timesheet and apply it to each entry, not just the weekly total.

Adding rows and printing

Insert a row above the last line so the SUM ranges expand. The print area is set to US Letter, portrait, one page wide. The approval line is at the bottom; print or save as PDF and ask the client to sign.

Timesheet vs invoice

A timesheet records time; an invoice asks for money. Keep both. The timesheet generator can turn the same rows into an invoice and reference the timesheet number.

FAQ

Does the workbook calculate the total?

Yes. Total hours and total due use SUM formulas, and each row’s amount uses hours × rate.

Can I use it for multiple weeks?

Yes. Save one copy per week and change the week-ending date. The formulas stay the same.

Should I bill breaks and travel time?

Do not bill breaks you were not working through. Travel time depends on what you agreed in writing.

Does it work in Google Sheets?

Yes. Upload the .xlsx and the formulas carry over; check the print area after import.

Related templates

All templates →