Inventory Spreadsheet

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

• XLSXInventory-Spreadsheet.xlsx (blank)
• XLSXInventory-Spreadsheet-with-Sample-Data.xlsx (a filled-in example: 18 items, 9 months of stock moves)
• PDFQuick-start guide (PDF)

Good for

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