Most revenue operations teams run two separate reports for the CFO: a quota attainment report (how did new business close against plan?) and a retention report (how did the existing base perform?). The CFO looks at both, asks about the relationship between them, and the answer usually involves toggling between two dashboards or two spreadsheets that were built by different people at different times using slightly different definitions.
This is a structural inefficiency with a real cost. When new business attainment and net revenue retention (NRR) are reported separately, it is easy to present a quarter where new business hit plan but silent churn eroded the total revenue picture — and vice versa. A CFO making capital allocation decisions needs to see both simultaneously, because the combination determines where to invest: a company with weak new business attainment but strong NRR has a different growth lever priority than one with strong new business and deteriorating NRR.
This post covers how to build a unified revenue narrative that presents quota attainment and NRR in a single coherent framework — not by merging two reports into one slide, but by using a data structure that makes the relationship between them explicit.
Defining the Metrics Consistently
Before combining NRR and quota attainment into a single narrative, both metrics need to be defined with precision — and the definitions need to be consistent across the reporting period. This sounds obvious, but revenue organizations frequently have minor definitional variations that create large reconciliation problems when reports are combined.
Net revenue retention is the percentage of contracted revenue from a cohort of customers retained over a 12-month period, including expansion (upsells, cross-sells, seat additions) and excluding contraction (downgrades, churn). NRR above 100% means the existing base is growing — expansion revenue is outpacing churn and contraction. NRR below 100% means the base is shrinking, which requires new business just to maintain flat total revenue.
Quota attainment is the percentage of new ARR closed against the target for a given period. "New ARR" must be defined consistently — does it include expansion from existing accounts? Some organizations include expansion in the new business quota; others attribute it to a separate customer success or account management quota. If expansion is double-counted across both NRR and new business quota, the combined narrative will be misleading.
The prerequisite to a unified narrative is resolving this definition question explicitly: expansion revenue belongs in exactly one of the two metrics. Where it lives determines how to read the combined report.
The Variance Waterfall Structure
The most useful single-page structure for combining quota attainment and NRR reporting is a revenue variance waterfall that starts with beginning-of-period ARR and ends with ending-period ARR, with each component of change labeled and attributed explicitly.
A typical quarterly waterfall looks like this:
- Beginning ARR: contracted ARR at the start of the quarter
- + New business closed: new logos × average contract value
- + Expansion ARR: upsell and cross-sell from existing accounts
- − Contraction ARR: downgrades and seat reductions from existing accounts
- − Churned ARR: customers who did not renew or cancelled mid-contract
- = Ending ARR
NRR is derived from this waterfall: (Beginning ARR + Expansion − Contraction − Churn) / Beginning ARR. Quota attainment is New Business Closed / New Business Target. Both metrics are visible simultaneously within a single structure, and the relationship between them is explicit — a CFO can immediately see how much NRR variance is driven by expansion versus churn, and whether new business closed was sufficient to offset a contraction in the base.
The waterfall also makes the forward-looking picture tractable. If NRR is 94% and new business attainment is 103%, total revenue might still be declining if the base is large relative to new business volume. The waterfall structure makes that arithmetic visible without requiring the CFO to do it mentally.
Forecasting the Components Separately
The forward-looking version of the unified narrative — the Q+1 forecast — requires projecting each waterfall component separately, because each has a different underlying driver and a different model structure.
New business closed is projected from the CRM pipeline, applying win rates by stage and segment. This is the quota attainment forecast.
Expansion ARR is projected from the expansion pipeline — upsell and cross-sell opportunities currently open for existing accounts — combined with a historical expansion rate for accounts that do not have an active expansion opportunity. The historical rate approach is necessary because organic expansion (seat additions, usage-based billing increases) often does not generate explicit CRM opportunities until after the expansion has already occurred.
Churn and contraction ARR are projected using a churn cohort model: accounts are segmented by risk indicator (health score, support signal, engagement trend, contract vintage), and the churn probability distribution for each cohort is applied to the contracted ARR within that cohort. This is not a precise number — churn projections at the cohort level carry substantial variance — but it is a better input to the CFO narrative than an extrapolated trailing average.
Each component projection carries its own confidence interval. The combined NRR projection is the sum of those interval-adjusted components, which produces a wider aggregate interval than any single component — appropriately, because the combined projection is more uncertain than any of its parts individually.
Where the Narrative Gets Complicated
The unified narrative breaks down when the two metrics are moving in opposite directions for different reasons that require different responses. A quarter where new business attainment was strong but NRR declined requires a specific type of explanation: the sales org is performing, but the customer base is eroding, and the combined revenue picture depends entirely on which force is larger and which is accelerating.
In practice, this often surfaces as a question the CFO does not know how to frame: "We hit our number, so why is revenue growth slowing?" The answer — NRR deterioration is partially offsetting new business gains — requires the variance waterfall to be visible, not just the aggregate attainment percentage.
We are not saying every revenue organization needs a complex unified reporting framework from day one. For small sales orgs with straightforward annual contracts and minimal expansion motion, a combined report might be overkill. The investment in unification pays off when the organization has both meaningful new business volume and a substantial existing base generating expansion and churn — typically when total ARR is over $5–10M and the customer base has heterogeneous health signals. At that scale, the CFO's questions start requiring answers that span both metrics simultaneously, and separate reports create blind spots.
Practical Implementation Notes
For RevOps teams building this framework incrementally, start with the historical waterfall before adding a forward-looking forecast. The historical waterfall for the past four quarters forces the definitional alignment that makes the forecast credible — it surfaces double-counting, inconsistent expansion attribution, and churn definitional gaps before they affect a live CFO presentation.
Once the historical waterfall is clean and consistently defined, adding the forward-looking component is a matter of layering in the CRM pipeline projection (quota attainment model) and the cohort-based churn projection (NRR model) against the same beginning-ARR baseline. The two models share the same starting point and the same definitional structure — the inputs differ, not the architecture.
Scalivo's forecasting model outputs a waterfall-structured revenue projection by default, separating new business, expansion, and churn components with confidence intervals for each. The CFO narrative is built from the same data model that drives the rep-level attainment forecast — no separate report, no toggle between two dashboards.
