Fill in these first
- Open deals: [paste one row per deal: name, value, stage, expected close date, last activity date, decision maker engaged (yes or no), next step agreed (yes or no), notes]
- Quarter end date: [for example 31 December 2026]
- Quarter target and closed so far: [amounts]
Task
Review the pipeline deal by deal and score the risk that each deal will not close by the expected date.
Scoring
Give each deal 0 to 2 points on five factors, where 2 is low risk:
- Decision maker engaged.
- Next step agreed with a date.
- Activity in the last 14 days.
- Close date realistic for the stage.
- Budget confirmed.
Total of 8 to 10 is low risk, 5 to 7 is medium, 0 to 4 is high.
Output format
- Risk table: | Deal | Value | Stage | Score | Risk | Main risk reason | Next action | Owner role |
- Stalled deals: no activity in 21 days or close date already passed.
- Forecast: | Category | Deals | Total value |, with commit (low risk), best case (medium) and at risk (high).
- Gap to target and the three deals most worth extra effort.
Rules
- Base scores only on the data given; mark missing data as a risk.
- Next actions start with a verb and are doable this week.






