Every Growth-tier client at RS gets a 12-month rolling forecast. Same spreadsheet structure, customized to the business. It is the single piece of FP&A output that does the most work for the money. Here is how we build it, what goes in each tab, and how the output ties back to a one-page summary that fits in a board deck or a Friday email to the owner.
What "rolling" means and why it matters.
A static annual budget is what most small businesses do. Build it in November for the next calendar year. Roll it out in January. By April it is stale. By August it is fiction. The team stops looking at it because the actuals have moved on.
A rolling forecast is different. Every month, when the books close, the forecast updates. We drop the oldest month off the back and add a new month onto the front. So at any point in time, you have a 12-month forward view that reflects what actually happened last month. The forecast never expires. The conversation about "where are we going" stays alive all year.
The mechanical work to maintain a rolling forecast is small. About 90 minutes a month, after the close. The behavioral benefit is enormous.
The structure: five tabs, in order.
Tab 1: Assumptions.
Every variable that drives the model lives here. Pricing. Headcount. Sales cycles. Conversion rates. Vendor cost inflation. Tax rates. Anything that you might want to flex when you build a scenario. The forecast tab does not contain hard-coded numbers. It contains formulas that pull from Assumptions. This is what makes scenario modeling possible. You change one cell on the Assumptions tab and the entire forecast recalculates.
Tab 2: Revenue.
Revenue gets its own tab because the build is bottom-up. We do not write "Revenue: $50K/month" as a single line. We build it from the units. Customers times average ticket. Or units times price. Or accounts times MRR. Whatever the right driver is for this business. Then the monthly revenue rolls up to a total row that feeds the P&L tab. When you want to see what happens if you add two salespeople, you flex the pipeline assumption. When you want to see what happens if pricing drops 5 percent, you flex the price assumption. The model handles it.
Tab 3: Cost build.
Same idea on the cost side. Direct labor by headcount by month, tied to a hiring plan. Materials by unit. Marketing spend by channel. Overhead by category. The cost tab is where most small business forecasts get sloppy, because "operating expenses go up 5 percent" is easy and lazy. We force the build to be granular. So when costs surprise you, you know exactly which line moved and why.
Tab 4: P&L forecast.
This is the output everyone looks at. 12 months across the top, line items down the side, all formulas pulling from the Revenue and Cost build tabs. Three columns to the right of the 12 months: trailing-twelve-month total, full-year forecast, and full-year prior year for comparison. Below the operating P&L, the bridge to net income (interest, taxes, depreciation).
Tab 5: Cash forecast.
The 13-week cash forecast is the most-used tab for owners who are cash-tight. Weekly inflows and outflows, opening cash balance, ending cash balance. We tie the inflows back to the AR aging from the books, and the outflows back to AP plus scheduled payroll and tax payments. It is the only tool that answers the question "do I have a cash problem in the next 90 days?" The answer is usually surprising in both directions.
Want to see what one of these actually looks like in client output?
Our sample reporting package includes a forecast walk-through, variance commentary, and the dashboard view that ties it all together. It is the kind of FP&A output we deliver every month.
Get the sample packageThe variance commentary template.
The forecast alone is not the product. The variance commentary is. Every month, after the close, we write a one-page document that explains what just happened relative to the forecast. The structure is always the same.
- Topline summary. One sentence. "Revenue came in at $412K, $8K below forecast, driven by softer enterprise close rates and offset by stronger SMB volume."
- What surprised us, good and bad. Two or three bullets each. The point is honest reporting, not spin. Owners want to know what is working and what is not.
- What we are changing in the next 30 days. The actionable part. Maybe a hiring plan slows down. Maybe a marketing channel gets reduced. Maybe a pricing experiment runs. These are the decisions the forecast is for.
- What to watch. Two or three forward indicators that will tell us whether this month was a blip or a trend.
The whole thing fits on a single page. Owners read it in 90 seconds. CFOs and operators can both ground the conversation in it. It is the bridge between the spreadsheet and the decision.
How the one-page board view falls out.
The single-page summary for a board or a lender is just the top of each tab, formatted for printing. Revenue trend chart from the Revenue tab. Operating expense chart from the Cost build tab. P&L summary from the P&L tab. Cash position from the Cash forecast tab. The variance narrative goes at the bottom. Done. No re-keying, no separate model, no maintenance burden.
This is why the forecast model is built the way it is. Every output downstream of it (board pack, lender update, investor email, internal review) is a view onto the same source of truth. When you change an assumption, every downstream document changes automatically.
Common mistakes to avoid.
- Hard-coded numbers in the forecast. Every number in the forecast should trace back to a formula. If you cannot answer "why is this number what it is?" the model is brittle.
- Forecast not updated when actuals come in. The point of a rolling forecast is that it reflects current reality. If the actual column shows last quarter's data, nobody trusts it.
- Overcomplexity. The model should be exactly as complex as the business. Not more. We have seen 14-tab models for businesses that did not need them. Simpler is almost always better.
- No variance commentary. A forecast with no commentary is just a spreadsheet. The commentary is what makes it useful.
If you are not ready to build this yourself.
This is what we do for Growth-tier clients. Build the model, maintain it monthly, write the variance commentary, deliver the one-page summary. The investment is meaningfully less than hiring a full-time FP&A person, and the output is decision-grade. If you have outgrown spreadsheets but cannot justify a full-time finance hire, this is the gap we fill.