Home and property

A household appliance register: dates, bills, warranty and life

An appliance register template for your home: columns for purchase date, bill, warranty end and expected life, with formulas that show age and years left.

Editorial illustration for A household appliance register: dates, bills, warranty and life

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?

ApplianceBought onPrice (₹)Warranty (months)Expected life (years)Warranty ends
Refrigerator15 June 201932,000241315 June 2021
Washing machine10 March 202224,500241010 March 2024
Water geyser5 November 20238,2002485 November 2025
Ceiling fans (4)1 April 20209,60012121 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?

  1. Service visits: date, what was done, amount paid
  2. Repairs: the date, the part and the cost, because a rising repair bill is a signal to replace
  3. Extended warranty or service plan: start, end and the fee, even though it is optional
  4. 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
SPENDIXAI JOURNAL

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

Explore your reports