Skip to the content.

Free Google Sheets Inventory Tracker

For a business that carries parts, chemicals or supplies on the truck and in the shop, and keeps running out of the one item a job needs.

Open the template · Make a copy · Google Sheet, free, no sign-up

What is inside

Tab What it holds
Dashboard Totals and views built from Items, Stock Transactions and Suppliers, no typing needed.
Items Columns Item ID, Item / part name, Category, Stock unit, Default supplier ID, Supplier, Standard unit cost (USD), Reorder level, Target stock and 6 more.
Stock Transactions Columns Transaction ID, Date, Item ID, Item / part, Movement type, Quantity (+), Signed quantity, Supplier ID (optional), Supplier and 4 more.
Suppliers Columns Supplier ID, Supplier name, Contact person, Email, Phone, Lead time (days) and Notes.
Settings Your own dropdown lists (categories and stock units), so the choices match how you work.

How to fill it in

  1. List every item once on Items with its unit, cost, reorder level and storage spot.
  2. Record each delivery, each use on a job and each count fix on Stock Transactions.
  3. Add suppliers with their lead time, so you know how early to order.
  4. Watch Suggested order qty and the Dashboard to reorder before anything hits zero.

A tip from the field

Put the job number in the reference column when parts leave stock. Later you can see what each job actually used.

Starter files

Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.

When you outgrow it

Smarfle tracks stock levels and the parts used on each job, with low and out of stock filters. See how it works on smarfle.com.

All free templates