Product Line P&L — Margin Per SKU With Slow-Mover Flags | Excel Template

An Excel workbook that tells you what each product actually earns and which ones have stopped moving.

Enter your products once, log your sales, and it works out net revenue, true gross margin, channel fees, allocated overhead and net profit for every SKU. It then rates each one — Star, Core, Watch, Slow or Dead — against four rules you set yourself: days since last sale, minimum units, months of stock cover, and a margin floor. Every flagged SKU comes with the reason and a suggested action.

Eight sheets: Start, Settings, Products (200 SKUs), Sales (1,500 pre-wired rows), SKU P&L (23 calculated columns), Line P&L, Dashboard and Terms. Opens on the dashboard with ten KPI cards, your best and weakest SKUs by net profit, and the slow-mover watchlist ranked by the cash sitting in dead stock.

Formula-driven — no macros, no add-ins, no subscription, works offline. Excel, Google Sheets, LibreOffice or Numbers. Instant download.

By downloading this product you agree to the accompanying Terms of Use.