Appliance Repair Tracker

The washer has been "awaiting parts" for 11 days and nobody called the customer. Most repair trackers are just a list of jobs; this one runs the shop. A Work Order Board moves every unit from Received through Diagnosing, Waiting on Parts and In Repair to Ready for Pickup and Done / Paid, counting days in shop and flagging AGING at 14 days, STUCK at 21, and any job PAST PROMISED DATE. A Quote & Approval Log records the diagnostic fee, the estimate and the customer's answer for every job, so no repair starts unapproved — and the fee is kept only when the customer declines. The Parts Inventory counts itself down as parts are fitted and flags parts on order OVERDUE once their ETA passes. A Warranty & Callback Tracker charges every callback's parts and labor against the job that caused it, with callback-rate boards by brand and by tech.

The file comes loaded with a fictional sample shop, FixRight Appliance Repair — 22 work orders from September–October 2026. One Samsung washer has sat Waiting on Parts for 22 days, its $189 control board 9 days past ETA. One LG washer job earned $68.90, then its drain pump failed again 18 days later, inside the 90-day warranty window; the $102.40 redo flips the job to a $33.50 loss. Samsung carries a 40% callback rate against a 20% shop average — and no tech flags at all.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

What you receive is the finished spreadsheet file, delivered instantly at checkout as a PDF containing your Google Sheets copy link. Open it, choose "Make a copy," and the file is yours. It runs in Google Sheets on a free Google account — nothing to install — and the sample data is included so you can see the formulas work. If a file ever breaks, you receive a corrected copy of the file free. This is a digital product — no physical item will be shipped.