Small Business Inventory Tracker | 20-Sheet Excel System with Real Formulas

• ✓20 sheets: Dashboard, Inventory, Locations, Movements, Sales Orders, Returns, Purchase Orders, Stock Take, Reorder, Dead Stock, Valuation, Profit by SKU, Category Summary, Monthly Report, Price List, Suppliers, BOM, Manufacture, Settings, README
• ✓2,894 real formulas, counted cell by cell in the buyer workbook; no macros anywhere
• ✓Dashboard with live KPIs and 4 charts: inventory value, revenue, profit, margin, units purchased vs sold
• ✓Sales Orders and Returns sheets with automatic checks against the Movements log
• ✓Monthly Report: units in and out, sales value and purchase cost for every month
• ✓Locations: stock split by storage place, with value and low-stock alerts per location
• ✓Movements log with four types: Purchase, Sale, Adjustment, Manufacture
• ✓Manufacture planner: finished goods in, components consumed out, tracked per batch
• ✓Reorder alerts and dead-stock flags with LOW/OUT status chips
• ✓Works in Excel 2016+, Google Sheets, and LibreOffice; every formula uses functions all three support
• ✓Sample copy with Hearth & Wick Candle Co. data, plus a blank copy with the same formulas and no sample data
• ✓1-page quick-start guide plus a 9-page visual walkthrough PDF

Daily workflow: log every stock event in Movements. For Manufacture, add one positive row for the finished good made and one negative row per component consumed. Log customer orders on Sales Orders and returns on Returns; the check columns confirm each one against Movements. Set your business name, currency, and as-of date in Settings to make it yours in about five minutes.

Single-user license, pay once, yours forever. You may use it in commercial projects; redistribution or resale of the product itself is not permitted.