Forecast Agency Revenue and Resource Needs

Answer in one sentence: Use your sales pipeline, historical retention, and service delivery capacity together to build rolling monthly revenue and resource forecasts you can trust.

Why a reliable forecast matters

Forecasts tell you if you will hit revenue targets and if you have the right people ready. Without a forecast, agencies scramble to hire or drop clients at the last minute. A good forecast makes planning calm and predictable.

Data you must collect

Collect these cleanly and update them weekly:

• Open pipeline by stage and expected close date.
• Average deal value per service or client type.
• Historical win rate by pipeline stage.
• Current recurring revenue and churn rate.
• Billable hours per person and utilization targets.
• Delivery capacity limits (max clients, project hours, or retainer load).

Keep values simple. Example: “Pipeline A: 10 leads, $8k average, 30% win rate.”

Step-by-step revenue forecast

1. Tally pipeline value by month. Group opportunities by expected close month.
2. Apply realistic win rates to each stage. Use recent history (90 days).
3. Add committed recurring revenue and subtract expected churn.
4. Build a rolling 3–6 month total. Update weekly.
5. Flag low-confidence deals (e.g., no meeting in 30 days) and mark them separately.

Practical tip: Use conservative, base, and optimistic scenarios. Base = current win rates. Conservative = base minus 10–20%. Optimistic = base plus 10%.

Forecasting resource needs (capacity planning)

Turn revenue into hours. Steps:

1. Map services to billable hours per month (e.g., SEO retainer = 20 hrs/month).
2. Multiply forecasted wins by hours needed per new client.
3. Add existing monthly hours from current clients.
4. Compare total hours to available billable hours (people x target utilization).
5. Plan hires, contractors, or scope changes if demand exceeds capacity.

Example calculation:

In this example, capacity meets demand, but watch for upcoming churn or extra projects.

Practical example: 90-day rolling forecast

1. Start with pipeline grouped by month.
2. Apply stage win rates: SQL (60%), Proposal (40%), Prospecting (10%).
3. Calculate expected revenue by month and scenario.
4. Convert expected revenue to hours using your service-rate table.
5. Compare hours to available capacity and mark hiring triggers.

If Month 2 shows a 30-hour shortfall, set a trigger: if shortfall > 20 hours for two consecutive weeks, approve a 30-hour contractor.

Hiring and outsourcing decision framework

Use a simple framework:

• Shortfall < 10% of capacity: use overtime or reprioritize.
• Shortfall 10–25%: hire 1–2 contractors or part-time help.
• Shortfall > 25%: hire full-time or pause new sales.

Also consider lead time to hire. Contractors fill gaps fast. Full-time hires take 6–12 weeks to onboard.

Checklist to build your first forecast (copy and use)

• Export pipeline with stages and close dates.
• Pull average deal value by service.
• Calculate stage win rates for last 90 days.
• List monthly recurring revenue and churn assumptions.
• Map services to hours and billable rates.
• Count available billable hours per person at target utilization.
• Create base/conservative/optimistic scenarios.
• Set hiring triggers and review cadence (weekly).

Tools and running cadence

Run forecasts weekly and review with sales and delivery leads. Keep three numbers: expected revenue, required hours, and available capacity.

For time tracking and utilization, follow industry best practices. If you want a step-by-step on time data and utilization, see this guide: Master agency time tracking and utilization.

If your CRM can link pipeline, tasks, and time, sync those feeds into the forecast. Many agencies put forecasts in spreadsheets first, then push them into a tool. For single-pane views of pipeline, tasks, invoices, and client workspaces, consider a CRM that centralizes those signals, such as Features.

How to handle uncertainty and risk

• Keep a "buffer" of 10–20% capacity for urgent work or scope creep.
• Reclassify stale deals to low confidence.
• Track one metric weekly: pipeline coverage ratio (pipeline value / target revenue). Aim for 3x coverage for new business, adjusted for win rate.

Example action plan for next 30 days

1. Export pipeline and calculate weekly win-rate.
2. Build a one-page forecast: month-by-month revenue, hours needed, capacity gap.
3. Set hiring triggers and a backup contractor list.
4. Review forecast every Monday with sales and delivery.

Where a client success role fits

A client success manager can reduce churn and free delivery time by handling onboarding and scope questions. If churn is above your target, consider creating this role. See other ideas in: Create a client success manager role in your agency.

Final notes on tools

Link your CRM pipeline to invoicing and time systems to keep forecasts live. If you use an all-in-one CRM like a connected agency platform, connect pipeline, tasks, and invoicing data to reduce manual updates.

Concrete next step: export your pipeline today, apply your real win rates, and build a 90-day forecast in a single sheet. Use the checklist above and set one weekly review meeting.