Skip to main content
The revenue waterfall projects recognition across future months for every active schedule. It is the standard view for forecasting future revenue and for the run-off of the deferred liability.
Revenue waterfall

​
What each row shows

Each row corresponds to a grouping, typically customer with product as a child row:
  • Booked total: the total invoiced amount tied to that row.
  • Recognized: the amount recognized as of today.
  • Remaining: the amount still to be recognized in future periods.
  • Monthly columns: one column per future month, showing the recognition expected in that month.
The columns extend to the latest end date across all active schedules in the row, giving a complete picture of the recognition runway.

​
Grouping

The waterfall is grouped hierarchically:
  1. Customer level: total booked, recognized, and remaining for that customer. The monthly columns sum across all of the customer’s products.
  2. Product level (child rows): the same metrics scoped to one product for one customer.
For a multi-product customer this makes it straightforward to see which product drives which month’s recognition, and to spot upcoming end-of-term recognition spikes or renewal cliffs.

​
Exporting

The waterfall is exportable to CSV for offline analysis. For accounts whose volume permits it, the export runs synchronously and the file downloads directly. Very large accounts may push the synchronous endpoint to its limit. If a timeout occurs, narrow the date range and re-export, or contact support about an asynchronous export path.

​
What the CSV contains

The CSV mirrors the in-app waterfall: one row per grouping, with the monthly columns expanded out as date-stamped columns. The format is well-suited to spreadsheet pivots and BI tools.

​
Reconciling to the deferred revenue report

The waterfall and the deferred revenue report describe the same book of business from two angles. They reconcile when scoped consistently. To make the figures tie:
  • Use the same as-of date on both reports.
  • Read the deferred report’s Remaining column (not Balance). Remaining is the column that ties to the waterfall, because both are measured against the deferred ledger.
  • For accounts with historical data, set both reports to start at the same earliest date (for example, the first month your business started recognizing revenue in Sequence).
Small differences can appear where a credit note reverses revenue from a back-dated parent invoice and routes part of the movement directly through recognized revenue. Both reports remain correct for their respective purposes: the deferred report shows the ledger balance at a point in time, the waterfall shows how that balance is expected to run off.