Key takeaways
- Every visit is recorded against the call.
- Parts carry cost, price and backorder status.
- Warranty work is marked and read separately.
- Margin is read per call, after technician time.
An appliance repair is quoted as a diagnostic plus a repair, and priced as though it happens in one trip. Often it does. When it does not, because the part has to be ordered and then does not arrive, the second and third visits are free to the customer and expensive to the business. That is where the margin on a parts job goes, and almost nobody measures it.
A call holds every visit
Visits are recorded against the call, numbered, each with its own hours, technician and charge.
A call that took three trips reads as three trips, and the two that earned nothing are on the same record as the one that did.
Parts cost, price and status
Every part ordered carries its cost and its price separately, and its state reads Received, On order, Backordered or Not ordered.
A special order that has been sitting eleven days is the reason a technician is about to make a wasted trip, and it is visible before they do.
Warranty work is different work
Warranty calls carry the manufacturer's authorised labor rate and parts supplied at cost, which is a much thinner job than a paid call.
Kept on the same sheet with the work type marked, the mix is readable rather than assumed.
Margin call by call
Call margin subtracts technician time at its own hourly cost and the real part cost from what the call billed.
A wrong part that cannot be returned plus a third visit turns a four hundred dollar repair into a loss, and the record says so plainly.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
ApplianceDesk US Google Sheets Edition is designed for use with a Google account and current desktop Google Sheets.
No dispatch board or route optimisation, no warranty claim submission to manufacturers, no parts inventory counts or reordering, no technician payroll or commission runs, and no card processing.

