An appliance register is a single sheet that lists every major appliance in your home with its purchase date, price, bill, warranty end date and how long you expect it to last. Add two formulas and one glance shows which appliance is oldest, whose warranty has ended and which one to plan for next.
Which columns does the register need?
- A: Appliance, for example refrigerator, washing machine, geyser, chimney, air conditioner
- B: Brand and model, copied from the rating plate or the bill
- C: Purchase date, as a real date and not text
- D: Price paid, in rupees
- E: Shop or seller, and the bill or invoice number
- F: Warranty period in months, as printed on the warranty card
- G: Expected life in years, which is your own assumption
- H: Age in years, from a formula
- I: Years left, from a formula
- J: Warranty ends, from a formula
- K: Service contact and last service date
Expected life is a judgement. You may use the maker's stated life if one is printed, or your own experience with the previous appliance. Do not treat it as a fact, since appliances fail earlier or later than any estimate.
Which formulas give age, years left and warranty end?
These work in both Excel and Google Sheets, assuming the first appliance is in row 2.
- Age in whole years in H2: =DATEDIF(C2, TODAY(), "Y")
- Years left in I2: =G2-YEARFRAC(C2, TODAY())
- Warranty end date in J2: =EDATE(C2, F2)
- Warranty status, if you want a word: =IF(TODAY()>EDATE(C2, F2), "Expired", "Active")
EDATE adds months to a date, so a purchase on 15 June 2019 with a 24-month warranty ends on 15 June 2021. YEARFRAC returns a decimal, so 5.5 means five and a half years. Format column J as a date, and format column I with one decimal place. If a result shows a number such as 44000, the cell needs a date format.
What does a filled row look like?
| Appliance | Bought on | Price (₹) | Warranty (months) | Expected life (years) | Warranty ends |
|---|---|---|---|---|---|
| Refrigerator | 15 June 2019 | 32,000 | 24 | 13 | 15 June 2021 |
| Washing machine | 10 March 2022 | 24,500 | 24 | 10 | 10 March 2024 |
| Water geyser | 5 November 2023 | 8,200 | 24 | 8 | 5 November 2025 |
| Ceiling fans (4) | 1 April 2020 | 9,600 | 12 | 12 | 1 April 2021 |
These entries are invented. The point is that each has a date you can search, a bill you can find and a warranty end you do not need to remember.
How do you make the oldest or expiring items stand out?
Use conditional formatting. Highlight column I in red when the cell is below 2 years left, and column J in amber when the warranty ends within the next 60 days. In Excel the rule can use =J2-TODAY()<60, and in Google Sheets the custom formula is the same. Sorting by column I puts the appliance with the least life at the top.
What else is worth recording?
- Service visits: date, what was done, amount paid
- Repairs: the date, the part and the cost, because a rising repair bill is a signal to replace
- Extended warranty or service plan: start, end and the fee, even though it is optional
- Where the manual and the accessories are kept
How do the payments connect?
The register holds the facts about the appliance, while your expense records hold the payments. If you track spending in SpendixAI, you can add the bill as a receipt on the purchase transaction, and keep a Home repairs category for servicing, so the cost of each appliance can be totalled from its date of purchase. Cash payments to a repair shop are added by hand.
A yearly review
- Check which warranties end in the next twelve months and book any free checks while they last
- Look at the years left column and list what falls due within three years
- Update service dates and add new bills
- Note any appliance whose repair costs are creeping up
Useful ideas start with a clearer picture of your own spending.
Explore your reports

