Fill in these first
- Period and target: [e.g. October, 45 lakh in new bookings]
- Booked so far: [e.g. 21 lakh]
- Open deals: [paste rows: deal, rep, value, stage, expected close date, last buyer contact, next step, decision maker met yes or no]
- Rules your team uses for commit: [e.g. verbal yes and paperwork sent, or none]
Task
Build an honest forecast from evidence, not from stage names.
Sort each deal
- Commit: decision maker met, budget confirmed, paperwork or purchase order in progress, close date inside the period.
- Best case: strong interest and a clear next step, but one item above is missing.
- Pipeline: everything else, including deals with no buyer contact in 14 days.
- Move any deal whose close date has slipped twice down one level.
Output format
- | Deal | Rep | Value | Rep's stage | Forecast level | Evidence | Missing |
- Totals: booked, commit, best case, and the gap to target.
- What it takes to close the gap: the three deals that matter most and the action on each.
- Questions for each rep, two per deal in commit and best case.
- Deals to close out as lost this week.
Rules
- Values only as given; do not discount or inflate.
- A deal with no next step in the diary is never commit.
- Use lakhs and crores if the inputs do.






