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?
| Column | Example |
|---|---|
| Item | Washing machine |
| Purchase date | 15-03-2025 |
| Price | ₹32,000 |
| Warranty months | 24 |
| Expiry date | 14-03-2027 |
| Status | Active until the date, Expiring soon from 14-12-2026 |
| Service contact | The 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
- Add a row on purchase day, with the invoice link.
- Review the Expiring soon rows at the start of each quarter.
- If something is faulty, raise the complaint before the expiry date and note the complaint number in Notes.
- Delete or archive rows for items you have sold or discarded.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

