Travel and vehicles

A wear-items log: tyres, battery, brake pads and chain

A wear-items log for tyres, battery, brake pads and chain: replacement date, km, cost and life, so you can estimate the next due date and set money aside.

Editorial illustration for A wear-items log: tyres, battery, brake pads and chain

A wear-items log is one compact table of the parts that wear out, with the date, kilometres and cost each time they were replaced. From two replacements you can work out how long a part lasted, estimate when the next one is due and put a little money aside each month. It turns a surprise bill into a planned one.

What does the table look like?

This example is for a bike, with invented figures. Each part has two replacements logged.

PartReplaced onKm at replacementCost (₹)Life of last set
Rear tyreEarlier at 14,000, now at 31,00031,0002,40017,000 km
Brake padsEarlier at 12,000, now at 26,00026,00060014,000 km
Chain and sprocket kitEarlier at 20,000, now at 41,00041,0002,20021,000 km
Battery12 Mar 2022 and 20 May 2025-2,00038 months

How do you estimate when the next one is due?

Add the last life to the last replacement. The rear tyre lasted 17,000 km and was replaced at 31,000, so the next is due around 48,000 km. Brake pads: 26,000 plus 14,000 is 40,000. Chain kit: 41,000 plus 21,000 is 62,000. For the battery, which ages with time, adding 38 months to 20 May 2025 gives about 20 July 2028. In a sheet, with replacement odometers in column C, life is =C3-C2 and next due is =C3+(C3-C2). Use the average of several past lives if you have them.

How much should you set aside each month?

Divide the cost by the months the part lasts. Say you ride 700 km a month. The tyre's 17,000 km is about 24 months, so ₹2,400 divided by 24 is ₹100 a month. Brake pads: 14,000 km is 20 months, so ₹600 divided by 20 is ₹30. Chain kit: 21,000 km is 30 months, so ₹2,200 divided by 30 is about ₹73. Battery: ₹2,000 divided by 38 months is about ₹53. Together that is roughly ₹256 a month for the four parts, a figure to put aside in a separate pot so replacements do not hit that month's budget.

Keep that money in a separate pot if you can, so it is not spent on something else. A small standing transfer on salary day is enough, and the pot means a ₹2,400 tyre arrives as a planned expense rather than a bad surprise.

Which columns keep it simple?

  • Part and position, such as front left or rear
  • Date and odometer of each replacement, one row each
  • Brand and cost, with the invoice photo link
  • Life in km and in months, as formulas
  • Estimated next due km or date
  • Notes on why it was changed

For months between two dates, use =DATEDIF(A2,A3,"m"), which works in Excel and Google Sheets. For a due date by months, use =EDATE(A3,38).

Which parts belong in the list?

  1. Anything that wears out through use: tyres, pads or shoes, chain and sprockets, clutch, wipers, bulbs.
  2. Anything that ages through time: battery, belts, rubber hoses.
  3. Anything expensive enough to hurt in one month.
  4. Leave out routine consumables like oil, which belong in the service history instead.

What if you have only one replacement logged?

Then you have one life figure, which is a start. Use it, mark it as based on one sample and refine it when the next replacement happens. If the part came with the vehicle, note the odometer when you first noticed wear. Honest gaps are better than made-up averages.

Where does SpendixAI help?

Wear-item purchases appear when you upload statements, and you can set up categories or sub-categories for tyres and batteries to see the total by year. Receipts can sit with each transaction. The kilometre history stays in your sheet.

When you replace a part

  • Record the date, odometer, cost and brand.
  • Update the next-due estimate.
  • Photograph the invoice.
  • Adjust the monthly set-aside amount.
SPENDIXAI JOURNAL

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

Explore your reports