Inventory Tracker Spreadsheet, Small Business Stock Control, Reorder Alerts, Inventory Management, Product Inventory, Excel Google Sheets

Inventory Tracker Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Never run out of a best seller again. Log purchases and sales, and this inventory spreadsheet keeps your stock on hand, inventory value and reorder list up to date automatically. ✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition. ★ WHAT'S INCLUDED ★ • Clickable Start Here cover page with quick-start steps and a colour key (yellow = you type) • Inventory Dashboard: stock value at cost and retail, net sales and profit for the last 30 days, items to reorder, out of stock, on order, net sales and gross margin for the year, inventory turns, days of cover, late deliveries, slow stock and overstock, plus a stock health table, reorder-now list, top 10 sellers, next deliveries, 7 automatic insights and 4 charts • Products: room for 300 SKUs with category, supplier, location, cost, sale price and starting stock. Stock on hand, on order, stock value, retail value, margin, units sold in the last 30 days, average per day, days of stock, last sale, 12-month sales and ABC class are automatic • Automatic reorder points (average daily sales x supplier lead time + safety days) or your own, a suggested order quantity and cost, and a status for every item: OK, On order, Reorder, Out, Overstock, Slow or Inactive • Stock Movements: 3,000 rows for purchases, batches you make, sales, returns, materials used, damaged stock, adjustments and samples. Pick the SKU and type from drop-downs; sales $, cost of goods and gross profit are worked out per line • Reorder List: everything that needs ordering, most urgent first, with days left, suggested quantity, estimated cost, an order-by date and a by-supplier total checked against each supplier's minimum order • Purchase Orders: 500 PO lines with expected date (from the supplier's lead time), quantity received, still to come, status (Received, Partial, Late, On order, Cancelled), days late and on-time tracking • Printable Purchase Order: pick a PO number and your details, the supplier, items, tax, shipping and total fill in. Fits one page, print or save as PDF • Suppliers: 50 suppliers with contacts, lead times, payment terms and minimum order, plus SKUs supplied, stock value, open orders, spend this year, late lines, on-time %, average actual lead time and a reliability rating • Sales Summary: month by month sales, returns, net sales, cost of goods, gross profit, margin, units in, purchases, units lost and same month last year, plus sales by category and by sales channel, with 4 charts • Inventory Valuation: stock value at cost and retail by category and by location, ABC analysis, top 10 items by value, slow movers and inventory turns, with 2 charts • Stock Count: type what is on the shelf and see the difference, value difference, match / short / over and the adjustment to log • Produc