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?
| Column | Example entry | Purpose |
|---|---|---|
| Appliance | Split AC, bedroom | One row per item |
| Purchase date and shop | Date and shop name | Starting point for warranty |
| Cover type | Manufacturer warranty, AMC, extended warranty | Different rules apply to each |
| Provider | Brand or third-party company | Who to call |
| Cover start and end | Two dates | Drives the alert |
| Cost paid | Amount in rupees | For yearly totals |
| Claims made | Date, issue, what was fixed | Shows whether cover earned its cost |
| Papers | Folder or album where bill and contract are kept | Saves 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.
| Item | Two years of AMC | Same work paid separately |
|---|---|---|
| AMC fee (₹2,500 × 2) | ₹5,000 | None |
| Two services | Included | ₹1,600 |
| Gas top-up | Included | ₹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?
- Find the row and note the cover end date.
- Check the contract for the claim route and any documents needed.
- Log the complaint date and reference number in the claims column.
- After the repair, note what was done and the date, and file the job sheet.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

