What is a repair tracking system?The repair workflow from check-in to pickup, and how to choose the right way to track it
Download the free repair log template (Excel)
In this guide
- The whole repair workflow
- 3 ways to track repairs
- What to settle before you start
Show contents
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.
The ticket number tells you whose item is whose.
See at a glance what's waiting on the customer, the bench or a call.
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
- 01Check-in
Give it a ticket number. Put the same number on the item and the customer's copy
- 02Inspection
Note scratches, missing parts and accessories with the customer
- 03Estimate
Diagnose, then quote a price and a promised date
- 04Approval
Write down the day the customer said yes
- 05Repair
Record the work done, the parts used and who did it
- 06Final check
Make sure it's fixed and nothing else got damaged
- 07Ready notice
Tell the customer, and note when you did
- 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.
| Column | Why 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 |
| Received | The day it came in. Turnaround time is counted from here |
| Customer, phone, email | How 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 |
| Problem | In the customer's words: "no sound", "heel worn on one side" |
| Condition at drop-off | Scratches, missing parts, accessories. Settles arguments at pickup |
| Estimate and approved on | How much, and when the customer said yes. No date means you're still waiting |
| Promised date | The day you told the customer it would be ready |
| Status | Checked in → Estimate sent → In progress → Done → Customer notified → Picked up |
| Work done and parts | What you did and what you used, so next time you can say "last time we replaced this" |
| Technician | Who did the work. A must once more than one person is on the bench |
| Picked up on and paid | When it went home and what you were paid. Your sales totals come from here |
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.
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 logbook | Spreadsheet | Repair software | |
|---|---|---|---|
| Cost | A notebook | Free (Excel or Google Sheets) | Free plans to a monthly fee |
| Getting started | Today | Today (with a template) | The day you sign up |
| Preventing mix-ups | Numbers written by hand | Numbers by hand, plus search | Ticket numbers and tags issued for you |
| Telling customers | Phone calls | Phone calls, log open in front of you | Messages go out when the status changes |
| Estimate approval | Said yes on the phone | Said yes on the phone | The customer approves online |
| Finding past repairs | Flip through the pages | Search by phone number | Grouped by customer automatically |
| Several people | One book, passed around | Shared online for editing together (OneDrive, Google Sheets) | Everyone sees the same screen |
| Phone and tablet | No | Opens, but wide sheets are hard to read | Screens made for phones |
| Sales totals | By hand | With formulas | Automatic |
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.
- Write down every item you're holding right now
These become the first rows of your log.
- Decide how ticket numbers work
A running number from 0001, one number per item.
- Agree on status names
Checked in, Estimate sent, In progress, Done, Customer notified, Picked up. If everyone words it differently, you can't filter.
- Decide how customers hear from you
Phone, text or email, and who makes the call.
- 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
- 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.
- 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.
- 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 added | What you track |
|---|---|
| Moves between sites | Where an item is while it travels from the store to the repair center and back |
| Claim forms and item tags | Signed claim forms, the copies you keep, and the tag on each item |
| Repairs from partners | Taking in repairs from dealers and partners, and sharing progress with them |
| Access and audit trail | Who 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)

- 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.
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 free plan covers up to 100 repairs a month. How it works in your trade: