Skip to main content

Waterfall calculation

Zuora

  • 日本語のコンテンツは機械翻訳されており、補助的な参照を目的としています。機械翻訳の精度は保証できません。英語版が正となります。また、現時点では検索機能は日本語での検索をサポートしていません。翻訳に関するフィードバックについては、docs@zuora.comに送信してください。

Waterfall calculation

  1. Last updated
    Apr 14, 2020
  2. Save as PDF

The following waterfall tables are provided as examples to help you better understand the calculations done in the waterfall. Different actual and forecast schedules are presented based on different percentages of released revenue in a revenue contract.

In the example, there are two sales order lines in the revenue contract. The revenue start date is 01-May-2019 and the revenue end date is 31-Aug-2019. In the forecast template definition, Revenue Start Date is selected for Forecast Start Date and Prorate is the adjustment method.

In the Workbench, the following filter is applied to generate waterfall at the transaction level.

waterfall-filter.png

When the revenue has not been released (Revenue Released PCT = 0%), the following waterfall data is generated:

released-revenue-0.png

When the revenue is partially released (Revenue Released PCT = 40%), the waterfall data is as follows:

released-revenue-40.png

When the revenue is all released (Revenue Released PCT = 100%), the following waterfall data is generated:

released-revenue-100.png

All the above waterfall tables can also be downloaded in the attached CSV file for your reference.