SSP range evaluation for SSP uploads
Zuora Revenue compares selling prices with uploaded SSP ranges and uses RC grouping template settings to determine the SSP values used for revenue allocation.
Zuora Revenue supports the direct upload of externally estimated standalone selling prices (SSP) through predefined SSP templates. After SSP data is uploaded and approved, the system applies the SSP values to transaction lines during revenue contract creation and allocation.
After SSP data is uploaded, the SSP direct upload configuration and the RC grouping template are used to determine how SSP values are derived and applied during revenue allocation.
How SSP ranges are evaluated
When SSP values are maintained as ranges, for example, with a low and high bound for each SSP stratification, Zuora Revenue compares the selling price of each contract line with the configured SSP range.
Based on the comparison result, the system classifies the line as one of the following:
- Within the SSP range
- Below the SSP range
- Above the SSP range
The RC grouping template determines which SSP value, low, midpoint, or high, is used for revenue allocation for each of these scenarios.
Numerical example
The following example illustrates the configuration used to calculate the SSP range.
SSP range setup
| Parameter | Value |
|---|---|
| SSP Template | % Upload |
| FV Percent (midpoint SSP) | 80% |
| Below Mid Percent | 70% |
| Above Mid Percent | 90% |
| RC grouping template configuration | withinSspFlag = M, belowSspFlag = M, aboveSspFlag = A |
| Apply SSP column | List price |
SSP range calculation
Example extended list price: 1000
| Calculation | Formula | Result |
|---|---|---|
| Below SSP | EXT_LST_PRC × 70% | 700 |
| Midpoint SSP | EXT_LST_PRC × 80% | 800 |
| Above SSP | EXT_LST_PRC × 90% | 900 |
SSP Range: 700-900
Scenario Examples
Scenario A — Selling price within SSP range
Selling price: $800
$700 ≤ $800 ≤ $900 → Within Range (SPWR-)
Result:
The CV baseline uses the midpoint configuration (
withinSspFlag = M).Fair value is calculated based on the $800.
Scenario B — Selling price below SSP range
Selling price: $600
$600 < $700 → Below Range (SPBR)
Result:
CV baseline uses the midpoint configuration (
belowSspFlag = M).Fair value is calculated based on $700.
Scenario C — Selling price above SSP range
Selling price: $1500
$1500 > $900 → Above Range (SPAR)
Result:
CV baseline uses the above-mid configuration (
aboveSspFlag = A).Fair value is calculated based on $900
Price-based SSP calculation
The examples above use percentage-based SSP uploads and for price-based SSP uploads, you upload a unit SSP value. Zuora Revenue then calculates the extended SSP range using the following formula:
Extended SSP = Unit SSP × Line Quantity × Line Term ÷ Batch Term
You can also explicitly configure which SSP value (low, midpoint, or high) is used for each scenario in the RC grouping template on the SSP Hierarchy tab. Configure the following columns:
• Selling Price Below Range SSP
• Selling Price Within Range SSP
• Selling Price Above Range SSP