Most agency founders look at their CRM deal pipeline, multiply the total deal value by stage probabilities, and call it a forecast. If you run a 10 to 100 person IT services or professional services firm, you already know this number is almost always wrong.
A 10 Lakh deal sitting at a 50% proposal stage doesn't mean you'll see 5 Lakhs next month. Late signatures, delayed client onboarding, and scope negotiations push real billing weeks or months into the future.
Here is a practical framework to build a quarter-ahead revenue forecast that actually holds up.
- Separate baseline revenue from new pipeline: Start with contractually locked revenue. Add up active retainers and ongoing project milestones already scheduled for next quarter. This is your revenue floor. Everything in your sales pipeline is variable on top of this base.
- Stage-weight by time, not just probability: Don't just apply a flat percentage to deal values. Tag every deal with an expected invoice date based on your average sales cycle length. If your average deal takes 45 days to close and 15 days to start, a deal created today won't generate billable revenue in month one of next quarter.
- Discount by delivery capacity: A closed deal is worth zero next quarter if your team doesn't have the capacity to execute the work. Compare your weighted pipeline against available billable hours. If your senior engineers or project leads are at full capacity, cap your forecast at your maximum billable delivery limit regardless of sales volume.
- Adjust for client payment terms: Revenue recognition and cash flow are different metrics, but for mid-sized agencies, cash dictates operations. If an enterprise client signs next month on Net 60 terms, that cash arrives two months after the work is delivered. Account for standard payment terms when projecting usable capital.
- Audit historical win rates by deal size: Smaller deals often close faster with higher win rates than large contracts. Break down your historical win rate by deal size tiers rather than using a single average across your entire pipeline.
Using simple example maths: if your committed retainers equal 30 Lakhs, your time-weighted pipeline yields 15 Lakhs, but your team capacity caps you at 40 Lakhs total output, your realistic operational forecast for the quarter is 40 Lakhs, not 45 Lakhs.
Running this exercise at the end of every month gives your delivery teams enough lead time to plan hiring or contractor allocations before projects start, rather than scrambling after a contract is signed.
How do you handle deal closure delays when projecting monthly revenue for your team?
We build Autovella, project, timesheet and invoicing software for Indian service firms.
Top comments (0)