Why your forecast and your pipeline don't agree
Most firms plan from the top down and sell from the bottom up. When those two numbers live in different systems, the gap shows up too late to fix.
Every professional services firm runs two plans at once, whether leadership names them or not. There is the forecast: what the firm expects to produce this year. And there is the pipeline: what is actually coming, weighted by probability and close date.
Those numbers will disagree. That is normal. The trouble starts when nobody sees the gap until June, after the forecast was set in November and the pipeline has shifted three times since.
When pipeline lives in a CRM, capacity lives in a spreadsheet, and the P&L lives in accounting software, nobody sees the full picture until someone manually reconciles them. That reconciliation is usually one person's job, done monthly at best, and always after the decision window has closed.
Firms that catch misalignment early treat pipeline and capacity as one view, not two reports. They layer weighted pipeline onto a roster-based forecast and ask a simple question: can the people we have actually deliver what we have sold, or are about to sell?
When the answer is no, you have options: hire earlier, reset the target, or decline work you cannot staff well. When the answer arrives in month six instead of month one, you only have damage control.
Closing the gap means connecting sold work to the people who deliver it, and both to the financial plan in one system, updated as deals move and hours land. Better spreadsheets will not do that on their own.