Music Store Inventory Template
For music shops selling instruments, strings, reeds, cables and sheet music. Track serialized instruments and the small consumables musicians buy every visit.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Category | Location | Unit | Qty on Hand | Reorder Point | Unit Cost | Stock Valueƒ | Statusƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|
| MU-STR-EG-1046 | Electric Guitar Strings 10-46 | Strings | Counter Drawer 1 | set | 40 | 15 | 3.9 | auto | auto | Harmony Music Wholesale |
| MU-RED-AS-25 | Alto Sax Reeds, Strength 2.5 (10-pk) | Reeds | Band Wall | box | 8 | 4 | 18.5 | auto | auto | Harmony Music Wholesale |
| MU-CBL-INST-10 | Instrument Cable 1/4 in., 10 ft | Cables | Accessory Wall | each | 15 | 6 | 6.75 | auto | auto | Soundline Audio Supply |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Category
- Location
- Unit
- Qty on Hand
- Reorder Point
- Unit Cost
- Stock Value — calculated automatically
- Status — calculated automatically
- Supplier
Tips for using this template
- Count strings and reeds by gauge and strength; they are the main reason players come back each month.
- Bump band-instrument accessories like valve oil, reeds and method books before back-to-school.
- Note serial numbers for instruments in the item name so warranty registrations and rentals match up.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateAuto Parts Inventory TemplateHardware Store Inventory SpreadsheetClothing Boutique Inventory TemplateConvenience Store Inventory SpreadsheetGift Shop Inventory TemplateBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory Template