Service centre · Free template

Service job sheet format for repair and service centres

A job sheet is the one page that follows a product through your service centre: what came in, what was promised, what was done and what went back. Below: the fields to include, a sample, and a free Excel template you can print today.

  • The fields to record at receipt, estimate and delivery
  • A sample with invented values
  • Printable job sheet plus a job register in Excel
  • Overdue jobs flagged by age
Service job sheet with customer and product details, condition on receipt, estimate table and delivery signature

What is a service job sheet?

A service job sheet is a form filled in when a product comes to a service centre for repair. It records who the customer is, what product it is, what was wrong, what condition it arrived in, what the repair will cost, and when it went back. One sheet per job, kept with the product.

It protects both sides. The customer has a record of what was handed over. The centre has a record of the condition on arrival, which settles most arguments about scratches, missing accessories and promised charges.

You will also hear it called a job card, a repair job sheet, a service request form or an equipment receipt. The contents are close enough that one format covers all of them.

Service job sheet format: what to include

Five groups of fields are enough for most repair centres.

1. Customer and job

Job number, date received, customer name, phone and address. The job number is what the customer quotes on the phone, so give every job one and never reuse it.

2. Product

Product, model, serial number, purchase date and warranty status. The serial number is the key: it links this visit to earlier ones.

3. Receipt

Fault as the customer describes it, condition on receipt, accessories received and whether photos were taken. Add a line the customer signs to confirm what was handed over.

4. Estimate

Parts with quantity and rate, labour, total, and whether the customer approved it and on what date. Do not start paid work before the approval line is filled.

5. Repair and delivery

Technician, work done, date ready, date delivered and the customer's signature on delivery. The two dates give you the time taken.

Optional

Courier or pickup details, a second phone number, the person who approved a goodwill repair, and a note on where the original invoice is kept.

Service job sheet sample

A filled example for a water purifier. Every name, number and rate here is invented. Replace them with your own.

FieldExample entry
Job number / date receivedJS-0001 / 14 November
CustomerExample Customer, 98XXXXXXXX, Pune
Product / model / serialWater purifier / EX-100 / SN-EX-00123
Warranty statusIn warranty (purchased 14 June; invoice copy received)
Fault reportedNo water output since 1 November
Condition on receiptLight scratches on the left panel, no cracks
Accessories receivedPower adapter, one filter cartridge
EstimatePump ₹850 + inlet valve ₹120 + labour ₹300 = ₹1,270 (before GST)
Estimate approvedYes, 15 November
Work done / date readyReplaced pump and inlet valve, tested for 30 minutes / 17 November
Date delivered18 November (4 days after receipt)

Example only. Rates and the warranty position are invented; a real job depends on the product's warranty terms and your own price list.

What is in the free Excel template

  • Job sheet.The form above, set to print on one A4 page. The estimate adds up parts and labour for you.
  • Job register.One row per job with drop-downs for warranty status, estimate status and job status, so the same status is always spelled the same way. Room for 500 jobs.
  • Age and overdue flag.Days since received (or days to deliver, once delivered). A job still open past the number of days you set is flagged Overdue.
  • Summary line.Open jobs, overdue jobs and the average days taken for delivered jobs.
  • How to use.A short sheet explaining each column. The file also opens in Google Sheets.

Five habits that make a job sheet work

  • Fill it in with the customer present.Condition and accessories are only worth recording if the customer can see them recorded.
  • Photograph the product at receipt.Two photos settle most disputes. Note on the sheet that they were taken.
  • Get the estimate approved before paid work.Record the date. See itemised repair estimates.
  • Write the serial number every time.It is how you spot the same fault coming back and how you check warranty. See warranty management software.
  • Look at the overdue list every morning.A register nobody filters is just a record of what already went wrong.

When a spreadsheet stops being enough

A job sheet and a register are a sound start for one counter and one person. The strain shows when several people edit the register, when the same product comes back and nobody can find the earlier visit, or when a customer calls and the answer to "where is my product?" means a walk to the workshop.

That is the point to move the job into software. In service centre management software each job is a ticket against the product's serial number, with the estimate, the parts used and the status in the same place. And moving from Excel to complaint management software covers how to make the switch without a big project.

Service job sheet: frequently asked questions

What is a service job sheet?

A form filled in when a product comes in for repair. It records the customer, the product and serial number, the fault, the condition on receipt, the estimate, the work done and the delivery.

What should a service job sheet include?

Job number and date, customer details, product, model and serial number, warranty status, fault reported, condition and accessories on receipt, the estimate and its approval, work done, and the dates ready and delivered, with customer signatures at receipt and delivery.

What is the difference between a job sheet and a job card?

In most service centres none. Both are the record that follows a job. Some businesses use "job card" for the technician's copy and "job sheet" for the customer's receipt; the fields are the same.

Is there a free service job sheet template in Excel?

Yes. Download it from this page. It has a printable job sheet, a job register with drop-downs and an overdue flag, and a how-to sheet. It also opens in Google Sheets.

Do I need the customer's signature?

It is good practice at receipt, to confirm what was handed over and in what condition, and again at delivery. What a signature means legally depends on your terms and local rules, so check them with your own adviser.

What is an equipment receipt?

The part of the job sheet the customer keeps: job number, product, serial number, accessories handed over and the condition on arrival. The sheet on this page covers both the receipt and the repair record.

When should a service centre move from a job sheet to software?

When several people share the register, when repeat visits for the same serial number are hard to find, or when you cannot answer a customer's "where is my product?" without checking in the workshop.

Related reading

Track every job from receipt to delivery.

Free Starter plan for up to 10 users, no credit card.

Start free