Blog Productivity Track utilization and billable hours in a 20 person agency
Productivity · Nov 21, 2026
Track utilization and billable hours in a 20 person agency
Utilization is billable hours divided by available hours. Here is how to measure it across 20 people with TimeUno's CSV export and a spreadsheet.
The best way to track utilization across a 20 person agency is to capture hours automatically, mark each project billable or not, and calculate utilization in a spreadsheet each month. TimeUno records the hours and exports them as CSV. It has no utilization dashboard, so the calculation is yours. The TimeUno team wrote this page.
Utilization is billable hours divided by available hours. This page defines both, shows an example, and gives a routine for a team of about 20.
What is utilization, and how do you calculate it?
Utilization = billable hours / available hours.
Billable hours are hours worked on client work you charge for. Available hours are the hours a person could work in the period, after holidays, leave and public days.
Example, with invented numbers: a designer works a 40-hour week. In a four-week month that is 160 hours. They take one day of leave (8 hours), so available hours are 152. They log 100 billable hours. Utilization is 100 divided by 152, which is 65.8%.
If you instead divide by total logged hours, you measure something else, the share of worked time that was billable. Both are useful, but label which you use.
What should the agency count as billable?
Decide this once and write it down. A simple split:
| Category | Billable? |
|---|---|
| Client project work | Yes |
| Retainer work within the agreed hours | Yes |
| Pitching and proposals | No |
| Internal meetings and admin | No |
| Training | No |
| Out-of-scope work you did not charge for | No, and worth tracking |
That last row matters. Unbilled client work hides in billable projects and inflates utilization. Mark such time so you can see it.
What utilization target is reasonable?
Targets depend on role, so set your own. Owners and account managers usually have lower targets than production staff, because they carry sales and management work. Pick a target per role, share it, and review it each quarter. This page does not quote an industry benchmark because it has no source to cite.
How do you collect the hours for 20 people?
- Each person tracks with TimeUno on macOS or Windows. Activity is filed to projects, and each person corrects wrong guesses with one tap, which TimeUno remembers.
- Create a project for each client and a few internal ones, such as admin or pitching.
- At month end, each person reviews their entries so nothing sits in a wrong project.
- Export a CSV per person or for the team, according to your setup.
- Combine the files into one spreadsheet.
Check how consistent project names are across the team, because a pivot table treats "Acme" and "ACME site" as different rows. Agree a naming list at the start.
How do you build the spreadsheet?
Make one tab of raw rows and one summary tab.
- Raw tab: person, project, date, hours from the CSV, plus a column that marks each project billable or not.
- Summary tab: for each person, billable hours (sum where billable is yes), total hours, available hours (typed in from the calendar), utilization and billable share.
Worked team example, invented: 20 people, an average of 152 available hours each, gives 3,040 available hours. The team logs 1,900 billable hours. Utilization is 1,900 divided by 3,040, which is 62.5%. If the target is 70%, the gap is 7.5 points, which is 228 hours (0.075 x 3,040). At an average rate of $100 an hour that is about $22,800 of unsold time a month. Check where it sits before you hire.
Look at the spread too. Three people at 90% and five at 40% means a distribution problem, not a team-wide one. For a profit view, see how to find which clients are profitable with time data.
How often should you review the numbers?
Monthly is enough for most agencies. Weekly figures swing with holidays and launches, so they mislead. Review the month, then compare it with the last three months to see a trend. Share the summary with the team in the same meeting, so the numbers are a shared picture and not a private verdict.
What are the risks of measuring utilization?
Utilization pushes people toward billable work and away from training, mentoring and quality. Do not make 100% the goal. Do not rank individuals publicly, because available hours, role and project mix differ. Use the numbers to balance work and plan hiring.
Tell the team what you measure and why before you start. See how to tell your team about time tracking without surveillance. If late entries are a problem, read how to stop agency staff logging time late.
What are the limits of TimeUno here?
TimeUno has no utilization dashboard and no billable-rate or margin reports. It exports CSV and PDF timesheets, and the billable flag, available hours and the formulas live in your spreadsheet. It does not import from other trackers, has no payroll or project-tool integrations, and has no alerts when a teammate stops tracking. It records computer activity only, so offline work needs a manual entry. Team plans are priced per seat.
What is the next step?
Run one month with two or three people, build the spreadsheet, and check the numbers against what you know. Then roll it out to the rest. TimeUno has a 14-day free trial with no card needed. Team is $12.99 per seat per month ($10.83 billed yearly), as of November 2026; see pricing or download TimeUno.