Utilization tracking template

Everhour tracks task and project time for utilization reporting, while your template defines capacity, leave, and billable rules.

How efficiently is yourteam's time being used?

Measure billable utilization against total capacity and see exactly how many hours you're leaving on the table each period.

Working hours this period

80%

Industry average for agencies: 75–85%

Utilization rate
Non-billable hours40h
Gap to target5%
Hours to recover8h

Everhour does it all — track, budget, report & invoice

The calculator gives you the number — Everhour takes it from there.

Go ahead — start tracking!

One click and you're timing. Start a timer, add an entry, edit the details. This is exactly how it feels in Everhour.

  • One-click timer — browser, desktop & mobile
  • Works inside Asana, ClickUp, Linear, GitHub & more
  • Simple setup, no learning curve
Works with your favorite tool:
Everhour — Time Tracking
Time Entries
01:24:00
00:31:00
01:07:00

No more budget surprises

Set a budget, assign rates, and get alerted before you're over.

  • Real-time cost tracking
  • Set different rates per person or project
  • Alerts before you hit the budget limit
Everhour — Budgeting
Acme Web Project
1
50% of budget used
$2,500.00of $5,000.00
$2,500.00 remaining
75%
Actual costRemaining cost

Measurement

Track your budget through time or costs

Simple, customizable reports

Every report you need — configured your way, always up to date.

  • See who does what in real time
  • Configure any report
  • Scheduled email reports
Everhour — Reports

Your invoice is ready!

Tracked hours flow straight into a polished invoice — no copy-paste, no manual math.

  • Billable hours straight into the invoice
  • Configure invoice templates
  • Copy invoices to QuickBooks or Xero
  • Invoicing dashboard with status
Everhour — Invoices
Your Company LLChello@yourcompany.com
INVOICE
Invoice #1042
Group by:
DescriptionHoursRateAmount
Website Redesign14h$150/h$2,100.00
Brand Guidelines7h$150/h$1,050.00
Marketing Strategy3.5h$150/h$525.00
Total Due$3,675.00
Try Everhour for real yourself

Building a usable utilization calculation

What this calculation answers

A utilization tracking template answers a practical operating question: how much of a person's defined available time turned into billable client work. The core ratio is billable hours divided by available hours. The template matters because available hours can mean gross capacity, working hours after PTO and holidays, or total logged hours. Each denominator produces a different percentage, so the template must label the denominator beside every result.

For U.S. teams, full-time capacity is an employer policy input, not a federal legal threshold. The FLSA does not define full-time or part-time employment. Many firms still use 40 weekly hours as gross capacity because federal overtime rules require covered nonexempt employees to receive overtime pay for hours worked over 40 in a fixed 168-hour workweek.

Choose the denominator first

A simple template should separate gross capacity from net available hours. Gross annual capacity based on a 40-hour week equals 2,080 hours before company PTO, holidays, unpaid leave, or other nonworking time. Net available hours subtract the time your policy removes from working capacity. In 2026, OPM lists 11 federal holidays for federal employees, but private-sector paid holidays depend on employer policy unless another law or contract applies.

Leave treatment changes the answer before billable work changes. If a consultant has 160 gross monthly capacity, 16 paid leave hours, and 8 holiday hours under company policy, net available hours equal 136. A 112-billable-hour month produces 70.00% utilization against gross capacity, but 82.35% utilization against net available hours. Both figures are mathematically valid. Only the labeled denominator makes the result usable.

Use the formula consistently

The standard utilization formula is billable hours divided by available hours, multiplied by 100. A template should place billable time in one field, available hours in another field, and the utilization percentage in a calculated field. Keep non-billable internal work, admin time, training, sales support, and leave outside the billable numerator unless your firm has a separate productive-utilization metric.

Example: a designer records 124 billable hours in a month. The firm defines available hours as 152 net working hours after PTO and holidays. Utilization equals 124 divided by 152, multiplied by 100, or 81.58%. At a $115 billing rate, those 124 billable hours carry $14,260 of billable value before discounts, write-downs, invoice timing, or collection changes.

Move from template to workflow

A spreadsheet or one-off template is enough for a monthly check, a planning exercise, or a quick comparison between denominator policies. It works when one person controls the inputs and the source data is small. The template becomes fragile when people update billable flags manually, leave records live somewhere else, or managers need utilization by person, project, client, role, and period.

A managed workflow fits recurring reporting. Everhour Time Tracking captures task and project hours through timers or manual entries, including tracking inside supported project tools. Approved timesheets, locked periods, reminders, and timer rules help teams keep time records stable before those hours feed reports, budgets, invoices, or payroll review. That workflow turns utilization from a monthly rebuild into an auditable operating metric.

This content is for general information only, may not be fully up to date, and is provided without any warranty or liability.

High Performer

G2

Summer 2026

Best Ease Of Use

Capterra

Summer 2026

Loved by teams. Proven everywhere.

Rated in the top time trackers across G2, Capterra, and TrustRadius — with consistent praise for ease of use, integrations, and support.

10K+Teams worldwide
90K+Installs Everhour extension
196M+Tasks completed
4M+Projects tracked

Frequently Asked Questions

How do you set up a utilization tracking template?

Start with columns for person, role, period, gross capacity, leave hours, holiday hours, net available hours, billable hours, non-billable hours, utilization percentage, and target. Calculate net available hours from capacity minus policy-approved nonworking time, then divide billable hours by that denominator. Label the denominator beside the percentage so managers do not compare unlike figures.

Should total logged time be the denominator in a tracker?

Total logged time works for time-entry completeness checks, but it usually weakens utilization analysis. Utilization normally compares billable hours with available capacity, not with whatever someone happened to record. A person who logs only billable work can show 100% utilization against total logged time while still using only part of their planned capacity.

Which leave hours should the template remove from capacity?

Remove leave hours only when your chosen denominator is net available hours. Company PTO, paid holidays, unpaid leave, and qualifying FMLA leave actually taken should reduce available hours under that method. The FLSA does not require payment for time not worked, including vacations, sick leave, or federal or other holidays, so private-employer leave rules come from policy, contract, or another applicable law.

How often should a utilization tracker be updated?

Weekly updates catch missing time and unusual billable swings while work is still fresh. Monthly updates work for finance reporting and leadership review, but they create more cleanup if people forget to classify time. A services team that plans capacity weekly should update utilization weekly, then close the month with approved totals.

Is utilization the same as billable value?

Utilization measures hours, while billable value applies a rate to those hours. A person can hit an 80% utilization target and still have lower billed revenue because of discounts, write-downs, delayed invoicing, or collection issues. Realization adds that next layer by comparing standard billable value with the amount actually billed or collected.

How does Everhour Time Tracking support a utilization tracker?

Everhour Time Tracking records task and project hours through live timers or manual entries, then feeds those hours into timesheets, reports, budgets, invoices, and payroll review. Admins can use approvals, locked periods, reminders, and timer rules to keep finalized utilization inputs from changing after review.

How does Everhour reporting help review utilization by role or project?

Everhour Reporting lets teams build reports with columns, grouping, filters, date ranges, and exports. Managers can group logged time by member, project, client, or other fields, then compare billable and non-billable time across the period used in the utilization tracker.

Track utilization from real hours

Use approved time entries, locked periods, and clear billable classifications before calculating utilization. Everhour Time Tracking gives teams cleaner source data for utilization reporting.

14-day free trial  ·  No credit card  ·  Cancel anytime

Or