To store warranty bills for electronics so you can find them when something fails, photograph or scan each bill on the day you buy, name the file with the date and product, and record the purchase date, warranty length and end date in one list. Add a reminder a month before the end date so you can check the gadget while a claim is still possible.
How should you name and file each bill?
A file name that starts with the date sorts itself. Use this pattern: year-month-day, product, shop. For example, 2025-06-05 laptop shop-name. Keep them in one folder per year, and put the box's serial number in the file name or in a note beside it. Thermal-paper bills fade, so photograph them the day you buy rather than trusting the paper.
What should the list contain?
| Product | Purchase date | Warranty (months) | Ends on | Check on | Bill location |
|---|---|---|---|---|---|
| Laptop | 5 June 2025 | 24 | 4 June 2027 | 4 May 2027 | Folder 2025 |
| Mixer grinder | 12 October 2025 | 12 | 11 October 2026 | 11 September 2026 | Folder 2025 |
| Phone | 20 January 2026 | 12 | 19 January 2027 | 19 December 2026 | Folder 2026 |
These dates are made up. Check how the maker counts the period, since some start from the invoice date and some from activation, and write down what the warranty card says.
Which formula gives the end date?
With the purchase date in B2 and the warranty length in months in C2, this works in Excel and Google Sheets.
- End date: =EDATE(B2, C2) - 1
- Check date, 30 days before: =D2 - 30
- Days left from today: =D2 - TODAY()
EDATE adds whole months to a date, and the minus 1 makes the warranty end the day before the anniversary. Format the cells as dates. Applying this to 5 June 2025 with 24 months gives 4 June 2027. To highlight rows ending within a month, use conditional formatting with the custom formula =AND($D2 >= TODAY(), $D2 - TODAY() <= 30).
When should you check a gadget?
A month before the end date, switch the gadget on and test the things that tend to fail quietly: the battery, ports, hinges, speakers, the display for dead pixels or lines, fans making a new noise. If something is off, you can raise it while the warranty is valid. Note the date you reported it and who you spoke to.
What if a bill is lost?
- Check your email, the shop's app and any order history for a digital invoice.
- Look for the payment on your bank or card statement; the date and amount help the shop find the sale.
- Ask the shop for a duplicate bill and say when and how you paid.
- Next time, photograph the bill and file it before you open the box.
What about accessories and bundled items?
Chargers, earphones and bundled gifts often have their own warranty, or none. Read the card in the box. Add a row for anything with its own period, and for items bought together on one bill, note the bill once and point each row to it. Keep the packaging for the first few weeks, because some service centres ask for the original box with a return or replacement.
When does the list stop being enough?
A sheet is perfectly good for a few gadgets. When you want each bill next to the payment that made it, SpendixAI keeps receipts with their transactions, so the bill and the amount sit together once you import the statement. The warranty end dates can stay in your sheet.
A five-minute habit
- Photograph the bill and the serial number on the day.
- Name the file with the date and product.
- Add one row to the list with the end date.
- Add the check date to your calendar.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


