← All Resources

Legal Ops Scorecard Template: A Free Excel Workbook

The Legal Scorecard Workbook is an Excel file you fill in each month. You paste in exports from your intake, matter, docket and invoice sources, and its Scorecard tab calculates the one-page board view. Sample data from a made-up company is already in it, so you can watch the page work before you add your own.

Get the Excel workbook. Open it, read the Start here tab, paste in your own exports. The Scorecard tab calculates itself from the data tabs.

Download the workbook

What the workbook is

It is a working Excel file (.xlsx) with ten tabs. One tab is instructions. One tab, Scorecard, is the page you show the board: eight numbers under five questions, each with a status, a trend, a confidence flag and a read. The other eight hold the bar you set and the data behind the page.

It is the build-it-by-hand track from the Scorecard Build Blueprint. To read what a board-level Legal Scorecard is and why it asks these five questions, start with the ebook.

What is in it

The Scorecard tab answers five questions with eight numbers.

1

Are we on top of the whole workload?

Work in vs. work clearedShadow demand
2

Is the business unblocked, and are matters moving?

Time to first responseStalled-matter rate
3

Are we protected?

Critical-date coverage
4

Are we growing capacity faster than headcount?

Self-serve rateLoad per lawyer
5

Is spend under control?

Outside counsel spend vs budget, with forecast

Each data tab is filled from a report you already pull, a list you keep, or, for Shadow demand, a reconciliation you run.

TabWhat it holds
Start hereHow the workbook works and the monthly routine
ScorecardThe one page. It fills itself, and you write the read.
TargetsWhat good looks like, the watch bands and last period’s values
RequestsReceived time, first human touch and how each request resolved
MattersOpen and close dates, native status, last activity, category and owner
Status mapEach native status mapped to one of five standard statuses
Critical datesOne row per date, with its matter, owner and source
SpendInvoiced to date and accruals per matter, and the phased department budget
RosterEach lawyer, in-house or an outside provider
Shadow demandThe traces you reconcile each period, and the prior count

The sample data is fictional, built for a made-up company called Northwind Industries. It is set up so every line on the Scorecard tab matches the example page in the ebook, which lets you check the workbook is calculating before you trust it with your own numbers.

How to use it

Set it up once, then run the routine each month.

Set it up

Run the monthly routine

Three things that make it stand up to a challenge

Identity, not labels. Every status mapping has a Map ID and an effective date, and every request carries a Dept ID from the Departments list. Names typed by hand cannot be grouped, trended, or audited. The Status map also counts the matters using each mapping and names one, so you can validate a rule instead of trusting it.

The audit trail. Keep the Map ID and Effective From columns current. When someone asks in six months why the stalled number moved, that trail is how you show a mapping changed rather than the work changing.

Declare your capacity basis. Whether outside counsel counts as capacity is a strategic decision, not a formula. Set it once on the Targets tab. The page names the assumption and shows the number both ways, so nobody reads load per lawyer without knowing what is in it.

When the monthly pull becomes the work

The workbook runs on exports and on a person who pulls them. LegalOperator produces a Legal Ops Scorecard in the app or as an emailed PDF. See how legal spend works in LegalOperator.

Common questions

What is the Legal Scorecard Workbook?

It is a free Excel file with ten tabs. You paste in exports from your intake, matter, docket and invoice sources, and the Scorecard tab calculates a one-page view of eight numbers under five questions. Sample data from a made-up company is already in it.

Is there a form, or a charge?

No. The download is a direct link to the file, with no form and no email address asked for.

Do I need LegalOperator or another system to use it?

No. Each tab is filled from a report you can already pull or a log you keep by hand. The workbook does not connect to any system.

Who writes the read on each line?

A person on your team types it. The workbook calculates the number, the status and the trend, and it does not write the read.

How do I check the workbook is calculating before I use my own data?

The sample data is built for a fictional company, Northwind Industries, and every line on the Scorecard tab matches the example page in the ebook. Compare the two, then replace the sample rows with your own export.

Where do I read what a board-level Legal Scorecard is?

In the ebook, How to Build a Board-Level Legal Scorecard. The workbook is the companion that builds the page it describes.

Craig Raeburn

Craig Raeburn

Craig Raeburn is a co-founder of LegalOperator. He has worked in legal technology since 1991 and ran customer success, product and sales at several legal technology vendors, from TyMetrix to SimpleLegal.

Want to see LegalOperator?

Book a demo and we walk through LegalOperator in the demo environment, with sample data.

Book a demo