Pipeline Forecasting for Law Firms: Turning Enquiry Volume Into Revenue Predictions

10 August 2026·6 min read

Quick answer: A pipeline forecast for a law firm is just enquiries × consult booking rate × consult-to-retainer conversion rate × average matter value, tracked as a rolling monthly number instead of a one-off guess. It turns "we're pretty busy at the moment" into an actual dollar figure you can plan cashflow, hiring and marketing spend around. Below is the fill-in-the-blank worksheet, three worked examples by practice area, and the mistakes that quietly make forecasts useless. 📈

Ask most principals how next month's revenue is looking and you'll get a shrug, a glance at the calendar, or "depends how many people call." That's not a forecast — that's a vibe, and vibes don't cover payroll. The firms that plan with confidence aren't the busiest ones, they're the ones who've turned their intake funnel into numbers they trust. 💖 The good news is you don't need expensive software to start — you need four numbers you probably already have, tracked consistently.

What most law firms get wrong about forecasting

Treating "enquiries" as one lump number — a phone call, a web form and a referral chat are not the same quality of lead, but most intake sheets lump them together.
Confusing a busy reception desk with new revenue — enquiry volume going up feels like growth, but if conversion is falling at the same rate, revenue is flat or dropping.
Using one average matter value for the whole firm — a family law firm's straightforward parenting matter and a five-day property settlement are not the same $3,000, and blending them wrecks the forecast.
Forecasting off last month only — one strong or weak month gets treated as the new normal, instead of smoothing it into a rolling average.
Nobody owns the numbers — the data lives in three systems (intake sheet, calendar, practice management software) and nobody's job is to pull it together monthly.

The fill-in-the-blank forecasting worksheet

Grab your last month's numbers (or better, a 3-month average) and work through this:

Step 1 — Enquiries this month: ______
Step 2 — Consult booking rate (enquiries who book a first appointment): ______% → Consults booked = Step 1 × Step 2 = ______
Step 3 — Consult-to-retainer conversion rate: ______% → New retainers = Step 2 result × Step 3 = ______
Step 4 — Average matter value (by practice area, not firm-wide): $______
Forecast new business revenue = New retainers × Average matter value = $______

To make it a rolling monthly number: repeat this for each of the last 3 months, average the four inputs (enquiries, booking rate, conversion rate, matter value) across those months, then run the formula on the averages. Recalculate at the start of every month, dropping the oldest month and adding the newest — that's your rolling 3-month forecast, and it smooths out the one-off busy or quiet month that throws a single-month number off.

Three real examples

Family law firm: 42 enquiries this month, 70% book a consult (29 consults), 48% of those sign a retainer (14 new matters), average matter value $3,200. Forecast: 14 × $3,200 = roughly $44,800 in new business this month. The lower average matter value is offset by higher enquiry volume — family law lives and dies on intake speed.

Conveyancing/property law firm: 65 enquiries, 80% book a consult (52), 60% convert to retainer (31 new files), average matter value $1,450. Forecast: 31 × $1,450 = roughly $44,950. Similar total to the family law example, but the whole game here is volume and speed to quote — matter value barely moves, so the forecast lives or dies on enquiry count.

Commercial litigation firm: 18 enquiries, 55% book a consult (10), 40% convert to retainer (4 new matters), average matter value $18,500. Forecast: 4 × $18,500 = $74,000. Low volume, low conversion, but each retainer is worth 5-10x a conveyancing file — this is why commercial firms should never benchmark their conversion rate against a high-volume practice area.

How to actually build this without extra software

You need three things tracked in one place, updated monthly — a spreadsheet is genuinely fine to start with. First, log every enquiry with its source and whether it booked a consult (your intake person or reception can do this in under a minute per enquiry). Second, log every consult outcome — retainer signed or not — straight from the calendar or practice management system. Third, pull average matter value per practice area from your billing data, ideally a trailing 12-month average so one unusually large or small matter doesn't skew it. Once those three feeds exist, the formula above takes five minutes a month to run. If you're already tracking enquiry source in a dashboard, this forecast should sit right next to it — it's the natural next step after knowing where leads come from.

💡 Heads up: this forecast tells you what new business is likely to come in — it does not tell you when it will be billed or collected. A signed retainer in a litigation matter might not generate an invoice for months. Treat this as a demand forecast that feeds your cashflow planning, not a replacement for it.

Mistakes that quietly wreck the forecast

Blending matter value across practice areas — a firm-wide average hides the fact that your conveyancing and commercial teams have wildly different economics.
Basing conversion rate on a single good (or bad) month — a referral-heavy month with unusually high conversion will make next month's forecast overconfident.
Counting raw enquiries as pipeline — an enquiry that never books a consult was never really in your pipeline; count consults, not phone calls.
Letting average matter value go stale — fee structures and matter complexity shift; recalculate it quarterly, not once and forget it.
No monthly owner — if updating the numbers isn't someone's actual job, it stops happening within two months.

Frequently asked questions

How many months of data do I need before this forecast is reliable?

At least 3-6 months of consistent tracking. With less than that, one unusual month (a referral spike, a slow holiday period) will throw the average off, and you won't yet know what your firm's normal conversion rate actually looks like. Start tracking now even if you can't forecast confidently for a few months — the worksheet is only as good as the history behind it.

What if my consult-to-retainer conversion rate swings wildly month to month?

That's common in lower-volume practice areas like commercial litigation, where four retainers instead of six can look like a huge swing but is really just small-number noise. Use a rolling 3-month average rather than reacting to any single month, and don't panic over one soft month unless the trend holds for a quarter.

Should I use average or median matter value?

Median is often more honest if you have a few very large outlier matters, since they can drag the average up and make your forecast look rosier than typical months will actually deliver. If your matter values are reasonably consistent within a practice area, average is fine — just check the spread occasionally.

Does this replace proper financial forecasting or a bookkeeper?

No, and it shouldn't try to. This formula estimates new business revenue from your marketing and intake funnel — it doesn't account for work in progress, billing timing, disbursements, or matters that stall. Use it to answer "is our pipeline healthy," and let your accountant or practice manager handle the actual cashflow and P&L forecasting.