Nobody plans a picnic using the weather forecast they saw in January. You check the morning of, and maybe again at lunch, because the sky has opinions and they change.
Most small business budgets work like the January forecast. They're built once, with real care, sometime in December. By April, a big client has doubled its order, a key hire took longer than planned, and the budget is describing a year that never happened. Everyone politely stops opening the file.
A rolling forecast is the fix. Below: what it is, how it compares to a budget, how to build one in a few hours, and the monthly routine that keeps it useful.
What is a rolling forecast?
A rolling forecast always looks the same distance ahead. With a 12-month version, in January you forecast January through December. When January closes, you swap its estimates for the actual numbers and add next January at the end. In February you're still looking 12 months out.
Compare that to a fiscal-year budget, which shrinks as the year goes on. By October, an annual budget only has three months left to say anything about. A rolling forecast still has twelve.
Rolling forecast vs budget: do you need both?
They answer different questions, so many businesses keep both.
- A budget is a target. It's set once, often approved by owners or lenders, and it stays fixed so you can measure against it.
- A rolling forecast is a best current estimate. It changes as the facts change, and that's the point.
The budget tells you what you meant to do. The forecast tells you where you're actually headed. If you want the longer version of that distinction, budgeting and forecasting: what's the difference, and do you need both? covers it in detail.
One caution: don't rewrite the budget every month to match the forecast. Then you have two forecasts and no target, and the budget vs actual report loses its job.
How to build a rolling forecast in an afternoon
You don't need special software. A spreadsheet works fine at most small business sizes.
- Start with 12 months of actual results from closed, reconciled books. Group them into 10 to 20 lines, not 140. Revenue by main service or product line, cost of goods sold, payroll, rent, software, marketing, everything else.
- Pick drivers for the big lines. Revenue might be clients times average monthly fee, or jobs times average job size. Payroll is headcount times cost per person, including employer taxes and benefits.
- Project 12 months forward using those drivers. Note your assumptions in a column next to the numbers (for example, "two new clients in Q2" or "new tech hired in May").
- Set a monthly update date, such as the day after the books close.
The drivers matter more than the totals. When something changes, you change the driver and the numbers follow, instead of retyping 48 cells.
A worked example: one month of rolling
Imagine a hypothetical event-rentals company (tents, tables, string lights) built its forecast in January with revenue of $90,000 for March. March closes at $112,000, because two corporate clients booked spring parties early.
At the monthly update, the owner does four things:
- Replaces March's $90,000 estimate with the $112,000 actual.
- Asks whether the bump is timing or growth. Here, the early bookings pull revenue forward, so April's forecast drops from $95,000 to $82,000.
- Bumps the summer months by 5% because quote requests are running higher than last year.
- Adds next March to the end of the forecast, using this March's actual as a starting point.
In a static budget, the year would just look "ahead of plan" and the owner might spend accordingly. The rolling forecast shows that April will be lighter, which is useful to know before committing to a new trailer.
Add a rolling cash flow forecast for the short term
A 12-month rolling forecast is mostly about profit: revenue, costs and margins. Cash can tell a different story in the short run, because customers pay late, loan payments come due and inventory gets bought ahead of busy seasons.
That's where a rolling cash flow forecast helps. It's usually weekly and covers about 13 weeks. Each week you drop the one that just ended and add a new one at the end. It tells you which Friday will be tight, while the 12-month forecast tells you whether the year is shaping up. If you're starting from zero, our guide to building a cash flow forecast for small business walks through it step by step.
Keeping it alive (the part most people skip)
Rolling forecasts rarely fail on the first build. They fail in month four, when updating it slips to "next week." A few habits help:
- Update on the same day each month, right after the close.
- Spend 30 minutes, not three hours. Big drivers first, small lines only if something moved.
- Keep a short change log: what you changed and why.
- Look back after six months at how close your forecasts were. That's how you learn which assumptions you're too optimistic about (usually revenue timing).
The quality of the forecast depends on the quality of the actuals. If last month's books are still a mess when you update, you're rolling bad numbers forward. When the forecast starts informing hiring, pricing or financing decisions, it can help to have someone own it with you; that's a core part of our fractional CFO services.
Questions owners ask
How far ahead should a rolling forecast go?
Twelve months is the most common choice for small businesses, updated monthly. Some add a weekly 13-week cash forecast alongside it. Longer horizons, like 18 or 24 months, can help when you're planning a loan or a big expansion.
Does a rolling forecast replace the annual budget?
It can, but many owners keep both. The budget stays fixed as the target, and the rolling forecast shows where you're likely to land. Lenders and investors sometimes ask for a budget specifically.
How long does it take to update a rolling forecast each month?
Once it's built around a handful of drivers, 30 to 60 minutes a month is typical for a small business. Most of that time is talking through what changed, not typing numbers.
Want more planning tools that don't gather dust?
The ABFI Accounting Brief is our newsletter of practical notes on books, closes, reporting and planning, written for owners who want numbers they'll actually use. Join The ABFI Accounting Brief for the next one. If you'd like help setting up a forecast that rolls on its own schedule, a consultation is the easy next step.