Appliance Register and Warranty Tracker

Who this is for

Every appliance in the house on one register, with its warranty counted down. Record the make, model and serial number, where it lives, what it cost and the date the warranty ends, and the browser and workbook versions show the days remaining.

Households that want to find a serial number in ten seconds when something fails, and to know whether it is still under warranty before ringing anyone.

What this helps you track

• Make, model and serial number for every appliance, ready for a repair call
• Days of warranty left, counted from today in the browser and workbook versions
• Whether the receipt has been kept, and where the manual is
• What the appliances cost in total, which is a figure an insurer may want

How to use it

1. Write the property and the date at the top.
2. Go round the house and copy the make, model and serial number from the rating plate on each appliance.
3. Fill in where it is, the date bought, the cost and the date the warranty or guarantee ends.
4. Tick whether the receipt is kept, and note where — the manual and the receipt are what a claim needs.
5. The days-left column counts down automatically in the browser and workbook; on paper, check the end dates against today once in a while.
6. Add a line when something new arrives and cross one out when something goes.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

Where do I find the serial number?

On the rating plate: usually inside the door, on the back, or under the base. Photograph it while the appliance is new and accessible, because it is harder to reach once it is built in.

What if the warranty was extended or registered?

Put the later end date in the warranty column and note the registration or extension reference in the notes. If you are unsure whether registration was done, assume the shorter period until you have checked.

Is the days-left column right on paper?

On paper the column is blank, because it depends on the day you look at it. It calculates in the browser and the spreadsheet, from the date you entered.

Does it cover boilers, heat pumps and the like?

It can, and many people add them. The dedicated boiler and heating logs on this site record servicing in more detail; this register is the index of what you own.