← Legal technology

The Hidden Cost of Poor Law-Firm Data Structure

Why important matter information gets trapped in notes and spreadsheets, and how a cleaner field structure improves search, reporting, automation, and migration.

Most firms do not have a data problem because they lack information. They have a structure problem: the information exists, but it is stored in places that software and colleagues cannot reliably interpret.

A limitations date may appear in a note, the calendar, a task description, a spreadsheet, and someone’s memory. The client’s industry may be part of a contact name in one matter and a free-text intake answer in another. When the firm needs a report, a conflict check, a document, or a migration, these inconsistencies become expensive.

Structured data is information with a defined meaning

Compare these two records:

Notes: Client called. Accident was 5/14/26. Statute possibly 5/14/28. Referred by Maria.

and:

  • Incident date: May 14, 2026
  • Limitations date: May 14, 2028
  • Limitations status: Requires lawyer verification
  • Referral source: Maria Santos
  • Referral type: Former client

The note may remain useful context. The fields make the information sortable, reportable, reusable, and subject to validation.

The cost appears in ordinary work

Search becomes guesswork

People must remember the words someone else used. “Demand sent,” “demand package,” and “sent demand” may represent the same stage while producing different search results.

Reports become manual projects

If practice area, matter stage, referral source, expected value, and key dates are stored inconsistently, management questions require spreadsheet cleanup rather than a reliable query.

Automation becomes brittle

A workflow cannot safely create the next task or document when the event that triggers it is buried in prose. Automation works best when important state is explicit.

AI receives ambiguous context

AI can extract structure from text, but extraction introduces uncertainty. When the underlying system already distinguishes a verified fact, an allegation, an estimate, a deadline, and a source, both human and machine assistance become safer.

Migration magnifies every inconsistency

Changing software does not create poor data; it exposes it. Duplicate contacts, unnamed custom fields, inconsistent dates, and unexplained codes must eventually be mapped or abandoned.

Native fields are rarely enough

General practice-management systems usually provide contacts, matters, tasks, documents, time, and billing. Different practices need additional concepts.

An immigration practice may track petition type, receipt number, priority date, and derivative beneficiaries. Personal-injury work may require incident facts, providers, liens, insurance coverage, and damages. Estate planning may need family relationships, asset categories, fiduciaries, and execution status.

When the software treats those fields as secondary decorations, firms retreat to spreadsheets. A durable system should treat well-defined custom fields as seriously as built-in fields: searchable, validated, reportable, exportable, permission-aware, and available to workflows.

Design a field deliberately

Before adding one, answer:

  1. What question does this field answer?
  2. Does it apply to a person, organization, matter, document, event, or transaction?
  3. What data type should it use: date, number, currency, choice, relationship, or text?
  4. Who supplies the value?
  5. Who verifies it?
  6. Can the value change, and should history be retained?
  7. Is it confidential enough to require narrower access?
  8. Will it drive a deadline, document, alert, workflow, or report?
  9. How should it appear in an export?

Use free text for narrative and nuance, not as the default for information that has a stable meaning.

Distinguish fact, source, and confidence

For consequential information, one value may not be enough. A limitations date may need:

  • the proposed date;
  • the event or rule from which it was calculated;
  • the source document;
  • the person or system that entered it;
  • verification status;
  • the reviewing lawyer; and
  • the review timestamp.

This structure is particularly important when AI assists with extraction or calculation. The system should not make a machine-proposed value indistinguishable from a lawyer-verified one.

Start small

Choose one practice area and one recurring workflow. Identify the ten or fifteen pieces of information people repeatedly search for, retype, or reconstruct. Define them carefully, clean active matters first, and make responsibility for each field part of the workflow.

Then measure whether the structure answers useful questions: Which matters are waiting on a client? Which deadlines remain unverified? Which referral relationships produce the right work? Where is capacity constrained? Which documents can be assembled from approved facts?

Good data structure is part of legal quality and operational control. It lets a firm improve its systems without rebuilding institutional knowledge each time the software changes.

This article is general information for legal professionals, not legal advice or an ethics opinion. Rules of professional conduct vary by jurisdiction—consult yours.

Usus founders program

Help shape legal AI that shows its work

Tell us a little about you and the legal work you want technology to handle more rigorously. Lu Jin will review every submission.

By submitting, you agree that Usus may contact you about the founders program and related product updates. Read our privacy notice.