← All templates

Cash Collection Forecast

When the open ledger is expected to turn into cash, and what could hold it up.

DashboardFinanceAny industry
The Cash Collection Forecast template, running on sample data
Shown on sample data. The figures are illustrative, not real business results — take the template and point it at your own.

What it needs from your data

Needsa revenue or money column, a category (~4 values)
Optionaldates for trends, 9 more

What is on it

  • Cash expected in, week by week Area chart
  • Billed against collected Combo chart
  • Where the cash sits, by terms Ranking chart
  • How concentrated the forecast is Treemap
  • How long each segment takes to pay Box plot
  • Size against lateness Scatter plot