Car Dealer MIS Reports: The Daily Numbers Every MD Should See

Every MD should see a short set of numbers daily: enquiries by source, test drives, bookings and retail against target by branch, model and salesperson, deliveries, lost reasons, cash collected and overdue follow-ups. Each week and month, add conversion ratios, stock ageing, and finance, insurance and accessories attach rates, so problems surface while there is time to fix them.

In many Indian dealerships, the MIS is still an Excel file that a sales coordinator builds every evening from three or four sources. By the time the MD reads it, the day is over, and when a number looks wrong there is no way to click into it. This guide sets out what a useful MIS should contain, how to read it, and how a dealer management system can take the manual work out of it.

What is an MIS report in a car dealership?

MIS stands for management information system. In a car dealership, the MIS is the set of numbers the owner, MD and general manager use to run the business: how many customers came in, how many booked and took delivery, how the team is doing against target, where money is stuck and where leads are being lost.

Dealers often call the sales-funnel summary the ETBR report, after the main stages: enquiries, test drives, bookings and retail (some add visits and lost leads: ETVBRL). A good MIS adds deliveries, lost leads, stock, add-on income and collections, and splits everything by branch, model and salesperson.

The daily MIS: numbers to check every morning

Keep the daily MIS short. If it takes more than ten minutes to read, it will stop being read.

Two habits make the daily MIS useful. First, look at month-to-date figures against the month-to-date target, not the full-month target. Second, always drill into the one number that looks wrong, down to branch, model and salesperson, before you call anyone.

The weekly MIS: patterns and people

Once a week, step back from daily totals and look at patterns:

• Conversion ratios. Enquiry to test drive, test drive to booking, booking to retail. Ratios show where customers stop moving.
• Source quality. For each lead source, how many enquiries became test drives and bookings. A portal or ad campaign that brings volume but no bookings needs a hard look.
• Salesperson leaderboard. Bookings, retail and test drives per consultant against their own target. Look for consultants with many enquiries but few test drives; they may need coaching or fewer leads.
• Lost-reason trend. Price, waiting period, finance rejection, bought elsewhere, not reachable. A changing mix tells you what to fix.
• Pending approvals. Bookings or discounts waiting for a manager. Every day of delay is a day the customer can change their mind.
• Stock ageing. Cars grouped by days in stock, by model and branch. Ageing cars need a plan: a transfer, a scheme or a focused push.

For more on reading the sales funnel stage by stage, see our automotive sales pipeline guide.

The monthly MIS: profit drivers and the big picture

At month end, the MD needs the full picture:

• Target vs achievement for the month by branch, model and salesperson, including your OEM targets
• Finance, insurance and accessories attach. Of the cars delivered, how many were financed through you, how many took insurance through you, and the accessories and extended warranty sold per car. These lines often decide the profit of the month.
• Exchange. How many used cars were evaluated, how many were bought in, and how many evaluations were lost on price.
• Branch comparison. The same ratios side by side, so a strong branch's habits can be copied by a weak one.
• Booking backlog. Bookings carried into next month, with their age, so you can spot cancellation risk.
• Collections outstanding. Money still to be received, and from whom.
• Lost-lead analysis. The full month's lost reasons by source and model.

Who should see which numbers

One MIS for everyone usually means a report that is too long for the MD and too vague for the team. Split it by role:

• MD or owner: the group and branch summary, target vs achievement, cash, stock ageing and the exceptions that need a decision.
• General manager or branch manager: the same numbers for their branch, plus pending approvals, deliveries and the team leaderboard.
• Sales manager or team leader: each consultant's enquiries, test drives, bookings, overdue follow-ups and lost reasons.
• Finance, insurance and accessories heads: attach per car delivered, by branch, model and consultant.
• Accounts: collections, receipts and outstanding amounts.

Everyone should work from the same underlying data, so the numbers match when the meeting starts.

How to read MIS numbers without fooling yourself

• Read ratios, not only totals. A month with more bookings can still be worse if enquiries doubled and conversion fell.
• Compare with your own history. Industry averages for India are rarely published reliably, and they vary by brand, city and season. Your own last month, and the same month last year, are the better benchmarks.
• Be careful early in the month. On the third of the month, month-to-date numbers are small and swing widely. Compare with the same days last month instead.
• Watch the festive calendar. Navratri, Dussehra and Diwali can shift bookings between weeks and months. Compare festive periods with festive periods.
• Ask "why" before "who". A falling ratio is a question about the process first. Lost reasons and follow-up data usually show the answer.

Overdue follow-ups are often the earliest warning in the whole MIS. Our car dealership lead follow-up guide explains how to set the follow-up routine that keeps them down.

Common problems with an Excel MIS

Excel is flexible, which is exactly why MIS sheets go wrong:

• It is late. Someone builds it after the day ends, so the MD reacts a day behind.
• It is fragile. One broken formula or pasted row changes a total, and nobody notices.
• It is inconsistent. Enquiries come from one system, bookings from another sheet and retail from accounts. Different managers quote different numbers in the same meeting.
• It cannot be drilled into. When a number looks wrong, the MD has to phone someone to find out why.
• It depends on one person. When the coordinator is on leave, the MIS stops.
• It lives on WhatsApp. Versions get forwarded, edited and lost.

What a DMS dashboard changes

When enquiry, test drive, booking, invoice, delivery and RTO all sit in one dealer management system, the MIS stops being a separate job. The numbers come from the same records the team works on every day, so they are current and consistent.

A good DMS dashboard should give you:

• Target vs achievement across the key funnel stages and add-on lines, by branch, model and salesperson
• Drill-down from the group to a branch, a team and a single consultant
• Live leads and bookings, not yesterday's sheet
• Stock ageing by model and branch
• Reports in Excel and PDF, for anyone who still wants the sheet
• A scheduled daily report sent to the right people, so managers see the numbers without logging in

If you are comparing systems, check reporting carefully with our checklist on how to choose a dealer management system in India.

Where an AI assistant helps

Dashboards answer the questions someone thought of in advance. MDs often have a different question: "Why are SUV bookings down in the second branch this week?" or "Which consultants have the most overdue follow-ups?" Building a new report for every question is slow.

This is where an AI assistant on top of the DMS helps. The Cyepro MD assistant, currently a Beta with pilot dealers, lets an owner or MD type a question, or ask by voice in Telugu, Hindi, Kannada, Marathi, English and more Indian languages, and answers from the dealership's own data, in English. It shows the data it used, can export the answer to Excel, and is read-only, so it cannot change anything. It does not answer every question yet; when the data is not available, it says so rather than guessing. Answers are not instant either: the assistant takes a little time to look up the data before it replies.

A simple MIS routine for an MD

• Every morning, ten minutes: the daily table above. Drill into the one number that looks wrong.
• Every Monday, thirty minutes: conversion ratios, source quality, the salesperson leaderboard, lost reasons, pending approvals and stock ageing, with the sales manager.
• At month end, one hour: target vs achievement, attach rates, exchange, branch comparison, backlog and collections, with the GM and accounts head.

Cyepro DMS offers role-based dashboards and reports for MDs. See how it works on our MD dashboard and MIS reports page, or read how the full Cyepro dealer management system connects every stage from enquiry to RTO. Book a demo and we will show your MIS built from your own process.