Life events

Appliance AMC and extended warranty renewals: keep one log

A simple log for appliance AMC and extended warranty renewals: columns, an expiry-alert formula and how to judge cover against your actual repair bills.

Editorial illustration for Appliance AMC and extended warranty renewals: keep one log

Keep one log with a row per appliance, showing the cover type, provider, cost, start and end dates and any claims made. Then add a days-left formula so cover that is about to end stands out. With that log you can decide each renewal using your actual repair history instead of the reminder call from the seller.

What does the log need to hold?

ColumnExample entryPurpose
ApplianceSplit AC, bedroomOne row per item
Purchase date and shopDate and shop nameStarting point for warranty
Cover typeManufacturer warranty, AMC, extended warrantyDifferent rules apply to each
ProviderBrand or third-party companyWho to call
Cover start and endTwo datesDrives the alert
Cost paidAmount in rupeesFor yearly totals
Claims madeDate, issue, what was fixedShows whether cover earned its cost
PapersFolder or album where bill and contract are keptSaves a hunt during a breakdown

How do you get an expiry alert?

Put the cover end date in column F. In column H, enter =F2-TODAY() to see days left. Then use conditional formatting with the custom formula =AND($H2>=0,$H2<=45) to colour the row when cover ends within 45 days. A negative number means cover has already ended, so add a second rule for $H2<0 in grey. Both Excel and Google Sheets support this.

Is the AMC or extended warranty worth renewing?

The log answers this better than a sales call. Say your split AC has a yearly AMC at ₹2,500 and, over the past two years, you used it for two services and one gas top-up. If you were quoted ₹800 for each service on its own and ₹1,500 for the top-up, you can write down the comparison.

ItemTwo years of AMCSame work paid separately
AMC fee (₹2,500 × 2)₹5,000None
Two servicesIncluded₹1,600
Gas top-upIncluded₹1,500
Total₹5,000₹3,100

In this made-up case the cover cost ₹1,900 more than the work it covered, so the decision is about peace of mind rather than money. Change the figures to yours. Remember to read what the contract excludes; many contracts list parts or conditions that are not covered.

Where does the manufacturer warranty fit in?

Most appliances come with a manufacturer warranty for a period from purchase, and a paid cover often begins when that ends. Read the warranty card to see which date it counts from, the invoice date or the installation date, and which parts it covers. Write that end date in the log as its own row, so your paid cover starts on the right day and you never pay for the same period twice.

What should you do when something breaks?

  1. Find the row and note the cover end date.
  2. Check the contract for the claim route and any documents needed.
  3. Log the complaint date and reference number in the claims column.
  4. After the repair, note what was done and the date, and file the job sheet.
  5. If cover was refused, write down the reason; it helps at renewal.

Keeping bills and statement entries together

A cover is only as useful as the proof of purchase behind it. If you import card statements into SpendixAI, you can attach the invoice to the matching transaction and find both under the same entry later. Adding a note with the appliance name helps the search.

A yearly clean-up

  • Delete rows for appliances you no longer own.
  • Move expired cover to a separate tab instead of erasing the history.
  • Total the cost column for the year, so you know what you spend on cover.
  • Check every end date falls on your calendar.
SPENDIXAI JOURNAL

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

Explore your reports