The 13-Month Rolling Forecast Isn't Broken—Your Process Is

According to industry surveys, roughly 72% of dealerships claim to use a rolling 13-month forecast model. Yet somehow, most of those same dealerships get blindsided by cash flow problems every single quarter. Something doesn't add up.

Here's the contrarian truth: the 13-month rolling forecast, as most dealerships actually use it, is a waste of your controller's time. Not because forecasting is bad. But because the way you're doing it right now is almost certainly wrong, and you don't even know it.

The Problem With How Most Dealerships Forecast

You know the drill. Your office manager or controller sits down every month and updates the forecast. They roll forward another month, adjust inventory assumptions based on what they think will sell, plug in some payroll estimates, maybe factor in whatever special event or promotion is planned for Q3. They send you a spreadsheet. You glance at it for thirty seconds, everything looks fine, and you move on.

Then it's mid-September, you've taken on more used inventory than expected because that auction deal was too good to pass up, and suddenly your floor plan lender is calling. Your cash position is tighter than it should be. Your controller looks confused when you ask why the forecast didn't catch this.

The reason? Most dealerships treat the 13-month rolling forecast like a financial astrology exercise instead of an operational planning tool.

A typical rolling forecast at most stores is disconnected from actual inventory movement, reconditioning cycles, days to sell, and the real constraints of your business. It's a guess wrapped in a spreadsheet. The forecast says you'll sell 18 new units next month because you always sell 18. It doesn't account for the fact that three wholesalers in your market are flooding the zone with competitive inventory, or that your used turn time has crept up from 34 days to 47 days in the last eight weeks.

And here's the part nobody wants to admit: if your forecast isn't tied directly to actual sales pipeline velocity and inventory status, it's already outdated the moment you finish building it.

Why Rolling Forecasts Fail When They're Disconnected From Operations

The real issue is structural. Your forecast lives in one place. Your actual inventory data, sales pipeline, and reconditioning status live somewhere else (or everywhere else—spreadsheets, your DMS, Slack messages, someone's email).

When those two things aren't connected, the forecast drifts. Fast.

Say you're looking at a typical month where you're projecting $385,000 in front-end gross profit from new vehicle sales. That number assumes you'll hit your unit target and maintain your average front-end gross per unit. But it doesn't account for the fact that your sales team has only one legitimate deal in pipeline for the third week of the month. It doesn't know that your lead conversion rate has been running 2.3% instead of the 3.1% you baked into the model six weeks ago. It doesn't know that seasonal demand for your market just shifted because the regional economy softened.

Your controller isn't running a forecast. They're writing fiction.

The financial statement at the end of the month will tell the real story. But by then, it's too late to adjust anything. You've already committed to payroll, floor plan, and expense assumptions that were based on a forecast that had nothing to do with reality.

The Contrarian Fix: Make Your Forecast Operational First

Stop treating the 13-month forecast as a standalone accounting document. Make it an operational mirror instead.

Your forecast should answer this question: based on where our inventory actually is right now, how fast it's actually turning, and what our sales pipeline actually looks like, what will our cash position look like twelve months from today?

That requires pulling real data from multiple places and forcing a conversation between your sales team, your service director, and your controller. Not a theoretical conversation. A real one, with actual numbers.

For example: if your used inventory is currently at 87 units with an average age of 52 days, and your actual turn time over the last 12 weeks has been 41 days, your forecast shouldn't assume you'll sell 20 units next month at a $2,800 average front-end gross. It should model out what realistically happens if you maintain that 41-day turn. Tighter inventory position. Different cash flow profile. Different gross profit picture. And that cascades into your payroll assumptions, your floor plan requirements, everything downstream.

Similarly, if your service department is producing $18,400 in daily gross profit on average, but it's trending down 3.2% month-over-month, your forecast shouldn't assume flat fixed operations revenue. It should model the decline and show you what that means for your ability to cover overhead.

This approach forces your team to actually think about the business instead of extrapolating from assumptions that haven't been questioned since 2019.

What This Looks Like in Practice

Here's a concrete scenario. Say your dealership is running a typical used car operation. Your current inventory is 72 units. Your average days to front-line has been drifting up from 28 days to 36 days over the last three months (thank you, extended reconditioning backlog and detail delays).

If your average unit cost on used inventory is $14,200, that 8-day slip in your turn time is tying up roughly $100,000 in extra floor plan carrying cost across the month. Your forecast needs to account for that.

Your controller should also be mapping cash flow week by week, not just month by month. If you're projecting 16 used unit sales in October, your forecast should show when those sales are likely to happen and when those floor plan payoffs and grosses will actually hit your cash account. Lumpy cash flow kills more dealerships than bad gross profit margins ever will. (And yes, I know some of you are thinking "But we've survived this way for ten years"—you've survived in spite of this, not because of it.)

Tools like Dealer1 Solutions can help here because they give your team a single view of every vehicle's status, reconditioning progress, and actual turn metrics. When your inventory data and your financial forecasting are talking to each other, your forecast stops being guesswork.

The Real Contrarian Take

Most dealerships think the problem is that they need a better forecast model. They don't. They need to connect their forecast to operational reality and actually update it based on what's happening, not what they hoped would happen.

If you're updating your rolling forecast once a month and not having a conversation with your sales director and service director about pipeline velocity and turn times, you're not forecasting. You're just managing a spreadsheet.

Your controller should be able to answer this question off the top of their head: "Given where we are right now operationally, what does our cash position look like in month seven of this forecast?" If they can't, your forecast isn't operational yet. You've got work to do.

The stores that actually nail this are the ones that treat the rolling forecast like a living, breathing operational tool. They update it based on real data. They kill assumptions that aren't holding up. They adjust payroll and expense commitments when the numbers shift. They don't wait for the month-end financial statement to figure out they missed something.

That's not a better spreadsheet. That's better management.

Getting Started

Start here: pull your last three months of actual sales data, inventory turns, and cash flow. Now build a forecast based on those real metrics instead of theoretical ones. See how different it looks from the forecast your controller built using assumptions.

That gap? That's the gap between theory and reality. Close it.