Free car showroom Excel template

What is inside

Six sheets, every one keyed by the car's registration number, because that is how every question in a showroom arrives: "the white Corolla", never a customer ID. You type only in the white cells. The shaded cells are formulas and fill themselves in.

• Stock. One row per car: make, model, year, the day it was bought, purchase price, asking price, status, the day it sold and the sale price. Total cost, profit and days on the floor are calculated, and a car that has stood more than 60 days turns red.
• Costs. Every rupee spent on a car after buying it: denting and paint, the agent's commission, transport, transfer fees. Each one is entered against the registration number and lands in that car's total cost, which is where most showroom margins quietly go missing.
• Partners. Who funded each car and with how much. Each partner's share of that car, and of its profit, is worked out row by row.
• Instalments. Cars sold on qist: the buyer, the down payment, the monthly amount and the number of months. What has been paid, what is left and how many qists the buyer is behind are calculated from the Payments sheet.
• Payments. Every qist received, one row each, so the balance is always the sum of real receipts rather than a number someone crossed out and rewrote.
• Read me. The rules above, inside the file, for whoever opens it next.

How the partner split works

The template uses the same rule as Odometric. The showroom's cut, set per car, comes off that car's profit first. What remains divides between the car's outside partners by the capital each put into that car. The showroom's own money in a car earns its return through the cut, not a share, so it is not listed as a partner; if partners funded only part of a car, they still divide everything left after the cut.

Other showrooms split differently: a fixed share regardless of capital, or capital first and the cut after. The three common models, with the arguments each one tends to cause, are on the investor profit sharing page. To use a different model, only column H on the Partners sheet needs to change.

How the instalment sheet works

Each sale on instalments is one row: sale price, down payment, the monthly qist, the date the first one is due and how many there are. Every payment goes on the Payments sheet against the same registration number. The template adds them up, takes them off the balance, and compares the qists covered with the qists that should have been paid by today. A buyer who is behind shows in red, which turns the morning phone round from memory into a list.

What it cannot do is remind anyone. A sheet waits to be opened. The piece on recovery rate covers what to do on day one, day seven and day fourteen of a missed qist, and the instalment software page covers what changes when the overdue list is produced for you every morning.

Starting with it

The file comes with three example cars so you can see every formula working. Delete their rows on each sheet, then enter the cars you have today, starting with what you paid and who funded them. Enter costs on the day they happen, not at month end: a cost remembered a month later is usually a cost not remembered at all. The guide to what a showroom should track is a good companion for the first week.

Where a spreadsheet runs out

A register like this works well for one person on one computer. It starts to break in predictable places: two people editing copies of the same file, a partner asking for their own figures and being sent the whole book, a qist taken at the counter and entered a week later, and the registration file handed over while money is still owed because nobody could see the balance. The longer version, with the signs that it is time to move, is running a car showroom on Excel, and when to stop.

Odometric is what the template becomes when those problems arrive: the same registration-number record on a phone, with a statement for each partner, overdue qists listed every morning, and the file held in a vault until the car is paid for. The twelve short videos show each part.

Common questions

Is the car showroom Excel template really free?

Yes. It is a normal .xlsx file with no sign-up, no email and no expiry. You can change it, copy it and share it with other showrooms.

Does it work in Google Sheets or on a phone?

It opens in Excel, Google Sheets and LibreOffice, and the formulas work in all three. On a phone it opens in the Excel or Google Sheets app, though a sheet this wide is easier to fill in on a computer.

How does the template split profit between investors?

The showroom's cut, set per car, comes off the car's profit first, and the rest divides between that car's outside partners by the capital each put in. The showroom's own money earns only the cut, so it is not listed as a partner. This is the same rule Odometric uses.

Can it track instalment (qist) payments?

Yes. Each instalment sale has a row with the down payment, monthly amount and number of months, and every payment is entered on its own sheet. The template shows what is paid, what is left and how many qists the buyer is behind.

Is there free car showroom software instead of a spreadsheet?

Some products are free or have long trials, and the comparison of car showroom software in Pakistan lists each one's price and trial from its own pages. Odometric is paid, with fifteen days free and no card.