Skip to content

FREE TIMESHEET TEMPLATE

A month of work.
On one page.

A free monthly timesheet template that summarises hours by week, client and task, with billable totals and approval. Download it for Excel or Google Sheets (with formulas), Word or as a CSV, without an email gate.

Word, Excel, Google Docs and PDF. No email required.

Last updated

TIMESHEETTemplate preview · Example
01

Who and when

Name, period, client and the person who approves the timesheet.

02

Entries

Week 1: Strategy for Larkspur Interiors, 28 hours, billable.

03

Totals

Total hours, billable hours, non-billable hours and utilisation.

04

Approval

Submitted by, approved by and the date, ready to attach to the invoice.

When to use a monthly timesheet

A monthly timesheet summarises a month’s hours by week, client and task. It suits retainers and monthly invoicing, where the client wants to see how the month’s hours were used rather than every day’s entries.

Keep recording daily (in a timesheet or time tracker) and roll it up monthly; a monthly sheet filled in from memory is never accurate.

The template

Details

  • Name: [Your name]
  • Period: [Start date — end date]
  • Client / project: [If the whole timesheet is for one client]
  • Approver: [Name]

Time entries

WeekClient / projectTaskHoursBillable (Y/N)Notes
Week 1[Client — project][Task][0.0][Y/N][ ]
Week 2[Client — project][Task][0.0][Y/N][ ]
Week 3[Client — project][Task][0.0][Y/N][ ]
Week 4[Client — project][Task][0.0][Y/N][ ]
Week 5[Client — project][Task][0.0][Y/N][ ]

Totals

  • Total hours: [0.0]
  • Billable hours: [0.0]
  • Non-billable hours: [0.0]
  • Utilisation: [Billable ÷ available hours]

Approval

  • Submitted by: [Name, date]
  • Approved by: [Name, date]

How to fill it in

  1. Fill in your name, the period and who approves your time.
  2. Add an entry for each block of work: date, client and project, task and hours.
  3. Mark each entry billable or not, and add a short note where the client might ask.
  4. Total the hours, split billable from non-billable, and work out utilisation.
  5. Submit it for approval at the end of the period.
  6. Use the approved timesheet as the backup for your invoice.

Use it in Word, Excel, Google Docs or PDF

Microsoft Word

  1. Download the Word (.docx) file and open it. If Word opens it in Protected View, select Enable Editing.
  2. Use Find (Ctrl+F or Cmd+F) and search for “[” to jump between the placeholders you need to replace.
  3. Save a clean copy as a Word template (File → Save As → Word Template) so every new document starts from it.

Google Docs

  1. Upload the .docx file to Google Drive.
  2. Right-click it and choose Open with → Google Docs, then File → Save as Google Docs to keep an editable copy.
  3. Use File → Make a copy for each new client so your master stays clean.

Excel and Google Sheets

  1. Download the Excel (.xlsx) file. It has a blank sheet and a worked example.
  2. Enter quantities, hours and rates: amounts, totals and tax calculate with built-in formulas.
  3. To use Google Sheets, upload the file to Drive and choose Open with → Google Sheets; the formulas carry over.

PDF

Use Print or save as PDF in the template section above to print just the template, or fill it in Word or Google Docs first and export it (File → Save As → PDF in Word, File → Download → PDF document in Google Docs).

Example: Tidewater Marketing month

A filled-in example. The companies are fictional.

Time entries

WeekClient / projectTaskHoursBillable (Y/N)Notes
Week 1Larkspur Interiors — quarterly lead generation campaignStrategy28Y
Week 2Larkspur Interiors — quarterly lead generation campaignCampaign set-up18Y
Week 3Larkspur Interiors — quarterly lead generation campaignContent creation32Y
Week 4Larkspur Interiors — quarterly lead generation campaignReporting12NInternal

Tips for accurate timesheets

  • Record as you go. Time reconstructed on Friday afternoon is lower and vaguer than time recorded daily.
  • Round consistently and say so in your agreements, e.g. to 15 minutes, or 6 minutes for law firms.
  • Track non-billable time too. It’s the only way to see real utilisation and price future work properly.
  • Use the client’s language. “Strategy” is easier to approve than “work”.

Turn approved hours into an invoice with the hourly invoice template.

MAKE IT WORK FOR YOU

Useful structure.
Your way of working.

01

Capture it daily.

A few minutes at the end of each day beats an hour of guesswork at the end of the week, and recovers time you’d otherwise forget to bill.

02

Split billable from the rest.

Knowing your non-billable hours shows where time really goes and whether your prices cover it.

03

Approve before you invoice.

An approved timesheet behind every hours-based invoice means fewer queries and faster payment.

GOOD QUESTIONS

Before you download.

Talk to us
Can I open this timesheet in Excel or Google Sheets?

Yes. Download the CSV version and open it in Excel, Google Sheets or Numbers, then add a SUM formula to the hours column. The Markdown version is easy to edit in any text editor.

How often should timesheets be submitted?

Weekly is the most common for client work: it’s frequent enough that people remember what they did, and it lines up with weekly or monthly invoicing.

What’s the difference between billable and non-billable time?

Billable time is work you charge a client for. Non-billable time is everything else, such as admin, sales and internal meetings. Tracking both shows your real utilisation.

Can I edit this template in Word or Google Docs?

Yes. Download the Word (.docx) file and open it in Microsoft Word, or upload it to Google Drive and choose Open with → Google Docs. There’s also a Markdown version for any text editor. No account or email address is needed.

How do I save it as a PDF?

Fill it in, then export it: File → Save As → PDF in Word, or File → Download → PDF document in Google Docs. On this page you can also print just the template or save it as a PDF from your browser’s print dialog.

Does the Excel version calculate totals?

Yes. Enter quantities, hours and rates and the amounts, subtotal, tax and total calculate automatically. It also works in Google Sheets: upload it to Drive and open it with Google Sheets.

THE CLIENT EXPERIENCE, IN ORDER

Good habits. A shared home.

Bring the work you share with clients into one place.