Skip to content
Back to retail resourcesFREE TEMPLATE

Inventory spreadsheet template

Know what came in. What sold. And what’s ready to reorder.
Start with a simple spreadsheet you can make your own.

Cartons staged outside yellow warehouse loading doors.

A little structure for your everyday stocktake.

Keep a product list, record incoming stock and log sales in one workbook. The connected sheets calculate quantities and highlight items at or below your reorder point.

  • Editable inputs are clearly marked in amber.
  • Missing entries and duplicate IDs are flagged.
  • Includes fictional examples to help you get started.

INSIDE THE WORKBOOK

Three sheets that work together.

Begin with your opening stock count. Add completed purchases and sales from that point forward.

01

Inventory

Add your SKUs, opening quantities, reorder points and unit costs. See received units, sold units and the resulting stock on hand.

02

Purchases

Record each completed receipt with a unique entry ID, date, SKU, quantity and unit cost. Include a supplier or purchase-order reference.

03

Sales

Enter completed sales with the same SKU used in Inventory. Quantities feed the stock calculation; unit prices calculate each line’s sales value.

Preview of the Inventory sheet with three fictional items, 32 units on hand and a stock value of $135.50
Actual template preview with fictional sample entries. Open full preview (opens in a new tab)

MAKE IT YOUR OWN

From download to your first count.

Get the template

  1. Save a working copy.

    Open the .xlsx workbook in your spreadsheet app. Keep an untouched copy, then replace the amber sample cells across all three sheets.

  2. Set your starting point.

    Use a consistent, unique SKU for each item and enter a physical opening count. The template has room for 100 items, 200 purchase entries and 200 sales entries.

  3. Record activity once.

    Log completed receipts and sales after the opening count, using whole units and unique entry IDs. “Check” messages identify entries that need attention before you use the totals.

  4. Review and reorder.

    On hand equals opening units plus received units minus sold units. Stock value uses your entered unit cost in USD. Reconcile the sheet with your physical count.

Designed for a simple stock log.

This is a manual workbook with prepared rows. It does not sync with your POS or calculate returns, write-offs, tax or accounting cost layers.

More resources for your store

Showing 3 of 3 more resources for your store