Every IP practice runs on shadow spreadsheets. Three hidden risks. Here's the operations playbook for owning them, one spreadsheet at a time.
Every firm has them. Most don't see them. All of them carry risk.
A partner stops by a paralegal's desk on a Monday morning. "Where are we on the Watson family?"
She doesn't open the docket. She opens a spreadsheet. Tab three. Sorted by client, color-coded by status, filtered to the cases the partner asked about last quarter. Three sentences later, the partner has what he needed.
That spreadsheet doesn't appear in any IT inventory. No system administrator backs it up. Nobody trained anyone else on how to use it.
That's a shadow system. The team doesn't call it that. They call it "my spreadsheet," or "the list I keep," or "tab three." Every IP practice runs on dozens of them.
Why Do IP Firms Run on Shadow Spreadsheets?
Shadow systems aren't a sign of bad people. They're a sign of work that the firm's tools weren't designed to do.
A paralegal builds a spreadsheet because the docketing system doesn't show her the view she actually works from. An attorney keeps a personal list of client preferences because the matter management system doesn't store them. A docketer maintains a separate tickler for soft dates that the docket marks as "informational" but that she treats as real deadlines.
Each one starts as a workaround. None of them are temporary. The spreadsheet becomes a system. The list becomes the reference. The personal tickler becomes the way the firm actually runs.
And the firm starts depending on it without ever deciding to.
IT calls these "shadow IT." Operations calls them "spreadsheets that work." Both are looking at the same risk.
What Are the Risks of Running an IP Practice on Spreadsheets?
Shadow systems hide three risks that traditional firm tools weren't built to surface.
One: a single point of failure.
The paralegal who maintains the citation grid leaves in March. Half her notes come with her. Half don't. The new hire opens the file and asks the obvious questions. Why is column F highlighted yellow on some rows? What does "RT" mean in the comments? Which of these references are confirmed and which are pending? Nobody knows. The institutional knowledge that kept the system running just walked out the door.
This isn't a hypothetical. Every IP team that's been around for a decade has lived this.
Two: version drift.
A shared file gets copied. Now there are two. Someone updates one and not the other. A week later, the status report goes to the client with last month's data. The client asks why three matters disappeared from the list. Nobody can explain it because the version that had them was overwritten in a save-as.
The file looked right. The data was wrong. Nobody knew until the client noticed.
Three: no audit trail.
A client emails. "When did you change my reporting preferences?" The spreadsheet that tracks client preferences shows the current state. It doesn't show when it changed, who changed it, or why. The answer to the client's question doesn't exist anywhere the firm can find.
In a docketing system, that question would have a timestamped answer. In a spreadsheet that nobody owns, the answer is a guess.
How Should IP Operations Own a Spreadsheet?
The point of operations isn't to kill every spreadsheet. The point is to know which ones you have, who owns them, and what would happen if they disappeared.
When a shadow system is owned by operations, three things change.
It has a documented owner. Not "the paralegal who built it." An explicit assignment, with a backup. If the owner leaves, the file doesn't leave with her.
It has a defined relationship to the firm's primary systems. Either the spreadsheet is the system of record (and is treated like one, with backups and access controls), or it's a working file that pulls from the system of record (and gets refreshed on a schedule, not by hand).
It has a sunset condition. Most shadow systems exist because a real system has a gap. When the gap closes, the spreadsheet retires. Naming the gap is the first step toward closing it.
Three things: an owner, a relationship, an exit. Apply them one spreadsheet at a time.
This is the work IP operations owns that no docketing system can do for you.
How Do You Find Shadow Systems in Your IP Practice?
You don't need a six-month audit. You need one question and one afternoon.
Ask your team: "What spreadsheet would scare you most if you lost it?"
The answers come fast. The citation grid for the top client. The status tracker the partners look at on Friday mornings. The foreign agent contact list nobody else has. The new-hire training doc that captures everything the official onboarding misses.
Pick the one that scares the most people. Document who owns it. Write down what it tracks, where the data comes from, and what would break if it disappeared. And that document is the first artifact of treating IP operations as a real function, not a side effect of docketing.
You don't have to fix it this week. You just have to see it.
If you run the practice, ask one person on your operations team to make this list and bring it to you. Then read it like a risk register. Because that's what it is.
The Bigger Picture
Every shadow system tells you something. It tells you what the firm's tools don't do, what work doesn't get credit, and where the practice would stall if one person took a long vacation.
Most firms have never made the list. Not because the work isn't important. Because the people who could make it are too busy maintaining it. That's the place to start.
If you want the full picture of what IP operations actually covers, we wrote a longer piece on the topic: What Is IP Operations?. And if you're starting to suspect that the gap you're seeing isn't a docketing problem at all, IP Operations Is Not Docketing is the place to go next.