Spreadsheets

Appliance and warranty tracker in Excel with expiry dates

Keep appliances, purchase dates, warranty months and service contacts in an Excel warranty tracker that works out expiry dates and flags those ending soon.

Editorial illustration for Appliance and warranty tracker in Excel with expiry dates

A warranty tracker is a table with one row per appliance: item, brand, purchase date, price, shop, warranty months and a service contact. A formula turns purchase date plus months into an expiry date, and conditional formatting highlights anything expiring within three months, so you can get a fault checked while it is still covered.

Which columns do I need?

  • A Item, B Brand, C Model, D Purchase date, E Price
  • F Shop, G Warranty months, H Expiry date, I Status
  • J Service contact (number or the brand's service request route), K Invoice link, L Notes (extended cover, parts covered separately)

Fill D from the invoice date, not the delivery or installation date, unless the warranty card says otherwise. Read the card for the start date and write it in Notes if it differs.

How do I calculate the expiry date?

In H2 write:

=IF(OR(D2="",G2=""),"",EDATE(D2,G2)-1)

EDATE adds whole months to a date, and the minus one makes a 24-month warranty bought on 15 March 2025 end on 14 March 2027 rather than the 15th. EDATE returns a serial number, so format column H as a date. If your warranty card states its own end date, type that in instead.

How do I flag what is expiring?

In I2 write =IF(H2="","",IF(H2<TODAY(),"Expired",IF(H2<=EDATE(TODAY(),3),"Expiring soon","Active"))). For colour, select H2:I200, choose Home > Conditional Formatting > New Rule > Use a formula, and enter:

=AND($H2<>"",$H2>=TODAY(),$H2<=EDATE(TODAY(),3))

Pick an amber fill. Add a second rule, =AND($H2<>"",$H2<TODAY()), with a grey fill for expired items. In Google Sheets the same formulas work in Format > Conditional formatting > Custom formula is.

What does a filled-in row look like?

ColumnExample
ItemWashing machine
Purchase date15-03-2025
Price₹32,000
Warranty months24
Expiry date14-03-2027
StatusActive until the date, Expiring soon from 14-12-2026
Service contactThe number printed on the card

The figures are for illustration. If the card says the warranty runs from the installation date, use that date in column D instead and add a line in Notes. With a purchase on 15 March 2025 and 24 months of cover, the formula =EDATE(DATE(2025,3,15),24)-1 returns 14 March 2027.

What else does the sheet tell me?

Total spent on appliances: =SUM(E2:E200). Items under cover: =COUNTIF(I2:I200,"Active")+COUNTIF(I2:I200,"Expiring soon"). Average age is useful for planning replacements: add a column M with =IF(D2="","",DATEDIF(D2,TODAY(),"y")) for years since purchase. Sort by it to see which appliances are old. The household also gets a ready list if you ever need to make a home insurance or moving claim.

Where do I keep the invoices?

Scan or photograph each invoice and warranty card the day you buy and keep them in one cloud folder named Invoices. Paste the file link in column K. If you track spending in SpendixAI, the bill can be attached to the matching transaction as a receipt too, so the purchase, its date and its proof sit together.

What about extended warranties and service contracts?

Add three more columns: N Extended cover provider, O Extended cover end date and P Cost paid. Extended cover usually begins when the basic warranty ends, so the end date is EDATE(H2,months)-1 on the extended term. A second status column lets you see both layers at a glance. Keep the paperwork link in Notes, and write down what the plan covers in plain words, because the sales conversation and the contract can differ. If a plan costs a large share of the item's price, the sheet makes that visible: =P2/E2 gives the percentage.

A routine for the sheet

  1. Add a row on purchase day, with the invoice link.
  2. Review the Expiring soon rows at the start of each quarter.
  3. If something is faulty, raise the complaint before the expiry date and note the complaint number in Notes.
  4. Delete or archive rows for items you have sold or discarded.
SPENDIXAI JOURNAL

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

Explore your reports