Most advice about showroom accounting starts with a chart of accounts, which is the wrong end of the problem. A showroom does not fail because its expense categories are badly organised. It fails because nobody knows what the Corolla actually cost.
The unit of account in a showroom is the car, not the month. Get that right and the monthly numbers assemble themselves. Get it wrong and no amount of bookkeeping discipline elsewhere recovers it.
Eleven things, against the plate
This is the whole list. Everything else a showroom needs can be derived from it.
| Record | When | What it makes possible |
|---|---|---|
| Registration number | At purchase | Everything. It is the key the whole record hangs on. |
| Purchase price | At purchase | The base of every later calculation. |
| Purchase date | At purchase | Days on floor, holding cost, ageing. |
| Who funded it, and how much each | At purchase | The investor split, and knowing whose money is where. |
| Agreed split and showroom cut | At purchase | Settlement without an argument. |
| Every cost, dated | As incurred | True margin. This is the one that decays fastest if delayed. |
| Scanned documents | As received | Survival of a lost file. |
| Where the physical file is | On any move | Handover without a search. |
| Sale price, buyer, date | At sale | Realised margin, and the open letter record. |
| Received and outstanding | At each payment | Cash position, and the document hold. |
| Paid to each investor | At each payout | What is still owed, and a statement they can check. |
Eleven fields. A showroom that has these against every plate can answer any financial question about the business, including the ones it has not thought to ask yet.
What you get without recording it
Every number an owner actually wants is a derivation of the eleven, which is why the list is short.
- Profit per car is sale minus purchase minus costs, then holding, then the split.
- Capital on the floor is the sum of purchase plus costs for everything unsold.
- Days on floor is today minus the purchase date, and average days is the mean across the floor.
- Money owed to you is the sum of outstanding balances.
- Money owed by you is the investor share earned minus the investor share paid.
- Which models earn is profit per car, grouped, once you have twenty of them.
None of those needs a separate record. All of them are impossible if the eleven are incomplete.
What you can safely not track
Equally important, and rarely said.
- Overhead allocated per car. Useful once, when working out your daily holding cost. Not worth maintaining per unit. Apply one rate.
- Staff time per vehicle. Genuinely a cost, and the effort of capturing it accurately exceeds what it tells you. Decide a policy and apply it uniformly.
- Anything in categories finer than you will act on. "Workshop" is a category. "Workshop: suspension: rear" is data entry. If you would not make a different decision because of the distinction, do not create it.
- Formal depreciation schedules. Your accountant may need these for tax. They are not a management tool in a business where the asset is sold within months.
The most common failure is not tracking too little. It is tracking a great deal about the wrong unit: detailed monthly expense categories, and no idea what the silver Civic cost. Monthly totals tell you what happened. Per-car records tell you why, and only the second changes what you buy next.
The timing rule
One rule underneath all eleven: record it on the day, against the plate.
This is not tidiness. A cost entered three weeks later is worth less than the same cost entered on the day, in two specific ways. It is more likely to be wrong or forgotten, and if an investor is involved it reads as an invention rather than a record, which is one of the most reliable ways to lose funding.
The practical consequence is that recording has to be possible from where the cost happens. If entering a 3,000 rupee transport payment means going back to the office and opening a laptop, it will not be entered, and no amount of intention changes that.
Common questions
What financial records does a car showroom need to keep?
Eleven things against each registration number: the plate, purchase price and date, who funded it and how much each, the agreed split and showroom cut, every cost as it is incurred, scanned documents, where the physical file is, sale price and buyer and date, amount received and outstanding, and what has been paid to each investor. Every other figure an owner wants, including profit per car, capital on the floor and money owed, is derived from those.
Should a showroom track costs per car or per month?
Per car. The vehicle is the unit of account in a showroom, and monthly totals can be assembled from per-car records while the reverse is impossible. The common failure is a showroom with well-organised monthly expense categories that cannot say what any individual car cost, because monthly figures tell you what happened while per-car figures tell you why, and only the second changes what you buy next.
Does a car dealership need accounting software or is a spreadsheet enough?
General accounting software is usually the wrong tool, because it accounts for a business by month rather than for vehicles individually. A spreadsheet handles the eleven fields adequately for a single operator with around ten cars and no outside investors. It stops working when more than one person needs the same record at once, when scanned documents and the physical file must be tracked, or when investors need a split they can audit. Where exactly that line falls is worth being specific about, and we have worked it through in showroom software against a spreadsheet.
Eleven fields, one record per plate
Odometric is built around exactly this: everything about a car on one record, entered from the showroom on a phone, with the monthly figures derived rather than kept separately.
Request a demo How to work out what a car actually made