Skip to main content
Post-Sales Playbook

How Do You Forecast Renewals and Expansion Without Rebuilding a Spreadsheet Every Quarter?

Stop rebuilding the renewal forecast each quarter: keep contract, deal, and health inputs live, split renewal from expansion, and review what changed monthly.

Arushi Jain

Arushi Jain

·9 min read
How Do You Forecast Renewals and Expansion Without Rebuilding a Spreadsheet Every Quarter?
On this page

You forecast renewals and expansion without a quarterly spreadsheet rebuild by keeping the forecast’s inputs live, not by finding a smarter formula. Contract values, renewal dates, open deals, account health, and expansion signals should update on their own, so the forecast becomes a short review of what changed instead of a fresh build. The spreadsheet can stay as the place where you apply judgment. It just shouldn’t be the place where you gather data.

Quivly, the AI workforce for post-sales teams, keeps those inputs on one customer record. Billing data such as MRR, ARR, and renewal dates comes from your billing provider, and renewal and expansion deals come from your CRM into Opportunities, next to health, usage, and support. Quivly doesn’t produce a forecast number for you. It gives you current inputs, flags renewals early, and drafts the account context your team needs to make the call.

Key Takeaways

  • Most forecast misses start with stale inputs, not a bad model. Fix how data arrives before you change the formula.
  • Forecast renewals and expansion separately. They depend on different evidence and carry different risk.
  • Pair every renewal date with a health view, so the forecast reflects how the account is actually doing.
  • Keep missing data separate from real zeroes. A blank renewal date is a data gap, not a lost customer.
  • Replace the quarterly rebuild with a short monthly review of what changed, plus one mid-year expansion check.

Why Does the Renewal Forecast Get Rebuilt Every Quarter?

A customer success lead at a small reseller we spoke with described next year’s forecast as their top priority. They built it by hand in a spreadsheet, adding seasonality and growth assumptions, and recent deals had come in below what they expected. Their contracts are yearly, renewal conversations open about three months before the end date, and there is a mid-year check for expansion. Most of that check depended on what each CSM happened to remember about the account.

That pattern is common in small post-sales teams, and it has three causes:

  • The inputs live in different places. Contract values sit in billing, deals sit in the CRM, and health lives in the CSM’s head or a separate tool. Each quarter someone exports and stitches them together again.
  • Assumptions stay fixed while accounts change. A growth rate set in January says nothing about the account that lost its champion in March.
  • Expansion is a guess. Without shared signals, mid-year expansion numbers are a CSM’s best estimate, which is why they tend to swing.

If you’ve already moved other reporting out of spreadsheets, this guide to getting customer insights without spreadsheets covers the wider shift. The forecast is usually the last spreadsheet to go, because it mixes data with judgment.

What Makes a Renewal and Expansion Forecast Reliable? 6 Criteria

Use these criteria to test your current forecast, or to decide what to fix first.

  1. Every renewal has a current value and date. The forecast starts from real contract data, not last quarter’s copy. In Quivly, each customer’s Revenue tab shows MRR, ARR, days to renewal, and the renewal date from your billing integration.
  2. Renewal and expansion are tracked as separate lines. A renewal is about keeping what you have. Expansion is about new value. Mixing them hides risk in one behind growth in the other. Quivly shows CRM deals in Opportunities, where you can filter and save a view for each type.
  3. Each line carries a health view. A renewal date alone tells you when, not how likely. Quivly scores each account across revenue, product usage, engagement, support, and market signals, so a weak renewal stands out before the forecast meeting.
  4. Gaps are visible. If a customer isn’t linked to a billing record, the forecast should show a gap, not a zero. Quivly marks unavailable revenue values with a dash and keeps a verified zero as zero.
  5. Expansion has named signals behind it. Usage near a plan limit, new teams asking for access, or a new stakeholder are evidence. A feeling that the account “should grow” is not.
  6. The review happens on a schedule. A monthly look at what changed beats a quarterly rebuild. Saved views and dashboards make the review start from current numbers.
Forecast inputWhere it should come fromCommon spreadsheet failure
Contract value and renewal dateBilling provider, synced automaticallyCopied once a quarter, out of date by the next month
Open renewal and expansion dealsCRM, with stage, amount, and close dateSeparate tab nobody reconciles with billing
Account healthScored across revenue, usage, engagement, support, and market signalsA color the CSM picks before the meeting
Expansion likelihoodNamed signals plus the CSM’s judgmentA flat growth percentage applied to every account

How to Forecast Renewals and Expansion Without Rebuilding, Step by Step

These steps replace the quarterly rebuild with a forecast that updates as accounts change. Each step shows how Quivly handles it.

  1. Connect billing and CRM once. The forecast’s base layer is contract value, renewal date, and open deals. Quivly reads MRR, ARR, subscriptions, invoices, and renewal dates from your billing provider, and opportunities with stages and close dates from your CRM. Neither system is changed by Quivly, so finance and sales keep their source of truth.
  2. Build a saved renewal list. On the Customers page, add MRR, health score, and risk level columns, filter to the segment or lifecycle stage you’re forecasting, and save it as a custom view such as “Renewals this quarter.” Sort by MRR to protect the largest revenue first, or by health score when risk should lead.
  3. Split renewal and expansion deals. In Opportunities, save one view for renewal deals and one for expansion deals. The calendar layout shows deals by date, which maps cleanly to a three-month renewal window. For a wider look at how teams run this motion, see this overview of renewal management capabilities for CS teams.
  4. Flag renewals early enough to change the outcome. Set signal rules for approaching renewals, up to six months ahead, so weak accounts surface before they reach the forecast as a surprise. Quivly can draft a recommendation when the rule fires, and the account owner decides what to do with it.
  5. Prepare each at-risk renewal with context. A Renewal prep brief Agent can run on a schedule, gather billing, usage, and health context, draft the brief, and pause for approval. CSMs can also draft a renewal brief in the customer’s notebook. The forecast owner then reads a short brief per account instead of chasing each CSM.
  6. Back expansion numbers with signals. Build an Agent from the Expansion spotter template to surface accounts ready to grow and draft outreach for review. Bring those accounts to the mid-year expansion check, so the expansion line rests on evidence. You can also add an AI field, such as an expansion-readiness rating your team defines, that refreshes weekly; test runs show the value with the reasoning behind it.
  7. Review what changed, monthly. Ask Quivly portfolio questions like “What does our MRR look like by customer segment?” or which customers renew soon with open invoices. A dashboard from the Revenue template can show subscription and opportunity widgets with date filters, and you can click any total to see the records behind it. Update the spreadsheet’s judgment columns from that review, not its data columns.

The step that removes the rebuild is step one. Once billing and CRM data arrive on their own, every later step becomes a review instead of a data-gathering exercise. The same idea underpins growing customer revenue beyond the first contract: growth planning works best when the account story is already current.

How to Choose: If You… Then…

  • If recent deals keep landing below forecast, then compare each miss with the account’s health and engagement in the three months before close. Misses usually show up there first.
  • If your forecast is mostly a flat growth rate, then split it into a renewal line and an expansion line, and require named signals for every expansion entry.
  • If the renewal window is three months, then set renewal alerts further out than that, so there’s time to fix an at-risk account before the conversation starts.
  • If CSMs give different answers about the same account, then use one saved view and one brief format, so everyone reviews the same evidence.
  • If finance owns the final number, then keep the spreadsheet for assumptions and sign-off, and feed it from synced billing and CRM data instead of manual exports.
  • If renewals slip because dates are missed entirely, then fix date coverage first. This roundup of platforms that prevent missed contract renewals compares approaches.

Buyer Considerations

If you’re evaluating tooling to support forecasting, test it on last year’s renewals. Check whether the accounts that churned or shrank looked weak in the tool before the renewal date. Ask how billing and CRM data sync, whether the tool writes back to either system, and how it shows a customer with missing revenue data. Confirm that renewal and expansion deals can be viewed separately and saved as shared views. Be wary of any tool that promises a forecast number without showing the inputs behind it. For a side-by-side view of options, see these renewal management tools for CS teams.

Conclusion

A renewal and expansion forecast stops needing a quarterly rebuild when its inputs stay current. Sync contract and deal data, attach a health view to every renewal, keep gaps visible, back expansion with named signals, and review what changed each month. Quivly keeps billing, CRM deals, health, and usage on one customer record, flags renewals up to six months ahead, and drafts the briefs your team uses to make the call.

If you’d like to see your renewal and expansion inputs in one place, book a demo with Quivly.

FAQ

Frequently asked questions

From Quivly

AI workforce for post-sales.