I Have 47 Open Matters and a Spreadsheet: A Recovery Story

Let’s be honest about the spreadsheet.

It started as a quick fix. A simple grid: client name, matter type, status, next deadline. Maybe a second tab for billing. It was clean and manageable when you had eight matters and a new practice.

Now you have 47 open matters. The spreadsheet has 14 tabs. There’s a color-coding system that made sense when you created it but now requires a legend you stopped updating in 2023. The billing tab doesn’t quite reconcile with QuickBooks because you stopped transferring entries in real time sometime around matter number 30. There’s a formula somewhere that references a deleted column, but you haven’t tracked it down because everything still mostly adds up.

You know the spreadsheet isn’t ideal. You’ve known for years. But it works. Or at least, it works enough that the pain of switching hasn’t exceeded the pain of staying.

This post isn’t here to tell you you’re wrong. You built a functioning practice with basic tools and professional discipline. Sixty-three percent of solo attorneys don’t use case management software. You’re not behind the curve — you are the curve.

But there’s a cost to “mostly works” that’s worth quantifying. Not to make you feel bad about the spreadsheet. To help you decide whether the math has finally tipped.

What the Spreadsheet Costs You (That You Can’t See on the Spreadsheet)

The time reconstruction tax. Here’s the most expensive problem: you almost certainly don’t track time in the spreadsheet as you work. You track it later — at the end of the day, the end of the week, or whenever you sit down to invoice. You reconstruct your hours from memory, calendar entries, and sent emails.

Thomson Reuters research puts a number on this: attorneys who bill contemporaneously — recording time as tasks happen — capture 25–40% more revenue than those who reconstruct. That’s not a feature of any particular software. It’s a feature of the behavior that software enables: recording a time entry when you close a call, finish a draft, or send an email, because the tool makes it take five seconds instead of navigating to the right spreadsheet tab, finding the right row, and entering a formula-compatible entry.

At the average solo rate of $288/hour, a 25% improvement in time capture across a year is tens of thousands of dollars. Not because you’re working more — because you’re recording more of the work you already do.

The version control problem. Spreadsheets are single-state documents. There’s one version. If you update a client’s address and accidentally overwrite a phone number, the old phone number is gone. If you delete a row from the billing tab that you meant to archive, it’s gone unless you’ve been maniacally backing up copies — which creates its own problem: eight copies of “Master Client List” with subtle differences between them.

Practice management software maintains history by default. Every change is logged. Every prior state is recoverable. This isn’t a luxury feature — it’s insurance against the kind of small data errors that compound over months and years.

The context switching tax. Your spreadsheet doesn’t know about your email. Your email doesn’t know about your calendar. Your calendar doesn’t know about your billing. Every time you switch between these tools to piece together the status of a matter, you’re spending cognitive energy on navigation instead of legal work.

Research on information workers found that poor document management wastes roughly six hours per week — about $19,000 per year in productivity. For an attorney billing at $288/hour, the opportunity cost is higher.

A practice management system puts the matter, the time entries, the documents, the communications, and the deadlines in one place. You open a matter and see everything. The spreadsheet requires you to hold the connections in your head and navigate between four different tools to verify them.

The deadline risk. You’re tracking deadlines somewhere — calendar, spreadsheet, memory, a combination. If your system has worked so far, that’s a credit to your diligence, not to the system. The question isn’t whether your current method can track deadlines. It’s what happens when you’re sick for three days, or you take on five new matters in a week, or a court moves a hearing and you need to cascade-update every dependent deadline.

Missed deadlines are the leading cause of legal malpractice claims. A calendaring system with automated reminders, conflict checking, and dependent-deadline tracking isn’t about efficiency. It’s about risk management. Your spreadsheet can tell you what’s due Thursday. It can’t remind you Monday that Thursday is coming.

The Emotional Audit

The cost of the spreadsheet isn’t purely financial. There’s a background anxiety that comes with knowing your system depends entirely on your discipline and memory. You feel it on Sunday night when you realize you didn’t update the billing tab on Friday. You feel it when a client asks for a quick status update and you need to check three places before you can answer. You feel it when you think about taking a week off and wonder what will slip.

This anxiety is so normalized in solo practice that most attorneys don’t register it as a problem. It’s just the way things are. But it’s not the way things have to be.

The attorneys who have made the switch consistently describe the same feeling: relief. Not excitement about features. Relief that the system holds the information instead of their brain holding it.

”But I’ve Made It This Far”

This is the strongest argument for the spreadsheet, and it’s a fair one. You have a functioning practice. You have clients. You’re making a living. The spreadsheet got you here.

The counterargument isn’t that the spreadsheet will fail catastrophically. It’s that the gap between where you are and where you could be is wider than it feels.

Solo lawyers who adopted better tools are billing 75% more and collecting 80% more than solos were billing in 2016. Realization rates have improved 9% for solos and 7% for small firms. The attorneys closing that gap aren’t working longer hours. They’re capturing more of the hours they’re already working.

There’s also a forward-looking argument. Forty states plus DC now require technology competence as part of the duty of competent representation. Client expectations are shifting — 38% of prospective clients consider a lawyer’s technology when hiring. The spreadsheet isn’t just competing against practice management software. It’s competing against clients’ rising expectations and the bar’s evolving standards.

And there’s the question you might not have considered yet: what happens when you want to sell your practice or retire? A firm’s value is partly based on the systems and processes a buyer can inherit. Client data in spreadsheets, billing records in QuickBooks, deadlines on a desk calendar, and institutional knowledge in your head — that’s not a practice someone else can take over. That’s a set of relationships that disappear when you do.

What “Switching” Actually Looks Like

The word “switching” makes it sound bigger than it is for a spreadsheet attorney. You’re not migrating from one complex system to another. You’re going from informal to formal. That’s actually easier than switching between platforms.

You don’t have proprietary data formats to export. You don’t have workflows built in a system that doesn’t map to the new one. You have spreadsheets and files — and those import cleanly into any modern practice management tool.

The typical process: sign up and send your first invoice within the hour. Enter your active matters that afternoon — you have 47, not 4,700. Start tracking time on new work in the new system. Migrate historical data as needed, or just set a clean starting date and leave the old spreadsheet as an archive.

You don’t need to go all-in on day one. Start with the features that directly affect revenue: time tracking and billing. When those are running smoothly, add matter management, calendaring, and client communication. Build the habit incrementally rather than trying to change everything at once.

Migrations from spreadsheets typically take 2–4 weeks, not months. The intimidation factor is worse than the actual process.

The Math, One More Time

Your spreadsheet is free. Practice management software costs $170–$948/year for a solo attorney, depending on the platform and tier.

Your spreadsheet also costs you 25–40% of your billable time in capture losses. At $288/hour, even a conservative 25% improvement over a year of billing dwarfs any software cost by a factor of 50 or more.

You don’t have to do this. You can keep the spreadsheet and the system that’s gotten you to 47 matters. But if you’ve read this far, some part of you already knows the answer.

You know it’s time.

---

This post is part of the “Compared to What?” series — examining the real costs of the tools solo attorneys use instead of practice management software. Next: “Your Email Inbox Is Not a Case Management System (Even Though It Feels Like One).”

---

Ready to retire the spreadsheet? Writly was built for this exact transition — simple enough to send your first invoice in an hour, affordable enough that it pays for itself in your first billing cycle. See how it works →