Weekly Team Utilization Report
An automated workflow pulls billable and nonbillable hours from your time tracking tool every Friday, calculates each team member's utilisation rate, and posts a colour coded summary to Slack so you can rebalance workloads before the week is lost.
The Problem
Billable utilisation is the number that keeps professional services firms alive. It measures how much of your team's available time converts into revenue. And most firms have no idea what theirs looks like until it's too late.
The typical approach: someone exports time entries from Harvest or Toggl at month end, pastes them into a spreadsheet, and spends an afternoon calculating rates per person. By the time the numbers land on a managing partner's desk, three or four weeks of imbalance have already eaten into margins. A senior consultant sitting at 50% utilisation instead of 75% represents over $40,000 a year in unrealised revenue. One person. One metric nobody checked.
The benchmarks are well documented. Consulting firms target 75% to 85%. Law firms aim for 60% to 70%. Accounting practices sit somewhere in between. But hitting those targets requires weekly visibility, not quarterly postmortems. Below 60%, a team member is costing the firm money. Above 90%, you're burning out your best people and they'll leave. Replacing them costs 50% to 200% of their annual salary.
Most firms already track hours. The data exists. What's missing is the bridge between raw time entries and a clear, weekly picture of who needs more work and who needs relief.
How It Works
A scheduled workflow runs every Friday afternoon, pulls the week's time data, calculates utilisation per person, and delivers a formatted report to your team's Slack channel. Here's the breakdown.
1. Friday afternoon trigger fires
A scheduled trigger in your automation platform (such as Make, Zapier, or n8n) kicks off the workflow every Friday at a set time. No manual action required.
2. Pull time entries from your tracking tool
The workflow connects to your time tracking platform's API (Harvest, Toggl Track, or Clockify) and pulls all time entries for the current week. Each entry includes the team member, project, hours logged, and whether those hours are billable or nonbillable.
3. Calculate utilisation per team member
For each person, the workflow totals billable hours, divides by their available capacity for the week (factoring in any leave or part time arrangements), and produces a utilisation percentage. Senior staff with management responsibilities can have adjusted targets built in.
4. Flag outliers with colour coded indicators
Anyone below 60% gets a red flag. Anyone above 90% gets an amber warning. Team members in the healthy range show green. These thresholds are configurable to match your firm's benchmarks.
5. Format and post the summary table to Slack
The workflow builds a clean summary table listing each team member, their billable hours, nonbillable hours, utilisation rate, and RAG status. It posts this to a dedicated Slack channel where leadership and team leads can review it.
6. Log weekly data to a tracking sheet
Each week's figures are appended to a Google Sheet, building a rolling history. This makes it simple to spot four week trends, compare periods, and identify persistent imbalances that a single week's snapshot might miss.
Why Monthly Reviews Don't Cut It
Picture a 20 person accounting firm in the middle of tax season. Three senior accountants are running at 95% utilisation, grinding through client returns. Two junior team members are sitting at 45%, waiting for work to be delegated down. The managing partner doesn't see this because the utilisation report won't land until the first week of next month.
By then, one senior accountant has handed in their notice. They'd been overloaded for six consecutive weeks. The juniors, meanwhile, have been filling their days with internal admin that bills at zero dollars. The firm lost a $180,000 per year employee and missed out on hundreds of billable hours that could have been redistributed.
The moment a managing partner sees their top biller at 95% for three weeks running while a junior sits at 45% with the right skills to help, the rebalancing conversation happens that afternoon. Not next quarter.
Weekly reporting turns utilisation from a backward looking accounting exercise into an operational tool. You see the imbalance on Friday. You adjust assignments on Monday. That's the difference between managing workload and reacting to turnover.
What the Numbers Actually Tell You
A single utilisation percentage is useful. Trends over time are where the real value sits.
When you log weekly data to a spreadsheet, patterns emerge fast. A team member whose utilisation has dropped from 72% to 55% over three weeks isn't slacking. They've probably lost a major client engagement and nobody's backfilled their pipeline. A team member creeping from 80% to 92% over the same period isn't being productive. They're heading for a wall.
The advanced version of this workflow calculates a four week rolling average per person, compares it against individual targets, and breaks utilisation down by team or department. Some firms add an AI layer that generates a short narrative summary: which teams are trending up, which are trending down, and what's driving the shift. That turns a data table into something a partner can scan in 30 seconds and act on immediately.
Firms with real time utilisation visibility report 15% to 20% better resource allocation. That's not a vague improvement. It means fewer hours wasted, fewer people overloaded, and more revenue captured from the same headcount.
The Business Impact
Take a 30 person professional services firm billing at an average of $150 per hour. Each team member has 40 available hours per week. At 70% utilisation, each person bills 28 hours weekly. That's $4,200 per person per week in revenue.
A 5% utilisation improvement across the team (from 70% to 75%) adds two billable hours per person per week. Across 30 people, that's 60 additional billable hours. At $150 per hour, that's $9,000 per week. Over 48 working weeks, that's $432,000 in additional annual revenue. From a workflow that takes less than a day to set up and runs on autopilot.
And that's before you factor in retention. Teams with balanced workloads (utilisation between 70% and 85%) show 25% higher retention rates. Replacing a single senior professional costs $80,000 to $200,000 when you account for recruitment, onboarding, and the revenue gap while the role sits empty.
- Weekly visibility into every team member's billable and nonbillable split
- Automatic flagging of underutilised staff (below 60%) and burnout risks (above 90%)
- Four week rolling trends that reveal patterns before they become problems
- 80% less time spent on manual workload reporting
- Direct line between utilisation data and workload rebalancing decisions made within days, not months
Frequently Asked Questions
My team already logs their hours. Why do I need this?
Logging hours and analysing utilisation are two different things. Your time tracking tool stores raw data. This workflow turns that data into a weekly snapshot with colour coded flags, trend tracking, and automatic delivery to the people who make staffing decisions. The gap between having the data and using it is where most firms lose money.
Won't this feel like micromanagement to my team?
This isn't about surveillance. The report goes to team leads and partners, not to individual contributors as a performance scorecard. It's designed to identify who needs more work and who needs support. Most team members appreciate it because it prevents the slow creep toward burnout that nobody notices until it's too late.
What time tracking tools does this work with?
Any platform with an API that distinguishes billable from nonbillable hours. Harvest, Toggl Track, and Clockify are the most common. If your firm uses a practice management tool like Clio, Accelo, or Productive that includes time tracking, those work too. The workflow adapts to whichever system your team already uses.
How do you handle part time staff or people on leave?
Each team member's available hours are configurable. Part time employees get a reduced capacity figure, and the workflow can pull leave data from your HR system or a shared calendar to adjust the denominator automatically. This prevents false red flags for someone who was only available three days that week.
Our utilisation targets vary by role. Can the thresholds be different for each person?
Yes. Senior staff with business development or management duties often have lower billable targets than delivery focused team members. The workflow supports individual or role based thresholds so a partner at 55% utilisation doesn't trigger the same alert as a junior consultant at 55%.
What if our firm bills by project or fixed fee rather than hourly?
Utilisation tracking still works if your team logs time against projects, even on fixed fee engagements. It measures how your people spend their hours, not how you invoice clients. Many fixed fee firms find utilisation data even more valuable because it reveals which projects are consuming more effort than the fee justifies.
How long does this take to set up?
A basic weekly utilisation report with Slack delivery and colour coded flags takes two to three hours to build. Adding rolling trend tracking and a Google Sheets dashboard adds another half day. If you'd like help scoping the right version for your firm, book your free audit and we'll map it out together.
Sources
Automations we’ve already built
Thirty days after onboarding begins, an automated workflow surveys your client, pulls milestone data from your project tools, generates an AI written retrospective, and flags anyone who needs a recovery call. Every onboarding teaches the next one.
When a new client lands in your practice management software, this automation generates a tailored engagement letter with the right services, fees, and deadlines, sends it for electronic signature, then builds the client folder and kicks off your onboarding checklist. No chasing. No waiting.
A project manager fills out a short form after a discovery call. Within minutes, AI drafts a full Statement of Work into your branded template, routes it through Slack for internal approval, and sends it to the client for signature.
When a project closes in your PM tool, this automation collects every contract, deliverable, and sign off from across your systems, organises them into a standardised archive folder, and generates a summary PDF. No manual cleanup required.
When a contact is tagged in your CRM as needing an NDA, the agreement is generated from a template with their details prefilled, sent for signature, and tracked automatically. Overdue NDAs trigger reminders so nothing slips through.
Automatically converts raw meeting notes or recordings into structured, branded board minutes with tracked resolutions and action items, so your admin staff can stop spending full days on documentation that nobody reads until it's too late.
Capture scope changes on site, generate costed PDFs, route them through internal approval and client e signature, and log everything automatically. No verbal agreements, no lost paperwork, no payment disputes.
When a new contract lands in your cloud folder, an AI agent extracts the text, checks every clause against a risk framework, and sends your team a structured memo flagging the problems that actually matter. Preliminary review drops from hours to minutes.
When a new contractor lands in your HR system or Airtable base, this automation generates a complete document bundle, sends it as a single signing package through PandaDoc, and updates your records the moment everything is signed.
When a deal hits the proposal stage in your CRM, this automation pulls the client name, scope, pricing, and line items, then merges everything into a branded template. The finished PDF lands back on the deal record and in the prospect's inbox without anyone touching a document.
When every party signs a document in DocuSign or PandaDoc, this automation downloads the completed PDF, renames it to your filing convention, stores it in the right client folder, and notifies the account manager. No manual downloading, no misfiled contracts.
A scheduled workflow scans your contracts database daily, flags renewals at 30, 14, and 7 day intervals, and sends tiered alerts to account managers and leadership so nothing expires unnoticed.
When a new client is created in your CRM, this automation builds their billing profile, generates the first invoice, sets up recurring payments, and sends a secure link to collect their payment method. No manual data entry between systems, no forgotten first invoices.
When a project is marked complete in your project management tool, this automation pulls billable hours and rates, generates a branded PDF invoice, and emails it to the client with payment instructions. A copy lands in the client folder without anyone lifting a finger.
When a new patient books an appointment, this automation sends digital intake forms, collects consent and insurance details, converts everything to PDF, files it in the patient folder, and notifies your front desk. No clipboards. No data entry.
An AI agent that turns your meeting recordings into structured summaries, assigned action items, and tracked tasks across Slack, Asana, and Notion. No more post meeting admin, no more forgotten decisions.
An automated workflow pulls client KPIs from your data sources on the first business day of each month, populates branded report templates, converts them to PDF, and emails every client their personalised report before your team starts work.
Automatically classify incoming contracts by type, route each one to the right reviewer, and track every document through the review pipeline so nothing stalls in someone's inbox.
When a new B2B client submits their intake form, this automation reads every team member's role and sends each person the exact onboarding content they need. Billing contacts get payment setup. Project sponsors get the timeline. Day to day operators get tool access and kickoff details. Every stakeholder's progress is tracked independently until all are ready.
When a new client record lands in your CRM with a signed engagement letter, a prefilled contract is automatically generated and sent for e signature. No copying, no delays, no forgotten clauses.
When a prospect opens your proposal, this automation logs the view in your CRM, pings the assigned salesperson on Slack, and sends a templated follow up email if the document stays unsigned after 48 hours.
When a real estate agent fills out a short form with property details and buyer information, the automation generates a complete contract of sale, attaches the correct disclosure forms, and sends the full package to DocuSign with the right signing order.
Automatically converts approved quotes into signed service contracts with warranty terms, payment schedules, and scope definitions. No manual paperwork, no verbal agreements, no disputes three months later.
When a vendor sends a contract, AI extracts payment terms, liability caps, termination clauses and auto renewal dates into a structured row. Your procurement team can then compare every vendor agreement side by side, spotting bad deals before anyone signs.
Not ready to talk yet? Start here.
Everything we've learned building 300+ automations for small businesses, in one practical guide. Written for business owners, not engineers.
- Where your team's hours are actually disappearing
- The five automations worth setting up first and why
- How to calculate what manual work is actually costing you
- A step by step checklist to get your first automation live this week
Completely free.