Show cash on hand, where it is heading, and the events ahead.
Short answer
Show cash on hand as a line with a forecast band ahead of it, so the runway and its range read together. To explain the next weeks, add a waterfall of the cash events ahead.
Updated Nov 2, 2026 · Fintech sample data
Cash balance forecast
Month
Balance
P10
P90
Kind
May
$2.10M
$2.08M
$2.12M
Actual
Jun
$2.20M
$2.18M
$2.22M
Actual
Jul
$2.15M
$2.13M
$2.17M
Actual
Aug
$2.30M
$2.28M
$2.32M
Actual
Sep
$2.35M
$2.33M
$2.37M
Actual
Oct
$2.41M
$2.39M
$2.43M
Actual
Nov
$2.46M
$2.39M
$2.53M
Forecast
Dec
$2.50M
$2.36M
$2.64M
Forecast
Jan
$2.52M
$2.31M
$2.73M
Forecast
Feb
$2.58M
$2.30M
$2.86M
Forecast
Mar
$2.60M
$2.25M
$2.95M
Forecast
Apr
$2.66M
$2.24M
$3.08M
Forecast
01Cash on hand in the heroToday's cash, with the confidence band of the forecast beside it.
02Actual, then forecastThe solid line up to today, the dashed forecast and its band after it.
03Cash events aheadThe dated payments and receipts that move the line next.
The data it needs
ColumnTypeExampleNote
monthMonth2026-10One row per month.
cash_usdNumber, USD2410000Actual cash at month end; empty for future months.
forecast_usdNumber, USD2280000The forecast for future months.
low_usd · high_usdNumber, USD1950000 · 2600000The band around the forecast, such as P10 and P90.
Cash events ahead
Cash events ahead
Step
Amount
Cash today
$2.41M
Payroll · Oct 15
−$0.41M
Tax · Oct 20
−$0.185M
Renewals · Oct 28
+$0.52M
Lease · Nov 1
−$0.062M
Nov 1
$2.273M
042 · Waterfall
Cash today is $2.41M. Payroll takes $410K on Oct 15 and the tax instalment $185K on Oct 20; enterprise renewals bring $520K on Oct 28, and the lease takes $62K on Nov 1. Cash on Nov 1: $2.27M. At the current burn, the runway is 14 months.
The band shows how sure the forecast is; the waterfall shows what moves it next. Put it under the widget for the weeks ahead.