In this guide 6 sections
Excel suits one careful owner. Switch when a second salesman edits the stock sheet, finance papers go missing or cold enquiries slip past, because a dealer system keeps one record per car. Everything else hangs off that record. Sheets cannot warn you.
Where a stock sheet holds up
A single sheet with chassis number, model, variant, colour, purchase date and asking price is perfectly workable for a dozen cars held by one owner. One owner, one laptop, one habit. Nothing here needs a system.
Trouble starts with a second user. A salesman marks a hatchback as booked while the manager, holding an older copy on his phone, quotes the same car to a walk-in customer. Both copies looked right.
Sheets forget history, and a used car taken on exchange, sent to the workshop for a clutch plate and returned for detailing has a story a row rarely tells.
Enquiries, test drives and follow-ups
Sales die after the first visit. Record the source of every caller, because a portal lead, a walk-in and a phone enquiry each need a different follow-up call, and a sheet rarely records which. A caller asks for a price quotation on Saturday, drives a car on Sunday and hears nothing until the following Friday, by which time the family has booked elsewhere.
In a sheet, follow-up depends on someone scrolling to the right row and remembering to call, while a dealer system raises a task on the due day. It also names the owner. Missed calls turn visible, not silent.
The enquiry stays attached to the car, so when the customer returns with a trade-in you see the earlier quotation, the test drive date and the colour they rejected. Nobody starts from zero.
- Source of the enquiry: walk-in, phone, website or portal
- Test drive date and the car used
- Quotation sent, with the variant and accessories quoted
- Next follow-up date and the person responsible
- Reason for a lost enquiry, such as price, delivery wait or finance refusal
Finance papers and insurance renewals
Here sheets begin to hurt. A finance file needs identity and address proof, the bank’s sanction letter, the invoice, a deposit receipt and the lender’s lien entry, yet each sits in a different chat.
Insurance is the quieter leak. A policy sold at delivery comes up for renewal a year later, and the dealer who remembers earns it, while the one relying on a renewal date column forgets.
A dealer system links the sanction letter, the invoice and the policy to one car record, and its pending-papers list tells the back office what is missing before delivery.
What a dealer system adds beyond a better sheet
One source is the real gain. Stock, bookings, used-car valuations, workshop jobs and accessories hang off one chassis number, so a manager asking for cars older than ninety days builds no pivot table.
A system also enforces a sequence, so a car cannot be marked delivered until the invoice is raised and the registration request is logged. The sequence protects you.
Sheets allow anything, which feels flexible until a delivery goes out without a signed handover note and the customer disputes the condition of the car on collection. The system then holds the signed note against the chassis number, so a dispute over scratches or missing accessories starts with a dated record instead of memory.
- Booking holds that expire unless a deposit is recorded
- Used-car appraisal with photos, odometer reading and expected refurbishment
- Accessory fitment against the invoice
- Registration and number plate status for every delivered car
How to decide when to switch
Do not wait for a crisis. Count three signs over a month, such as a car quoted twice, a finance file that stalled for want of one paper, and an insurance renewal noticed after expiry. Two hits mean retire the sheet.
Move stock first, run the sheet and the system side by side for two weeks, compare the counts every Monday, and retire the sheet once they agree. Add enquiries next and finance papers last.
List unsold chassis numbers today.
Showroom sheet-or-system scorecard
A single printed scorecard lists twelve tasks, from stock count and booking hold to follow-up, test drive log, used-car appraisal, finance file, insurance renewal and delivery note. Three columns grade each task as copes, struggles or fails, and a last column names the owner who fixes it. Ten minutes at a Monday meeting is enough to fill it in with the sales manager and the back office clerk.
Open a blank worksheet to printQuestions owners ask
How many cars can a showroom manage on Excel?
Count matters less than people. One person can run a dozen cars on a sheet, but once a second person updates stock, bookings or enquiries, conflicting copies appear and the sheet loses trust.
Can I start with only the stock and enquiry modules?
Yes. Many showrooms begin with stock and enquiries, then add finance files, insurance and workshop jobs, so ask the vendor whether the modules share one customer and car record.
What happens to my old spreadsheets?
Import current stock, open enquiries and live finance files, and keep the old sheets read-only as an archive that staff can search when a past customer returns. Closed deals rarely need loading.
Does a dealer system replace my accountant’s software?
Usually not. It records vehicle sales, receipts and invoices, then passes the totals to your accounts package, so ask how the export works and which fields it carries. Check the export fields.