Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. Can We Stop Relying on a Spreadsheet to Track Undertakings Given by Our Staff?
Problems We Solve

Can We Stop Relying on a Spreadsheet to Track Undertakings Given by Our Staff?

Undertakings tracked in a spreadsheet get missed when a fee earner forgets to log one. How we build a law firm undertakings register tied to each matter.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Undertakings get missed when the register depends on fee earners remembering to add a row to a spreadsheet and remembering to mark it discharged. We build a register tied to each matter that spots likely undertakings in outgoing letters and emails, asks the fee earner to confirm and log them, tracks them to discharge, and warns supervisors about open ones on closing files. Whether something is an undertaking remains the fee earner's and firm's judgement.

A spreadsheet on the shared drive

Your firm has an undertakings register. It is a spreadsheet, or a tab in one, and every fee earner is supposed to add a row whenever they give an undertaking and update it when it is discharged. Some do, carefully. Some remember a week later. Some give undertakings in the body of an email and do not think of them as undertakings at all.

When a supervisor asks for a list of open undertakings for a departing fee earner, someone has to read through months of sent items to be sure.

Why the register is always incomplete

The register is separate from the work. Undertakings are given in letters, emails, completion correspondence and phone calls confirmed in writing, and the register is somewhere else entirely. Adding to it is an extra step, and extra steps get skipped when people are busy.

Discharge is even harder to track. The fee earner knows the undertaking was met, but updating the spreadsheet is an afterthought, so the register fills with entries that look open but are not, which makes people trust it less.

ProblemEffect
Logging is a separate stepUndertakings never make it into the register
Discharge not recordedRegister shows stale open entries
Undertakings in informal emailsGiven without anyone realising
Register not linked to mattersOpen undertakings missed at file closure

What a missed undertaking costs

Failing to meet an undertaking is treated seriously, and it is personal to the individual who gave it as well as the firm. Even where nothing goes wrong, an incomplete register means a supervisor or compliance lead cannot show they have oversight, and file reviews find gaps.

The spreadsheet itself becomes a burden: long, unreliable and checked mostly in a panic.

How we build a matter-linked register

  1. Register inside the workflow: each undertaking is a record on the matter, with who gave it, to whom, what it requires, when and the source document.
  2. Spotting candidates: outgoing letters and emails on each matter are scanned for wording your firm identifies as indicating an undertaking. Matches are shown to the fee earner, who confirms whether to log them.
  3. Quick logging: confirming creates the register entry with the source document attached. Fee earners can also add one manually in a few fields.
  4. Tracking to discharge: each open undertaking has a review date. The fee earner is prompted to mark it discharged with evidence, or to update the expected date.
  5. Supervisor view: supervisors and your compliance lead see all open undertakings by team, by age and by fee earner.
  6. Closure and leavers: a matter cannot pass the closure checklist with an open undertaking, and a departing fee earner's open undertakings are listed for reallocation.

The detection is deliberately cautious. It asks the question rather than deciding, because what counts as an undertaking depends on the wording and context.

What the register becomes

Instead of a spreadsheet that everyone suspects is incomplete, the firm has a list that is built from the actual correspondence and kept up to date by prompts. Supervisors can answer 'what is outstanding?' in a minute. Leavers' undertakings are handed over rather than discovered.

Fee earners also get a gentle reminder when they have phrased something as an undertaking without meaning to, which some find the most useful part.

You might need this if

  • Your undertakings register is a spreadsheet updated by hand.
  • It contains old entries that are probably discharged but not marked.
  • Undertakings are sometimes given in emails without being logged.
  • Checking a leaver's undertakings means searching their sent items.
  • File closure does not check for open undertakings.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does the tool decide what is an undertaking?

No. It flags wording your firm tells it to look for and asks the fee earner. Whether something is an undertaking is the fee earner's and your firm's judgement.

Can we import our existing spreadsheet?

Yes. We import it and link entries to matters where the references allow, and flag rows we cannot match for someone to review.

Does it read every email?

It reads outgoing correspondence on matters, as your firm configures it. What is scanned and who can see results is set by your policy.

Will it work with our practice management system?

It can sit alongside it or inside it, depending on the system's API. Linking to matters and closure is the important part, and we confirm how that works for your system first.

Keep reading

More on Problems We Solve

Start here

Tell us where matter admin slows your firm down

Describe the task, the practice management system you use and who does the work today. We will tell you what we would automate, what must stay with a fee earner or your compliance team, and if a setting in your existing system would fix it, we will say so instead.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →