Inventory Spreadsheet

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. After checkout you get a download page right away, plus a receipt by email. 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.

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

Email varsdigitals@gmail.com and we'll help you get set up.