Early accessOnboarding sellers in waves — join now
dashcaptain
Free Google Sheets templateFree

Free Inventory Spreadsheet Template with Reorder Points (Google Sheets)

Stockouts don't announce themselves — they arrive on the day the maths already predicted. This template tracks the six numbers that predict them per SKU, and when connected to Dash Captain the runway maths (days of stock left at your sales rate, against your supplier lead time) runs continuously.

Copy it free into your own Google account and use it standalone, or connect it read-only and let the dashboard watch your stock for you.

Inventory & reorder tracker

Copies straight into your Google account. Yours forever, no signup.

Download the CSV

Import it into Google Sheets. Free, no signup.

What it tracks

SKU
Your product identifier — one row per SKU.
Product
A human name so the dashboard reads well.
Units on hand
Current sellable stock.
Reorder point
The level at which you reorder — powers the flags.
Units sold / day
Average daily sales rate — powers the runway.
Lead time (days)
How long a resupply takes door to door.

Then it comes alive

Connect your copy to Dash Captain (read-only, only the files you pick) and these tiles run live — Dash Captain watches them like any other source:

  • Inventory Pulse — Units on hand, SKUs below reorder point and your earliest runout.
  • Stock Runway — Days of stock left per SKU, soonest first, with reorder-now flags.

Live connection is rolling out through early access — the sheet already works on its own today.

Frequently asked questions

Is the template really free?

Yes — the copy link gives you the sheet outright, no signup. Connecting it to a live dashboard is what Dash Captain adds.

How is the runway calculated?

Units on hand ÷ units sold per day, per SKU. A SKU is flagged "reorder now" when it's under its reorder point, or when its runway is shorter than its lead time.

Do my edits break the dashboard?

No — that's the point of the template. Structure lives in named ranges and headers; you edit values. A broken row is skipped and reported, never silently wrong.