Inventory report template: days of stock and when to reorder
Short answer
An inventory report shows, for each product, how much is on hand, how fast it sells, how many days of stock are left and when to reorder. Reorder when stock falls below the daily sell rate times the supplier's lead time plus a few safety days. Products with over 90 days of stock tie up cash.
What this report answers
What runs out before the next shipment can arrive?
What should I reorder this week?
Which products tie up cash on the shelf?
Every number and how it's computed
| Number | Formula |
|---|---|
| Sold per day | Units sold in the last 28 days ÷ 28 |
| Days of stock | On hand ÷ sold per day |
| Reorder point | Sold per day × (lead time + safety days) |
| Status | Reorder below the reorder point; slow mover above 90 days of stock |
| Sell-through | Units sold ÷ (units sold + on hand) |
A filled-in example
| Product | On hand | Sold per day | Days of stock | Reorder point | Status | Sell-through |
|---|---|---|---|---|---|---|
| Whole bean coffee, 12 oz | 420 | 30 | 14 | 840 | Reorder | 66.7% |
| Ground coffee, 12 oz | 610 | 18 | 34 | 504 | OK | 45.2% |
| Cold brew packs, 6-pack | 95 | 10 | 10 | 210 | Reorder | 74.7% |
| Ceramic mug | 380 | 4 | 95 | 148 | Slow mover | 22.8% |
| Pour-over dripper | 60 | 2 | 30 | 74 | Reorder | 48.3% |
| Paper filters, 100 | 900 | 7 | 129 | 147 | Slow mover | 17.9% |
The cold brew packs run out in 10 days
Cold brew packs, 6-pack
10 days
Whole bean coffee, 12 oz
14 days
Pour-over dripper
30 days
Ground coffee, 12 oz
34 days
Ceramic mug
95 days
Paper filters, 100
129 days
Free template, formulas included
A CSV for Google Sheets, Excel or Numbers, with the example numbers filled in.
Fill it in with your numbers
Pull stock on hand
In Shopify, open Analytics, then Reports, filter to Inventory, and open Inventory remaining per product. Step-by-step guide
Pull units sold
Products by sell-through rate gives units sold; set the range to the last 28 days.
Add lead times
Ask each supplier how many days an order takes to arrive, then add your safety days.
Get weekly sales beside your stock check
Replo doesn't read Shopify inventory yet, so keep this sheet for stock. Replo can email the week's sales and ad results every Monday, so a spike shows up early.
“every Monday at 8am, send last week's sales against the week before”
Replo sends today
Total sales against last week
Ad spend and ROAS by ad
Emailed to up to 10 teammates
Not yet
Shopify inventory and stock levels
Reorder alerts by product
Frequently asked questions
- How do I calculate a reorder point?
- Multiply how many units you sell per day by the supplier's lead time in days plus your safety days. Selling 10 a day with a 14-day lead time and 7 safety days gives a reorder point of 210 units.
- What is a good sell-through rate?
- It depends on how often you restock. Over a 28-day window, a product that sold half its available stock is moving well; under 20% usually means too much stock or a product that needs a better page or price.
- Can Replo send an inventory report?
- No, not yet. Replo doesn't read Shopify inventory, so use this sheet or Shopify's inventory reports. Replo can email your weekly sales and ad results, which shows a demand spike before stock runs out.
More report templates
All report templatesReport template
Weekly sales report
This week against last week, from net sales down to ad spend.
Report template
Sales dashboard and KPI report
Nine store KPIs each month, beside target and the median store.
Report template
Daily sales report
Yesterday against the same weekday last week, plus ads that sold nothing.
