02 · How much cash, and when
Ten days at a time
One single matrix: line items in rows, ten-day periods in columns. Opening balance, inflows, outflows, period flow and closing balance. Ten days is the step at which a payment is decided — a whole month is too coarse to tell whether cash holds.
Every cell opens up: underneath are the items that make it, with company name, due date, bank and amount. Filters by bank and accounting due-date ledger, and Excel export of whatever is on screen.
The month in five numbers · illustrative example
- 1,6
- months of cover from the order book
- 136
- average days to collect on 12-month revenue
Illustrative values. The twelve-month cash trajectory comes from the same ten-day treasury periods, aggregated by month, with the low point marked.