Where the money actually goes missing: reconciliation friction on a small used-car lot
Ask a small dealer if their books are accurate and most will say yes, pretty sure. That "pretty sure" is the tell. On a lot where every dollar — sale price, trade-in credit, doc fee, commission, HST — gets tracked across a spreadsheet, a notebook, and a bank statement instead of one ledger tied to the deal, small drifts accumulate quietly. Nobody's stealing. The money's just not all pointing at the same number anymore, and finding out how far off usually happens at month-end, or at tax time, or during an audit — never at a convenient moment.
Every dealer knows roughly how much money moved through the lot last month. Fewer can say, without checking three places, exactly how much of it was HST, how much was commission, how much was a documentation fee, and whether the number on the bank statement actually matches the number in the deal records. That gap — between “roughly” and “exactly” — is where small-lot bookkeeping quietly gets into trouble.
It's rarely dramatic. Nobody's cooking the books on a five-car-a-month lot. What actually happens is smaller and more boring: the same deal's money gets tracked in more than one place, by hand, and those places don't automatically agree with each other.
The HST problem specifically
HST on a used-vehicle deal isn't one flat calculation. The vehicle price, a documentation fee, a trade-in credit, and aftermarket products like extended warranties or GAP insurance can each carry different tax treatment. Getting the total right means applying the correct treatment line-by-line, not just multiplying one number by a tax rate. When that math happens by hand — once on a desk worksheet, maybe again when the bill of sale gets filled out — there are two separate chances for the numbers to land on slightly different totals, and whichever one goes to the customer is the one that has to be right.
Where commission tracking gets fuzzy
On a lot with one or two salespeople and an owner who's also doing everything else, commission often isn't tracked in a formal system at all — it's a running mental tally, or a line jotted in a notebook after the fact. That works fine right up until someone's memory of a deal and someone else's memory of the same deal don't quite match, and there's no record either side can point to that settles it cleanly.
The ledger that lives in three places
The most common pattern: a spreadsheet says what was supposed to happen on a deal, a bank statement says what actually moved, and a notebook or memory fills in whatever's missing between the two. None of these is wrong, exactly — they're just three separate records of the same set of facts, updated at different times by different amounts of attention, and nothing forces them to agree.
If closing the books every month involves manually cross-checking a spreadsheet against a bank statement to figure out where they disagree, that's not a bookkeeping habit — it's a sign the money was never tracked as one system to begin with.
Why this stays invisible until it doesn't
Small drift is genuinely small, deal to deal. A few dollars of HST rounding, a commission that's slightly off, a fee that got applied inconsistently — none of it is enough to notice in the moment. It compounds quietly across a year of deals, and it surfaces at the worst possible times: when an accountant is trying to reconcile year-end numbers, when a commission dispute needs a clean answer, or when a compliance review asks for records that are supposed to tie out and don't quite. OMVIC's all-in price advertising rules already require every fee to be itemized and consistent on the bill of sale — a ledger that doesn't reliably agree with itself makes that consistency harder to guarantee than it should be.
What actually fixes it
Not more discipline — a different structure. If every dollar on a deal (price, trade-in credit, doc fee, commission, HST) is entered once and tied directly to that deal's record, there's nothing left to reconcile by hand, because there was never a second, separate version of the numbers to drift away from the first. The ledger stops being a monthly cross-checking chore and becomes something that was accurate the moment the deal closed.
That's what the Money view inside Lot Jacket is built to do — every dollar tied back to the deal it came from, HST calculated correctly across trade-ins, doc fees, and add-on products, and a clean export your accountant will actually thank you for. It's the one screen we deliberately kept plain — nobody wants “cute” near their ledger. If you want to see it against your own numbers, book a free 15-minute demo.
Sources
- All-in Price Advertising — OMVIC
- Fees — OMVIC
Frequently asked questions
Why is HST tricky to calculate on a used-car deal?
Because not every line on a deal is taxed the same way. The vehicle price, a documentation fee, a trade-in credit, and aftermarket products like extended warranties or GAP insurance can each have different HST treatment, and getting the total right means applying the correct treatment to each line rather than one flat percentage on the whole deal. Doing that by hand across multiple documents is where small calculation errors creep in.
What does 'reconciliation friction' mean for a small dealership?
It refers to the time and risk that comes from tracking a deal's money across multiple disconnected places — a spreadsheet, a notebook, a bank statement — instead of one ledger tied directly to the deal. Because nothing keeps those places automatically in sync, they can quietly drift apart, and someone has to manually reconcile them to find out whether the numbers actually agree.
How do commissions typically get tracked on a small independent lot?
Often informally — a running mental tally, a note in a notebook, or a line in a spreadsheet updated after the fact. Without commissions tied directly to the deal record they're earned on, it's easy for the total to become a matter of memory and trust rather than a number either party can verify at a glance.
What's the risk of loose money tracking beyond just inconvenience?
At minimum, it costs time every month reconciling numbers that should have already agreed. At worst, an undetected HST miscalculation, an untracked commission dispute, or a gap between what the books say and what the bank shows can become a real problem at tax time or during a compliance review, when there's less room to simply sort it out informally.
Go deeper
This guide is general information for Ontario used-car dealers, not legal or compliance advice. OMVIC requirements can change — always confirm the current rules with OMVIC or a qualified advisor.