Small-Business Inventory & Reorder Tracker - Excel & Sheets

A simple stock tracker for makers, resellers and small shops, built on a plain-English stock log.

What you get

• Items sheet: up to 300 SKUs with cost, sell price, supplier, reorder level and reorder quantity
• Stock Movements: up to 2,000 rows for Received, Sold, Customer return and Damaged / lost
• Automatic on-hand count, stock value at cost, retail value, margin % and an OK / Reorder / Out status
• Dashboard: tiles, a reorder list (up to 15 items, out-of-stock first) with order cost, value by category and a chart
• Setup lists for categories and suppliers, Start Here guide
• BLANK and EXAMPLE workbooks (EXAMPLE = 12 items, 24 movements)

How it works

You log each delivery, sale, return or write-off with a SKU dropdown. The sheet does the maths.

Honest limits

• Manual logging only: no barcode scanning, no store or marketplace sync
• Single location; no batch or expiry tracking
• Costs are your own figures: planning only, not accounting or tax software
• No macros or add-ins. Formulas checked in LibreOffice (0 errors); built for Excel 2010+ and Google Sheets, not tested in every Excel version