Inventory Management Spreadsheet Template: Monitor Stock Levels, Reorder Points, and Supplier Lead Times
inventory managementstock controlreorder pointsoperationsExcelGoogle Sheets

Inventory Management Spreadsheet Template: Monitor Stock Levels, Reorder Points, and Supplier Lead Times

SSpreadsheet Top Editorial Team
2026-11-17
7 min read

Build an Excel or Google Sheets inventory tracker with stock levels, reorder points, lead times, purchase orders, and review routines.

An inventory management spreadsheet can turn scattered stock counts, purchase orders, and supplier notes into a repeatable control system. This guide shows how to build an inventory tracker in Excel or Google Sheets, calculate available inventory and reorder points, record receipts and adjustments, and identify slow-moving items before they distort purchasing decisions.

Overview

A useful inventory spreadsheet does more than list products and quantities. It should help answer four operational questions:

  • How much stock is physically on hand?
  • How much is already committed to customer orders or internal use?
  • When should the next purchase be triggered?
  • Which products, suppliers, or locations require attention?

A practical workbook can contain five sheets:

  1. SKU Master: product code, description, category, unit, supplier, cost, and storage location.
  2. Stock Ledger: receipts, shipments, returns, adjustments, dates, and references.
  3. Reorder Model: demand, supplier lead time, safety stock, reorder point, and order status.
  4. Purchase Orders: order number, supplier, order date, expected date, quantity, and receipt status.
  5. Dashboard: low-stock items, overdue deliveries, stock value, and slow-moving products.

For a small catalog, a single-sheet inventory tracker Excel file may be enough. As the number of SKUs, suppliers, or locations grows, separating master data from transactions reduces accidental overwrites and makes the calculations easier to audit. The same structure works in Google Sheets, provided that shared editing permissions and change history are managed carefully.

Keep the distinction between on-hand inventory, available inventory, and inventory position clear:

  • On hand is the quantity recorded at the location.
  • Available is usually on hand minus committed stock.
  • Inventory position is commonly on hand plus confirmed on-order stock minus committed stock.

These measures support different decisions. Available inventory helps with fulfillment; inventory position helps decide whether another order is needed.

How to estimate

The central calculation in a stock reorder spreadsheet is the reorder point. A straightforward model is:

Reorder point = average daily demand × supplier lead time in days + safety stock

Use consistent units throughout. If demand is measured in units per day, lead time must be measured in days. If demand varies substantially, calculate average daily demand from a defined period rather than entering an informal estimate.

In Excel or Google Sheets, suppose the following columns are used:

  • F2 = average daily demand
  • G2 = lead time in days
  • H2 = safety stock
  • I2 = reorder point

The formula in I2 can be:

=F2*G2+H2

To calculate available stock, if C2 is on hand and D2 is committed, use:

=C2-D2

For inventory position, if E2 is confirmed on order, use:

=C2+E2-D2

A basic reorder flag can compare inventory position with the reorder point:

=IF(J2<I2,"Reorder","Monitor")

Here, J2 represents inventory position. If your business does not count on-order stock until it has been received, compare available stock instead and document that choice in the assumptions sheet.

For a more responsive model, calculate demand from transaction history. If the Stock Ledger contains dates in column A and quantities issued in column D, you can summarize units issued by SKU and period with SUMIFS. The exact formula depends on the workbook layout, but the design principle is consistent: include only relevant outbound quantities, exclude receipts and corrections, and use a clearly labeled lookback period.

Conditional formatting can make the sheet easier to review. Apply a red fill when inventory position is below the reorder point, an amber fill when a purchase order is overdue, and a neutral highlight for items with no movement during the review period. Use labels as well as color so the workbook remains understandable when printed or viewed by someone with color-vision limitations.

Inputs and assumptions

The formulas are only as reliable as the inputs behind them. Build an assumptions area that records how each number was selected and when it was last reviewed.

Demand

Choose a consistent demand window, such as recent weeks or months, and record whether unusual promotions, seasonal peaks, or one-time orders are included. A simple average is useful for stable products. For products with changing demand, consider separate values for normal demand and peak demand, then compare the resulting reorder points in a scenario analysis spreadsheet.

Supplier lead time

Lead time should represent the interval from placing an order to receiving usable stock. If supplier processing, transit, customs, inspection, or put-away adds time, decide whether those steps belong in the lead-time input. Avoid combining different suppliers in one average if their delivery patterns differ materially.

Safety stock

Safety stock is a buffer for uncertainty in demand or delivery. It is not a substitute for accurate counts. Set it by product or product group where practical, and state whether it is a fixed quantity, a percentage of demand, or a management judgment. A small business inventory spreadsheet can start with simple fixed quantities and become more detailed as transaction history improves.

Stock status

Define how the workbook treats damaged, quarantined, reserved, returned, and consignment stock. These quantities should not silently appear available for sale. Add a status column to the ledger and use separate columns when a quantity affects fulfillment or replenishment differently.

Data controls

Use drop-down lists for SKU codes, supplier names, transaction types, and purchase-order status. Protect formula columns, freeze header rows, and include a last-counted date. Before relying on the workbook, test a receipt, shipment, return, and adjustment from start to finish. A separate spreadsheet audit checklist can help identify broken formulas and inconsistent references.

Worked examples

Assume a product has average demand of 12 units per day, a supplier lead time of 7 days, and safety stock of 30 units.

Reorder point = 12 × 7 + 30 = 114 units

The product currently has 80 units on hand, 10 units committed, and 40 units confirmed on order.

  • Available inventory: 80 − 10 = 70 units
  • Inventory position: 80 + 40 − 10 = 110 units
  • Reorder comparison: 110 is below the 114-unit reorder point

The workbook should flag the item for review. It should not automatically create a purchase order unless the business has also defined an order quantity, supplier minimum, budget limit, and approval process.

Suppose the target inventory position after replenishment is 180 units. A simple suggested order quantity would be:

Suggested order = target inventory position − current inventory position

Suggested order = 180 − 110 = 70 units

This is a planning estimate, not a universal rule. Round it to an appropriate case or pack size, and check supplier minimums and open orders before submitting it.

For slow-moving stock, add a days-since-last-movement calculation. If the last movement date is in K2, the formula =TODAY()-K2 returns elapsed days. Use a documented threshold to create a review flag, but do not automatically write off inventory based only on age. Check customer commitments, product condition, seasonality, and storage cost first.

If you manage several sites, add a location column to every transaction and SKU record. A multi-location sheet should show both total stock and location-level stock; total inventory can conceal a stockout at the location that actually needs the product.

When to recalculate

Recalculate the inventory management spreadsheet whenever an input that affects the decision changes. At minimum, review it after each stock count, receipt, shipment, return, or inventory adjustment. Update purchase-order status when an order is placed, delayed, partially received, or closed.

Review the model on a regular operating cadence as well. A weekly review may suit fast-moving products, while a monthly review may be practical for slower-moving stock. Revisit demand and lead-time assumptions when supplier performance changes, pricing inputs change, a promotion or seasonal period begins, a product is discontinued, or a new sales channel is added.

Before each review, follow this checklist:

  1. Import or enter the latest stock counts and transaction activity.
  2. Reconcile unusual differences between the ledger and physical count.
  3. Update committed quantities and open purchase orders.
  4. Recalculate demand, lead time, safety stock, and reorder points where assumptions have changed.
  5. Review low-stock, overdue-order, and slow-moving flags.
  6. Record the decisions, owner, and follow-up date in a review log.

Inventory decisions also connect to wider planning. Link expected sales volumes to a sales forecast spreadsheet, reflect large purchases in a cash flow forecast, and use a KPI dashboard to track stockouts, inventory value, supplier reliability, and aged stock. With those updates, a customizable inventory spreadsheet remains a decision tool rather than a static stock list.

Related Topics

#inventory management#stock control#reorder points#operations#Excel#Google Sheets
S

Spreadsheet Top Editorial Team

Senior SEO Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.