Free template
Free inventory spreadsheet template for Google Sheets and Excel
A free planning workbook for Excel and Google Sheets. List your SKUs, paste in weekly sales, and it works out safety stock, reorder points and what to order, then connects the plan to landed cost, margin and stock health.
Download the template
One workbook, 200 SKU rows and 12 weeks of sales history. It ships with ten example coffee SKUs so you can follow the calculations before replacing them with your own. No macros and no email gate.
Already tracking stock? Import it straight into Skuvelo.
What is in the workbook
- Start Here
- How to fill the sheet in, in six steps, starting with replacing the example data, and which SKU fields are required and what each blank falls back to.
- Definitions
- A built-in Definitions tab explains every term in the workbook in plain English: where it shows up, how it is worked out, and the free calculator that covers it.
- Settings
- Service level, default lead time, review period, the Watch window and the variability to assume without history. Supplier lead times and lead-time variability (standard deviation in days), a planning date, your overstock target and retail open-to-buy inputs go here too.
- SKUs
- One row per product. Only SKU and on hand are required; name, category, supplier, on order, unit cost, estimated weekly sales, lead time, case pack, MOQ, lead-time SD override, seasonal index and manual uplift are optional.
- Sales History
- Units sold per SKU per week, for up to 12 weeks.
- Planning
- Calculated for every SKU: adjusted weekly sales, demand and lead-time variability, safety stock, reorder point, weeks of supply, MOQ/case-pack quantity, EOQ reference and min/max. Protected without a password so formulas are not overwritten by accident.
- Cost Inputs and Money
- Enter price, shipment charges, duty, order cost and carrying rate. Read landed unit cost, margin, markup, carrying cost and GMROI.
- Period Inputs, Forecast History and Health
- Enter opening and closing balances and receipts for the sales-history period, plus optional forecasts made before each week. Read sell-through, average inventory, turnover, DIO, forecast accuracy, revenue ABC and overstock/dead-stock flags.
- Reorder List and Summary
- Filter items to order, with suggested order dates and calendar-day arrival dates. See the cost of that list and retail/cost open-to-buy for your chosen period. Build the PO with our free PO template.
- Dashboard
- SKUs to order now, suggested order value, units and stock value on hand, and charts by status, weekly sales and weeks of supply.
- Beyond the spreadsheet
- What the workbook cannot do, and how Skuvelo compares.
How the plan is worked out
- Average weekly sales
- The trailing mean from Sales History, or the SKU estimate if there is no history, multiplied by your manual seasonal index and uplift. The sheet does not learn seasonality.
- Lead time
- The SKU's own lead time, else its supplier's on Settings, else the default. The Planning tab shows which one it used.
- Safety stock
- Combines demand variability over the lead time plus review period with average daily demand × lead-time SD, using root-sum-of-squares and your service-level Z. It rounds up to whole units. A blank SKU lead-time SD uses the supplier's; a typed 0 switches lead-time variability off for that SKU, leaving demand variability only.
- Reorder point
- Sales over the lead time plus safety stock.
- Suggested order quantity
- Enough to cover the lead time plus the review period, plus safety stock, less stock on hand and on order. A positive need is raised to MOQ and rounded to whole case packs. Only items at or below the reorder point appear as orders to place on Reorder List.
- Status
- Order now at or below the reorder point; Watch within two weeks of sales of it; OK above that; Add sales when there is nothing to plan from; Add on hand when there are sales to plan from but on hand is blank, because a blank count is not zero.
Connected calculators
The workbook brings these public tools together for one item at a time:
- Lead time
- Safety stock
- Service level
- Reorder point
- Order quantity
- EOQ
- Min/max
- Weeks of supply
- Landed cost
- Margin
- Markup
- Carrying cost
- GMROI
- Sell-through
- Forecast accuracy
- Average inventory
- Inventory turnover
- Days inventory outstanding
- Open to buy
It also includes revenue ABC classification, a manual seasonal index and uplift, suggested reorder dates, overstock/dead-stock flags and the cost of the reorder list. ABC labels are for sorting and review; they do not change service levels.
For store-shelf replenishment, use the separate par level calculator.
Worked example
Using the safety stock calculator's example: average daily sales of 20 units, daily sales SD of 6, a 14-day lead time, lead-time SD of 3 days and a 95% service level give 106 safety-stock units and a reorder point of 386. To compare this with the workbook, use 140 weekly sales, weekly SD of 6 × the square root of 7, and a zero-day review period. With a review period, compare the calculator using lead time plus review days for safety stock, then use the actual lead time for the reorder point.
With lead-time SD at 0, the buffer covers demand variability only and uses the Z from the template's service-level table. With the template's default 7-day review period, that gives a demand-only buffer of 46 and a reorder point of 326.
Where a spreadsheet breaks
This workbook is a manual planner for one stock pool and one sales series per item. It has no live data connections, automatic learning, allocation between channels or locations, or buying decisions across products. Its cash total tells you the cost of the list; it does not choose what to buy when money is short. Adding a channel, a second location or a few hundred SKUs makes that harder each week. If your product list or supplier price list lives in a OneDrive or SharePoint workbook on a work or school account, Skuvelo imports it from there, and a linked price list re-imports every saved change. Skuvelo adds live sync, forecasts that learn your seasons and new products, cash-aware buy plans, a view across channels and locations, and alerts. When you need that connected picture, start a 14-day Skuvelo trial, no card required.
Questions
Is the inventory planning spreadsheet free?
Yes. Download the workbook without an email address or sign-up.
What is the reorder point formula in the template?
Average weekly sales over the lead time, rounded up, plus safety stock. With lead-time variability, safety stock is Z × the square root of ((lead time + review period) × weekly sales SD squared ÷ 7 + (weekly sales ÷ 7) squared × lead-time SD squared), rounded up. Lead time and its SD are in days. When lead-time SD is 0, safety stock covers demand variability only and uses the template's service-level Z table.
How is the suggested order quantity calculated?
The order quantity column calculates enough to cover sales over the lead time plus the review period, plus safety stock, less stock on hand and on order. A positive need is raised to the minimum order and rounded to whole case packs. The Reorder List selects items at or below their reorder point.
Can I use it in Google Sheets or Excel?
Yes. Open the .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets. The formulas use only functions both support, and there are no macros.
Can I start without sales history?
Enter an estimated weekly sales figure on the SKUs tab. The sheet plans from the estimate and the variability set on Settings until you add weekly sales.
Is it an inventory management spreadsheet or a forecasting template?
It plans rather than records. It tracks on hand and on order per SKU and forecasts demand over the lead time from up to 12 weeks of sales, but it does not log individual receipts or orders: paste in weekly totals.
When should I move beyond a spreadsheet?
When sales come from more than one channel, stock sits in more than one location, or purchase orders and supplier lead times change faster than someone can update the sheet.
A sheet is a starting point.
Skuvelo keeps demand, stock and supplier timing together as they change across your products.