School Band Instrument Inventory Spreadsheet

For band and orchestra directors tracking school-owned instruments loaned to students. Records serials, which student has each instrument and condition at checkout and return.

Download free Excel template Fill it from supplier invoices →

Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.

Asset Tag	Item	Category	Brand / Model	Serial #	Location	Assigned To	Condition	Purchase Date	Purchase Cost	Useful Life (yrs)	Current Valueƒ
BND-TBA-02	Tuba (BBb)	Brass	Yamaha YBB-105	214887	Band Room Storage	Student: K. Johnson	Good	2025-07-22	5400	25	auto
BND-CLR-11	Bb Clarinet	Woodwinds	Buffet E11	BF677201	Band Room Locker 11	Student: M. Alvarez	Fair	2025-08-05	1350	15	auto
BND-SNR-03	Concert Snare Drum	Percussion	Pearl Philharmonic 14x5	PL300918	Percussion Closet	Ensemble	Excellent	2026-01-16	690	20	auto

ƒ = calculated automatically by formula.

What's included

Asset Tag
Item
Category
Brand / Model
Serial #
Location
Assigned To
Condition
Purchase Date
Purchase Cost
Useful Life (yrs)
Current Value — calculated automatically

Tips for using this template

Record the serial from the instrument itself, not the case; cases get swapped between students.
Use a checkout form signed by a parent and log the date and condition in the sheet at the same time.
Plan summer repair work from the condition column so instruments are ready by the first rehearsal.

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