Short answer: Use one repair record from intake to pickup. Give every job a number and status, link it to the customer and exact instrument, document condition, obtain written approval, track parts and labor, and keep completed work searchable.
Spreadsheets can list open jobs, but they do not naturally preserve photos, approval history, technician activity, parts, customer messages and instrument custody. Paper tags can travel with the instrument, but they are easily separated from the information staff need at the counter.
The repair workflow at a glance
| Stage | Required record | Next action |
|---|---|---|
| Intake | Customer, instrument, serial, photos, stated problem | Assign job number and storage location |
| Inspection | Diagnosis, parts, labor and estimate | Request approval |
| Approval | Amount, scope, date and customer response | Schedule work or return unapproved item |
| Work | Technician notes, parts used and time | Test and quality check |
| Ready | Final amount and completion evidence | Notify customer |
| Pickup | Payment, collection date and recipient | Close but retain history |
1. Create a complete intake record
Record customer contact details, instrument type, brand, model, serial number, included case or accessories, visible damage and the customer's description of the problem. Photograph the instrument before it leaves the counter.
If the serial number is absent or unreadable, create an internal asset reference. Never use only “black Strat” as identification.
2. Separate customer property from store inventory
Customer-owned repairs are in your custody, but they are not your stock. Mark ownership clearly and store them in a designated area with the job number visible. This avoids overstating inventory value and reduces the chance of an instrument being offered for sale.
For store-owned items, link the job to the existing serialized inventory record so repair cost contributes to the unit's true margin.
3. Use a small, controlled status list
A practical list might be: received, inspecting, awaiting approval, waiting for parts, in progress, quality check, ready for pickup and closed. Every status should imply a responsible person and next action.
Do not create dozens of nearly identical statuses. Use notes for detail and status for workflow.
4. Make estimates and approvals explicit
An estimate should state the approved scope, labor, parts, tax where applicable, exclusions and what happens if further damage is discovered. Record the customer's approval or rejection with date, amount and method.
Do not rely on “I think they said yes.” If the scope changes, issue a revised estimate and obtain approval before continuing.
5. Track parts, labor and deadlines
Parts affect both customer price and shop margin. Record ordered, received and used parts against the job. Track technician time consistently enough to understand capacity and profitability, without turning every adjustment into administrative burden.
Expected dates should account for parts lead time and workload. An overdue queue is more useful than an optimistic date nobody reviews.
6. Communicate from the job record
Log meaningful customer updates: estimate sent, approval received, delay explained, ready notice sent and pickup arranged. This gives any staff member context when the customer calls.
Use templates for consistency, but keep the message specific: what was found, what is approved and what happens next.
7. Quality check before “ready”
The technician or a second staff member should confirm the requested work, playability, tuning stability where relevant, electronics and cosmetic condition. Attach final notes or photos for significant work. Only then change the job to ready for pickup.
8. Close the financial loop
The final invoice should match the approved work or clearly identify approved additions. Record payment and pickup, then retain the job history. That history helps answer warranty questions, repeat-fault patterns and future trade-in evaluations.
Use the free repair work order template if you need a consistent intake form immediately.
Repair metrics worth reviewing weekly
- Jobs awaiting approval
- Jobs waiting for parts
- Jobs past the promised date
- Average days from intake to pickup
- Ready jobs not collected
- Labor and parts margin
- Repeat faults within the shop's service warranty
These are operational queues first and management reports second. Each number should lead to a specific action.
Why connected records matter
When repairs share customer and instrument records with inventory, rentals and sales, staff can see prior work without searching another system. A rental unit's downtime and maintenance cost remain visible. A used instrument's refurbishment cost remains part of its real margin.
Music Shop Suite keeps repair tickets, customers and instruments together for $49/month flat. It is not a full POS till; it manages the work behind the counter alongside your existing payment terminal.
SIGN UP TODAY to replace the repair spreadsheet with a searchable workflow. See repair shop software or pricing.