Running a showroom on Excel, and when to stop

What Excel is genuinely good at

It is worth being fair to the spreadsheet, because dismissing it is how software sales pitches lose credibility with people who have actually run a business on one.

Excel costs nothing you are not already paying. It needs no training, because every accountant and half the salesmen already know it. It bends to any process you invent on a Tuesday afternoon without asking permission. It works with no internet. And when you want a number that nobody anticipated, you can just write the formula yourself, immediately, without raising a request with anyone.

No purpose-built system beats those five things. Any honest comparison starts by admitting it.

When you should stay on Excel

There are real situations where buying showroom software is the wrong decision:

• One person does everything. If the owner buys, sells, keeps the money and holds the papers, there is no coordination problem to solve. Software mostly solves coordination.
• Under roughly ten cars at a time, self-funded. Small enough to hold in your head, with no partner who needs to see it.
• No outside capital. The investor ledger is the strongest reason to move. Without investors, the case is much weaker.
• Cars turn over in days. If nothing stands long enough to accumulate costs and questions, most of what software tracks does not apply.

A showroom in that position should keep its spreadsheet and spend the money on stock.

The four points where it breaks

Two people needing the same file at once

This is almost always the first real failure, and it arrives earlier than people expect. The munshi has the file open, the owner wants to check a number from home, the salesman is at the showroom with a buyer asking about a car. Somebody sends a copy on WhatsApp. Somebody edits the copy. Within a month there are three versions and the true one is whichever the loudest person is holding.

The spreadsheet did not fail here because of a limit in Excel. It failed because a file is a single object and a business is not.

Documents

A spreadsheet cell can hold a filename. It cannot hold the excise book. So the scans, if they exist at all, live in a phone gallery, a folder on a laptop, and a WhatsApp thread, connected to the spreadsheet only by whoever remembers the naming convention. And the physical file, the thing that actually has to be handed to a buyer, is not represented anywhere at all.

Investors

This is where spreadsheets get genuinely dangerous rather than merely inconvenient. Capital-proportional splits with a showroom cut are perfectly expressible as formulas, and the arithmetic is not hard. The problem is that the sheet holds only the current state. When a partner asks why they received PKR 74,000 rather than 92,500, the sheet shows today's numbers, not the cost that was added last week, the one that was corrected, or who changed the cut. Recalculation is silent and history is gone.

A partner cannot audit a spreadsheet. They can only be told what it says.

Part payments and document holds

A sheet can record that a buyer still owes PKR 400,000. It cannot stop the man at the counter handing over the file on a Friday afternoon to a buyer who is being persuasive. Enforcing a rule is different from recording a number, and enforcement is exactly what a deferred sale needs.

Side by side

The honest cost comparison

Excel appears free, and the fair way to compare is against what the failures cost rather than against a licence fee.

On the worked example used across this site, a car bought at PKR 3,200,000 and sold at PKR 3,750,000 with PKR 180,000 of costs earns PKR 370,000 of gross profit. A Starter subscription at PKR 10,000 per month costs PKR 120,000 a year, which is about a third of the profit on one such car.

So the question is not whether the subscription is cheap. It is whether, over a year, the showroom loses more than a third of a car's profit to reconstructed cost lists, a partner argument that ends a funding relationship, a file handed over on an unpaid balance, or three days spent rebuilding a sheet somebody overwrote. For a showroom of ten cars with no investors, quite possibly not. For a showroom of forty with four partners, it is not a close call.

If you do switch

The transition that works is deliberately incomplete:

1. Enter only the cars currently standing, with purchase cost, costs so far and who funded them.
2. Leave every sold car in the old sheet. Keep it, do not migrate it.
3. Run both for one month, entering new cars in the new system only.
4. Stop updating the sheet once a full month has closed cleanly.

The changeovers that fail are the ones that begin by trying to key in three years of closed sales. It takes weeks, nobody enjoys it, and the project dies before reaching the part that would have helped.

Common questions

Can you run a car showroom on Excel?

Yes, and many profitable showrooms do. A spreadsheet works well for a single operator holding roughly ten cars or fewer, self-funded, with quick turnover. It stops working when more than one person needs the same record at the same time, when scanned documents and the physical file have to be tracked, when outside investors need an auditable split, or when unpaid balances need to actually block a document handover rather than just be noted.

What does a spreadsheet not do that showroom software does?

Four things. It cannot be edited by several people without producing conflicting copies. It cannot hold scanned documents against a vehicle or track where the physical file is. It keeps no history, so a recalculated investor split cannot be audited afterwards. And it can record an unpaid balance but cannot enforce anything, so it cannot stop documents being released on a part-paid car.

At how many cars should a showroom move off Excel?

Car count is the wrong trigger. The reliable ones are people and capital: the moment a second person needs to read or update the same record, or the moment outside investors need to be paid from a calculation they can check. A ten-car showroom with four investors needs a system more urgently than a forty-car showroom run entirely by its owner with his own money.

Whichever tool holds the numbers, the list of what to record is the same: what a car showroom actually needs to track.

Comparing against other software rather than a spreadsheet? eight car showroom software products compared, from their own pages.