Billing in one system, hours in another, case status in a spreadsheet, new leads in someone’s inbox. Without one place to see it all, a simple question like “how’s the firm doing?” can take an afternoon to answer.
This free legal KPI template gives your firm one place to track billing, collections, utilization, cases, and leads. Paste in your data, and the dashboard does the math. It’s built for any lawyer who wants to see how the firm is really doing, not just the managing partner reviewing numbers once a quarter.
Download the legal KPI template
With a pre-built legal KPI template, you skip choosing metrics, writing formulas, and building charts. Your firm starts with a law firm dashboard already organized around billing, collections, utilization, cases, and leads.
This free legal KPI template downloads as either a Google Sheets legal dashboard template you can copy and edit right away, or an Excel spreadsheet with the formulas and formatting already built in. To get started:
-
Set your as-of date, attorneys, practice areas, and lead sources on the Lists tab
-
Replace the blue sample rows on the four data tabs with your own data
-
Open the Dashboard tab, where the scorecard and charts update on their own
-
Set your targets in the yellow cells
Ready to see your firm’s numbers in one place? Fill out the form to get your free template.
Download for: Excel | Google Sheets
What is a legal KPI template?
A legal KPI template is a spreadsheet where a law firm enters its billing, time, case, and lead data and sees key performance indicators calculated automatically.
Some firms call this a legal dashboard template, a law firm dashboard, or a law firm KPI dashboard. What sets it apart from a legal reporting or financial dashboard is where the data comes from. In a template, you enter or paste in your own data. In software like MyCase, a dashboard pulls billing, time, and case data in automatically.
By keeping your KPIs in one place, your firm:
-
Catches slipping collections before they hit cash flow
-
Sees where attorney time is actually going
-
Gives partners and staff the same view of how the firm is performing
A legal KPI template is usually the first step a firm takes before moving to automated legal reporting software.
Which KPIs should a legal KPI template track?
The most useful legal KPI templates track a short list of metrics relevant to running a law firm. Here’s what this one covers, whether you want a sample KPI for legal department reporting or a scorecard for your own firm. For a wider list, see our guide to law firm KPIs .
Financial and billing KPIs
Getting paid is the clearest sign of a healthy firm, and these five metrics show it from every angle.
-
Billed vs. collected: What you invoiced against what came in. Bill $30,000 and collect $27,000, and $3,000 is still out. A growing gap is an early warning that payments are slipping. The Dashboard shows both totals, and Report Tables tracks them by month.
-
Collection rate: Collected divided by billed. A slide over several months means invoices need follow-up. In the sample data, it’s 88.9% against a 90% target.
-
Billing realization rate: Billed divided by standard value (hours × your standard rate), which shows how much of your time’s value makes it onto invoices. If 100 hours at $300 are billed at $25,500, realization is 85%. A rate that keeps falling means more of your time is being written off.
-
Outstanding A/R: Money billed but not yet collected, sorted into aging buckets from not yet due to 61+ days past due. The Dashboard shows the total, and Report Tables breaks it out by age.
-
A/R over 60 days past due: The share of your A/R that’s 61 or more days late, the money most at risk of never arriving. In the sample data, it’s 35.5% against a 15% target.
MyCase also tracks financial metrics a spreadsheet can’t easily hold, like case revenue and profitability. See our guide to law firm financial metrics for more.
Attorney productivity KPIs
Billable time is one of your firm’s most valuable resources, and this metric shows how much of it goes to client work.
-
Utilization rate: Billable hours divided by total hours worked, taken from the Time Data tab. A falling rate means more time is going to admin work instead of client work. In the sample data, utilization is 58.6% against a 60% target.
-
Beyond the template: MyCase also tracks time and expenses across your firm, including unbilled time and each attorney’s workload.
Case management KPIs
A full caseload only helps if matters keep moving.
-
Open vs. closed cases: How many cases are open and how many are closed in each practice area, counted from the Case Data tab. If open cases keep climbing without matching closures, you may have a backlog.
-
Average case duration: The average number of days from open to close for your closed cases. Compare by practice area, since a probate matter and a misdemeanor won’t run on the same clock. In the sample data, closed cases average 152 days, under the 180-day target.
-
Beyond the template: Case Analytics in MyCase can show open cases by stage, with no manual tracking.
If you need a place to track each matter first, check out our free legal case management template .
Leads and intake KPIs
Every lead is something you worked to earn, and these metrics show where your intake is paying off.
-
Lead conversion rate: The share of leads that become clients, or clients signed divided by leads received. A low rate can point to slow follow-up or marketing that attracts the wrong inquiries. In the sample data, the rate is 37.3% against a 30% target.
-
Leads by referral source: Where your leads come from and how many from each source become clients, so you can see which channels are worth your marketing budget. In the sample data, paid ads convert at 55.6% while online directory leads convert at 0%.
-
Beyond the template: MyCase also tracks lead sources, so you can connect where a lead came from to the revenue that client brings in.
Goals and targets
A KPI without a target is just a number. A goal for each one turns a dashboard into something you can act on.
Base your targets on your own history, practice area, and size rather than industry benchmarks. A solo attorney’s utilization won’t look like a 10-attorney firm’s. Start with your last 6 to 12 months, then set a target that’s a realistic step better.
The Goal tracking table on the Dashboard compares each KPI’s actual result with your target, shows the variance, and marks it on target or off target. The default targets are starting points, so edit the yellow cells to match your firm’s goals.
Best practices for tracking legal KPIs
Most legal KPI templates calculate your numbers, but these four practices go further and help you act on them.
Start with a short list of KPIs
Tracking everything produces a dashboard nobody reads. Pick a handful of metrics tied to decisions you actually make, like which past-due invoices to chase or whether it’s time to hire. Drop any metric you’ve reviewed for three months without acting on.
Look at trends, not single months
One month can mislead you. Collections are counted against the month an invoice was issued, so recent months look low until payments arrive. In the sample data, September shows a 5.4% collection rate because those invoices aren’t due yet. Look at several months, and give recent ones time to catch up before you react.
Give each KPI an owner and a review rhythm
Match each KPI to the person who can act on it, like the managing partner for realization and utilization, whoever manages billing for collections and A/R, and whoever handles intake for lead conversion. Automated reporting also makes a regular review easier to keep up, since the numbers are already current when the meeting starts.
Keep definitions and data consistent
A KPI changes meaning if you calculate it differently each month. Decide once what counts as a converted lead or a closed case, pull your data from the same source each time, and set the as-of date to the day you pulled it.
Using a KPI spreadsheet vs. legal analytics software
For a small firm with a manageable number of matters, a KPI spreadsheet in Google Sheets or Excel is a good starting point. It’s free, flexible, and a practical way to learn which metrics matter most. But even small firms tend to find that a spreadsheet isn’t as effective as legal analytics software.
Keeping it current gets harder as your data grows, with billing, time, and case exports to paste in and fix every month. If you’re spending more time updating the spreadsheet than acting on it, manual entry and disconnected systems have become the real cost. A spreadsheet is a great place to start, and the natural next step is reporting where billing, time, and case data update on their own.
For more on what that looks like, see our guides to legal data analytics and the financial dashboard , or watch our webinar on law firm financial KPIs .
How 8am MyCase takes legal KPIs further
Once your firm has outgrown what a spreadsheet can track, MyCase takes over where the template leaves off. Legal Financial Reporting and Case Analytics keep the KPIs from this template up to date automatically from live billing, time, and case data, and add metrics the template doesn’t cover:
-
Legal Financial Reporting : Billed vs. collected, realization, and outstanding A/R update as invoices and payments are recorded.
-
Case Analytics : Open and closed cases and case duration come straight from the matters already in MyCase.
-
Time tracking : Hours tie directly to cases and invoices, so utilization and unbilled time reflect the work your team actually did.
-
Metrics beyond the template: Case revenue, firm time and expenses, and lead sources, alongside the rest of your firm’s data.
Start a free trial to see how MyCase can take your legal KPIs further.