Where warranty tracking breaks down
In many shops the warranty is a handshake, or it's written on a paper work order nobody can find later. The problem shows up months after:
- A unit comes back and nobody knows what was done or when it went out.
- The customer has several identical units and there's no way to tell which is which.
- You do free work that wasn't covered, or charge for work that was.
- Nobody knows what warranty work costs each month, or which repair keeps coming back.
The fix is the same for all of them: every job logged, with the unit identified and the delivery date.
What to log on every job
| Field | Why it matters |
|---|---|
| Work order number | To find the job and its paperwork. |
| Customer | Who the warranty belongs to. |
| Unit | What it is: a motor, a pump, a cylinder, a power tool. |
| Serial number | To know the unit that came back is the same one, not a lookalike. |
| Work done | The warranty covers that work, not the whole unit. |
| Parts used | To file a claim with the supplier if a part fails, and to know what the job cost. |
| Delivered on | The day the unit left the shop. The warranty starts here. |
| Warranty period | In days or months. If it varies by job, log it on each one. |
| Expires on | Delivery date plus the period. Calculated, never typed by hand. |
| Terms | What it doesn't cover: impact damage, misuse, a unit opened by another shop. |
The field that matters most is the serial number. If the unit doesn't have one, give it one: a riveted tag, an oil-resistant label or an engraved number. From then on, that's its name in your shop.
Put your warranty terms in writing on the work order and on the invoice: what's covered, for how long, from what date, and what voids it. It's what you'll point to when a claim comes in.
The spreadsheet, ready to use
It has all of those fields as columns. Fill in the white ones; the gray ones calculate on their own. The first row, in gray, is an example: type over it or delete it.
Repair warranty log
One row per job delivered. Expiration date, “Under warranty today?” and days left calculate on their own.
Excel (.xlsx) · Also opens in Google Sheets and LibreOffice
- A unit that comes back several times gets several rows, one per job.
- To check coverage, filter by serial number and look at its latest job.
- If you give warranties in months, the second tab shows how to change the formula.
- One spreadsheet for the whole shop. If each tech keeps their own, the unit comes back and it's in someone else's.
How to tell if a returning unit is covered
- 01Look it up by serial number
Not by customer: one customer can have ten identical units.
- 02Check its latest job
If today is on or before the expiration date, it's covered.
- 03Check what was repaired
The warranty covers that work. A different failure is a new job.
- 04Check the terms
Impact damage, misuse, parts you didn't install, signs that someone else opened it.
- 05Log it before teardown
On the new work order: “Warranty claim on work order #…”. That way it's on record from the start.
How to handle a warranty claim
- 01Open a new work order flagged as warranty
Reference the original work order. A claim is a job too, and it gets logged.
- 02Diagnose before you promise
If the failure is the one you repaired, it's covered. If it's something else, quote it separately and get the customer's OK before doing it.
- 03Log parts and labor
The customer doesn't pay for them, but the shop does. If you don't log them, you don't know what warranty work costs you.
- 04If a part failed, file a claim
With the supplier who sold it to you, with their invoice. That's why you log the parts on every job.
- 05Deliver with paperwork
What was done and how long it's covered. Decide once whether warranty work restarts the clock or keeps the original date, and apply it every time.
The most common mistakes
- Identifying units by description. “5 HP motor” describes dozens. A serial number describes one.
- Counting from a date nobody wrote down. Pick when the warranty starts (usually delivery) and always log it.
- Doing warranty work without a work order. Later nobody knows how many there were or what they cost.
- Promising before diagnosing. What gets said at the counter is hard to take back.
- Keeping several lists. One per tech or one per year: the unit comes back and it's in the other one.
- Typing the expiration date by hand. It's a calculation: the spreadsheet does it.
When you outgrow the spreadsheet
A spreadsheet works while jobs are few and one person keeps it up. As the shop grows, the problem is that the warranty lives apart from the work order, the delivery note and the sale, so everything gets entered twice.
In Relevo's repair shop software the warranty comes from the work order itself:
- Every unit has its number, its customer and its history: the work orders, delivery notes and sales that touched it.
- The warranty starts counting on its own the day you deliver. The equipment list shows “Under warranty until…” or “Warranty expired on…”.
- You set the warranty months once, for the whole shop.
- A warranty order bills the customer $0, but parts still come out of stock: you see what each warranty costs.
- On delivery, the delivery note and the sale come out together.