Guide / Repair shops

How to track warranties in a repair shop

A unit comes back, the customer says it's under warranty, and nobody remembers when it went out. Here's what to log on every job, how to tell right away if it's covered, and how to handle the claim. With a spreadsheet to download.

· 6 min read

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

FieldWhy it matters
Work order numberTo find the job and its paperwork.
CustomerWho the warranty belongs to.
UnitWhat it is: a motor, a pump, a cylinder, a power tool.
Serial numberTo know the unit that came back is the same one, not a lookalike.
Work doneThe warranty covers that work, not the whole unit.
Parts usedTo file a claim with the supplier if a part fails, and to know what the job cost.
Delivered onThe day the unit left the shop. The warranty starts here.
Warranty periodIn days or months. If it varies by job, log it on each one.
Expires onDelivery date plus the period. Calculated, never typed by hand.
TermsWhat 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

Download the spreadsheet ↓
  • 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

  1. 01
    Look it up by serial number

    Not by customer: one customer can have ten identical units.

  2. 02
    Check its latest job

    If today is on or before the expiration date, it's covered.

  3. 03
    Check what was repaired

    The warranty covers that work. A different failure is a new job.

  4. 04
    Check the terms

    Impact damage, misuse, parts you didn't install, signs that someone else opened it.

  5. 05
    Log 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

  1. 01
    Open a new work order flagged as warranty

    Reference the original work order. A claim is a job too, and it gets logged.

  2. 02
    Diagnose 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.

  3. 03
    Log 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.

  4. 04
    If 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.

  5. 05
    Deliver 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.

Before you start

Practical questions.

When does a repair warranty start?

Usually on the day the unit goes back to the customer. What matters is that it's written on the work order and on the paperwork the customer takes home.

Does the warranty cover the whole unit?

It covers the work done and the parts installed. If the unit comes back with a different failure, it's a new job and gets quoted separately.

What if the unit has no serial number?

Give it one: a riveted tag, a tough label or an engraved number. Log it on the work order and in the spreadsheet.

How do I calculate the expiration date in Excel?

Delivery date plus warranty days: if the delivery date is in G5 and the days in H5, the formula is =G5+H5, formatted as a date. For months, use =EDATE(G5,H5). The spreadsheet in this guide already has the formulas.

Can I track warranties in Relevo?

Yes. The repair shop software keeps every unit with its history and calculates the warranty from the delivery date. Request a free demo and we'll show you with a real case from your shop.

You might also need

Request your free demo.

We'll show you the repair shop software with a real case from your shop.

Request your free demo →