Most independent shops put off a full stocktake because the only version they know involves closing on a Sunday and arguing about a spreadsheet. There is a better way, and it starts with treating the serial number — not the model — as the thing you are counting.
Why model-level counts always disagree
If your stock list says "3 x Telecaster Standard" and the wall has three Telecasters, you have proved nothing. One might be a consignment unit, one might be held on layaway, and one might have come back from a rental with a cracked nut. A count that cannot tell those apart cannot tell you what your stock is worth.
Counting by serial gives you a yes-or-no answer per unit: it is here, or it is not, and if it is not, the record already says where it went.
Count in sections, over a week
- Monday: the wall. Highest value, most movement, count it first.
- Tuesday: the back room and cases. Everything not customer-facing.
- Wednesday: on loan and on rental. Not a physical count — a reconciliation against agreements.
- Thursday: the bench. Instruments in for repair are still your responsibility if they are consignment or shop-owned.
- Friday: accessories by quantity. These are the only lines that genuinely count as quantities.
Nothing on that list needs the shop to be shut.
Three discrepancies you will find, and what they mean
- Present but not on the list. Usually a trade-in that was never booked in. It has no cost basis, so your margin on it is fiction.
- On the list but missing. Check loans and the bench before you panic. What is left after that is shrinkage, and it needs a date.
- Present but wrong status. Sold-but-not-collected and held-for-layaway units get counted as available and sold twice. This is the one that costs you a customer.
Make the next count easier than this one
Every unit that gets a proper record now — serial, cost, condition, photos — is a unit you will never argue about again. Serial number tracking gives each instrument one card and one history. Barcode inventory turns next quarter's count into a scan rather than a transcription exercise. And if stock is arriving without records in the first place, the fix is upstream in purchase orders.
Ready to stop counting twice?
Music Shop Suite runs inventory, rentals, repairs, lessons, and accounting for one flat $49/month. See pricing and sign up today.