Smaller law firms are stuck in the gap. The big practice management products (NetDocuments, iManage, Aderant) are sized and priced for AmLaw firms. The mid-market tools (Clio, MyCase, PracticePanther) work but charge per-attorney and force firms into their workflow rather than the other way around. Many smaller firms end up with a mix of spreadsheets, email, and partial use of a paid tool — paying for software they barely use.
A custom no-code system gives a small or mid-sized firm matter management, intake automation, document tracking, and billing operations built around the way the firm actually works. Built on Airtable with Make for the automation layer, it covers most of what dedicated legal tools do at a fraction of the cost.
What a Law Firm Operations System Looks Like
Matter Management as a Real Database
The core of any legal operations system is the matter database. Every active and closed matter has one record. Linked to it:
- The client (which is itself linked to all their matters)
- The responsible attorney and paralegal
- All deadlines and statutes
- All documents (or references to where the documents live)
- All time entries
- All invoices
- A communication log
Open the matter, see everything. A partner reviewing the matter doesn't have to ask anyone what's happening — the record shows status, last activity, upcoming deadlines, and current WIP value.
Views slice the data different ways:
- By attorney for an associate's "my open matters"
- By practice area for departmental management
- By status as a Kanban (Active → Discovery → Trial Prep → Closed)
- By deadline for "what's due this week"
For the relational patterns underneath, see our linked records guide.
Intake That Doesn't Eat a Day
New matter intake is the single most repetitive workflow in a small firm. Conflict check, engagement letter, retainer collection, file setup, calendar entry, billing setup — repeated for every new matter, often spread across multiple staff and a couple of days.
A structured intake workflow collapses this to about 30 minutes of work and a few automation triggers:
- Inquiry comes in via Softr form, website lead, or referral
- Conflict check runs automatically against Clients, Opposing Counsel, and Adverse Parties tables — surfaces hits for human review
- Initial scoping call happens (still human)
- Engagement letter generated from template, populated with matter details, sent for e-signature
- Trust deposit collected (link to client portal or accounting system)
- Folder structure created in Drive/SharePoint automatically
- Matter record opened with deadlines pre-populated based on practice area template
- Welcome email sent to client with portal link
The first matter takes the longest to set up (configuring the templates). The 10th takes minutes.
Document Tracking Without Replacing Your Document System
Documents typically live in Drive, OneDrive, SharePoint, or Dropbox — and they should stay there. Lawyers know those tools. The legal-specific document management systems (NetDocuments, iManage) are expensive and overkill for smaller firms.
What we add: a Documents table in Airtable that holds metadata about each document, not the document itself. For each document:
- Type (pleading, contract, email, exhibit, memo)
- Version (Draft v3, Final, Filed)
- Status (Draft, Under Review, Finalized, Filed)
- Author and date
- Matter (linked)
- URL to the actual file
A view filtered to a matter shows every document associated with it, regardless of where it lives in storage. Search by type ("show all pleadings in matter X"), by status ("which contracts are still in draft?"), by author.
The discipline is that the metadata record gets created when the file is created. A Make scenario can watch your Drive folder and auto-create Airtable records when new files appear, capturing as much metadata as possible from the filename.
Deadline Tracking That Doesn't Depend on Memory
Statute of limitations, response deadlines, discovery cut-offs, trial dates — every matter has a calendar of must-hit deadlines and the consequences of missing one are professionally severe.
The deadline system:
- Deadline records linked to matters, with type, date, and responsible attorney
- Practice area templates that pre-populate common deadlines when a matter opens (e.g., for a new civil litigation matter, automatic deadlines for answer, scheduling order, discovery cutoff)
- Calculated dates for relative deadlines ("answer due 30 days from service")
- Daily deadline report to each attorney showing what's due today, this week, and in 30 days
- Escalation reminders at 30/14/7/1 days
Every morning each attorney gets an email of their deadlines. The firm's malpractice exposure from missed dates drops to near zero.
Time Tracking and Billing Prep
Most small firms have time entry tools but billing prep is still a manual reconciliation exercise. Time entries are scattered, some attorneys haven't entered theirs yet, some entries are too vague to bill against, write-offs happen at the last minute.
We build the operational layer that surfaces:
- Daily missing-time report — attorneys who haven't entered time for yesterday
- Pre-billing review for each matter showing all WIP grouped by attorney, with the description text editable before invoicing
- WIP aging report showing unbilled time over 60 days
- Realization tracking — billed vs collected, by attorney and matter
When billing prep is structured this way, monthly billing becomes a half-day exercise instead of three.
Invoicing connects to Xero or QuickBooks for the accounting side. Trust accounting stays in your trust-compliant tool (Clio, LeanLaw) — we don't try to replace that piece.
The Tools We Use and Why
Airtable Business is the structured database for matters, clients, deadlines, and documents. Business plan unlocks field-level permissions critical for confidentiality and the audit logging required for ethics compliance.
Make Pro handles automation — intake workflow steps, document generation, deadline reminders, daily reports.
Softr Business powers client-facing portals where appropriate — secure document delivery, status updates, intake forms.
Microsoft 365 or Google Workspace stays as your document storage and email. We integrate; we don't replace.
Xero or QuickBooks for accounting and operating account invoicing. Trust accounting stays in your dedicated tool if you have one.
Real Results from Law Firms We've Worked With
Our legal operations clients typically see:
- 3-5 hours/week per attorney saved on operational work (status checking, file finding, time entry follow-up)
- 40-60% faster matter intake — new matters opened the day of intake rather than 2-3 days later
- Zero missed deadlines in firms running the deadline reminder system as designed
- 15-25% reduction in billing leakage — time captured that previously got forgotten or dropped
For a 5-attorney firm, this typically pays back the implementation in 4-8 months and continues compounding.
Who This Is For
This solution fits small to mid-sized firms (1-30 attorneys) in matter-driven practice areas:
- Civil litigation, family law, immigration, IP, transactional, regulatory
- Firms currently using spreadsheets, email folders, and partial-use of a paid tool
- Practices that have outgrown DIY but find Clio or PracticePanther over-priced for their needs
- Firms with a managing partner or office manager willing to lead the operational change
Less of a fit for:
- High-volume practices (PI mills, debt collection) that need specialized industry software
- AmLaw firms — they need (and can afford) the enterprise document management and conflicts systems
- Firms with regulatory court e-filing as a daily integration requirement
- Practices where trust accounting needs are central — those need Clio or equivalent
Where to Go Next
For the underlying patterns, our contact management tutorial covers the relational base most legal operations sit on top of. For the document automation side, the mail merge guide shows how engagement letters and routine documents get generated.
To discuss a specific firm setup, get in touch and we'll walk through your matter workflow.
