Monitor stock levels with auto-calculated daily sales velocity, reorder point, suggested order quantity, and Reorder / Watch / OK status pills. Knows which SKUs to restock and when.
What's Inside
Start Here — How velocity is calculated, what Reorder Point means, and tips on setting Safety Stock.
Inventory — One row per SKU. Current Stock, Lead Time, Safety Stock — Daily Velocity, Reorder Point, Suggested Order Qty, and Status all auto-calculated.
Sales Log — Append a row per sale. Drives the velocity calc (last 30 days).
Dashboard — Snapshot (Total SKUs, Need Reorder, Watch, Total Units, Inventory Value), "Needs Reorder Now" table with suggested quantities, Fastest-Selling column chart.
Key Features
Reorder Point = Daily Velocity × Lead Time + Safety Stock, auto-calculated per SKU.
Suggested Order Qty = Reorder Point × 2 − Current Stock — covers the next reorder cycle.
Daily Velocity computed from last 30 days of Sales Log entries.
Status pills: Reorder (red), Watch (yellow), OK (green).
"Needs Reorder Now" Dashboard table sorted by urgency.
Fastest-Selling SKUs column chart shows where to focus restock attention.
Sample Formulas
Here are some of the formulas powering this template:
Daily velocity from 30-day log
=COUNTIF('Sales Log'!A:A, A2) / 30
Reorder Point
=ROUND(F2*D2+E2, 0)
Status pill logic
=IF(C2<=G2,"Reorder",IF(C2<=G2*1.5,"Watch","OK"))
Get this template free
Enter your email and we'll give you instant access to copy this template into your Google Drive.
You're in.
Click below to copy this template into your Google Drive. Check your email for setup instructions.
We build custom inventory systems that connect Shopify, ShipStation, or your 3PL to Google Sheets — real-time stock levels, automatic reorder alerts, and purchase order generation.