Skip to content
The title slide and first slides of the Inventory Tracker template

Inventory Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

This template is a stock list for a small business that keeps parts, products or supplies on hand. The Items tab holds one row per item, with its SKU, category, stock on hand, reorder level, unit cost and supplier. The reorder flag and stock value calculate on their own.

The Dashboard shows how many items you track, the units and value on hand and how many need reordering, with a breakdown by category. The Suppliers tab shows the lead time and stock value for each supplier.

It comes with sample data. Make a copy, then replace the sample rows with your own items. Formulas, dropdowns and charts update on their own.

Useful for

  • Keeping a count of parts or products for a repair shop or small workshop
  • Knowing when to reorder before an item runs out
  • Working out how much money is tied up in stock

What's included

  • 4 tabs: Dashboard, Items, Suppliers, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Items: a table
  • Suppliers: 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

Is this Inventory Tracker template free?

Yes. Download the template and use it in Google Sheets or Excel at no cost.

Does it work in Excel?

Yes. Download the .xlsx file to open it in Excel. The formulas, dropdowns and charts work in both Excel and Google Sheets.

How do I change when an item is flagged to reorder?

Change the reorder level in the Reorder level column on the Items tab. The item is flagged when its on-hand figure is at or below that level.

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

More inventory templates

See all 6

Also in Business operations

All business operations templates
Get this template

Preparing your template…