Law Firm Sales Forecast Template

Start with the Assumptions sheet. Download the file and open it in Excel or upload it to Google Sheets. Enter your attorney headcount by role, billing rates, target billable hours per month, and your expected realization and collection rates. If you're a solo practitioner, this takes ten minutes — enter your own rate, your working hours, and the retainer revenue you already have under agreement. If you run a small firm, enter each role tier separately. Take your time with realization and collection rates: if you're not sure, 88–92% for realization and 93–97% for collection are reasonable starting points for most general practice and transactional firms. These two inputs have an outsized effect on the forecast.

Next, populate the Matter Pipeline sheet with every active matter and prospective engagement. Include matters already in progress (probability 100%), engagement letters pending (80–90%), and referrals or consultations you're actively pursuing (30–60%). The weighted pipeline total is your most important leading indicator — if it's less than three months of target revenue, the forecast downstream will be soft. Then review the Revenue Forecast sheet to see how the model builds monthly revenue from your billing stream mix, and check the Capacity sheet to confirm the implied billable hours are achievable. Adjust assumptions until the forecast reflects what you genuinely believe is achievable, not what you're hoping for.

At month-end, enter actuals in the Actuals vs Forecast sheet: total hours billed, flat fee collections, retainer receipts, and any contingency recoveries. This takes under ten minutes and is the step that makes the forecast genuinely useful over time. The variance patterns you accumulate over six months will tell you whether your realization rate assumption is too optimistic, whether flat fee matters are closing on the schedule you projected, and whether your January slowdown is deeper than you're modeling. Law firm managing partners who track actuals monthly consistently report that the forecast becomes a real planning tool rather than a number they produce once a year for their bank.

Law firm revenue forecasting is more complex than most service businesses because of the gap between hours worked and dollars collected. A firm might work 200 billable hours in a month, bill 180 of them (a 90% realization rate), and collect payment on 165 billed hours (a 92% collection rate) — meaning 17.5% of the work performed that month never becomes cash. Without a structured forecast that models both adjustments, revenue projections are systematically overstated, cash flow planning is unreliable, and decisions about hiring and expansion are made on numbers that won't materialize. This is the core reason law firms need a purpose-built forecast, not a generic sales spreadsheet.

Practice area mix adds another layer of complexity. Hourly billing in a litigation practice generates predictable monthly revenue tied directly to attorney activity, but it's capped by capacity and vulnerable to trial continuances and scheduling delays. Flat fee work in transactional practices generates lumpy revenue that depends on deal closings outside your control. Retainer arrangements from corporate clients provide a recurring revenue base that grows slowly but churns suddenly when clients go in-house or change relationships. And contingency matters are financially invisible until they settle — sometimes for years — and then produce large, irregular receipts. A single revenue line can't capture any of this, and neither can a standard pipeline tool built for product sales.

The practical forecast cadence for a law firm runs on three layers. Monthly, review your billed hours versus target and enter actuals into the variance tracker — this is where you catch a utilization problem before it becomes a three-month revenue shortfall. Quarterly, revisit the pipeline and reforecast the next six months with updated matter status, any rate increases, and changes to retainer clients. Annually, reset the assumptions entirely: adjust billing rates, update headcount, re-model the practice area mix based on where your work is actually coming from. Firms that maintain this cadence consistently make better decisions about lateral hires, office space, and marketing investment — because the forecast tells them whether growth is funded by current revenue or requires outside capital.