Inventory & Stock Tracker (Excel)
Never run out of your best sellers.
Log stock in and out, and the tracker keeps every product's stock level up to date, tells you what to reorder and what it'll cost, and shows what's selling. No macros.
WHAT IT DOES
• Up to 300 products and 2,000 stock moves
• Stock levels from In, Out, and Adjust (SUMIFS)
• Status: OK, Reorder, or Out of stock
• Reorder list with order quantity, supplier, and estimated cost
• Stock value at cost and retail, plus margins
• Best sellers and days of stock left
• Stock value by category
• Units sold per week chart
• Duplicate and unknown SKU checks
WHO IT'S FOR
Online shops, makers and crafters, and small retail businesses.
GOOD TO KNOW
• Works in Microsoft Excel: Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac
• Normal .xlsx file: no macros to enable
• One-off payment, instant download
Made by Lee at Sheet Leveller, whose tutorials have been watched 6.3 million times on YouTube.