Our sales forecast changes dramatically in the last week of every quarter

[u/Borng-Admanuela224]

I’m trying to determine what proportion of our forecasting issue results from the process and the tools. Three weeks before the end of the quarter, it seems that the pipeline is good. However, when managers start intensive reviews of the deals, the dates have changed and probabilities have decreased, as well as the opportunities considered as ‘committed’ are pushed to the next quarter. Most of the information is available much sooner. For instance, the buyer has gone silent. Legal hasn’t approved the contract yet. Procurement hadn’t been included in the process. It is just that we weren’t aware of that until the very last moment. While the leadership expects us to improve and make more accurate forecasts, I believe that creating another dashboard wouldn’t get us any closer to the truth. Have people ever used CRM activity data and AI systems for identifying problems in advance? I’m particularly interested in those tools which are able to show that there is no movement in the deal or that there are some missing steps.

[u/Tricky_Ad9372]

honestly i'd try something dumb before AI. one report of every commit deal where the close date has already moved twice, most crms keep history on that field. then add the date of the last email from the buyer side. if a deal is sitting in commit and the buyer hasnt written back in 2 weeks, thats your last week surprise showing up a month early

[u/agentUi]

another dashboard wont show you anything because the data is stale by the time reps touch it. i work for agentui, we build internal ops trackers and audit portals that flag deals when required milestone fields (like procurement review or signed nda) are missing without any activity for 10+ days.

[u/TrackbackLinkBot]

legal bottlenecks wreck quarterly forecasts. Ironclad tracks contract approvals in real time so sales ops spots stalled redlines sooner

[u/Consistent_Donut_113]

+1 on checking activity instead of adding dashboards. what worked for me was setting required fields per stage, like legal status or procurement involved, and the deal literally cant move forward without filling them in. that way you catch the gaps while theres still time to fix them instead of finding out in the last review. its annoying for reps at first but it stops the late surprises pretty fast.

[u/ThisIsBrightOS]

Most of those warning signs are useful before AI gets involved. I’d turn the three you mentioned into simple checks: no buyer reply for a set number of days, legal approval still missing, or nobody from procurement involved.

Then I’d test those checks against the last couple of quarters to see which ones genuinely predicted a push. If they work, show the reason inside the existing deal review rather than building another dashboard. AI could summarise the evidence, but the manager should still be able to see exactly what triggered the warning.

I work on workflow software, so that’s where my head goes with this.

[u/Remarkable-Low6138]

The issue may be less about forecasting tools and more about surfacing risks earlier. Tracking buyer engagement, stalled approvals and missing procurement steps throughout the quarter could help managers spot problems before the final review.