How to set up a rolling cash flow forecast

Step 1 — choose your horizon and cadence

Decide how far ahead you need to see and how often you will update. For hands-on cash control, 13 weeks rolled weekly is the standard; for strategic planning, 12 to 18 months rolled monthly. Some businesses run both. The horizon is the distance you always keep in view; the cadence is how often you refresh it. See the rolling forecast guide for the principle.

Step 2 — build the base forecast

Start with a normal cash flow forecast over your chosen horizon: opening balance, receipts and payments by period, running balance. This is your baseline. If you are working weekly, that means a full 13-week forecast; if monthly, twelve months of projected inflows and outflows.

Step 3 — roll and extend each cycle

At the end of each period, do two things: drop the period just finished off the front, and add a fresh period on the end so the horizon stays constant. If you always want 13 weeks in view, adding week 14 as week 1 falls away keeps it there. This is the mechanic that stops your visibility shrinking as time passes.

Step 4 — replace forecast with actuals

As each period passes, replace its forecast figures with what actually happened, and note the variance. Consistent variances tell you your assumptions are off — customers paying slower than assumed, a cost you underestimated — so you can correct the forecast going forward. This feedback loop is what makes a rolling forecast progressively more accurate over time.

Step 5 — act on what it shows

Because you always see a full horizon ahead, you can act calmly and early on anything it reveals: a trough to fund, a surplus to deploy, a trend to arrest. Arranging finance with weeks of notice is always cheaper and easier than doing it in a scramble.

Credicorp lends to your company, not to you personally, and takes no personal guarantee. See business loans or apply online.