In-House Litigation Matter Tracker Template for Excel

What a litigation matter tracker is

A D&O insurance renewal application asks for every open matter with a settlement demand large enough to need board sign-off, as of the application date. The general counsel’s answer lives in three places: a folder of PDFs from outside counsel, a monthly status email, and a spreadsheet someone updates when they remember to. None of the three agree on what the current exposure figure actually is. This litigation matter tracker template for Excel keeps that figure in one place, dated, before the next renewal or board meeting asks again.

Most litigation tracking spreadsheet templates are a flat list: matter name, one exposure number, a closed date. That structure erases what a legal department needs on file — how the exposure estimate moved, whether a litigation hold reached everyone it should have, and whether last year’s consent order still has a report due. This register keeps the history instead of overwriting it.

The result is a corporate litigation tracker excel workbook that records where matters stand, what they might cost, and what they obligate the organization to preserve or report, while the actual legal work stays with outside counsel.

What’s inside the Excel workbook

This litigation matter tracker template ships as one Excel workbook, nine sheets deep — a Start Here tab, then eight data sheets covering matters, parties, settlements, holds, exposure, documents, orders, and order reports:

• Start Here — column conventions and the row-not-overwrite habit
• Matters — 26 fields
• Matter Parties — 4 fields
• Matter Settlements — 9 fields
• Litigation Holds — 6 fields
• Matter Exposure Assessments — 11 fields
• Matter Documents — 6 fields
• Matter Orders — 10 fields
• Order Reports — 6 fields

That’s 78 tracked fields across the eight data sheets. Thirteen pre-built dropdown lists cover matter type, stage, party role, payment direction, and document type, among others, so a value never drifts into free text.

Matters and jurisdiction

Matters carries 26 fields — name, counsel, forum, jurisdiction, and current stage, plus links back to the contract, property, or insurance policy involved. When a regulatory inquiry escalates into a lawsuit, that’s a type change on the same record, not a new one to reconcile.

Jurisdiction splits into country and subdivision, structured rather than typed free-hand. Matter type spans lawsuit, arbitration, mediation, regulatory inquiry, internal investigation, and government proceeding.

Exposure and reserves

Matter Exposure Assessments — 11 fields — is where most litigation tracking spreadsheet templates stop short. Instead of one overwritten number, every assessment gets its own dated row: likelihood, a low-high loss range, the reserve recorded, and the basis for it.

That distinction answers what a board or an insurer actually asks — not just today’s exposure, but how the estimate moved.

Holds, settlements, and orders

Litigation Holds — 6 fields — treats every hold as its own record: issued date, scope, released date, and a next review date, so an open hold doesn’t go unnoticed after the matter looks closed.

Matter Settlements — 9 fields — separates “agreed” from “paid”: settlement amount and payment direction sit beside a paid-on date and payment reference. Matter Orders and Order Reports — 10 and 6 fields — track what a consent order or undertaking requires after a matter’s closed date, each filed report its own dated row.

How to use the template

A regulatory inquiry lands, and the first question is simple: which entity, and what’s the exposure. An inbox search takes a day; a register takes a lookup. Building a litigation matter tracker from these eight sheets follows a short, repeatable sequence.

1. Log one row per matter in the Matters sheet. Name, type, forum, and jurisdiction go on every row first.
2. Add every party on its own row in Matter Parties. Record the role each one plays — plaintiff, defendant, or co-defendant.
3. Log a new exposure assessment at every material update, not just at filing. Give each one its own row.
4. Issue litigation holds the day preservation duty triggers, and set a next review date. Never leave a hold without review history behind it.
5. Record settlements and orders as they close. Log every report an order requires as its own row.

One row per matter

Matters rows should map one-to-one with the underlying dispute; parties, settlements, holds, exposure, documents, and orders all live on their own sheets, keyed back to that matter. A matter that escalates from inquiry to lawsuit is a type change on the existing row, not a second one to reconcile.

Tracking exposure over time

As a litigation exposure tracking template, this sheet only works as a log, not a field to overwrite. Add a new row at every material update — a motion ruling, a settlement offer, a change in counsel’s assessment — so the current exposure figure has a history behind it.

Built for a multi-entity legal department

A single-matter spreadsheet assumes one entity, one lawsuit — workable, right up until a second entity, a regulatory inquiry, and an internal investigation are all open at once. Filtering Matters and Matter Parties by entity turns that single list into a per-subsidiary view — which matters a given entity is party to, not just which counterparty sits opposite.

Jurisdiction is recorded as country plus subdivision, not free text, so a portfolio spanning multiple states or countries sorts by jurisdiction instead of getting reconstructed by hand later. Most corporate litigation tracker excel builds assume a single entity; this register assumes a corporate family with matters open in more than one place at once.

In-house counsel and legal operations teams feel that gap first — the moment a spreadsheet built for one lawsuit has to answer for a dozen, right when a D&O renewal or a board update asks for exactly that answer.

When a spreadsheet stops working

This register takes most legal departments a long way, but it has real edges. There’s no version history, so an overwritten exposure figure loses its past, and reconstructing an earlier estimate means doing it by hand. With more than one person editing the workbook, nothing controls who can see which matters, and nothing sends a reminder before a hold’s next review date or an order’s next report comes due.

None of that means the spreadsheet was the wrong place to start. This template’s column headers match Lextree’s import templates, so it loads directly into Lextree’s Matters module — no re-keying, no remapping. From there, review dates and report deadlines drive reminders on their own, connected to the same contracts, properties, and policies the matter already touches.

Frequently asked questions

What is a litigation matter tracker? A structured record of every legal matter an organization is involved in — lawsuits, arbitrations, regulatory inquiries, and internal investigations — with the parties, financial exposure, and obligations that outlive the matter itself, kept current enough that “where do things stand” has an answer without a call to outside counsel.

What should a litigation matter tracker include? At minimum: matter name, type, forum, jurisdiction, and current stage. A complete tracker also records every party and their role, dated exposure assessments instead of one static number, litigation holds with review dates, settlement terms with proof of payment, and any consent order or undertaking that continues after the matter closes.

Who is this litigation matter tracker template for? In-house counsel, corporate legal operations, and compliance teams tracking matters across a multi-entity organization — where a flat spreadsheet row per lawsuit stops answering which entity, which policy, and which reserve once more than a handful of matters are open at once.

What’s the difference between this and a basic litigation tracking spreadsheet? A basic spreadsheet is a flat list: matter name, one exposure figure, a closed date. This litigation matter tracker template separates exposure into dated assessments, holds into their own sheet with review dates, and settlements and post-closure orders into records that survive the matter’s closed date — the history a single-row list overwrites.

How do I track litigation holds in Excel? The Litigation Holds sheet holds one row per hold — issued date, scope of what’s covered, released date, and a next review date. It ties back to the matter that triggered it, so a hold that’s still open after the underlying matter looks closed is visible instead of forgotten.

How do I track litigation exposure and reserves? Matter Exposure Assessments is a dated log, not a single field — assessment date, assessor, likelihood, a low-high loss range, the reserve actually recorded, and the basis for the number. Every prior assessment stays on the sheet, so a reserve change has a trail behind it.

How do I track settlement payment due dates? Matter Settlements records the settlement date, settling party, amount, payment direction, payment due date, and a paid-on date with reference — so “agreed” and “actually paid” are two different facts, not one assumed from the other.

How do I track consent orders and undertakings after a matter closes? Matter Orders holds the instrument itself — order type, what it requires, when it expires, and the next report due — separate from the underlying matter’s closed date. Order Reports logs each filed report as its own dated row underneath it.

Can I track matters across multiple entities in Excel? Yes. Every matter and every party record ties back to the entity involved, so filtering by entity turns one flat list into a per-subsidiary view — which matters a given entity is party to, not just which counterparty sits opposite.

Does this replace outside counsel or a law firm’s practice software? No. This is a register — a system of record for the corporate legal team. It doesn’t replace legal advice or run an outside firm’s practice; it holds the facts — parties, exposure, holds, settlements, and orders — in one place.

Is the template really free? Yes. Enter your email below and the workbook is sent to your inbox — no credit card, no sales call.