Enterprise DNA

Omni by Enterprise DNA

Enterprise DNA Resources

Step-by-step how-tos. Practical AI operating-system thinking for owners, operators, and teams doing real work.

220k+

Data professionals

Omni

AI agents and apps

Audit

Map the manual work

Guide Intermediate Omni Ops

Track Attorney Utilization Without Spreadsheets

A practical way for small law firms to track attorney utilization, find unbilled time, and make smarter staffing decisions.

Sam McKay |
Track Attorney Utilization Without Spreadsheets

The utilization number is usually wrong

Most small law firms can tell you how many hours an attorney entered last month. Fewer can tell you, with confidence, how much of that attorney’s working time was billable, collected, written off, or consumed by work that never made it into the time system.

That’s the real problem behind attorney utilization tracking.

A partner opens the practice management platform, exports a report, compares it against payroll or calendar data, then asks each attorney why their numbers look light. The answers are usually reasonable:

  • “I was handling urgent client calls.”
  • “I reviewed the intake before deciding whether to take the matter.”
  • “I was managing discovery production.”
  • “I spent time fixing work that came back from a junior associate.”
  • “I was answering internal questions and dealing with admin.”

The issue isn’t that this work lacks value. Much of it matters. The issue is that the firm can’t see it clearly enough to decide what should be billed, delegated, automated, absorbed as overhead, or removed entirely.

For a law firm doing $1 million to $25 million in annual revenue, small gaps compound fast. We commonly see 4 to 6 hours per attorney per week spent on work that isn’t billed or consistently recorded. Some of that is appropriate non-billable effort. Some is missed time. Some is a workflow problem that shouldn’t require attorney attention in the first place.

If your firm has 10 timekeepers, even a modest slice of recoverable time can change the economics of the practice. It can also tell you that you don’t need another associate yet, or that you needed one three months ago.

The best way to track attorney utilization isn’t a better spreadsheet. It’s a connected operating view that compares planned capacity, recorded time, billable time, collections, matter workload, and the work arriving at the front door.

This is where Omni for law firms fits. The goal isn’t to produce another dashboard that no one checks. It’s to expose the decisions hiding behind the utilization number.

Start with a utilization definition your partners will accept

“Utilization” gets used loosely in law firms. Before you automate reporting, agree on the formula and the purpose.

At its simplest:

Attorney utilization rate = billable hours recorded ÷ available working hours

If an associate has 160 available hours in a month and records 112 billable hours, utilization is 70 percent.

That calculation is useful, but it isn’t enough. It can hide poor realization, uneven workload, and time entered late. It can also punish attorneys who are doing necessary supervision, business development, training, and client relationship work.

A better operating model uses four linked measures.

Capacity utilization measures billable hours against available hours. This shows how fully each timekeeper is being used.

Time capture rate measures recorded hours against calendar and matter activity. This identifies work that happened but wasn’t entered.

Billing realization measures the value billed against the value worked. This identifies write-downs and work the firm doesn’t believe clients will pay for.

Collection realization measures cash received against the amount billed. This shows where payment terms, matter selection, or client management are affecting profitability.

For example, an attorney can show 82 percent capacity utilization and still be unprofitable on certain matter types if a large share of their time is discounted or written off. Another attorney may show 58 percent utilization but generate stronger profit because they handle higher-value advisory work, supervise a team efficiently, and collect promptly.

The point isn’t to turn lawyers into a production line. It’s to get past a single number and see where partner judgment is needed.

Why manual utilization tracking breaks down

The manual process usually starts with good intentions.

An office manager exports time entries every Friday. A partner reviews billable targets monthly. Someone maintains a capacity spreadsheet. Attorneys are asked to explain low utilization during performance reviews. Finance tries to reconcile hours, invoices, and collections at month-end.

That process breaks because the underlying data is fragmented.

Time entries live in one system. Calendars live in another. Intake calls and website forms may sit in a phone platform, email inbox, or CRM. Matter status is held in practice management software. Staffing decisions are made in partner meetings from memory and instinct.

By the time the firm compiles the report, it is often looking backward by three to six weeks. The partner can see that litigation utilization fell in the prior month. They can’t see that a senior associate spent 18 hours reviewing unqualified inquiries, handling intake follow-up, and chasing missing client documents before those activities affected the month’s economics.

The common manual work looks like this:

  1. An administrator pulls billing reports by attorney and practice area.
  2. Attorneys are chased for late time entries.
  3. Calendars are checked to find meetings, hearings, calls, and document review that may not have been captured.
  4. A partner asks who is overloaded and who has capacity.
  5. The answer comes from anecdotes rather than a current workload view.
  6. New work is assigned based on who replies first, not who has the right expertise and available capacity.
  7. Billing write-offs are reviewed after the work is already complete.

That isn’t a people problem. It’s an operating design problem.

A firm can run this way for years because revenue keeps coming in. But firms in this range often carry $80K to $250K in annual leakage across missed time, slow intake response, avoidable attorney admin, write-downs, and poorly matched staffing. The exact number depends on hourly rates, practice mix, leverage, and the number of timekeepers. You don’t need to accept the upper end of that range to justify fixing the process.

Build a weekly utilization operating rhythm

The most effective utilization tracking happens weekly, not at the end of the quarter.

A weekly view gives partners enough time to act. They can reassign work, challenge unrecorded time while it is still fresh, fix an intake bottleneck, or shift a discovery workload before a deadline forces expensive overtime.

Your weekly report should answer five practical questions.

Who has capacity next week? Show each attorney’s target billable capacity, booked commitments, active matter load, and unassigned work. Avoid treating every hour as equal. A partner with four complex hearings may have less usable capacity than a junior associate with a lighter calendar.

Who is carrying invisible work? Compare calendar events, call activity, document review tasks, and matter communications against time entries. This does not mean every meeting should be billed. It means the firm should know what work is occurring.

Where are hours being written down? Break write-downs out by attorney, client, matter type, and reason code. A repeat pattern can signal weak scoping, poor delegation, slow workflows, or a client relationship that needs attention.

Which matters are consuming unexpected time? A matter with a rising number of unbilled communications or repeated document cycles should be flagged before the billing partner discovers it on the invoice draft.

Where should the next piece of work go? Routing should consider practice area, client relationship, seniority, current workload, deadline pressure, and profitability, not just raw available hours.

This operating rhythm is also a better basis for staffing decisions. If one practice group is at 90 percent or more of realistic capacity for several weeks, while intake remains strong, hiring or contract support may be justified. If utilization is low but attorneys are busy with non-billable work, hiring won’t fix the problem. The firm needs to remove or redesign that work first.

You can find more practical operating ideas in our legal operations resources, but the key is to create a process people can actually follow every week.

What an AI-assisted utilization workflow looks like

AI doesn’t replace partner judgment on billing or staffing. It does remove the manual reconciliation that prevents partners from getting useful information.

A practical setup begins by connecting your practice management system, timekeeping data, calendar, phone system, intake forms, matter records, and billing data. The system creates a shared activity trail for each attorney and matter.

From there, an operations agent can perform several repeatable tasks.

It can detect activity that likely needs a time-entry check. For example, it may identify a 45-minute client call, a document review task, and a meeting with opposing counsel that have no related time entry after 24 hours. It should not automatically bill the client. It should send the attorney a concise prompt with the activity, matter reference, and an option to confirm, edit, classify as non-billable, or dismiss.

It can prepare a weekly utilization brief for each partner. Instead of handing over raw exports, the brief might show:

  • 68 percent recorded billable utilization against a 75 percent target
  • 11 calendar activities without a linked time entry
  • 9.5 hours of matter administration on three active files
  • two matters with repeated write-downs
  • one associate approaching capacity and another with room for additional work
  • new qualified matters awaiting assignment

It can also identify patterns. If an attorney’s low utilization coincides with late time entry, the solution may be a daily capture habit. If it coincides with heavy intake screening and document collection, the solution is different. That attorney is doing work that should be routed or supported elsewhere.

This is where Omni Ops becomes useful. It can monitor activity across systems, apply clear rules, and place the right information in front of the right person without requiring someone to rebuild a report every Monday.

A good implementation remains controlled. Partners define which activity types are flagged, which data is visible by role, how matter confidentiality is handled, and where human approval is required. The firm keeps its billing judgment. The automation handles the repetitive evidence gathering.

Fix utilization at the source, not only in the report

A utilization dashboard can reveal the problem. It can’t fix an attorney spending too much time answering unqualified calls, sorting intake emails, or performing first-pass document review.

That is why the best utilization programs connect front-office workload with legal delivery workload.

The Intake Voice Agent answers incoming calls after hours, at lunch, and on weekends. It captures the caller’s details, performs an initial conflict check based on the firm’s process, collects matter information, and books a consultation into the right calendar. This matters because 30 to 40 percent of after-hours intake may never convert when it waits until the following business day. It also means attorneys don’t need to interrupt billable work to handle basic intake conversations.

The Matter Triage Agent reviews form submissions and incoming emails, identifies the relevant practice area, scores fit against the firm’s criteria, and routes the matter to the appropriate partner with a one-paragraph brief. Instead of a partner reading every new inquiry and forwarding it manually, the firm receives structured information and a clear next action.

Those agents improve utilization in two ways. First, they protect attorney capacity by removing work that should not sit with a billable timekeeper. Second, they make demand visible. If a practice group has a growing queue of qualified matters but low recorded utilization, the report should trigger an investigation. The issue may be assignment delays, not a lack of work.

The Document Review Agent addresses another common drain. Junior associates can spend days on first-pass review of contracts, discovery batches, and matter files. At typical associate billing rates of $200 to $400 per hour, that work needs careful supervision and clear scoping. The agent can organize documents, flag specified clauses or issues, summarize positions, and produce an associate-grade memo for lawyer review. The responsible attorney remains responsible for legal judgment. The workflow reduces the volume of repetitive first-pass effort that gets buried in utilization reports.

If you want to see how these workflows connect across calls, routing, and attorney work queues, see Omni for law firms. The point is not to add AI for its own sake. It’s to reduce the work that keeps lawyers from doing work clients value and will pay for.

Use the data to make staffing decisions earlier

Law firm staffing is expensive because the decision is often delayed until the pressure becomes obvious.

A partner feels overloaded. Deadlines are tighter. Client response times slip. Work is passed to whoever is available. The firm hires an associate or brings in contract help after service quality has already taken a hit.

Utilization data gives you earlier signals.

High utilization with low realization may mean your team is busy but work is being poorly scoped, underpriced, or delivered at the wrong level of seniority. Hiring another lawyer may increase the problem.

Low utilization with high intake volume may mean leads are not being qualified, followed up, or assigned quickly enough. The fix may be an intake workflow, not more marketing.

High partner utilization alongside low associate utilization often points to delegation failure. The partner may be handling routine client updates, initial document review, or administrative coordination because the matter handoff is unclear.

High associate utilization with rising deadlines and increasing non-billable admin can justify additional support. That support may be a legal assistant, paralegal, contract reviewer, or a process agent before it needs to be a full-time associate.

The important distinction is this. You are not tracking utilization to pressure people into more hours. You are tracking it to understand the flow of work and protect margin.

A practical checklist before you automate

Before connecting systems or building agents, map the path from inquiry to collection.

Document who owns intake, who checks conflicts, who opens a matter, who assigns work, when time should be entered, who reviews billing narratives, and how write-downs are coded. If no one owns a step, automation will expose it quickly.

Our AI Client Intake Checklist for Law Firms is a useful worksheet for this exercise. It helps you identify the information your team should capture, the routing rules to define, and the handoffs that create delays. You can also download the checklist directly and use it in your next partner or operations meeting.

Then choose one starting point. For many firms, that is a weekly utilization brief that combines time entries, calendar activity, matter workload, and write-down trends. For others, it is intake triage because attorneys are absorbing work that should never reach them.

Don’t start with every workflow. Start with the point where you can clearly measure lost time, delayed response, or an overloaded team.

If you want a clear view of what to prioritize, Book a 60-min Omni Audit. In 60 minutes, we map the workflows creating leakage, identify the highest-value automation opportunities, and outline a practical implementation path. No deck and no vague recommendations.

Turn utilization into a management tool

The right utilization process gives a managing partner more than a monthly target report.

It shows where time goes before it is billed. It identifies which matters are eroding margin. It helps route new work to the right attorney. It separates a genuine staffing shortage from a workflow failure. And it gives attorneys a fairer conversation about capacity because the discussion is based on work, not assumptions.

For a firm with $80K to $250K in potential annual leakage, you don’t need to recover every dollar to make this worthwhile. Capturing a portion of missed time, reducing unnecessary attorney admin, and avoiding one premature hire can produce a material result.

The first step is to understand your firm’s actual workflow, data sources, and constraints. Book my Omni Audit to get the three outputs that matter: a view of where operational leakage sits, the agents that can address it, and a prioritized plan for implementation.