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
| 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
- On Clients, type each client once with your hourly rate for them.
- 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).
- Choose Yes or No for billable. A billable row for a client not on Clients gets no amount and turns red.
- Read Clients for hours and amounts by client.
- 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.