Rolling Cash-Flow Forecast: keep the next decision in view

Static forecasts expire; rolling forecasts learn

A fixed annual or quarterly forecast may be useful for a plan, but it becomes stale as soon as a major receipt, supplier bill or tax payment moves. A rolling forecast closes the week with actual bank movement, keeps the same future horizon, and adds a new week or month at the far end. This preserves a forward view of the cash cycle instead of waiting for the original plan to finish.

British Business Bank guidance says a forecast should cover at least the cash-flow cycle, record income when cash is expected in the bank rather than when it is invoiced, include all outgoings, and maintain a running cash position. Its usefulness increases when estimates are updated as better information arrives.

Reconcile the opening balance before explaining the future

Start each refresh with the cleared bank balance, not last week’s expected balance. Investigate any difference before rolling forward; otherwise unexplained errors become part of every later period. Mark each significant item as actual, committed, probable or uncertain so a reader can see the confidence in the forecast.

Include dates for payroll, tax, loan repayments, rent, supplier payments and other commitments, as well as customer receipts. For sales, use the expected cleared date, supported by customer confirmation or payment history. Do not treat an application, a grant or a prospective sale as received cash before the conditions are met and the money is due to clear.

Use variance notes to improve decisions, not to assign blame

For material differences, write a short cause note: ‘invoice submitted five days late’, ‘customer payment run moved to month end’, ‘VAT payment higher after corrected return’ or ‘stock order brought forward’. Then decide whether the cause is one-off, a timing shift or a repeatable process issue. That distinction improves future receipt dates and prevents the team from recreating the same optimistic forecast each week.

A cash forecast is not a profit-and-loss account. A profitable job can still use cash before the customer pays, while a deposit may arrive before the income is recognised in accounts. Keep the model focused on money entering and leaving the bank; use your accounts to understand profitability and your rolling forecast to understand timing.

Make the review meeting end with a dated action

At each refresh, identify the lowest projected balance, the date it occurs and the assumptions that could move it. Agree an owner and deadline for the most important action: confirm a customer’s payment date, correct an invoice, postpone a discretionary commitment, agree staged billing, or obtain qualified support. A forecast without an action list is reporting, not control.

If the forecast indicates obligations may not be met when due, do not wait for the balance to become critical. Address the shortfall early and seek appropriate professional support. A rolling forecast can support a conversation with an accountant, lender or adviser, but it is not a promise of funding or a reason to take new credit by default.

Review forecast confidence, not just the low point

The lowest projected balance is the headline output, but the reliability of the inputs determines whether it is useful. Mark receipts as committed, probable or uncertain; distinguish invoices issued from money cleared; and show recurring payments separately from discretionary spending.

At each weekly review, compare the prior forecast with actual bank movements and explain the largest variances. Carry forward only assumptions that still have evidence. If the low point moves repeatedly, the answer may be an input or timing problem rather than a need for new finance.

Keep a base case and at least one downside case. Link each downside trigger to an action such as pausing discretionary spend, chasing a named debtor, renegotiating a supplier date or seeking qualified help. Do not count an unapproved facility or hoped-for funding as cash until it is available.

What to do, in order

1. 1

   Choose a regular rhythm

   Use a weekly review for a tight or fast-changing position, and a monthly strategic view where appropriate. Keep the forward horizon consistent.

2. 2

   Replace the completed period with actuals

   Reconcile to the cleared bank balance and explain material differences from last week’s forecast.

3. 3

   Refresh dated cash movements

   Update major receipts, payroll, tax, debt, supplier and planned-spend dates using the best current evidence.

4. 4

   Add the new future period

   Extend the end of the forecast so that the cash cycle remains visible rather than allowing the horizon to shrink.

5. 5

   Record confidence and actions

   Mark uncertain assumptions, identify the low point and assign a dated owner action before closing the review.