Consultant timesheet by client and project

One log for all your clients, with a rate for each client. Hours and billable amounts add up by client, and a grid shows each client's hours month by month.

  • No email needed
  • Last reviewed 15 November 2026

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

What it's for

  • Independent consultants with several clients, each on one hourly rate.
  • Seeing how many hours each client takes each month.
  • Separating billable hours from unbilled ones such as admin and proposals.

What's inside

How to use
Short instructions and the colour key.
Clients
Your clients and the hourly rate for each, with hours, billable hours and billable amount for each.
Log
One row per piece of work: date, client, project, activity, hours and billable or not. The amount fills in from the client's rate.
By month
Each client's hours for 12 months from the month you choose.

Preview

Worked example: two clients, March and April 2027
Date Client Project Hours Billable Amount
2 Mar Northwind (rate 180) Strategy 4 Yes 720
3 Mar Northwind Strategy 3.5 Yes 630
3 Mar Contoso (rate 200) Audit 6 Yes 1,200
15 Apr Contoso Audit 2 Yes 400
16 Apr Contoso Admin 1 No 0

Northwind: 7.5 hours, 7.5 billable, amount 1,350. Contoso: 9.0 hours, 8.0 billable, amount 1,600. By month, March has Northwind 7.5 and Contoso 6.0 hours, and April has Contoso 3.0. The rates are examples.

How to use it

  1. On Clients, type each client once with your hourly rate for them.
  2. In the Log, add a row for each piece of work. Pick the client from the list, type the project and activity, and the hours as decimals (1 hour 30 minutes is 1.5).
  3. Choose Yes or No for billable. A billable row for a client not on Clients gets no amount and turns red.
  4. Read Clients for hours and amounts by client.
  5. On By month, type the first month to see each client's hours month by month.

The formulas, explained

Amount
=IF(E4="","",IF(AND(F4="Yes",COUNTIF(Clients!$A$4:$A$33,B4)>0),N(E4)*N(INDEX(Clients!$B$4:$B$33,MATCH(B4,Clients!$A$4:$A$33,0))),0))

Hours times the client's rate, for billable rows only. A client missing from Clients gets 0 and the row turns red.

Hours for a client
=SUMIFS('Log'!$E$4:$E$303,'Log'!$B$4:$B$303,$A4)

Adds up the hours logged against that client.

Hours in a month
=SUMIFS(Log!E,Log!B,client,Log!A,">="&B$4,Log!A,"<"&EDATE(B$4,1))

The client's hours dated from the first of the month up to, but not including, the first of the next month.

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

Questions

Why one rate per client and not per project?

Many consultants charge a client one rate whatever the project. If your rate changes by project, the agency timesheet has a rate on each project.

Can I see hours by project?

Not in a summary: the Log has a project column you can filter or sort. The totals are by client and by month.

How many rows does the Log have?

300 ready rows, and the totals read rows 4 to 303. To add more, copy the last row's formula down and widen the ranges.

What is the difference from the agency timesheet?

The agency timesheet is for a team and works by project and week. This is one consultant: a rate per client and a month-by-month grid.

Does it work in Google Sheets?

Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, OR, AND, N, ISNUMBER, SUM, SUMIFS, COUNTIF, INDEX, MATCH, DATE, YEAR, MONTH and EDATE). 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.