Shopping

One sheet for every family device: purchase date, warranty and bill

A family electronics warranty tracker in one sheet: owner, purchase date, price, warranty end and bill link, with formulas and a made-up sample for four.

Editorial illustration for One sheet for every family device: purchase date, warranty and bill

One sheet can track every phone, laptop, tablet and charger in the house: a row per device with owner, purchase date, price, warranty end date and a link to the bill photo. Two simple formulas then calculate the warranty end date and flag anything ending within a month. Here is the layout, filled with made-up devices for a family of four.

Which columns should the sheet have?

  • A: Owner. B: Device and model. C: Serial or IMEI.
  • D: Purchase date. E: Price in rupees. F: Warranty months.
  • G: Warranty end date, calculated. H: Status, calculated.
  • I: Bill link or folder path. J: Notes, such as the accessory list or where the box is.

What does a filled sample look like?

Everything below is invented for the example, including prices.

OwnerDevicePurchase datePriceWarranty months
AshaPhone10 Jan 2026₹18,00012
RaviPhone5 Aug 2025₹22,00012
MeeraTablet20 Jun 2025₹15,50012
AmanLaptop2 Mar 2026₹48,00024
FamilyWi-Fi router15 Sep 2025₹2,00012

The total spent on devices is ₹18,000 + ₹22,000 + ₹15,500 + ₹48,000 + ₹2,000 = ₹1,05,500.

Which formulas do the calculating?

Assume the data starts in row 2, with the purchase date in D, the price in E, the warranty months in F and the end date in G. These work in Excel and in Google Sheets.

  1. Warranty end date in G2: =EDATE(D2, F2) - 1. EDATE adds the number of months to the date; subtracting 1 gives the last day of cover. Format column G as a date. If your card gives its own end date, type that instead.
  2. Status in H2: =IF(G2 < TODAY(), "Ended", IF(G2 - TODAY() <= 30, "Check soon", "Active")). This shows Ended once the date has passed, Check soon within thirty days, and Active otherwise.
  3. Total spent: =SUM($E$2:$E$200).
  4. Spend per person, with owner names in column A: =SUMIF($A$2:$A$200, "Asha", $E$2:$E$200).

Copy the formulas down for each new row. Use a range that is longer than your list so new devices are included.

Name the bill photo with date, item, shop and amount, save it in a folder, and paste the file link into column I. If you cannot paste links, write the folder path and the file name. Do the same for the serial number photo.

What happens when a device is sold or given away?

Do not delete the row. Add a note with the date and who got it, and change the status text by hand to Sold or Gifted. It keeps a record of what you owned and what became of it, which is handy if a question comes up about a serial number.

When does a sheet stop being enough?

When you want the purchases to flow into your monthly spending without retyping, an expense tracker is a better home. SpendixAI imports card and bank statements and lets you add expenses by hand, with receipts kept alongside each transaction, though it is not a warranty tracker, so keep this device sheet for expiry dates.

Which devices are worth a row?

Add anything that cost enough that you would want to claim for it, and anything with a warranty: phones, laptops, tablets, smartwatches, routers, speakers and power banks. Leave out very cheap items unless they carry a warranty you care about. A charger or cable earns its own row only if the brand lists it separately; otherwise mention it in the notes of the main device, along with where the box is.

Setting it up in ten minutes

  • List the devices you can see right now.
  • Fill purchase date and price from the bills.
  • Paste the formulas and check one date by hand.
SPENDIXAI JOURNAL

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

Explore your reports