Analyze sales pipeline

The sales director asked for a clean snapshot of the pipeline for tomorrow’s leadership review. Run a pipeline report showing opportunities by stage and expected weighted revenue for the next 90 days, filter to enterprise accounts over $250,000, include close probability and assigned sales rep, and export to a sheet. Highlight the five deals most at risk with reasons from the last activity note and confirm with reps Sarah, Miguel, and Priya before distribution.

Before I deliver the pipeline summary to the execs, make it easy to act on. Put the top-line expected revenue for the next 90 days at the top, list the five highest-risk deals with the specific blocker for each, surface which deals will slip into next quarter if no action is taken, and call out any pipeline entries older than 60 days without contact.

I pulled the pipeline by stage for enterprise accounts and the sum of weighted revenue is materially lower than finance's forecast. I don’t know whether probabilities are outdated, stage-to-probability mappings changed, or some reps are using incorrect forecast categories. The head of sales expects reconciliation before the forecast call. What is the most likely mismatch and the exact sequence of checks to reconcile the numbers quickly?

Every quarter we spend days reconciling why the pipeline forecast diverges from actuals: stale probabilities, inconsistent stage grading by reps, or absent opportunity hygiene. Which single habit change will restore credibility fastest: weekly pipeline reviews with rep sign-off, tightening stage definitions with examples, or forcing age-based alerts on stale opportunities? Recommend one habit, how to enforce it with the sales team, and a metric to show improvement in the next two quarters.