The Dealer's Playbook for the 13-Month Rolling Forecast

Why Most Dealerships Get Their Rolling Forecast Wrong (And What Your Controller Needs to Know)

It's late June. Your controller walks into your office with a spreadsheet open on their laptop, and you can already tell from the look on their face that something's off. Sales were supposed to track 8% ahead of plan. Instead, the month is trending flat, and they need to know what that means for July, August, and beyond. The problem? Your current forecast model is built on last year's numbers, which doesn't account for the shift in floor plan strategy you made three months ago, the new service director's ramp-up curve, or the fact that your parts inventory just expanded into a whole new category. That's when you realize: a static budget isn't a forecast at all.

A 13-month rolling forecast isn't just an accounting exercise. It's a real-time operational tool that keeps your dealership's cash flowing smoothly, your floor plan in balance, and your gross profit targets within reach.

1. The Core Logic: Why 13 Months, Not 12

A 13-month rolling forecast works like this. Every single month, you drop the oldest completed month and add a new projected month at the end. This means you're always looking 12 months forward, but you're doing it with actual performance data from the month you just closed.

That extra month—the 13th—matters more than you'd think.

When you only plan 12 months at a time, you're forced to have awkward conversations every December about whether next year's plan is still valid. With a rolling model, you're updating continuously. October's actual results immediately reshape your November, December, January, and February projections. Your controller isn't scrambling to rebuild an annual plan from scratch; they're refining a living document based on real data.

This approach is especially important for dealerships managing floor plan cycles. Say you're carrying $1.2M in floor plan on your New vehicle inventory with an average age of 52 days. When you roll your forecast forward each month, you catch inefficiencies immediately. If days-to-front-line is creeping up because wholesale velocity is slower than projected, your cash flow forecast updates right then. You're not finding out six months later that you've been carrying dead inventory longer than your financial statement showed.

2. Building the Forecast: Top-Line Revenue and the Dealership Accounting Framework

Start with unit sales and average transaction prices (ATP). These are your foundation.

Your office manager should own this piece. They pull actual ATP from the past three months (not just last month,seasonality matters), segment by new vs. used, and project forward based on your sales pipeline and market conditions. If you've got 47 days of new vehicle inventory on the lot in July, and your market absorption rate is 15 units per day, you can model with confidence. If inventory is tight, dial it back.

The same logic applies to used vehicle sales. A typical high-volume used dealer might project 35-45 units per month on average, but summer months often run 10-15% hotter than winter, and holiday weeks kill velocity. A dealership in a truck-country market (think Texas Hill Country or Oklahoma panhandle) might see a seasonal bump in used truck sales around spring and fall when ranchers and contractors refresh their fleets. Your forecast needs to account for that regional rhythm.

Here's where most dealerships miss the mark: they forget to account for changes in sales mix. Say your gross profit per vehicle has been $2,100 on average across all sales. But in August, you know you're running a heavily promoted used car event targeting lower-margin vehicles. Your ATP might stay the same, but your per-unit gross drops to $1,650. Your 13-month forecast has to reflect that shift month by month, not pretend the mix stays constant.

3. Fixed Costs, Variable Costs, and Cash Flow Breathing Room

This is where your controller's accounting discipline becomes critical.

Break your operating costs into three buckets: fixed (payroll, rent, insurance, utilities), semi-variable (parts inventory, advertising spend that scales with sales), and variable (commissions, auction fees, reconditioning supplies). Your financial statement probably shows all of these lumped together as "operating expenses." A real forecast separates them.

Fixed costs are predictable. Your lot payment, your office staff salaries, your utilities,they're the same whether you sell 80 units or 120 units next month. Semi-variable costs move with volume, but not dollar-for-dollar. If you sell 20% more vehicles, you're not spending 20% more on advertising; maybe it's 8-10% more. Variable costs track almost directly to sales activity.

Why does this matter for a 13-month rolling forecast? Because when you separate these buckets, you can model cash flow scenarios accurately. A month where you sell 15% fewer units than projected doesn't mean your operating profit drops 15%. Your fixed costs stay the same, so the actual profit hit might be 28-30% because you're losing more gross profit than you're saving on variable spending.

Consider a typical mid-sized dealership with $850K in fixed monthly costs, $180K in semi-variable costs at planned volume, and variable costs that average 6% of gross profit. If your projected gross for next month is $420K (200 units at $2,100 average), and you miss volume by 25 units, your gross drops to $367.5K. But your fixed costs don't budge. That's a $52.5K swing in operating profit,about a 22% hit to your monthly profit plan. Your rolling forecast needs to catch that sensitivity.

4. Floor Plan and Inventory Days: The Cash Binding Factor

This is the piece that separates a dealership accounting spreadsheet from an actual cash flow tool.

Floor plan isn't just a line item on your balance sheet. It's cash that's locked into vehicles sitting on your lot. Every day a vehicle doesn't sell, you're paying interest to your floor plan provider. If you're carrying 45 new units at an average cost of $32,000 per unit with an average age of 48 days, you've got $1.44M tied up in floor plan. At a typical 7% annual rate, that costs you about $8,400 per month in interest expense.

Your 13-month rolling forecast should model inventory levels by vehicle type (new, used, demo, loaner) and track the cash impact month by month. If your service department is growing and you're adding loaners, that's cash going out. If your wholesale velocity is accelerating because a competitor closed their lot, that's cash coming back in.

A realistic scenario: You're a Texas dealer planning to add 12 loaners to your service fleet over the next six months. Each loaner costs you $28,000 in inventory investment. Over six months, that's $168K of floor plan draw. Your cash flow forecast needs to show that impact clearly, month by month, so your controller can coordinate with your floor plan provider and make sure you've got enough line capacity.

Tools like Dealer1 Solutions give your team a single view of every vehicle's status, inventory age, and floor plan impact in real time. When you're rolling your forecast forward each month, you're pulling actual data from your system, not guessing at averages.

5. Service Revenue and Parts: The Fixed Ops Multiplier

Most dealerships build their forecast around front-end sales. That's a mistake.

Fixed ops,service, parts, and body shop,often represents 35-45% of your total gross profit. If you're only forecasting new and used vehicle sales, you're missing nearly half your cash picture.

Service revenue is one of the most stable, predictable revenue streams a dealership has. A customer who buys a vehicle from you typically returns for service during the warranty period. Repeat customers come back for maintenance. Warranty work is predictable based on your in-service inventory. A typical dealership with 1,200 vehicles in customer hands (within warranty) might generate $85-120K in monthly service revenue, depending on brand, age of vehicles, and local labor rates.

Your rolling forecast should model service gross separately: labor, parts gross, and warranty absorption. If you know you've got 320 vehicles hitting their 30K-mile service window in September, you can project the labor hours and parts consumption. If you're running a manufacturer-subsidized recall campaign that month, that's additional service volume and parts pull-through.

Parts department revenue is even more straightforward to forecast. Track your monthly customer-pay parts sales, warranty parts absorption, and internal shop usage. A high-performing parts department at a volume dealer might see $35-55K in monthly sales. But if you're launching a new parts program or expanding hours, your forecast needs to reflect the ramp-up curve, not assume you'll hit steady-state sales immediately.

6. Seasonal Patterns and Regional Adjustments

Static forecasts ignore seasonality. Rolling forecasts embrace it.

Every dealership has seasons. In Texas, summer is hot, and people delay truck purchases. Winter brings buying activity for holiday bonuses and year-end budget flushes. Spring is typically the strongest sales month for pickup trucks. Fall is when lease returns hit and used inventory surges. Your 13-month rolling forecast has to account for these patterns with actual data from your own market and customer base.

But here's where it gets interesting: your regional market matters more than national trends. A dealership serving oil and gas workers in West Texas might see a demand spike in April and May when energy prices firm up. A rural dealer in Oklahoma might see a surge in used truck sales around spring when ranchers start thinking about equipment replacement. A suburban Houston dealer might track buying patterns tied to school calendars and employment cycles.

Your controller should build seasonal indices based on your actual historical performance: calculate each month's sales as a percentage of your annual average. If your three-year average for June is 112% of monthly average, and your three-year average for January is 87%, those indices go into your rolling forecast. Then, when you're projecting next June, you apply that 1.12 multiplier to your base forecast.

7. Approval Workflows and Scenario Planning

A forecast isn't useful if nobody acts on it.

Your controller should update the rolling forecast on the same schedule every month. Ideally within 5 business days of month-end close, when your actual results are finalized. That forecast then goes to your general manager or dealer principal, along with a variance analysis showing where you're tracking versus plan and what that means for the next quarter.

The real power comes when you use the forecast for scenario planning. What if floor plan rates spike to 8% instead of 7%? What if used vehicle wholesale prices drop 4%? What if your service advisor count falls short by one person due to turnover? A good rolling forecast lets you model these scenarios and understand the cash impact before they happen.

This is where an integrated platform makes a difference. When your forecast is built inside a system that also manages your ROs, your estimates with line-by-line approval, and your parts tracking, you're not manually updating numbers. Your controller runs a report, pulls actual performance data, adjusts projections based on the forward pipeline, and the forecast updates automatically.

8. The Monthly Rhythm: Who Owns What

Here's the operational reality: a 13-month rolling forecast only works if someone is accountable for maintaining it.

Your office manager or controller owns the model. Your general sales manager owns the front-end revenue projections (units and ATP). Your service director owns service revenue and parts forecasts. Your finance manager owns floor plan and interest expense assumptions. Your dealer principal owns the final review and approval.

Each of these people should have a defined input deadline. Sales projections due by the 3rd. Service and parts by the 4th. Finance reconciles floor plan and interest by the 5th. Controller builds the consolidated forecast by the 8th. GM reviews by the 10th. Done.

Without this structure, your forecast becomes a relic that nobody updates and nobody trusts.

9. The Data Discipline That Makes It Real

Your financial statement is historical. Your rolling forecast is predictive. The only way they work together is if they're built on the same data foundation.

Your vehicle inventory system, your service management system, your accounting software,these all have to feed clean data into your forecast model. If your days-to-front-line calculation is different in your accounting spreadsheet than it is in your DMS, you've got a problem. If your service labor revenue is calculated differently in your RO system than on your P&L, your forecast won't reconcile.

Spend time up front building data definitions and reconciliation points. Then trust the system.

10. When the Forecast Breaks (And How to Know It's Broken)

A rolling forecast is only as good as the assumptions behind it. And assumptions break.

If you're tracking three months of actual results against forecast and you're consistently missing revenue by 8-12%, something in your forecast model is wrong. Maybe your ATP assumptions are too high. Maybe your market absorption rate has shifted. Maybe your sales cycle is longer than you thought. Don't just accept the variance,investigate it and update the model.

The same applies to costs. If your semi-variable costs are running 15% higher than projected at the same sales volume, dig into line items. Is advertising spend higher than assumed? Did you add a position mid-month? Did parts inventory grow beyond plan? Once you understand the driver, adjust the forecast forward.

A rolling forecast should improve every month because you're getting smarter about your business with real data. If it's getting worse,becoming less accurate,you need to step back and rebuild your assumptions.

The Bottom Line

A 13-month rolling forecast isn't about creating a perfect prediction of the future. It's about building a disciplined system for understanding your cash position, your profit drivers, and your operational trends 90 days, 6 months, and 12 months ahead. It's about having real conversations with your controller, your GMs, and your team about what's working and what needs to adjust. And it's about making decisions based on data instead of surprises.