Directly Upload SSP to RevPro

Knowledge Center > Zuora RevPro > Policy Related Configuration > SSP Setup > Directly Upload SSP to RevPro

Directly Upload SSP to RevPro

If SSP can be estimated outside RevPro, you can upload it as a spreadsheet to RevPro based on your defined SSP templates.

Procedure

Before your SSP data can be uploaded to RevPro, an SSP template must be defined. The SSP data is uploaded as an SSP batch that is created based on the SSP template.

Complete the following steps to upload SSP to RevPro:

  1. Create an SSP template and download the template.
  2. Fill in your SSP data in the downloaded file.
  3. Create an SSP batch based on that template to upload the file.

Create and Download SSP Template

  1. Navigate to SSP > Upload.
  2. In the SSP Upload left pane, to add an SSP template, click add_icon.png.
  3. In the New SSP Template window, complete the following steps and then click save-icon.png.
    • Provide a unique name for this template in the Template Name field.
    • Specify the start effective date of this template in the Start Date field.
    • Select SSP for the SSP Type field.
    • Specifies whether the uploaded data is based on amount or on percent for the Value Type field.
    • Select appropriate transaction field or fields from the Available Fields list to the Selected Fields list. The selected fields are used for grouping transaction lines. 
  4. Ensure that the Enabled switch is toggled to Yes.
  5. (Optional): If you select PERCENT for the Value Type field, you can also select the allocation apply method and allocation apply field, and click save-icon.png.
  6. (Optional): Specify other optional fields and click save-icon.png.
    • Template Description: A short description of this template.
    • End Date: The end effective date of this template.
  7. Close the window and click the template name in the left pane.
  8. To download the SSP template, click the Download Template icon download-template-icon.png.

Create SSP Batch to Upload SSP Data

After the SSP data is filled in the downloaded SSP template file, you can create an SSP batch to upload the data to RevPro.

  1. Navigate to SSP > Upload.
  2. In the SSP Upload left pane, select the template based on which you want to upload data and click the Create Batch icon add_icon.png.
  3. In the New SSP Batch window, specify the following required fields and click save-icon.png.
    • Batch Name: A unique name of this batch.
    • Start Date: The start effective date of the SSP data.
    • End Date: The end effective date of the SSP data.
    • Term: If you select AMOUNT for the Value Type field in the SSP template, specify the term for the SSP amount. For example, enter 1 for one month, and enter 12 for one year.
  4. Close the New SSP Batch window. The SSP batch is created and listed on the right.
  5. To upload your SSP data file, click the Upload icon upload-icon.png.
  6. In the New SSP Upload window, click Choose File to select the file and then click Upload
  7. Close the New SSP Upload window.
  8. Click the Refresh icon refresh-icon.png until the Batch Status column value changes from NEW to SSP UPLOADED.
  9. (Super user only) To make the SSP data valid, click the Approve icon approve-icon-new.png and provide your comment to approve the SSP data.

Result

After the SSP data is approved by a super user, it will be applied to incoming transactions to determine the SSP value. You can review the SSP stratification by clicking the View Stratification icon.

What to Do Next

Optionally, you can assign the defined SSP template to an existing RC grouping template. So that the SSP rules can be applied to the related revenue contracts. To do it, edit the RC grouping template and select this SSP template in the SSP Hierarchy tab. For more information, see Create RC Grouping Template.

Example

The following example shows an SSP template that will be used to upload the SSP value as percent.

ssp-upload-template.png

The following spreadsheet is created based on the above SSP template and uploaded to RevPro.

ssp-upload-file.png

 

Last modified

Tags

This page has no custom tags.

Classifications

(not set)