How to Build a Rolling Cash Flow Forecast

Most forecasts start life as a one-off: someone builds a 12-month spreadsheet for a bank meeting, it’s useful for a few weeks, and then it quietly goes out of date. A rolling forecast avoids that. Every time a week or month ends, you replace it with what actually happened and add a new period at the end, so the forecast always looks the same distance ahead and always reflects the latest information. This guide explains how to set one up and the routine that keeps it rolling.

Fixed vs rolling

By October, a fixed January-to-December forecast only looks three months ahead, just when you need to plan the next year. A rolling 12-month forecast in October runs to the following September.

Choosing your horizon

• 13 weeks, rolled weekly: for managing cash closely, especially when it’s tight. See the 13-week forecast guide.
• 12 months, rolled monthly: for planning hires, purchases, seasonality and funding.
• Both: many businesses roll a 13-week forecast every week and a 12-month forecast every month, with the first quarter of the monthly view agreeing with the weekly one.

Setting up a rolling forecast

1. Use dates, not fixed labels. Headers should be calculated from a start date (for example, each month is one month after the previous one), so changing the start date moves the whole forecast.
2. Keep the structure stable. Use the same lines every period, so comparisons work.
3. Add an actuals area. Either an actuals tab with the same layout, or a column for each period’s actual next to the forecast.
4. Add a variance view. Actual minus forecast, line by line, highlighting big differences.
5. Set a buffer so low periods are flagged automatically.

Our templates are built this way: change the start date on the Settings tab and every header moves.

The roll-forward routine

At the end of each period:

1. Record actuals. Enter what actually came in and went out, from your bank statement or accounting software.
2. Compare and explain. Note every line where actual differed from forecast by more than about 10 percent, and why.
3. Adjust the future. If a difference will repeat, change future periods. A customer who always pays two weeks late should be forecast that way from now on.
4. Move the start date forward by one period.
5. Add the new last period. Forecast it from your current plans and last year’s equivalent period.
6. Save a version. Keep a copy so you can compare forecasts over time.
7. Decide. Check the lowest balance ahead and agree any action.

A worked example

A business rolls its 12-month forecast at the end of March. March actuals show customer receipts $5,500 lower than forecast because two clients paid in April instead. The owner:

• moves those receipts into April, where they’ve now arrived
• notices the same two clients paid late in January too, and pushes their future invoices back two weeks across the forecast
• adds next March, based on this March’s actuals plus 8 percent growth
• sees that the lowest balance ahead has moved from July to August and fallen by $3,000, still above the buffer, and makes no change except to chase those two clients earlier

The whole update took twenty minutes.

Keeping versions

Saving a copy at each roll-forward, such as “Forecast at 31 March”, builds a history you can learn from. Compare what you forecast for June in January, March and May, and you’ll see which assumptions drift and in which direction. That’s the fastest route to better forecast accuracy.

Rolling forecasts and budgets

A rolling forecast doesn’t replace an annual budget. The budget sets the target for the year; the rolling forecast tells you where you’re heading and whether you can fund it. Compare the two quarterly: if the rolling forecast shows the year finishing well away from budget, that’s an early signal to change plans. See cash flow forecast vs budget.

Rolling forward when things change fast

In a crisis or a period of rapid growth, a monthly roll may not be enough. Switch the 12-month forecast to monthly rolls as usual, but add a weekly 13-week roll for the period of uncertainty, and review both together. Once things settle, drop back to the monthly routine.

Common mistakes

• Rolling without actuals. Moving the dates forward without recording what happened loses the learning.
• Changing the structure every month. Adding and removing lines breaks comparisons.
• Only adjusting the new period. If you’ve learned something, apply it to every future period.
• Skipping a period. Once the routine lapses, the forecast goes stale quickly. Put it in the calendar.
• Too much detail. The more lines, the longer each roll takes. Twenty to forty lines is plenty for most small businesses.

Who should own it

One person should own the rolling forecast: usually the owner in a small business, or a finance manager or bookkeeper in a larger one. They don’t have to produce every number, but they make sure the roll-forward happens on time, collect updates from whoever manages sales and purchasing, and bring the forecast to a short review meeting. Shared ownership usually means no ownership, and a forecast nobody owns stops rolling within a couple of months.

Making the routine stick

Tie the roll-forward to something that already happens: the Monday morning payment run for a weekly forecast, or the day your bookkeeper closes the month for a monthly one. Keep a short checklist next to the file. After three or four cycles it becomes a habit, and the forecast becomes the thing you open first when a decision comes up.

Templates built to roll

The free templates use a start date on the settings, so rolling forward is a matter of changing one cell and updating the numbers. Premium templates add an actuals tab and a variance report, so the comparison step is automatic.