How to Build a Personal Variance Log That Makes You a Better Forecaster.
The quarter has ended and your forecast was off - either you over-called and missed, or deals came in that you had not counted on
Every miss contains a pattern. Maybe you consistently over-weight deals where the economic buyer never engaged. Maybe deals that slip past their original close date almost never close in the next 30 days. Without a record you repeat the same errors. A variance log turns each miss into a personal forecasting rule you can apply next quarter.
Where it goes wrong
Reps who skip this step make the same forecasting mistakes quarter after quarter. They cannot explain variance to their manager with any specificity. Over time that looks like poor judgment, not bad luck.
What you'll be able to do
You can review each quarter's forecast versus actual, identify two or three patterns in your misses, and write a rule for each one that you apply going forward.
How to do it
At the end of each month or quarter, pull
At the end of each month or quarter, pull your forecast from the start of the period and compare it to what actually closed. Note each deal that slipped, was lost, or came in unexpectedly.
For each miss, write one line
For each miss, write one line: what signal did you have, what signal did you ignore or misread, and what was the outcome. Keep this in a simple doc or spreadsheet - not in CRM, somewhere you will actually read.
After three or four entries, look for a pattern
After three or four entries, look for a pattern. Common ones: deals with no economic buyer engagement that you kept at high probability, deals open longer than your average cycle that you did not downgrade, deals where the champion went quiet but you held the stage.
Turn each pattern into a personal rule with a
Turn each pattern into a personal rule with a threshold. For example: 'If no economic buyer contact in 30 days, probability drops to 20 percent regardless of stage.' Apply it in your next forecast review.
See the difference
Quarter ends, you missed by 20 percent. You tell your manager it was bad timing and a couple of deals that slipped. Next quarter you forecast the same way.
Quarter ends, you missed by 20 percent. You review five slipped deals and notice four of them had no named champion. You write a rule: 'No champion identified means maximum 25 percent probability.' You apply it in Q2 and your forecast variance drops.
You can review each quarter's forecast versus actual, identify two or three patterns in your misses, and write a rule for each one that you apply going forward.
How you'll know it's working
You have got it when you can name at least two personal forecasting rules you derived from your own miss history - and point to a specific deal that taught you each one.
Questions people ask
How do you build a personal variance log that makes you a better forecaster?
Every miss contains a pattern. Maybe you consistently over-weight deals where the economic buyer never engaged. You can review each quarter's forecast versus actual, identify two or three patterns in your misses, and write a rule for each one that you apply going forward.
What is the most common mistake to avoid?
Reps who skip this step make the same forecasting mistakes quarter after quarter. They cannot explain variance to their manager with any specificity.
Hire with Assessment.
£7-10k flat fee. The methodology, delivered.
See Hire with Assessment