What is a repair tracking system?The repair workflow from check-in to pickup, and how to choose the right way to track it

Published November 14, 2026 · Updated November 14, 2026 · By Repair Karte

Download the free repair log template (Excel)
A camera with a claim tag, a laptop showing the repair list, and a phone showing a ready notice, joined by a dotted line

In this guide

  1. The whole repair workflow
  2. 3 ways to track repairs
  3. What to settle before you start
Show contents
  1. 01The basics
  2. 028 steps
  3. 03What to record
  4. 04Comparing methods
  5. 05Common mistakes
  6. 06Before you start
  7. 07Larger organizations
  8. 08Free template
  9. 09Try Repair Karte

01What changes with a repair tracking system?

A repair tracking system keeps every repair you take in on one record, so you can follow each item from check-in to pickup. It can be a paper logbook or a spreadsheet, but dedicated repair software also sends customer updates and finds past repairs for you.

Repair tracking itself means being able to answer, for every item in the shop: where is it, what stage is it at, and who does what next. And once it's gone home: what was done, and what was paid.

With one record for every repair, three things change.

No more mix-ups or lost items

The ticket number tells you whose item is whose.

Nothing stalls, nobody is forgotten

See at a glance what's waiting on the customer, the bench or a call.

History you can use next time

Past work, parts and prices, looked up by customer.

Item, customer, status, price and history, in one place.

02From check-in to pickup in 8 steps

  1. 01Check-in

    Give it a ticket number. Put the same number on the item and the customer's copy

  2. 02Inspection

    Note scratches, missing parts and accessories with the customer

  3. 03Estimate

    Diagnose, then quote a price and a promised date

  4. 04Approval

    Write down the day the customer said yes

  5. 05Repair

    Record the work done, the parts used and who did it

  6. 06Final check

    Make sure it's fixed and nothing else got damaged

  7. 07Ready notice

    Tell the customer, and note when you did

  8. 08Pickup & payment

    Record the pickup date and the amount paid. Keep the row

Every repair goes through these eight steps. The two where repairs stall are Approval and Ready notice: both are waiting on the customer, to answer or to come in. Give each a date column, and look at the blank ones every morning.

Finished repairs piling up?Telling customers their repair is ready

0312 things to record for every repair

Paper, spreadsheet or software, the columns are the same.

ColumnWhy it's there
Ticket #A running number. The same number goes on the claim tag and the customer's copy: the single best defense against mix-ups
ReceivedThe day it came in. Turnaround time is counted from here
Customer, phone, emailHow you'll reach them. Keep the phone number searchable so past repairs are easy to find
Item type and item"Watch" plus "Automatic, steel, serial 48812". Enough to tell it apart from similar items on the shelf
ProblemIn the customer's words: "no sound", "heel worn on one side"
Condition at drop-offScratches, missing parts, accessories. Settles arguments at pickup
Estimate and approved onHow much, and when the customer said yes. No date means you're still waiting
Promised dateThe day you told the customer it would be ready
StatusChecked in → Estimate sent → In progress → Done → Customer notified → Picked up
Work done and partsWhat you did and what you used, so next time you can say "last time we replaced this"
TechnicianWho did the work. A must once more than one person is on the bench
Picked up on and paidWhen it went home and what you were paid. Your sales totals come from here
0012Repair logNo.0012Claim tagClaim ticket0012Customer's copy

The ticket number does the most work. When the log, the item and the customer's copy carry the same number, mix-ups all but stop.

The same columns on one card per repair (a repair record in Repair Karte).

Numbering and tagsRepair claim tags and tickets

04Paper, spreadsheet or software, side by side

There are three ways to track repairs. Here they are on the same yardstick.

Paper logbookSpreadsheetRepair software
CostA notebookFree (Excel or Google Sheets)Free plans to a monthly fee
Getting startedTodayToday (with a template)The day you sign up
Preventing mix-upsNumbers written by handNumbers by hand, plus searchTicket numbers and tags issued for you
Telling customersPhone callsPhone calls, log open in front of youMessages go out when the status changes
Estimate approvalSaid yes on the phoneSaid yes on the phoneThe customer approves online
Finding past repairsFlip through the pagesSearch by phone numberGrouped by customer automatically
Several peopleOne book, passed aroundShared online for editing together (OneDrive, Google Sheets)Everyone sees the same screen
Phone and tabletNoOpens, but wide sheets are hard to readScreens made for phones
Sales totalsBy handWith formulasAutomatic

Paper to spreadsheet is about finding things. Spreadsheet to software is about who tells the customer.

Comparing software?How to choose repair shop software for a small shop

055 common mistakes, and how to avoid them

Mix-ups

Two silver watches, two black jackets. A paper stub alone can't tell them apart. A ticket number on the item itself can.

Forgetting to call

The work is done, but nobody told the customer, so it sits on the shelf. Keep a "Done (customer not told)" status and check it every morning.

Stuck waiting for approval

You quoted on the phone and you're waiting for a call back. Keep an Approved on column and follow up on every blank one the next day.

No history

Throw away the finished tickets and you'll be asking "what did we do last time?" Keep the rows, filter them out instead.

Tickets go missing

Paper tickets end up next to whatever is on the bench. Keep one log in one place, and find tickets by number.

06Before you start

Whatever you track repairs with, settle these five things before the first row. It saves redoing them later.

  1. Write down every item you're holding right now

    These become the first rows of your log.

  2. Decide how ticket numbers work

    A running number from 0001, one number per item.

  3. Agree on status names

    Checked in, Estimate sent, In progress, Done, Customer notified, Picked up. If everyone words it differently, you can't filter.

  4. Decide how customers hear from you

    Phone, text or email, and who makes the call.

  5. Decide who writes in the log

    For example, whoever checks the item in adds the row there and then.

Which tool fits your shop today

  1. Stage 1

    While you can keep every item in your head

    A paper logbook or a spreadsheet is enough. What matters more than the tool is a ticket number on every item and a status column.

  2. Stage 2

    Once you need the log to know what's in the shop

    A spreadsheet fits. You can look up history by phone number and filter by status to see only what's on your shelf. Calls are still by hand, and they become the biggest chore.

  3. Stage 3

    When updates and lookups eat your day, or two or more people take in repairs

    Software that sends the updates and keeps the history for you saves the most work. A good sign: you phone customers every day about estimates and pickups.

07Repair tracking in larger organizations (manufacturers, retailers, service centers)

Manufacturers, retailers and service centers that collect repairs from several stores track everything above, plus a few more things:

What's addedWhat you track
Moves between sitesWhere an item is while it travels from the store to the repair center and back
Claim forms and item tagsSigned claim forms, the copies you keep, and the tag on each item
Repairs from partnersTaking in repairs from dealers and partners, and sharing progress with them
Access and audit trailWho can see what, and who changed what, when

When each site keeps its own log, the same item ends up with several records, and retyping between them causes mistakes. The basic rule is to choose a system where the store that took the repair and the site that fixes it work on the same record.

Don't split the record by site. One repair, one record, shared by every site.

08Free repair log template (Excel)

The repair log template in Excel with three sample rows colored by status
Three sample rows. Pick a status and the row changes color: yellow while you wait for the customer, gray once it's picked up.
  • Add a row for every repair you take in, and write the ticket number on the claim tag.
  • When the customer says yes to the estimate, fill in Approved on. A blank one means you're still waiting.
  • When the work is done, set the status to Done (customer not told), and to Customer notified once you've told them.
  • Keep picked-up rows. They are your history.
Start by listing what's on your shelfrepair-log-template.xlsxWorks in Excel and Google Sheets. Three sample rows included. Change it and share it with your staff however you like.
Download freeNo sign-up or email

Columns, statuses and a morning checkRepair tracking spreadsheet

09Try it in Repair Karte

As repairs pile up, or once two or more people take them in, the log itself stops being the hard part. Telling customers and finding past repairs take the time. Repair software takes those two off your hands.

Repair Karte is repair tracking software that started on a real repair bench. It keeps one record per repair and a history per customer, sends the estimate and the "ready for pickup" message, lets customers approve estimates online, and gives each customer a page where they can check their repair themselves. It all runs in the browser. The Free plan covers up to 100 repairs a month for 1 staff login, with no credit card, and stays free. Automatic email updates to customers start on Standard. Every new account gets all Pro features free for 14 days. Pricing and plans

Already keeping a spreadsheet? Send the file and our team imports it for you, free on every plan. Importing sends nothing to your customers.

The page your customer opens to check their repair, without calling the shop.

The free plan covers up to 100 repairs a month. How it works in your trade:

Repair log templateDownload