Case management software vs a spreadsheet, Google Drive and a shared calendar
Plenty of firms run on Google Workspace or Microsoft 365 and do fine. Here is exactly where that stack holds, exactly where it breaks, and the one failure mode that should end the debate for you.
A spreadsheet, a Drive folder per client and a shared calendar is a real system. It is free, everyone already knows how to use it, it never has an outage you cannot work around, and plenty of profitable firms have run on it for a decade. Anyone who tells you it is unprofessional is selling something.
It also has three specific jobs it cannot do, and one of them is the reason this comparison usually ends. Below is where the DIY stack genuinely holds up, where it starts costing you quietly, and where it stops being a question of efficiency.
What the spreadsheet stack does well.
A matter list
Client, matter, stage, next date, responsible attorney. A sheet does this perfectly and sorts and filters better than some software. If your practice is thirty rows, a sheet is genuinely fine.
Document storage
One folder per matter in Drive or SharePoint, with version history and full-text search that is honestly very good. Storage is not the weak point people assume it is.
A calendar you already check
Deadlines land on the calendar your phone already alerts you from. Adoption is the hardest part of any system and this one has it solved.
Flat-fee billing
If you charge flat fees and invoice from a template, you do not need a billing engine. The complexity in legal billing comes from hourly work and trust draws.
What a sheet cannot assert
BalancedA trust ledger that proves it was never wrong.
A spreadsheet will calculate a three-way reconciliation. What it will not do is prevent the disbursement that overdraws one client using another client's money, and it will not tell you who changed a figure or when. Every cell is silently editable by anyone with the link, and a corrected mistake looks identical to a covered one. That distinction is the entire point of a trust record.
- No overdraft prevention. The sheet lets you type any number. The bar treats a momentary shortfall as a shortfall.
- No audit trail. Version history in Drive is not a ledger audit trail, and reconstructing it under scrutiny is not a position you want.
- Retention is on you. Most states want these records for five to seven years, in a form you can produce on demand.
The other two it cannot do.
A conflict check that covers everyone
Searching a matter sheet finds clients. A conflict check has to cover opposing parties, spouses, corporate affiliates, witnesses and every person named on every matter you have ever opened, including the consultations that never became files. That is a different data model, not a better search box. Family law generates these constantly.
Dates that live on the matter
A date in a personal calendar is one person's arithmetic, kept where only that person sees it. Count the interval once in a date calculator, in calendar or business days, and save it to the matter instead: the date sits with the file, the warnings reach whoever is covering it, and it survives the attorney who worked it out being on holiday the week it falls due.
The Drive question has a second layer for injury work.
A personal injury, medical malpractice, workers' compensation or disability practice keeps thousands of pages of somebody's health history. Two separate rules govern where that sits, and firms tend to argue about the wrong one. Whether HIPAA reaches you depends on your role: a plaintiff firm receiving its own client's records under an authorization is generally holding them as that client's representative rather than as a business associate, while a firm doing work for a hospital, plan or provider usually is a business associate and needs a signed agreement covering every service the records touch.
- A BAA exists, but not on the account you probably have. Google and Microsoft will both sign one for eligible paid editions, covering designated core services only. Free and personal accounts get no agreement at all, and a marketplace add-on you connect to the folder sits outside the scope of the one you do have.
- The real exposure is link sharing, not the platform. Both are secure enough. Neither stops somebody setting a folder of medical records to anyone-with-the-link to get a file to an expert quickly, and nothing in the interface treats that folder differently from a folder of stationery.
- One spreadsheet is a bigger blast radius than one file. A tracker with every client's name, injuries, treating providers and settlement posture is the single most sensitive object the firm owns, and it shares in one click like anything else in the drive.
Who can see this matter
Records attachedWhat actually happens is not a failure, it is a drift. The sheet stays accurate and everything around it stops matching: an email with a key agreement that lives in one inbox, a document saved to a desktop and never uploaded, a date changed on the calendar but not in the sheet. Nobody notices, because each gap is small and the system still looks right. Then someone leaves, or you are ill for a week, and the practice turns out to have been running on one person's memory with a spreadsheet attached.
Keep the sheet. Stop betting the trust account on it.
Your matter list, contacts and folders come across as they are, so nothing you have built is wasted. What you gain on day one is a client ledger that refuses to go negative, a conflict check across every party, and deadlines calculated rather than typed. Migration is included, and your data exports whole if you decide the sheet was right after all.
Common questions about the DIY stack.
Is Google Workspace or Microsoft 365 compliant enough for client data?
Can I do trust accounting in QuickBooks instead?
What about Airtable or a low-code build?
Will my spreadsheet import cleanly?
Is it worth it if I only bill flat fees?
The software that does this for you.
CaseFuze handles the ledger, the statement, and the checks. $49 per user per month.