Skip to content
Warranty Tracker cover: a sample sheet with items tracked, active warranties and expiring within 60 days and a column chart, beside the Dashboard and Items tabs

Warranty Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Minimal
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

Households, landlords and small offices that keep track of appliances, electronics, tools, furniture and vehicle parts can use this register. The Dashboard shows items tracked, active warranties, warranties expiring within 60 days and the value still covered, with a column chart by category and a doughnut chart of status. The Items tab records the purchase date, price, warranty length in months, the calculated end date, days left, status and a receipt checkbox for each product.

Enter the warranty length exactly as the receipt or the manufacturer card states it. Tick Receipt saved once a copy is stored where you can retrieve it quickly. Rows that expire within 60 days turn red, so review them every month and decide whether to register the product or buy extra cover. Consumer protection rules in your area can apply beyond the written warranty, so check them before you assume a claim is refused.

Useful for

  • Find which appliances are still under warranty
  • Keep receipts together ready for a claim
  • Plan replacements before cover runs out

What's included

  • 3 tabs: Dashboard, Items, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Items: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Items tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How is the warranty end date worked out?

The end date adds the warranty months to the purchase date, landing on the same calendar day. A purchase on 18 November with a 24-month warranty ends on 18 November two years later. Days left subtracts today's date from that end date.

What counts as expiring soon?

Any warranty with 60 days or fewer left shows Expiring soon, and the Dashboard counts it. To change the window, edit the 60 in the status formula on the Items tab, for example to 90 days for longer-lead planning.

Does a standard warranty cover accidental damage?

Usually not. A manufacturer warranty normally covers faults in materials and workmanship, while accidental damage often needs a separate protection plan. Read the terms that came with the product, since each one sets its own rules.

  • #tracker
  • #warranty-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 15

Also in Business operations

All business operations templates
Get this template

Preparing your template…