Why music shop stock counts go wrong
Most retail stock counts assume interchangeable units. A music shop's stock is the opposite: one guitar has a setup in it, one is consigned, one is out on approval with a session player, and one is on the bench with the neck off. Counting "12 electrics" tells you nothing useful.
A count that balances treats the serial number as the unit of truth.
Before the count
- Freeze movements for the counting window. No sales, no intakes, no rentals out.
- Print or open a list of every unit with status: for sale, on hold, on approval, consigned, in repair, out on rental.
- Reconcile the repair bench first. Instruments in pieces are the single biggest source of "missing" stock.
The count order that saves time
- Sales floor — scan or check every serial on display.
- Back stock and cases — the shelf where accessories quietly disappear.
- Repair bench — match every work order to a physical instrument.
- Out on rental or loan — verify against agreements, not memory.
- Consignment — count separately; it is not your stock and should never be in your valuation.
- On approval / demo out — call the customer if it has been out more than 30 days.
The three discrepancies that repeat
Consignment counted as owned stock. It inflates your inventory value and your insurance premium. Keep consigned units in their own bucket with the owner, split, and return date attached.
Repairs not booked out. An instrument on the bench under someone else's name looks like shrinkage. Every bench ticket should reference the unit.
Accessories without a home. Strings, reeds, and cables need a count method (weight, box, or scan) or they will drift every single quarter.
After the count
Write the variance down per unit, not as a lump figure. A single missing $2,400 archtop is a very different problem from $2,400 spread across picks and patch cables — and only the unit-level record tells you which you have.
Do it in software instead of a spreadsheet
Serial-level counting is exactly what music store inventory software exists for: statuses that already distinguish sold, consigned, on rental, and in repair, plus barcode scanning so a count is a walk-around instead of a weekend. If you want to see what your stock is actually costing you to hold, run the numbers through our free inventory turnover calculator.
Music Shop Suite is $49/month for the whole shop — inventory, clients, rentals, repairs, lessons, and the books behind them. Start your shop and import the spreadsheet you already have.