I’m going to answer my own question here as our VP Sales had a strong preference for a renewal deal that “shows everything in just one deal” and I needed to deploy a solution ASAP.
We have two funnels: sales and renewals
sales now has: new bookings and pro-rated upsells/expansions
renewals now has: renewal deals including any price changes
Renewal deals are configured with a “Client ARR” value that reflects their ARR prior to starting the renewal process (~90 days out). This value is maintained by the CSM. EG if an upsell/expansion is added after their initial contract, the ARR from this pro-rated deal is added to the the Client ARR value in the renewal.
Here’s the fun part: As the renewal negotiation is taking place, the deal amount is updated to reflect ANY change to ARR - 3 or 5% price increase, expansion seat, or downgrade. Two calculated fields (one for expansion and one for contraction) are used to calculate either upward or downward revisions from the Client ARR: 1) Deal amount - Client ARR = expansion OR 2) Client ARR - Deal amount = downgrade depending if Client ARR or Deal amount is larger. So now I have three “amount” values for each renewal: renewal amount (what i expect to see / actually close), Client ARR (going into the renewal), and the difference between them (up or down).
Now to report on a few KPIs:
New ARR = all new deals in the sales funnel
Expansion ARR = expansion deals from the sales funnel + expansion amount from renewal funnel
Contraction ARR = downgrade amount from renewal funnel
Quota achievement for AEs (aka their Bookings) = all their sales funnel deals + deal split from renewal funnel (certain upsell deals are credited to AEs)
Total Bookings = total from sales funnel + expansion amount from renewal funnel (tragically these are separate reports)
So that’s how it works for us. I’m not sure that I’d recommend it to everyone as it has pros and cons:
Pros:
- Easier to make sense of a client journey → fewer deals to interpret and all renewal related info is in each renewal deal
- should make it easier for accounting to invoice clients (we use saasoptics so deals are pushed automatically)
Cons:
- reporting is more difficult → standard reports can’t generate bookings by rep (have to use deal splits), total bookings and total expansion can’t be totalled inside HS, the deal board/kanban view doesn’t reflect total quota achievement for AEs (sum at bottom of closed won stage)
We’re only a few weeks in… time will tell whether the pros outweigh the cons! Hope this helps others consider their options.