Templates

Inventory Tracker

Small retailers, online shops and makers

Small shops and makers: track stock, suppliers and orders so you reorder in time.

OperationsRetailinventorystocksuppliersordersretailreorder
Use this template

Inventory Tracker

On hand fills in for you: opening stock plus what you received, minus what you sold. Stock level turns to Reorder soon at the reorder point and to Out at zero, so there is nothing to update by hand.

Dashboard

Receiving checklist

Reorder rules

Monthly stock take

Low stock

Stock levels
ProductCategoryUnit costPriceOpening stock (units)Reorder point (units)Supplier
Amber Fig 8oz candleCandles$6.40$2812040Beeswax Brothers
Cedar & Smoke 8oz candleCandles$6.90$289640Beeswax Brothers
Sea Salt Orchid 8oz candleCandles$6.10$283040Beeswax Brothers
Wild Sage travel tinTins$3.20$1615060Glassworks North
Lavender Honey travel tinTins$3.40$16060Glassworks North
Holiday trio gift setGift sets$14.50$642225Beeswax Brothers
Cotton wick pack, 50 countSupplies$8$04010Wick & Wonder Supply
Amber glass jar, 8ozSupplies$1.30$0300120Glassworks North

2 more rows

Purchase orders

Purchase orders
PurchasePO numberStatusQuantityCost eachOrderedExpected
Amber Fig 8oz candle restock—Received60$7.90Oct 25, 2026Nov 3, 2026
Cedar & Smoke 8oz candle restock—Received60$8.49Oct 25, 2026Nov 3, 2026
Sea Salt Orchid 8oz candle restock—Ordered80$7.55Nov 13, 2026Nov 22, 2026
Lavender Honey travel tin restock—Shipped200$4.36Nov 6, 2026Nov 16, 2026
Soy wax flakes, 10 lb bag restock—Ordered12$49.91Nov 16, 2026Nov 25, 2026
Amber glass jar, 8oz restock—Received500$1.88Oct 9, 2026Oct 30, 2026
Holiday trio gift set restock—Ordered30$17.46Nov 17, 2026Nov 29, 2026

Sales orders

Sales orders
CustomerOrder numberStatusQuantityUnit priceOrderedShipped on
Hollis Maddox—Delivered8$28Nov 6, 2026—
Priscilla Banda—Delivered6$28Nov 8, 2026—
Craft fair booth—Delivered24$16Nov 9, 2026—
Lena Okafor-Wright—Delivered14$16Nov 10, 2026—
Corporate gifts, Adler Insurance—Shipped10$64Nov 15, 2026Nov 15, 2026
Dmitri Volkov—Packed5$28Nov 17, 2026—
Rosalind Tran—New4$28Nov 18, 2026—
Online order batch—New9$16Nov 18, 2026—

Suppliers

Suppliers
SupplierContactEmailPhoneLead time (days)RatingPayment terms
Beeswax BrothersGarrett Lindegarrett@beeswaxbrothers.net(505) 555-01619ExcellentNet 30
Glassworks NorthImelda Rossiimelda@glassworksnorth.net(505) 555-016221Good50% upfront
Wick & Wonder SupplyTobias Eketobias@wickandwonder.net(505) 555-01636ExcellentNet 15

What's inside

4 tables · 16 views · 1 form · 3 row actions · 1 agent

5 pages

  • Inventory Tracker
  • Dashboard
  • Receiving checklist
  • Reorder rules
  • Monthly stock take

4 tables

  • Suppliers1 view · 3 sample rows
  • Products3 views · 10 sample rows
  • Purchase orders6 views · 7 sample rows
  • Sales orders6 views · 8 sample rows

Questions

What is included in the Inventory Tracker template?
5 pages (Inventory Tracker, Dashboard, Receiving checklist, Reorder rules and Monthly stock take) and 4 tables (Suppliers, Products, Purchase orders and Sales orders), filled with 28 sample rows so every view opens with realistic data.
Who is the Inventory Tracker template for?
Small retailers, online shops and makers.
Is the Inventory Tracker template free?
Yes. Sign up free, press Use this template, and a full copy is added to your workspace.
Can I change the template after I use it?
Yes. Every page, table, column and view in your copy is yours to rename, edit or delete, and the sample rows can be cleared.