Inventory Spreadsheet, Stock Tracker with Reorder List, Stock In and Out Log (Excel)

Inventory spreadsheet for a small shop: list your items once, log stock in and out, and always know what you have on hand, what to reorder and what your stock is worth.

WHAT IT DOES
- Items: SKU, item name, category, unit, supplier, unit cost, selling price, opening stock, reorder point and reorder quantity
- On hand for every item, worked out from your opening stock and every move in, out or adjusted
- Status for every item: OK, Reorder (at or below your reorder point) or Out of stock, in yellow and red
- Stock moves log: date, SKU from a drop-down, In (received), Out (sold or used) or Adjust (count correction), quantity and a reference. A SKU that isn't on your item list is flagged
- Stock value at cost and at your selling price, and the margin on every item
- Dashboard: items listed, units on hand, stock value, items to reorder and out of stock, a reorder list (out of stock first) with order quantity and cost, units in and out by month and stock value by category, with two charts
- Room for 300 items and 3,000 stock moves. Whole or decimal quantities (kg, metres) and any currency
- Reselling one-off items? Our Reseller Inventory and Profit Tracker is built for that; this one is for repeat stock with SKUs

WHAT YOU GET
- Inventory-Spreadsheet.xlsx (blank)
- Inventory-Spreadsheet-with-Sample-Data.xlsx (a filled-in example: 18 items, 9 months of stock moves)
- Quick-start guide (PDF)

HOW YOU GET IT
Digital download. Your files are available right after purchase from your Etsy Purchases page. Nothing is shipped.

COMPATIBILITY
- Microsoft Excel 2016 or newer (Windows or Mac) and Excel for the web
- Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets
- Needs a computer or tablet with a spreadsheet app. It does not connect to a store, barcode scanner or marketplace

GOOD FOR
Small shops, makers, market sellers and online stores who want simple stock control without inventory software.

PLEASE NOTE
A record-keeping tool, not accounting software. Stock value uses the unit cost you enter (a simple standard cost, not FIFO). For use in your own business; please don't resell or share the files.

DISCLAIMER
This template is a planning tool and does not replace advice from a qualified or licensed professional (such as an accountant, financial advisor or lawyer). Check the results before you rely on them. Sold as is: because this is an instant digital download, all sales are final, with no returns, exchanges or refunds. If a file is damaged or won't open, message us and we'll send you a working copy.

HOW IT WAS MADE
Designed by VARS Digital with AI-assisted tools. Every formula is checked before release, and the sample file shows each tab working.

QUESTIONS
Message us through Etsy and we'll help you get set up.