ARR / CARR Waterfall
The ARR / CARR Waterfall report displays how recurring revenue changes over time in a waterfall-style table.
The report allows you to track starting balances, period-by-period changes, and cumulative balances for each customer within a selected date range. Recurring revenue movements are shown at the customer level across multiple reporting periods.
What This Report Shows
The ARR / CARR Waterfall report displays recurring revenue in a period-by-period waterfall format.
The table includes the following elements:
Customer The customer associated with each recurring revenue balance.
Starting Balance The recurring revenue value at the beginning of the selected date range.
Period Columns Each column represents a reporting period within the selected range, such as Aug 2025 or Sep 2025. These columns show the change in recurring revenue for each customer during that period.
Ending Balance When the Balance view is selected, the table reflects cumulative balances after period changes are applied.
Totals are displayed at the bottom of the table.
The Period selector determines which reporting periods are included.
Report Controls and Selectors
The values displayed in the report depend on the selected configuration options at the top of the page.
Breakdown
The Breakdown selector determines which recurring revenue metric is displayed.
Available options include:
MRR Monthly Recurring Revenue.
ARR Annualized Recurring Revenue.
The selected option determines which recurring revenue values populate the table.
Status
The Status selector filters contracts based on their classification.
Available options include:
Active
Committed
The selected status determines which contracts are included in the calculation.
Type
The Type selector determines how values are displayed.
Available options include:
Balance Displays recurring revenue balances by period.
Rollforward Displays period-by-period changes in recurring revenue.
When Rollforward is selected, recurring revenue movements are shown as incremental changes by period.
Additional Filters
You can refine the report using:
Customer search
Subsidiary selection
Custom filters
Period selector
If Manual Overrides are configured, override adjustments are reflected in the displayed values when the Rollforward view is selected.
How the Report Works
Rillet calculates recurring revenue using contract line items that are configured to count toward MRR or ARR.
The report determines the Starting Balance for each customer at the beginning of the selected date range.
It then applies recurring revenue changes for each reporting period and calculates the cumulative balance accordingly.
Recurring revenue changes may result from:
New contracts
Contract amendments
Expansions
Contractions
Terminations
Manual overrides (when applicable)
All values are displayed according to the selected Breakdown, Status, and Type options.
See Also
Learn more about recurring revenue and related reports:
Last updated