Stock and Sales Reports for Car Dealers: How to Use Your Data to Sell More Cars
Most independent dealers I speak to know roughly how their month is going. They know which cars sold, which ones have been sitting on the forecourt too long, and whether they are up or down on last month. But "roughly" is the problem.
When margins on a used car can be anywhere from a few hundred pounds to a couple of thousand, the difference between a good month and a bad one often comes down to decisions you made weeks ago - what you bought, what you priced it at, and how long you held it. Without proper reporting, you are making those decisions on gut feel.
That is why we built stock and sales reports into the Vehiso dealer management system. Not a bolt-on analytics tool, not a spreadsheet export - reporting that sits inside the same system where you manage your stock, enquiries, and sales every day.
Why reporting matters more than most dealers think
Here is a scenario I see all the time. A dealer buys a car at auction for GBP 6,500, spends GBP 400 on prep, lists it at GBP 8,995, and eventually sells it for GBP 8,500. That looks like a GBP 1,600 profit on paper.
But what if that car sat on the forecourt for 90 days? Factor in your pitch rent, insurance, advertising costs, and the opportunity cost of tying up GBP 6,900 for three months, and that profit shrinks fast. Meanwhile, the car you bought for GBP 4,000 and sold in two weeks for GBP 5,200 - the one that felt like a small deal - actually delivered a much better return on investment.
You only see that pattern if you are tracking the right numbers.
What to track in your stock reports
Days in stock
This is the single most important metric for any used car dealer. Every day a vehicle sits unsold costs you money - pitch space, insurance, depreciation, and advertising fees.
As a rule of thumb:
- Under 30 days - healthy. Your pricing and stock selection are working
- 30 to 60 days - review the price and listing quality. Are the photos good? Is the description compelling?
- Over 60 days - consider a price reduction or moving the vehicle to auction. Holding on "because you know it's worth more" rarely pays off
In Vehiso, you can see days in stock at a glance for every vehicle on your lot. Sort by this column and the cars that need attention jump straight out.
Stock value and composition
Knowing your total stock value tells you how much capital is tied up on the forecourt at any given time. But the breakdown matters more than the total.
Ask yourself:
- Are you too heavy on one price bracket? If 80% of your stock is GBP 8,000 to GBP 12,000 cars and the market softens in that range, you are exposed
- Do you have the right mix of makes and models for your area? A dealer in central London needs a different stock profile to one in rural Wales
- How does your current stock value compare to the same point last month or last year?
Stock turn rate
Stock turn measures how many times you sell through your average inventory in a given period. A higher turn rate means you are moving cars faster and recycling your capital more efficiently.
For example, if you hold an average of 20 cars and sell 15 in a month, your monthly stock turn is 0.75. Over a year, that works out to a turn rate of 9 - meaning you cycle through your average stock nine times.
Most successful independent dealers aim for a turn rate of 8 to 12 per year. Below 6 and your capital is sitting idle too often.
What to track in your sales reports
Profit per unit
Total revenue is a vanity metric. What matters is profit per unit sold - and that means tracking every cost that goes into each car:
- Purchase price (auction fee, transport, buyer's premium)
- Preparation costs (MOT, service, valet, bodywork, tyres)
- Advertising costs (your share of marketplace listings)
- Finance commission (if applicable)
When you can see true profit per unit, you start spotting patterns. Maybe BMWs look great on your listings but cost so much in prep that the margin is thinner than a Kia with half the sale price. You would never know that without tracking it.
Sales by source
Where are your buyers actually coming from? If you are spending GBP 500 a month on AutoTrader and GBP 200 on CarGurus, you want to know which platform is delivering more sales - and at what cost per sale.
Track every enquiry source:
- AutoTrader
- Motors.co.uk
- CarGurus
- Facebook Marketplace
- Your own website
- Walk-ins and phone calls
Over a few months, this data will show you exactly where to increase your spending and where to cut back. I have seen dealers save hundreds of pounds a month just by dropping a marketplace that was not converting.
Sales trend over time
A single month's numbers do not tell you much. It is the trend that matters. Are you selling more cars this quarter than last? Is your average profit per unit going up or down? Is your mix shifting toward higher or lower value stock?
Monthly and quarterly comparisons help you spot seasonal patterns too. Most dealers see a dip in December and a surge in March and September around plate-change months. Knowing your own pattern helps you plan your buying accordingly.
How Vehiso reporting works in practice
The reports in Vehiso are not a separate module you have to log into. They are built into the same dashboard where you manage your day-to-day operations.
Stock reports let you:
- View every vehicle with days in stock, purchase price, asking price, and preparation costs
- Filter and sort by make, model, price range, or age on the lot
- See your total stock value and how it has changed over time
Sales reports let you:
- See profit per unit with all costs factored in
- Track sales volume by week, month, or quarter
- Break down performance by vehicle type, price bracket, or source
Because everything runs through the same system - from the moment you add a vehicle to stock, through advertising it on marketplaces, handling enquiries, generating offer sheets and invoices, and completing the sale - the data is already there. You do not need to enter anything twice or reconcile spreadsheets.
Five things your reports should tell you every Monday morning
If you are going to check one thing at the start of each week, make it these five:
- How many cars did I sell last week? Compare it to your weekly average. If you are below, check your pricing and listing quality before buying more stock
- What is my oldest unsold vehicle? If anything is past 60 days, take action today - reprice it, refresh the photos, or move it on
- What was my average profit per unit last month? If it is dropping, look at whether your purchase prices have crept up or your sale prices have come down
- Which marketplace delivered the most enquiries? Double down on what is working. Cut what is not
- What is my total stock value right now? Make sure you are not over-committed. Your stock value should be a number you are comfortable holding if sales slow down for a couple of weeks
Spreadsheets vs a proper DMS
I know plenty of dealers still running their business on Excel or Google Sheets. It works - until it does not. The problems with spreadsheets:
- Data entry is manual, so it is always slightly out of date
- No one updates the spreadsheet at 6pm on a Saturday after selling a car
- Formulas break, rows get deleted, and there is no audit trail
- You cannot connect a spreadsheet to your website, marketplace feeds, or finance integrations
A dealer management system captures data as a byproduct of doing your job. When you mark a vehicle as sold in Vehiso, the stock report updates, the sales report updates, and the vehicle is removed from your website and marketplace listings automatically. No extra work.
Getting started
If you are not currently tracking your stock and sales data properly, start simple:
- Get your stock into a system that tracks days in stock and purchase costs - even if you do nothing else, this one metric will change how you buy
- Record your preparation costs against each vehicle so you know your true margin
- At the end of each month, review your profit per unit and stock turn rate
- After three months, you will have enough data to spot patterns and make better decisions
Vehiso plans start from GBP 49 per month and include full stock management, sales tracking, and reporting alongside your dealer website, marketplace feeds, and finance integrations. You can be set up and running within minutes.
Frequently asked questions
Can I export my reports?
Yes. Vehiso lets you export your stock and sales data so you can share it with your accountant or use it for your own analysis.
Do I need to enter data separately for reports to work?
No. Because Vehiso is an all-in-one system, data flows into your reports automatically as you manage your day-to-day operations - adding stock, handling enquiries, completing sales, and recording costs.
What if I am just starting out and have no historical data?
Start tracking from day one. Even one month of proper data is more useful than years of gut feel. Within three months you will have enough to spot trends in your stock turn and profit per unit.
How is this different from what AutoTrader or CarGurus show me?
Marketplace dashboards show you performance on their platform - views, clicks, and enquiries. That is useful but incomplete. Your own DMS reports show you the full picture: purchase costs, prep costs, true profit, and performance across all channels - not just one marketplace.
