AI Matrx Logo

Music store

Ravenshaw Harbor Music · Music store · Port Townsend, WA

Cosmo Maddox owns Ravenshaw Harbor Music, a music store with lessons, and uses this to see each week's rental numbers by type of instrument without a spreadsheet.

RetailReportingDashboards3 tables · 4 views · 1 form · 1 dimension set · 1 dashboard · 1 digest · 1 notification · 1 agent
Use this template

Rental board

Rentals
Reserved3
Flute for the new school yearRosalie Nwachukwu-KeaneWoodwind
Five-piece drum kit for the garageDagmar Ellsworth-PereiraDrums
Digital piano for a new studentTobin Fairchild-OkekeKeyboard
Out21
Digital piano for a home practice roomCassius Vandermeer-OyelaranKeyboard
Clarinet for the school yearLorcan Hargrove-AdeyemiWoodwind
Bass guitar for the garage bandAnselm Tiwari-BellamyGuitar and bass
Three-quarter violin, second termIngeborg Lindahl-FellStrings
Alto saxophone for the winter jazz nightDagmar Ellsworth-PereiraWoodwind
16 more
Returned12
Half-size violin for a first-year studentIngeborg Lindahl-FellStrings
Acoustic guitar for beginner lessonsOluwaseun Brightmore-HaleGuitar and bass
Trumpet for the middle school bandThierry Lancaster-MwangiBrass
Flute for the spring concertMaribeth Okonkwo-LaurentWoodwind
Snare and practice kit for drumlineYevgenia Bhatt-SorensenDrums
7 more

Tables

Rentals

36 sample rows · 12 columns

Every instrument that goes out on rent, from the day it is reserved to the day it comes back.

RentalRenterRental typeInstrumentStatusStartsDue back
Digital piano for a new studentTobin Fairchild-OkekeKeyboardDigital pianoReservedOct 10, 2026Apr 8, 2027
Five-piece drum kit for the garageDagmar Ellsworth-PereiraDrumsFive-piece drum kitReservedOct 8, 2026Jul 5, 2027
Flute for the new school yearRosalie Nwachukwu-KeaneWoodwindFluteReservedOct 6, 2026Apr 4, 2027
French horn for the winter concertAnselm Tiwari-BellamyBrassFrench hornOutSep 25, 2026Dec 24, 2026
Cello rental, three-quarter sizeBeatrix Montgomery-ZunigaStringsThree-quarter celloOutSep 21, 2026Sep 21, 2027
Acoustic guitar for a giftLorcan Hargrove-AdeyemiGuitar and bassAcoustic guitarOutSep 17, 2026Dec 16, 2026
Alto saxophone, trial monthYevgenia Bhatt-SorensenWoodwindAlto saxophoneOutSep 14, 2026Oct 14, 2026
Keyboard for winter lessonsCassius Vandermeer-OyelaranKeyboardKeyboard with standOutSep 10, 2026Dec 9, 2026
Snare drum kit for the school pep bandMaribeth Okonkwo-LaurentDrumsSnare and practice kitOutSep 7, 2026Mar 6, 2027
Half-size violin to replace a cracked oneThierry Lancaster-MwangiStringsHalf-size violinOutSep 5, 2026Dec 4, 2026
Trombone for the beginner bandOluwaseun Brightmore-HaleBrassTromboneOutSep 2, 2026May 30, 2027
Bass guitar with small ampIngeborg Lindahl-FellGuitar and bassBass guitarOutAug 31, 2026Nov 29, 2026

24 more rows

Renters

12 sample rows · 8 columns

The households that rent from the shop, with every instrument each has had.

RenterPhoneEmailHome addressRenting sinceRentals
Anselm Tiwari-Bellamy(360) 555-0133anselm.tiwaribellamy@harbormailbox-maddox.net640 Fogbell Drive, Port Townsend, WA 98368Oct 20, 2025Bass guitar for the garage band, Trumpet for the holiday parade, French horn for the winter concert
Beatrix Montgomery-Zuniga(360) 555-0129beatrix.montgomeryzuniga@harbormailbox-maddox.net85 Ropewalk Spur, Port Townsend, WA 98368Aug 11, 2025Quarter-size violin for a seven year old, Practice pad and drum sticks set, Cello rental, three-quarter size
Cassius Vandermeer-Oyelaran(360) 555-0117cassius.vandermeeroyelaran@harbormailbox-maddox.net77 Tideline Place, Port Townsend, WA 98368Jan 13, 2025Digital piano for a home practice room, Cello rental, half size, Keyboard for winter lessons
Dagmar Ellsworth-Pereira(360) 555-0141dagmar.ellsworthpereira@harbormailbox-maddox.net195 Mooring Hill Road, Port Townsend, WA 98368Jun 7, 2026Alto saxophone for the winter jazz night, Digital piano for the recital season, Five-piece drum kit for the garage
Ingeborg Lindahl-Fell(360) 555-0101ingeborg.lindahlfell@harbormailbox-maddox.net214 Quillfeather Lane, Port Townsend, WA 98368Apr 18, 2024Half-size violin for a first-year student, Three-quarter violin, second term, Bass guitar with small amp
Lorcan Hargrove-Adeyemi(360) 555-0125lorcan.hargroveadeyemi@harbormailbox-maddox.net16 Spindrift Close, Port Townsend, WA 98368Jun 2, 2025Clarinet for the school year, Acoustic guitar for the camp week, Acoustic guitar for a gift
Maribeth Okonkwo-Laurent(360) 555-0113maribeth.okonkwolaurent@harbormailbox-maddox.net431 Kelpwood Terrace, Port Townsend, WA 98368Nov 4, 2024Flute for the spring concert, Drum kit for the church band, Snare drum kit for the school pep band
Oluwaseun Brightmore-Hale(360) 555-0105oluwaseun.brightmorehale@harbormailbox-maddox.net58 Gullwatch Row, Port Townsend, WA 98368Jun 17, 2024Acoustic guitar for beginner lessons, Electric guitar kit with practice amp, Trombone for the beginner band
Rosalie Nwachukwu-Keane(360) 555-0137rosalie.nwachukwukeane@harbormailbox-maddox.net23 Capstan Mews, Port Townsend, WA 98368Dec 29, 2025Trombone for the jazz ensemble, Full-size viola for the community orchestra, Flute for the new school year
Thierry Lancaster-Mwangi(360) 555-0109thierry.lancastermwangi@harbormailbox-maddox.net9 Pilings Court, Port Townsend, WA 98368Aug 26, 2024Trumpet for the middle school band, French horn for the youth orchestra, Half-size violin to replace a cracked one
Tobin Fairchild-Okeke(360) 555-0145tobin.fairchildokeke@harbormailbox-maddox.net4 Breakwater Gardens, Port Townsend, WA 98368Jul 27, 2026Keyboard with stand for songwriting, Clarinet for a second child, Digital piano for a new student
Yevgenia Bhatt-Sorensen(360) 555-0121yevgenia.bhattsorensen@harbormailbox-maddox.net302 Driftmark Way, Port Townsend, WA 98368Mar 24, 2025Snare and practice kit for drumline, Flute for a returning adult beginner, Alto saxophone, trial month

Forms and booking

Set up a rental

Form
Set up a rentalWhat the counter fills in when a family picks out an instrument.
What is being rented, and for whom? *A short line, like Half-size violin for Odette.
Which household is renting? *
Which kind of instrument is it? *StringsGuitar and bassBrassWoodwindKeyboardDrums
Which instrument exactly? *
What day does the rental start? *
What day is it due back? *
What is the monthly fee? *
How much deposit was taken?
Save the rental

Dashboards

Weekly numbers by rental type

Rentals
Rentals by type
  • Strings7
  • Guitar and bass6
  • Brass6
  • Woodwind7
  • Keyboard5
  • Drums5
Monthly fees by type
  • Strings$198
  • Guitar and bass$176
  • Brass$248
  • Woodwind$258
  • Keyboard$186
  • Drums$162
Rentals started each week
  • Jul 26, 20265
  • Aug 2, 20264
  • Aug 9, 20265
  • Aug 16, 20265
  • Aug 23, 20264
  • Aug 30, 20264
  • Sep 6, 20262
  • Sep 13, 20262
Deposits held by type
  • Strings$396
  • Guitar and bass$352
  • Brass$496
  • Woodwind$516
  • Keyboard$372
  • Drums$324

Also included

  • Instruments outDigest
  • Due back in two daysNotificationTells the counter two days before an instrument is due back so the renter gets a call.

Related templates