Cash Flow
The 13-Week Cash Flow Forecast: The Most Useful Report You're Not Running
Why 13 weeks?
Thirteen weeks — one quarter — is the sweet spot between accuracy and usefulness. Short enough that you can forecast receipts and payments with real confidence (you know who owes you and what bills are coming), long enough that when trouble appears, you have time to act: accelerate collections, resequence payments, arrange a credit line before you need it.
It's the same tool restructuring advisors deploy first when companies hit distress — which should tell you something. The businesses that never hit distress tend to be the ones already running it.
The anatomy of the forecast
The structure is simple: starting cash, plus expected receipts by week (customer collections, other inflows), minus scheduled disbursements by week (payroll, rent, inventory, loan payments, taxes), giving ending cash per week. The power isn't in the arithmetic — it's in the discipline of updating it weekly against actuals. Variances teach you how your cash actually behaves: which customers really pay in 45 days despite 30-day terms, how seasonal your outflows are, what your true payroll coverage buffer is.
A good forecast also carries scenarios. What if the biggest receivable slips two weeks? What if you accelerate the inventory buy? Weekly granularity makes these questions answerable in minutes.
From spreadsheet to habit
The forecast only works as a rhythm: update actuals Monday, review variances, adjust the coming weeks, decide. Thirty minutes a week, once the template is built. Every Beryl FP&A engagement includes a 13-week forecast maintained for you, reviewed together — because the tool matters less than the cadence.
If you've ever been surprised by a cash crunch, you didn't have a cash problem that day. You had a visibility problem for the six weeks before it.