Month End in a Car Showroom, in Six Steps

Closing a month in a showroom is not general bookkeeping. It is six reconciliations, and doing them in order matters, because each one makes the next easier and the last one is worthless if the first five were skipped.

Done properly it takes an afternoon. Done in the usual way, which is trying to remember July in the middle of August, it takes three days and produces numbers nobody trusts.

1. Cash, first and always

Count what you physically have and what the bank says, and compare both against what the records claim you should have. Do this before anything else, because every later step assumes the cash figure is real.

A discrepancy here is almost never theft. It is a payment received and not entered, an expense paid from a pocket, or a deposit taken and recorded against the wrong car. All three are findable on the day and effectively unfindable a month later, which is the entire argument for closing monthly rather than quarterly.

2. Count the floor against the ledger

Walk the showroom with the list. Every car physically present should be on the ledger as unsold, and every car on the ledger as unsold should be physically present. The list is only as good as whatever it is kept in, which is the practical case for a system rather than a spreadsheet once more than one person touches it.

The two failure directions are different problems. A car in the showroom that the ledger thinks is sold usually means a deal fell through and nobody reversed it. A car on the ledger that is not in the showroom means it went out on an open letter, or to a workshop, or to someone's cousin for the weekend, and the record did not follow it. The second is worth chasing immediately.

3. Total the outstanding buyer balances

Every car sold with money still owed. One figure at the end.

This is money you have already spent and not yet collected, and it grows quietly because no single overdue balance feels urgent. Showrooms that compile this list for the first time are usually surprised by the total, and occasionally by finding a balance nobody has mentioned in four months.

Check the document holds while you are here: any car with an outstanding balance whose file has already been handed over is an exposure with no leverage left, and you want to know about it now rather than later.

4. Work out what you owe investors

For every car sold during the month, the profit share earned by each investor. Against that, what has actually been paid.

The gap is a real liability sitting in your account looking like your money. A showroom that has not separated these two figures is spending investor share as working capital without having decided to, which works until the month an investor asks to be settled in full.

The full method is in running an investor payout ledger.

5. Hunt the costs that did not get entered

Take the three or four cars that sold this month and ask, per car, whether anything is missing. Was there a commission? Transport? A small workshop job paid in cash?

This is a five-minute check per car and it is the highest-value part of the whole close, because the costs that vanish distort not just this month's profit but your sense of what every future car of that type will earn.

6. Review margin, last

Only now, with cash reconciled, stock verified, balances totalled, investor liability separated and missing costs recovered, is the margin figure worth looking at.

Three things to look at, and none of them is the headline profit:

• Profit per car, not in total. Total profit is a function of how many cars happened to sell. Per-car margin tells you whether the buying is any good.
• Average days on floor for what sold. Rising is the earliest warning you get, and it precedes a cash problem by about two months.
• Estimated days against actual, per car. Over time this tells you whether your judgement at purchase is calibrated, which is the most valuable thing the close produces.

Why the order matters

Every step depends on the ones before it. Margin computed before missing costs are recovered is wrong. Investor liability computed before the stock count is wrong about which cars actually sold. Everything is wrong if the cash figure was never verified.

Most showrooms do step six, occasionally step one, and none of the others. That produces a profit number that is confidently stated, internally consistent and disconnected from the bank account, which is the specific condition described in why a profitable showroom runs out of cash.

Common questions

How do you close the books for a car dealership at month end?

Six reconciliations in order. Verify cash against physical count and bank. Count the cars on the floor against the ledger in both directions. Total the outstanding buyer balances and check no held documents were released early. Separate investor profit earned from investor profit paid. Go back over cars sold this month for costs that were never entered. Only then review margin. Each step depends on the ones before it, so the order is not arbitrary.

How often should a used-car showroom close its books?

Monthly, and the reason is memory rather than accounting convention. The most valuable step is recovering costs that were never recorded, and people can reconstruct three weeks accurately while nobody can reconstruct three months. Anything found in a quarterly close that is older than about six weeks is an estimate rather than a record, which means quarterly closing systematically understates the cost of older stock.

What should a showroom owner look at in the monthly numbers?

Not headline profit, which mostly reflects how many cars happened to sell. Look at profit per car, which tells you whether the buying is good; average days on floor for units sold that month, which rises about two months before a cash problem arrives; and estimated days to sell against actual days, per car, which over time reveals whether your judgement at purchase is calibrated.