Skip to content
Spryhand

Small Business

Inventory Tracker

Track stock levels and reorder points by SKU, with automatic inventory value and low-stock flags.

Delivery
Instant download
Purchase
One-time payment
Format
  • Google Sheets
  • Excel
Updated
August 2026
$5.90Buy on Etsy
Sample preview — illustrative data

Inventory value at cost

$318.85

Cost to reorder now

$406.80

SKUStatus
  • SKU-1042 — Signature candle6 / 15 — Reorder
  • SKU-2210 — Travel tin-5 / 10 — CHECK
  • SKU-5000 — Gift box25 / 10 — OK, never moved

Sample data preview of the Inventory Tracker spreadsheet, shown for illustration only.

What this spreadsheet does

Stock counted only when someone remembers leads to running out of popular items and overstocking slow ones.

What you can do with it

  • See current stock level and value by SKU
  • Get flagged when an item drops below its reorder point
  • Find the SKU where the log and the shelf disagree

What's included

Sheet tabs

  • Instructions
  • Inventory List
  • Stock Movement
  • Low Stock

Features

  • On hand derived from opening stock plus every logged movement, not typed in
  • Signed adjustments for breakage written off and stock found at a count
  • A negative book position flagged for a recount instead of reported as a stock level
  • Inventory value at cost and at retail, ignoring negative positions
  • Reorder point per SKU with a low-stock list and the cost of topping up
  • A count of SKUs that have never moved

How it works

  1. 1Add each SKU with unit cost, opening stock and a reorder point
  2. 2Log every movement: Received, Sold, or a signed Adjustment
  3. 3Check the Low Stock tab before placing an order

Who it's for

Small business owners managing physical product inventory.

Frequently asked questions

Does it flag low stock automatically?

Yes. Each SKU has a reorder point, and the Low Stock tab lists anything at or below it with the cost of the restock.

What is an Adjustment for?

Breakage, shrinkage, or something found at a stock count. It is signed — negative or positive — so the book can be corrected without editing history.

What if a SKU goes negative?

That means the log says you sold more than ever arrived, which is a data problem, not a stock level. It reads "CHECK — negative", is excluded from the inventory valuation, and still appears on the reorder list.

Complete the setup

The rest of the tools this one was built to sit beside.

Similar tools

The same kind of tool, for a different job.