Travel and vehicles

Vehicle service history sheet: date, km, work done and bill

A vehicle service history sheet with date, km, work done, parts, labour and next due, plus how to attach job card photos and work out the average cost.

Editorial illustration for Vehicle service history sheet: date, km, work done and bill

A service history sheet needs one row per visit with the date, the odometer, the workshop, the work done, parts and labour amounts, the total and the next due km and date. Add a link to a photo of the job card and you can answer, in a minute, what was done last time and what a service costs on average. It works equally well for a car or a bike.

Which columns should the sheet have?

  • A: Date of service
  • B: Odometer (km)
  • C: Workshop, written the same way each time so you can filter later
  • D: Work done, in a few words
  • E: Parts (₹) and F: Labour (₹), as shown on the bill
  • G: Total (₹), which is E plus F
  • H: Job card photo, as a link to the file
  • I: Next due km and J: Next due date

If a bill has a separate consumables or tax line, add it to the nearest column or give it its own column, but be consistent from row to row.

What does a filled sheet look like?

These rows are made up to show the layout. Say the car has had four visits.

DateOdometer (km)WorkshopWork doneParts (₹)Labour (₹)Total (₹)
10 Feb 202512,400AuthorisedGeneral service, oil change1,8009002,700
18 Aug 202518,900Local garageFront brake pads, oil2,6007003,300
5 Feb 202625,100AuthorisedGeneral service, air filter2,4001,1003,500
30 Jul 202631,300Local garageOil, coolant top-up3,1008003,900

How do you work out the average cost of a service?

With the totals in G2 to G200, the average is =AVERAGE($G$2:$G$200), which ignores empty cells. Here the four totals add up to ₹13,400, and the average is ₹3,350 per visit. For a rough cost per kilometre, leave out the first bill and divide the later ones by the distance since that first service: ₹10,700 divided by 18,900 km, which is about ₹0.57 per km. Call it a rough guide, because visits are uneven and some include one-off parts.

How do you attach the job card photo?

  1. Photograph the job card or invoice before you leave the workshop, with every line readable.
  2. Name the file with the date and odometer, for example 2026-07-30_jobcard_31300km.
  3. Save it to one cloud folder, then paste a link to that file into column H. In Excel use Insert, then Link; in Google Sheets use Insert, then Link.
  4. Keep the paper original too, if the workshop gave you one.

How do you plan the next service?

Check the manual for the interval in km and in months, because it differs by vehicle. If it says every 10,000 km or 12 months, whichever is first, then the next due km is =B5+10000 and the next due date is =EDATE(A5,12). Where those two limits pull in different directions, use whichever comes first. The related article on whichever-comes-first reminders goes into the arithmetic.

What does the sheet teach you over time?

  • Whether a workshop's bills drift upward visit after visit.
  • Which items repeat, so you can budget for them instead of being surprised.
  • How much you actually spend per year, which helps when comparing with a service package.
  • What to tell a buyer when you sell, since a complete history is easier to trust.

Can SpendixAI replace the sheet?

Not for the odometer and the next-due logic, which stay in your sheet. What it does well is the money side. If your payments come from an uploaded statement or an entry you add by hand, you can categorise them as vehicle maintenance and attach the job card as a receipt on the same transaction.

Before you leave the workshop

  • Take a photo of the job card.
  • Note the odometer.
  • Ask what is due next and when.
  • Add the row to your sheet the same day.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports