Dealer Software

Dealership Sales Forecasting: A Practical Guide for Independent Lots

11 min read · Updated 2026-11-16 · by the Loturn team

Dealership Sales Forecasting: A Practical Guide for Independent Lots

Dealer calculating a monthly sales forecast

A dealership sales forecast is an estimate of how many units you will sell next month or quarter, and how much gross profit those units will bring in. For an independent used-car lot, the useful version is built from your own deal history, adjusted for season and inventory, and stated in gross dollars rather than revenue. That only works if every car’s real cost is recorded correctly, because a forecast of sales built on guessed profit is a forecast of the wrong number. Loturn tracks every cost on each vehicle, from purchase price to transport and recon, so the gross figures a forecast rests on are real.

Loturn
loturn.com
Forecast With Clearer Cost Data
Loturn tracks each vehicle’s costs, from purchase price to transport and recon, so your sales forecast can use more accurate gross figures.
Visit

TL;DR

  • Forecast units and gross per unit separately, then multiply. Revenue alone hides whether you are making money.
  • Start with 12 to 24 months of your own closed deals, grouped by month, and adjust for seasonality instead of buying a complex model.
  • With limited history, use a simple trailing average plus a pipeline check of live leads and cars in recon.
  • Measure accuracy every month with percentage error and keep the forecast only as good as your cost data.
  • Forecast cash alongside sales: a good sales month can still drain a floorplan line.

Table of Contents

What forecasting means on a used-car lot

Big-company guides define forecasting as estimating future revenue from past sales, market trends and the deals in progress. On a lot, three questions matter more than that definition:

  1. How many units will I retail and wholesale? This drives how many cars you need to buy.
  2. What gross will they produce? This drives whether you can cover payroll, rent, floorplan interest and advertising.
  3. When does the cash arrive and leave? Gross on paper is not money in the bank until lender funding lands.

A forecast that answers all three lets you decide how much to spend at auction this week, whether to hire a second salesperson, and when to slow down buying. Most of the top-ranking forecasting guides are written for SaaS and B2B sales teams, with pipeline stages and quota. A dealer has a shorter cycle and a physical product, so the method below is adapted to that.

What data to pull before you forecast

You do not need a data warehouse. You need five sets of numbers, each by month:

Data Why it matters Where it comes from
Units sold (retail and wholesale, separately) The base of the forecast Closed deals
Gross per unit, after all costs Turns units into profit Per-vehicle cost records
Days in inventory at sale Shows how fast stock converts Purchase and sale dates
Live leads and appointments The near-term signal CRM or lead log
Cars in recon and incoming What you will have to sell Inventory list

The second row is where most lots go wrong. If transport, auction fees, parts and detail are lumped into a general expense account, the gross you see on a deal is overstated, and so is any forecast built on it. Recording costs on the vehicle itself is the fix, and our guides on per-VIN unit cost rollup and auction fees accounting show how to do it. Loturn assigns recon and transport costs to each car, so the gross you pull for forecasting is the gross after every cost.

A step-by-step forecast for an independent dealer

Step 1: Pull 12 to 24 months of closed deals

Export sold units by month. Twelve months is the minimum to see one full season; 24 lets you compare a year against the one before. Separate retail from wholesale, since they behave differently and carry different gross.

Where it goes wrong: counting deals when the contract is signed rather than when they are posted. Unwound deals and late funding then distort the month. A consistent posting routine, like the one in our deal posting checklist, keeps each month clean.

Step 1: Pull 12 to 24 months of closed deals

Step 2: Find the baseline

Take the average units per month over the last three to six months. That is your baseline. If the lot sold 14, 17, 15, 16, 13 and 17 units, the baseline is 15.3 units per month.

Step 3: Apply a seasonal factor

Sales are not flat across the year. The national industry measure, the Seasonally Adjusted Annual Rate (SAAR), is calculated by dividing unadjusted monthly sales by a seasonal factor and multiplying by 12. The same logic works on a single lot. Divide each month’s units by your average month to get your own factor. A month with 18 units against an average of 15 has a factor of 1.2; a month with 12 has 0.8.

Apply it forward. If your baseline is 15.3 units and next month’s historical factor is 1.2, forecast about 18 units. Use selling days too: the same source notes a daily average is monthly sales divided by selling days, so a month with five weekends will not match one with four.

Seasonal factor applied to monthly sales baseline

Step 4: Forecast gross per unit

Take the average final gross per unit over the last three to six months, by retail and wholesale. Multiply by your forecast units. If the lot averages $2,400 on retail units and you expect 15 retail sales, that is $36,000 of retail gross before overhead.

This is the step that needs trustworthy cost data. Our walk-through of audit-ready appraisal gross calculation explains how the number should be built.

Step 5: Check it against your pipeline

A historical average does not know that you have three cars still in recon or that a run of leads came in last week. Compare the forecast with:

  • Cars that will be front-line ready in the next two to three weeks
  • Active leads and scheduled appointments
  • Deals pending lender approval

If the forecast says 18 units and you will have 9 sale-ready cars, either buying has to speed up or the forecast comes down. For a way to structure the lead side, see our guide to sales pipeline stages for independent dealers. A general read on structuring a selling process is in these sales methodologies that move revenue.

Step 6: Set low, expected and high cases

Write three numbers: a cautious case (say 80 percent of expected), the expected case, and an upside case. Plan fixed costs against the cautious case and buying against the expected case. This turns a forecast from a guess into a decision rule.

What if you have limited sales history?

A lot open for under a year, or one that recently changed its bookkeeping, still has options.

  • Use a short trailing average. Three months of weekly sales is enough to set a rough baseline. Update it weekly.
  • Forecast from inventory. If your average car sells in about 40 days, then a lot with 30 cars should sell roughly 22 cars a month at a steady pace. Divide the number of cars by days to sell and multiply by 30.
  • Lean on the pipeline. Without seasonal history, leads and appointments carry more weight. Count them weekly and track how many turn into sales.
  • Keep the range wide. Use a plus or minus 25 percent band until you have a full year.

If you are importing earlier data from a spreadsheet, history from the past year can often be rebuilt from bills of sale and purchase invoices, which is much faster when the import is handled for you. Loturn offers free data import and setup help for that reason.

Season, inventory and pricing: what moves the forecast

Seasonality. Many lots see a strong early-year stretch tied to tax refunds and a slower late-year period, but your own history is the better guide than a national pattern. Build your own factors as in Step 3.

Inventory levels. You cannot sell cars you do not have, and cars you cannot sell tie up cash. Track days in inventory and write down stale units on a schedule; our guide to inventory write-downs covers when and how.

Pricing and sourcing. Buying price decides gross before the car is ever listed. McKinsey’s assessment of 15,000 car transactions in 2022 and 2023 found an incremental 2 percent margin opportunity from bidding with real-time used-car market pricing data, on top of an average auction margin of about 6 percent. The takeaway for a small lot: your forecast of gross per unit should be compared against what you actually paid and what that car type sells for, not just last month’s average.

Floorplan interest. Carrying cost rises the longer a car sits. A forecast that ignores it will overstate net gross; see our guide on floorplan cash flow.

How to measure forecast accuracy

After each month, compare forecast with actual. The most common measure is mean absolute percentage error (MAPE): for each period, take the absolute difference between forecast and actual, divide by actual, then average the results. A Georgia Tech study summarized by the Institute of Business Forecasting found MAPE the most popular measure companies use. The same article reports that forecast error is lowest at the industry level and highest at the location level, which is the level a single lot sits at. Expect your numbers to be noisier than national ones.

A worked example: you forecast 18 units and sold 15. The error is 3 divided by 15, or 20 percent. If next month you forecast 16 and sold 17, the error is about 6 percent. Average the two and your MAPE is about 13 percent.

There is no universal passing score. Instead:

  1. Track MAPE for units and for gross per unit separately.
  2. Look at the direction of errors. If you always forecast high, your seasonal factor or your pipeline count is off.
  3. Review quarterly and drop methods that do not improve on a simple trailing average.

The same IBF article reports that satisfied companies are more likely to measure forecast accuracy, so the habit matters more than the exact score.

Forecast cash, not just sales

A strong sales month can still leave you short. Cars sold on financing may not fund for days, floorplan payoffs go out when the car sells, and recon bills come due before the next car sells. A 13-week view of money in and out catches this early. Our guide to the 13-week dealership cash flow forecast shows the layout. To keep the numbers honest, reconcile what lenders actually paid against the deals you booked using the lender funding reconciliation process.

Where a forecast breaks, and how to fix it

  • Costs are scattered. Receipts in a folder and fees in a general ledger mean gross is guessed. Put costs on the vehicle.
  • Wholesale and retail are mixed. Their margins differ, so a blended average misleads. See wholesale deal accounting.
  • Inventory counts drift. The list says 40 cars; the lot has 37. Run a physical inventory count regularly.
  • The forecast lives in one head. Write it down, share it with whoever buys cars, and check it monthly.

Our perspective

Forecasting is only as good as the numbers underneath it, and on most independent lots those numbers are the problem. Costs sit in text messages, receipts and a general ledger that was never built for individual vehicles, so a dealer ends up forecasting a profit figure they cannot trust.

That is why we built Loturn around the single car. Every cost, from purchase price to transport and recon, attaches to the vehicle, so you see profit before the sale and the gross behind your forecast is the real one. Inventory, accounting, CRM, deal paperwork and reporting live in one place, so the units you expect to sell, the leads behind them and the money they will produce are read from the same records instead of three spreadsheets.

A forecast does not need to be sophisticated. It needs to be built on clean cost data, reviewed every month and used to decide what to buy. Get the data right first and the method can stay simple.

Eric Dosset

Put clean cost data behind your forecast

Loturn is financial management built for independent used-vehicle dealers, with per-car profit tracking, inventory, native double-entry accounting, CRM and reporting included for one flat monthly price. Plans are Flipper at $99 per month, Dealer at $349 per month and Multi-Lot at $699 per month, and free data import and onboarding support come with them. See the Loturn plans and pricing to find the size that fits your lot.

Loturn

FAQ

How far ahead should a used-car dealer forecast?

Forecast units and gross one month ahead, and cash 13 weeks ahead. Update both every week or at least every month. Longer horizons are less reliable at the single-lot level, so use them only for broad planning such as hiring or a lease decision.

What is a good forecast accuracy for a small dealership?

There is no fixed benchmark that fits every lot, and single locations see more error than large groups. A better test is whether your error shrinks over a few quarters and whether it beats a simple average of recent months. Track it with MAPE and review it monthly.

Do I need software to forecast dealership sales?

A spreadsheet can handle the arithmetic in this guide. What it cannot do is give you reliable gross per car, because that depends on every cost being recorded against the vehicle. Loturn records those costs per vehicle and reports gross in real time, which gives the forecast a solid base.

Should I forecast retail and wholesale separately?

Yes. Retail units usually carry higher gross and a different sales cycle, while wholesale moves faster at lower margin. Blending them hides trends in each. Forecast units and gross for both, then add them together.

Sources

See your real profit on every car

Loturn puts every cost on the VIN as it happens, so the profit on screen is the profit in the bank. Flat price, no contract, we import your data.

Start free trial