Title card reading Inventory Reorder Tracker under a laptop showing the Dashboard tab with SKU, stock value and reorder cards.
  • Title card reading Inventory Reorder Tracker under a laptop showing the Dashboard tab with SKU, stock value and reorder cards.
  • The Dashboard tab with cards for SKUs, units on hand, stock value and cost to reorder, a stock value by category chart and a top 10 table.
  • The Items tab with one row per SKU: supplier, unit cost, reorder point and quantity in yellow, then in, out, on hand, value and status in gray.
  • The Reorder List tab with two cards and a table of two SKUs needing reorder, showing supplier, on hand, order quantity and cost.
  • The Movements tab: dated rows with SKU, In, Out, a Sales note, item name and a Check column reading OK.
  • The Setup tab with business name, as-of date, days of use to measure and a list of eight categories.
  • A card listing the Example and Blank .xlsx files and the tabs Start Here, Setup, Items, Movements, Reorder List and Dashboard with row limits.
  • A card describing how the file was tested: six sets of test data recalculated in LibreOffice and compared with Python, with no differences found.

Inventory Spreadsheet

A small shop that counts stock by SKU can see what is running low without a manual tally. List each SKU on the Items tab with its cost per unit, starting count, reorder point and reorder quantity. When stock moves, add a row on the Movements tab and pick the SKU from a drop-down. On hand, stock value and a status of OK, Reorder, Out of stock or Negative are worked out for you. The Reorder List tab collects each SKU that has dropped to its reorder point or below, with supplier, order quantity and cost. The reorder points are your own numbers, and the file never suggests any. It keeps one count per SKU, so it does not cover several locations. The Example file is stocked with 20 made-up SKUs. The Blank file starts empty.

$5.99 on Etsy

From our listing records. Etsy shows the current price and your local currency at checkout.

Buy on Etsy

An .xlsx file with ordinary formulas and no macros. A script recalculated it in Excel for Mac and LibreOffice. Excel for Windows and Google Sheets have not been tried.

Instant download from Etsy · nothing shipped

What's included

  • Inventory-Reorder-Tracker-Example.xlsx, filled in with made-up SKUs
  • Inventory-Reorder-Tracker-Blank.xlsx, for your own stock
A card listing the Example and Blank .xlsx files and the tabs Start Here, Setup, Items, Movements, Reorder List and Dashboard with row limits.

How it works

  1. The Dashboard tab with cards for SKUs, units on hand, stock value and cost to reorder, a stock value by category chart and a top 10 table.
    Read the Dashboard Cards show SKUs, units on hand, stock value at cost and cost to reorder. Stock value by category has a chart. The numbers are made up.
  2. The Items tab with one row per SKU: supplier, unit cost, reorder point and quantity in yellow, then in, out, on hand, value and status in gray.
    List each SKU One row per SKU. You set the reorder point and quantity. On hand, value, status and days of cover are worked out.
  3. The Reorder List tab with two cards and a table of two SKUs needing reorder, showing supplier, on hand, order quantity and cost.
    Use the reorder list Every SKU at or under its reorder point appears with supplier, order quantity and order cost, and a total cost at the top.
  4. The Movements tab: dated rows with SKU, In, Out, a Sales note, item name and a Check column reading OK.
    Log stock moves Date, SKU, quantity in or out and a note. The Check column flags an unknown SKU or a row with no quantity.
  5. The Setup tab with business name, as-of date, days of use to measure and a list of eight categories.
    Set the days Setup holds the as-of date and the number of days used to measure use and days of cover, plus your category list.

Compatibility and file formats

An .xlsx workbook with ordinary formulas. No macros and no add-ins. A script recalculated it in LibreOffice 26.8 and compared the results with a separate Python calculation. Another script confirmed it uses no LAMBDA, LET, XLOOKUP or spill formulas. A script also opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation: every cell matched the values stored in the file, with no error cells. That test did not type new data into Excel or look at the screen. Excel for Windows and Google Sheets have not been tried.

Instant download from Etsy · nothing shipped.

Video

Questions

Can it track more than one location?

No. It keeps one count per SKU.

How is stock value worked out?

On hand times the one unit cost on the Items tab. It does not do FIFO or average costing, so it is not an accounting valuation.

What if I leave Reorder qty blank?

The order quantity brings the SKU back up to its reorder point.

How do I correct a count?

Add a movement for the difference and write Count in the note.

This file adds up what you type. Reorder points are your own numbers. License: for your personal use only. No resale or sharing of this file. AI helped write the listing text, the how-to text and the code that builds this file. Scripts tested: on hand, stock value, status, days of cover, the Reorder List and the Dashboard, on 6 sets of test data including stock exactly at the reorder point, zero and negative counts, a duplicate SKU, unknown SKUs, more lines than the list holds and full tables of 300 SKUs and 2,000 movements. No person is claimed to have checked it unless stated here.