Consulting Sales Forecast Template

Start with the Assumptions sheet. Download the file and open it in Excel or upload it to Google Sheets. Enter your consultant headcount by role, billing rates, target utilization, and current retainer base. If you're a solo consultant, this takes ten minutes — enter your own rate, your weekly capacity, and the retainer revenue you already have locked. If you run a small firm, enter each role tier separately. Getting the assumptions right is the one step that matters most: everything else in the model flows from these inputs.

Next, populate the Pipeline Tracker with every active proposal and prospect. Be honest about close probabilities — 90% on a deal you haven't heard back on in three weeks is not 90%. The weighted pipeline total on that sheet is your leading indicator of whether next quarter's revenue is covered. Then move to the Revenue Forecast sheet and review how the model builds monthly revenue from your retainer base, pipeline conversions, and assumptions. Check the Utilization Tracker to confirm the implied hours are achievable with your current team before treating the forecast as final.

At the end of each month, enter actuals in the Actuals vs Forecast sheet. This is a five-minute task that pays off over time. The pattern of variances — whether you're consistently overestimating project starts or underestimating retainer growth — will recalibrate your assumptions and make your quarterly forecasts materially more accurate. Consultants who track actuals monthly report that the forecast becomes genuinely useful for business development timing: you can see three months out whether you need to be actively proposing new work, rather than discovering a revenue gap when it's too late to fill it.

Consulting revenue has a split personality that makes it hard to forecast with generic tools. The retainer portion behaves like subscription revenue — predictable, compounding slowly as you add clients, and lost suddenly when a client churns or reduces scope. The project portion behaves like a lumpy transaction business — dependent on proposal timing, client budget cycles, and decision-making processes that can stall for months. A single spreadsheet row labeled 'revenue' misses all of that. A proper consulting forecast separates these streams and models them on their own terms, because they require different management responses when they're off track.

Utilization rate is the hidden variable in any consulting forecast. Most consultants set a revenue target without checking whether it's achievable given their available hours. At 70% billable utilization — a healthy target for most consulting practices — a solo consultant working 45 weeks a year has roughly 1,260 billable hours to sell. At $200 per hour, that's $252,000 in annual revenue before expenses. Push utilization to 85% and you get $306,000, but at the cost of having almost no time for business development, administration, or vacation. The Utilization Tracker sheet makes this math explicit so your revenue target and your capacity are always reconciled.

The practical forecast cadence for consulting is different from product businesses. You need a weekly pipeline review — not because deals change that fast, but because consulting sales cycles are long and you need to be actively managing every proposal to closure. You need a monthly revenue close — comparing what you billed against what you forecast, so you catch patterns of over- or under-estimation before they compound. And you need a quarterly reforecast — looking at the next nine months with updated assumptions about retainer clients, likely new business, and headcount changes. This template is structured around that three-layer cadence, giving you the right view for each.