How to Build a Cash Flow Dashboard Finance Teams Actually Use
TL;DR
- A company with a Days Sales Outstanding of 45 days on $10M annual revenue has $1.25M of receivables outstanding at any moment, which can increase to $1.5M if DSO creeps to 55 days.
- Extending Days Payable Outstanding from 30 to 45 days on $8M of annual payables can free up $330K of working capital, but has limits due to vendor relationships and early payment discounts.
- For companies under $50M revenue, a 13-week cash flow forecast is a crucial operational tool, providing a rolling week-by-week projection of cash in and cash out, updated weekly with actual beginning cash.
Most cash flow dashboards fail for the same reason most dashboards fail: they were built to prove something was measured, not to drive a decision. A finance team's cash dashboard should answer one question daily: are we going to have a problem in the next 13 weeks, and if so, when and how big? Everything else is noise.
"Cash flow is the lifeblood of any business. A company can be profitable on paper and still run out of cash. The dashboard that shows you profitability without showing you 13-week cash flow is not a finance dashboard — it is a rear-view mirror."
— Joseph Hribar, CFO Practice Leader, Korn Ferry, in CFO Magazine (2023)
The metrics that matter for cash visibility
Days Sales Outstanding measures how long it takes to collect from customers after invoicing. At DSO of 45 days on $10M annual revenue, you have $1.25M of receivables outstanding at any moment. If DSO creeps to 55 days, that is $1.5M, an additional $250K of cash tied up in the billing cycle with no underlying business change. DSO spikes are often the first signal that customers are struggling before they surface in any other metric.
Days Payable Outstanding is the mirror: how long you are taking to pay suppliers. Extending DPO from 30 to 45 days on $8M of annual payables frees up $330K of working capital. But DPO extension has limits. Vendors notice, early payment discounts get withdrawn, and relationships strain at the extremes. Track it against contractual terms, not just averages.
Cash Conversion Cycle ties the two together: CCC equals DSO plus Days Inventory Outstanding minus DPO. For service businesses without inventory, CCC simplifies to DSO minus DPO. A negative CCC means you collect before you pay. A high positive CCC means the business is a working capital consumer, which matters enormously for growth planning.
The 13-week cash flow forecast is the operational tool. Not a 12-month model, but a rolling 13-week week-by-week projection of cash in and cash out, updated weekly with actual beginning cash. This is the instrument that tells treasury whether to draw on the revolver, hold a payment run, or accelerate a collection effort.
Tool choices
For companies under $50M revenue, a well-built Excel or Google Sheets model connected to your ERP via API export is often sufficient. The 13-week model can pull confirmed AR aging, scheduled AP payments, and payroll runs automatically and require manual input only for items not yet in the system.
For companies over $50M or with multiple entities and currencies, dedicated treasury management tools like Kyriba, HighRadius, or Coupa Treasury add cash pooling, bank connectivity, and forecasting workflows that become worth the cost.
Weekly vs monthly cadence
Cash flow reporting should be weekly for the 13-week operational view and monthly for the strategic view. Monthly board-level reporting on cash should show ending cash, free cash flow generation, CCC trend, and liquidity headroom. Four numbers. If your board is looking at more than that in a monthly cash report, you are in the weeds of operations rather than governance.
The threshold alerts that matter
Build automatic alerts into the dashboard: trigger at 60 days of operating cash remaining, at DSO exceeding 20 percent above trailing 90-day average, and at any week in the 13-week forecast where projected cash balance drops below the policy minimum. These three alerts, if they fire, require an action. Everything else is informational.
📊By the numbers
| Metric | Finding | Source |
|---|---|---|
| SMB failures attributed to cash flow problems | 82% | U.S. Bank Study on Business Failure, 2023 |
| CFOs with real-time cash visibility | Only 23% | Kyriba Treasury Benchmark Report, 2023 |
| Median cash visibility horizon for finance teams | 5–7 days ahead | AFP Treasury Survey, 2024 |