# Revenue Waterfall Dashboard

Map subscription, license, services, and hardware bookings through stream-specific recognition into deferred revenue, with YTD lag and conversion metrics that reconcile bookings to recognized revenue.

- Canonical: https://finamodel.com/excel-dashboard/revenue-waterfall
- Excel download: https://finamodel.com/templates/revenue-waterfall.xlsx

## About this dashboard

The Revenue Waterfall dashboard shows how subscription, license, services and hardware bookings translate into recognised revenue over 12 months. Review YTD bookings, YTD revenue, closing deferred revenue, recognition lag and revenue-to-bookings conversion by stream to see where billing and revenue timing diverge.

The supporting workbook applies a separate recognition period to each stream. Subscription and services revenue is spread over time, while license and hardware revenue is recognised at booking. Monthly schedules track opening deferred revenue, new bookings, recognised revenue and closing balances. A reconciliation check connects the closing total with cumulative bookings and revenue, making the summary traceable to its underlying movements.

Use the dashboard for monthly close reviews, forecast updates and discussions of revenue timing. CFOs, revenue accountants, controllers and FP&A teams can compare streams, review deferred balances and assess changes to recognition periods. Bookings can be replaced with invoiced amounts in the supporting schedule when preparing a view based on actual activity.

## What's included

- 12-month bookings across subscription, license, services, and hardware
- Stream-specific ratable and point-in-time recognition logic
- Per-stream deferred-revenue roll-forward
- Closing-balance reconciliation check
- YTD lag and revenue conversion summary
- Editable recognition periods and opening deferred balances

## Frequently asked questions

### How are the four revenue streams recognized?

Subscription bookings are spread ratably across the recognition period, defaulting to 12 months. Services use a default three-month ratable period. License and hardware are recognized in the booking month, so each stream’s timing remains visible separately in the Recognition sheet.

### What does the deferred-revenue roll-forward show?

For each stream, closing deferred revenue equals the prior closing balance plus bookings minus recognized revenue. The workbook also provides a check row that ties the closing total to opening deferred revenue plus cumulative bookings less cumulative revenue.

### Can I use actual invoiced bookings?

Yes. Replace the formula-driven monthly values on the Bookings sheet with invoiced amounts for each stream. The Recognition, Deferred Revenue, and Summary sheets then recompute, while the closing-balance check highlights any roll-forward inconsistency.

### Can recognition periods be changed?

Yes. Recognition periods are editable assumptions for each stream. Changing the subscription or services period recalculates the recognition schedule, deferred-revenue balances, YTD results, recognition lag, and conversion metrics throughout the workbook.

### Does this model track cash collection?

No. Bookings are treated as billings or invoiced amounts rather than cash receipts. The model focuses on recognition timing and deferred revenue; pair it with a cash-flow or three-statement model when collection timing is required.

## Related dashboards

- [Financial Health Dashboard](https://finamodel.com/excel-dashboard/financial-health)
- [Board Reporting Pack Dashboard](https://finamodel.com/excel-dashboard/board-reporting)
- [Cash Flow Dashboard](https://finamodel.com/excel-dashboard/cashflow)
- [Income Statement Dashboard](https://finamodel.com/excel-dashboard/income-statement)