A Simple CRM Setup for Small Law Firms (Without Buying Enterprise Software)

17 August 2026·6 min read

Quick answer: You don’t need a five-figure legal practice management suite to stop losing enquiries — you need one place every enquiry lands, a simple six-stage pipeline (New Enquiry → Contacted → Consult Booked → Consult Held → Engaged → Lost), and someone who actually updates it. A basic spreadsheet or a free-tier lightweight CRM will do this job perfectly well for most firms under about five lawyers. The full copy-paste structure is below. 📈

Here’s the truth about how most small firms are tracking new enquiries right now: it’s living in one lawyer’s personal inbox, scribbled on a legal pad next to the phone, or floating around as “I’m pretty sure I called them back.” Nobody designed that system on purpose — it just accumulated, one busy week at a time. And it works fine right up until a lead goes cold because the associate who took the call was in court all week, or the practice owner realises six months in that they have no idea how many enquiries actually turn into paying clients. You don’t need enterprise software to fix this. You need a system simple enough that your team will actually use it 💖

What most small law firms get wrong about tracking leads

Enquiries live in whoever answered the phone’s inbox, with zero visibility for the practice owner
There’s no record of “stuck” leads — enquiries that went quiet three weeks ago and nobody followed up
The firm buys a full legal practice management suite for the CRM features alone, then never configures the pipeline properly because it’s built for a 40-lawyer firm, not a 3-lawyer one
Nobody can answer “how many enquiries did we get this month, and how many became clients?” without manually digging through old emails
Different practice areas or partners track leads differently, so nothing rolls up into one view of the firm’s actual pipeline

The copy-paste pipeline (works in a spreadsheet or any lightweight CRM):

1. New Enquiry — date received, source (phone, web form, referral), contact details, one-line matter summary

2. Contacted — date of first response, who responded, method (call/email), any urgency flag (e.g. limitation date, settlement deadline)

3. Consult Booked — consult date/time, assigned lawyer, fee arrangement discussed (free consult, paid, fixed fee quoted)

4. Consult Held — outcome notes, likely matter value or fee estimate, next-step deadline (“decide by Friday”)

5. Engaged — engagement letter sent date, signed date, matter opened in practice management system

6. Lost — reason (went with another firm, priced out, matter not viable, went quiet), so you can actually see your patterns over time

Add one column for “days in this stage” — that single column does more to stop leads going cold than anything else on this list.

Three real examples

Solo family lawyer: Sarah runs a one-partner family law practice on the Gold Coast and gets 15-20 enquiries a month, mostly from Google and word of mouth. She doesn’t need automation or lead scoring — she needs a single tab in Google Sheets she checks every morning with a coffee, filtered to show anything sitting in “Contacted” for more than 48 hours. That one filter has probably saved her three or four clients a year who would otherwise have gone quiet while she was in mediation all day.

3-partner commercial firm: This is where “whose lead is this?” becomes a real problem. Three partners, each with their own referral network, all fielding enquiries independently — and no one has visibility into who’s carrying the heaviest pipeline or which partner is converting best. A lightweight CRM (even a free-tier one built for small teams) with an “Assigned To” column and a shared dashboard fixes this in an afternoon. The practice owner can finally see conversion rates by partner instead of guessing.

High-volume conveyancing firm: This firm doesn’t need deep relationship tracking — they need speed. Fifty-plus enquiries a month, most decided within 24-48 hours based on who responds first with a fixed-fee quote. Their pipeline is deliberately shallow: New Enquiry → Quoted → Engaged → Lost, with an automatic “quoted more than 24 hours ago, no response” flag. For this firm, the win isn’t nuance — it’s never letting a quote sit unanswered while a competitor gets there first.

Getting it set up (without overthinking it)

You’ve got three realistic options, and the right one depends entirely on enquiry volume, not firm prestige. Under roughly 20 enquiries a month, a shared Google Sheet with the six-stage structure above is genuinely enough — no subscription, no onboarding, no IT ticket. Between 20 and 100 a month, a free or low-cost lightweight CRM (think Trello-style boards, Pipedrive, or HubSpot’s free tier) starts earning its keep because it can send reminder notifications when a lead sits too long in one stage. And if your firm already runs practice management software like Clio, LEAP, or Actionstep, check whether you’re actually using its built-in contact and matter-intake features before buying anything new — most firms pay for CRM functionality they already own and never switch on. Whichever option you choose, the setup itself takes an afternoon. The part that actually matters is deciding, in writing, who updates it and when — after every call, not “at the end of the week.”

💡 Heads up: a CRM is only as good as the discipline behind it. We’ve seen firms spend real money migrating to a beautiful new system, then watch it go stale within six weeks because nobody made updating it part of anyone’s actual job. The spreadsheet you use every single day beats the enterprise platform you open once a month.

Mistakes to avoid

Building a 12-stage pipeline when six will do — extra stages just mean extra admin nobody keeps up with
Tracking leads somewhere only one person can see, which quietly recreates the exact inbox problem you were trying to fix
Skipping the “Lost” reason field — it’s the single most useful piece of data for improving your intake process, and almost every firm leaves it blank
Choosing a tool based on features you’ll never use instead of whether your team will actually open it every day

Frequently asked questions

Do I really not need proper legal practice management software for this?

You still need practice management software for matter files, trust accounting, and document management — that’s not optional. What you don’t need is to force your lead tracking into its CRM module if that module is clunky, or to buy an entirely separate enterprise CRM just to track enquiries. A simple pipeline sitting alongside your existing system is often the cleanest fix.

At what point does a spreadsheet stop being enough?

Honestly — somewhere around 50-80 active enquiries a month, or once more than two or three people need to update it at the same time. Past that point, version conflicts and “who edited this last” problems start costing you more time than the spreadsheet saves. That’s the natural moment to graduate to a proper lightweight CRM with automated reminders.

Who should actually be responsible for updating the pipeline?

One named person, even in a solo practice — that might be you, or a paralegal, or whoever answers the phone first. “Everyone” updates it is the same as “no one” updates it. Build a two-minute end-of-call habit: log the enquiry, set the stage, move on.

What if my partners don’t want to share visibility into their leads?

That’s a culture conversation more than a software one, but it’s worth having directly — a shared pipeline isn’t about surveillance, it’s about the practice owner being able to see total enquiry volume and conversion rate, which is essential for pricing, staffing, and marketing decisions. Most partners come around once they see it also protects them when they’re on leave or in trial.