Knowledge Center > Zuora RevPro > Forecasting


Foreseeing the revenue from the particular line is called Forecasting. Forecasting is done for the deferred revenue and not for recognized revenue. Forecasting templates are created to specify the forecasting methods, forecast process, and different types of forecast adjustment methods. You can generate a forecast based on Forecast template and also upload the forecasted data.

A background job is scheduled to run on a daily basis to regenerate the forecast based on the schedules associated with POBs.

This job will regenerate the forecasting only for the POBs, which have a forecast template associated or manually uploaded schedules. Periodic snapshot of the forecast will be captured at the end of the month. 

Create Forecast Templates

For every forecast type, a template will be defined and attached to POB Templates. The Template also captures the details like Date Hierarchy and Schedules. Date Hierarchy is to determine based on what specific data point the revenue has to be forecasted. There can be multiple criteria defined but the revenue is defined based on the criteria defined in the Date Hierarchy pane. A Schedule is defined to determine what percentage of the amount has to be forecasted based on the duration type.

Forecast schedules are created for Contractual Revenue and Carves and that will be used to compute the Net Revenue. All the forecast amounts are calculated only for Lines and stored in the system as percentages and then applied to all the lines within the POB. Actual amounts will be derived as part of the reporting and displayed accordingly.

Perform the following steps given in this section before uploading forecasts.

  1. In the RevPro Application, select Forecast > Template and from the Name pane, select an existing template or click New Template to create a new template.
  2. Enter the Name of the template. 
  3. Select the Start Date for the template to be effective.
  4. Select the Forecast Method as any one of the following:
    • By System – Forecast method is based on the System Date.
    • By Ratable Method – Forecast method is based on the provided Start Date and End Date. For Ratable POBs, if there exists forecast schedule definition, then by default system will use the forecast schedule defined in the template ignoring the POB Start and End Date. 
  5. In the Forecast Date Hierarchy pane, enter the following:
    • Seq – Enter the sequence of the forecast date of a valid contract document.
    • Forecast Start Date – The Date from which the revenue has to be forecasted. The Date             can be any one of the following dates:
      • Contract Date
      • Contract Modification Date
      • Forecast Date
      • Fair Value Date
      • Original Fair Value Date
      • RC Line Created Date
      • RC Line Date
      • RC Line Updated Date
      • Revenue Start or End Date
      • Sales Order Date
      • Scheduled Ship Date
      • Ship Date.
    • Adjustment Method – Specify LIFO, FIFO, or Prorate as the Adjustment Method. The Adjusted Forecast is based on the adjustment method associated with the hierarchy and also whether they are Prorate, LIFO or FIFO. All these schedules are called as Adjusted Forecast Schedules. 
    • Prorate – In this method, the available actuals and forecasted amount of the current open period will spread evenly across the remaining forecast schedules.
    • LIFO – (Last In First Out) In this method, adjustment starts from the last forecast schedule period.
    • FIFO – (First In First Out) In this method, adjustments starts from the current period + 1.
  6. In the Schedules pane, enter the following:
    • Seq – The sequence in which the forecasted revenue will be collected.
    • Duration Type – Type of the duration and it can be Periods or Days.
    • Duration – Actual count of the period or days in which the forecasted revenue will be collected in the schedules defined in this section.
    • Percent- The percentage of the forecasted revenue that will be released in the specified duration.

Upload Forecasts

The forecasted data is uploaded to the system and RevPro will update or create the Base Forecast. After creating the Base Forecast, RevPro will validate for any actuals available to calculate the adjustment entry. Also, based on the adjustment entry in the current period, RevPro will derive the adjustment method from the forecast template to adjust the delta amount by creating the adjusted forecast.

You can upload the forecast schedule manually through excel or CSV file into RevPro and generate the manual forecast schedules. You have to define the Forecast Upload template and criteria based on which the POB information along with the existing forecast schedule is extracted and downloaded in a CSV format.

You will be able to lock the forecast based on which the forecast schedules are uploaded manually and will be restricted from overriding the forecast information.

  1. In the RevPro application, select Forecast > Forecast Upload.
  2. In the Template Definition screen, click New Template.
  3. Enter a valid name and description for the template in Name and in Description.
    1. Select the Enabled checkbox to enable the newly created forecast template that can be used for uploading.
    2. In the File Specifications template, select the type of the file that is allowed for upload. An error message is displayed if you loaded some other file format.
    3. Select the Date Format to specify the format you use in your Organization. If the uploaded file’s date format is different from the template then an error message gets displayed.
    4. Select the Start Row as 2. First row is the heading row. You can specify the starting row number from which the actual data gets inserted into the table from the uploaded file. This helps the user to differentiate the header from the transaction data.
    5. Click Save to create the template and save the details.

      Freeze buttons appear when you click Save.

  4. After entering the filter details given in the below steps, click Freeze to lock the template so that no changes can be made in the template. The name of the button changes to Unfreeze
  5. Click Unfreeze to make the template available for editing. Make the necessary changes and then click Freeze.
  6. Select the Filters tab and click the + button to create a new filter.
    1. Enter the sequence of the filter fields in Seq.
    2. Select Aggregated Values, All Lines, or Any Line to specify for which the criteria will be applied. 
    3. Select the Field Name from the drop down for which the newly created filter criterion is applied.
    4. Check Enabled to make the filter criteria active.
    5. Click Save.
  7. Select the newly added Forecast Template, right-click and select Download Template.
  8. Place the raw data in the template excel.
  9. In the Forecast Upload screen, select the newly added Forecast Template, right-click and select Upload.
  10. In the File Upload -< File Name> screen, click Browse to select the .csv file in which you have placed the raw data. The selected file name is displayed in the Template Name field.
  11. Click the Upload button to upload the .csv file to upload the file to the Forecast template.

A success message appears stating that the file was successfully uploaded. The newly uploaded file is listed in the Uploaded Files pane with the Status as Successfully Uploaded. In the Uploaded Files pane, the following details are displayed:

  • File Name – Name of the uploaded .csv file.
  • Created By – Name of the RevPro user who uploaded the file.
  • Creation Date – Date on which the file was uploaded in RevPro.
  • Download File – Link to download the uploaded file is available.
  • Status – Successfully Uploaded status message appears if the upload is successful. Error appears if the upload is not successful.
  • Message – Count of the success or failures that occurred while uploading the file.
  • Next Action – This link gets enabled after successfully uploading the file. When you click the Next Action link, the data collection process gets started.

Examples For Setup Screens

Following are the screens where you can find the setup related information:

Forecast Prorate Setup

Forecast Prorate Setup.png

LIFO For Adjustment Period

Forecast LIFO Setup.png

FIFO for Adjustment Period

Forecast FIFO Setup.png


The following examples are provided for the better understanding of the calculations done in Waterfall, Line and Forecast Schedules.

Waterfall Calculation

Waterfall calculation.png

Line Calculation

line calculation.png

Forecast Schedule Calculationcalculation.png

Last modified


This page has no custom tags.


(not set)