How to Build a Rolling Forecast
An annual budget starts going stale the day you finish it. A rolling forecast fixes that by always looking the same distance ahead: every month you drop the month that just ended, add a new one at the end and update the rest with what you now know. Here is how to build one in a simple spreadsheet and keep it alive without it eating your week.
Key takeaways
- A rolling forecast always covers a fixed window, often the next 12 months, and moves forward one month every time a month closes.
- Build it from a handful of drivers, such as customers, average order value and headcount, instead of guessing every line by hand.
- Update it on a fixed monthly routine: load actuals, compare them with the forecast, adjust drivers and add the new month.
- Keep it simple enough that one person can refresh it in about an hour, or it will quietly stop being updated.
If you have ever opened your budget in June and thought "none of this is true anymore," you are not alone. Budgets are usually built once a year, often in a rush, based on what you believed at the time. By the middle of the year, a big client has arrived or left, a supplier has changed prices and the plan no longer matches reality. You still need a view of the future, though, especially when you are deciding whether to hire, buy stock or sign a lease.
A rolling forecast gives you that view. It does not replace the thinking behind a budget. It simply keeps that thinking current, so the numbers you use for decisions are the best numbers you have today.
What a rolling forecast is (and how it differs from a budget)
A rolling forecast is a projection of your revenue, costs and cash that always extends a set number of months into the future. With a 12-month rolling forecast, in late May you look at June through the following May. When June closes, you replace the June estimate with actual results, add the following June at the end, and you are once again looking 12 months ahead.
A budget is different. It is usually fixed for a calendar or financial year and works as a target or a spending limit. It is useful for accountability, but it shrinks as the year goes on: in November, your budget only shows you two months ahead.
| Annual budget | Rolling forecast | |
|---|---|---|
| Time window | Fixed year that shrinks as months pass | Always the same length, such as 12 months |
| Main job | Set targets and limits | Show the most likely future |
| How often it changes | Rarely, maybe once mid-year | Every month |
| Best for | Accountability and approvals | Decisions on hiring, stock and cash |
Many small businesses keep both: a budget as the promise, and a rolling forecast as the weather report. If you already run a short-term weekly cash view, such as a 13-week cash flow, the rolling forecast sits above it and covers the longer horizon.
Choose your window, level of detail and drivers
Before you open a spreadsheet, make three small decisions. They shape everything else and stop the forecast from growing into a monster.
Pick a window
Twelve months is a common choice because it always shows a full seasonal cycle. A shop that sells more in December, or a landscaper who is busiest in summer, can see the next peak and the next quiet patch at any point in the year. Some fast-moving businesses use 6 months; some planning big investments use 18 or 24. Start with 12 unless you have a clear reason not to.
Pick a level of detail
You do not need every line from your accounting software. Group expenses into 8 to 15 categories that you actually make decisions about: payroll, contractors, rent, software, marketing, cost of goods sold, travel and so on. Monthly columns are plenty for most businesses.
Pick your drivers
Drivers are the few inputs that cause most of your numbers to move. Instead of typing a revenue figure for each month, you forecast the driver and let a formula do the rest. Good examples:
- Subscription or retainer business: starting customers, new customers per month, cancellations per month, average monthly price.
- Product business: orders per month, average order value, cost of goods as a share of sales.
- Service business: billable hours or projects per month, average rate, utilization of the team.
- Costs: headcount and average cost per person, plus a few fixed costs that rarely change.
Pro tip
Limit yourself to five or six drivers at first. If you cannot explain in one sentence why a driver changes, it probably is not a driver. It is just a line item.
How to build your first rolling forecast
Set aside two or three hours for the first version. After that, each monthly update should take far less time.
- Pull the last 12 months of actuals. Export your profit and loss by month from your accounting software, plus bank balances at each month end. This is your history and your sanity check.
- Set up the layout. One tab for drivers, one for the forecast, one for actuals. Months run across the columns; categories run down the rows.
- Enter your drivers for the next 12 months. Start from recent averages, then adjust for anything you already know: a price change, a new hire, a seasonal pattern you saw last year.
- Link the forecast to the drivers. Revenue equals customers times price, or orders times average order value. Payroll equals headcount times average cost. Fixed costs can stay as typed numbers.
- Add a simple cash line. Start with opening cash, add expected receipts, subtract expected payments, and carry the closing balance forward. Adjust for timing if customers pay late or you pay suppliers on terms.
- Mark the known events. Annual insurance, tax payments, loan repayments, a planned equipment purchase. These are easy to forget and painful to discover.
- Sense-check against history. If the forecast says next quarter will be twice as good as any quarter you have ever had, ask what has really changed.
Example
Imagine Lena, who runs a small bookkeeping practice with three staff. Her drivers are clients (40 today), new clients per month (2), lost clients per month (1) and average monthly fee ($350). Her forecast for next month shows 41 clients times $350, or $14,350 of revenue. Payroll is 3 people times an average monthly cost of $3,800, or $11,400. When she considers a fourth hire, she changes one driver and instantly sees the months where cash would dip. (All figures are made up for illustration.)
A rolling forecast template you can copy
Here is a stripped-down layout to start from. Copy the rows into a spreadsheet and extend the columns to 12 months. The amounts are made-up examples, not benchmarks.
| Line | Type | Jun (example) | Jul (example) | Aug (example) | Notes |
|---|---|---|---|---|---|
| Active customers | Driver | 41 | 42 | 43 | +2 new, 1 lost each month |
| Average monthly price | Driver | $350 | $350 | $365 | Price change planned for August |
| Revenue | Formula | $14,350 | $14,700 | $15,695 | Customers times price |
| Payroll | Formula | $11,400 | $11,400 | $15,200 | Fourth hire starts August |
| Closing cash | Formula | $22,000 | $23,100 | $20,900 | Includes annual insurance in August |
Add a column at the far right for "12-month total" and a small block at the top that shows the lowest closing cash balance in the window. That single number tells you a lot about how much room you have.
Add a simple best case and worst case
Once the base version works, copy the driver tab twice. In one copy, nudge your key drivers down (fewer new customers, more cancellations, slower payments). In the other, nudge them up. You now have three views of the year without building three models. You do not need precise probabilities. The point is to see which months get tight if things go a little worse than planned.
Common mistake
Forecasting profit and forgetting cash. A profitable month can still leave your bank account lower than you expect if customers pay in 60 days and your supplier wants payment upfront. Always include at least a basic cash line, and adjust it for the timing of money in and money out.
The monthly update routine
The whole value of a rolling forecast comes from updating it. Pick a fixed day, such as the fifth working day after month end, once your bookkeeping is closed. Put it in your calendar as a recurring meeting with yourself.
- Load the actuals. Replace last month's forecast with the real figures from your books.
- Compare and note the gaps. Where were you off by more than a small amount? Write one line explaining each big gap.
- Update the drivers. Did a gap reveal something lasting, like a higher cancellation rate? Change the driver for future months, not just the past.
- Add the new month. Extend the window by one column so you are looking 12 months ahead again.
- Check the key outputs. Lowest cash point, total revenue, total profit. Did any of them move a lot?
- Decide and act. Write down any decision the update triggers: delay a purchase, chase invoices, raise prices, start hiring.
Keep a small accuracy log
Add a tab where you record, each month, what you forecast three months earlier and what actually happened. Over time this shows whether you are consistently optimistic or cautious. Most owners lean optimistic on revenue and cautious on costs, and seeing it in black and white helps you correct.
Pro tip
Late spring and early summer are a natural time to start. You already have several months of this year's actuals, and you can see the second half of the year and the following spring in one view before the busy season hits.
Common pitfalls and how to avoid them
Rolling forecasts fail for boring reasons, not complicated ones. Watch for these:
- Too much detail. Hundreds of rows make the monthly update a chore, so it gets skipped. Group lines and use drivers.
- Treating it as a target. If people are judged against the forecast, they start padding it. Keep the budget for targets and the forecast for honesty.
- Hard-coded numbers everywhere. Typing values directly into formula rows breaks the link to drivers. Color-code input cells so you can see what is typed and what is calculated.
- No owner. Someone has to update it every month. In a small business that is usually the owner or the bookkeeper. Name that person.
- Ignoring tax and one-off payments. Tax bills, annual renewals and loan repayments belong in the forecast from day one.
A quick note: this article is general information about financial planning, not accounting, tax or investment advice. For decisions with big consequences, such as taking on debt or a major hire, it is worth reviewing your forecast with an accountant or a qualified financial adviser.
Your rolling forecast action plan
- Choose your window, usually 12 months
- Group expenses into 8 to 15 decision-friendly categories
- Pick five or six drivers that explain most of your numbers
- Export the last 12 months of actuals and month-end bank balances
- Build the drivers, forecast and actuals tabs and link them
- Add a basic cash line and mark known one-off payments
- Create simple best case and worst case copies of the drivers
- Book a recurring monthly update slot after your books close
- Start an accuracy log and review it every quarter
Frequently asked questions
Do I still need an annual budget if I have a rolling forecast?
Many businesses keep both. The budget sets targets and spending limits for the year, while the rolling forecast shows what is most likely to happen. If you are a solo business, a rolling forecast alone may be enough, as long as you update it.
Can I build a rolling forecast in a spreadsheet?
Yes. For most small businesses a spreadsheet is the best place to start, because it is flexible and easy to change. Dedicated planning tools can help later, but check current features, pricing and privacy policies before you connect your accounts.
How accurate should a rolling forecast be?
It will never be exact. Aim for a forecast that is close enough to make good decisions and that improves over time. Your accuracy log tells you whether you are getting better.
What if my business is very seasonal?
A 12-month rolling forecast suits seasonal businesses well, because you always see a full cycle of peaks and quiet months. Base your drivers on the same months last year, then adjust for what has changed.
Related reading
The bottom line
A rolling forecast is a living view of the next 12 months. Build it from a few clear drivers, include cash as well as profit, and refresh it on the same day every month: load actuals, explain the gaps, update the drivers and add the new month. That routine matters far more than a clever spreadsheet.
Start this week with a rough version. It does not need to be pretty. Once you have used it to make one better decision about hiring, stock or spending, you will not want to go back to a budget that goes stale by June.
