{"product_id":"retail-shop-stock-and-sales-tracker","title":"Retail Shop Stock and Sales Tracker","description":"\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Stock counts sit in one place, sales in another, and supplier orders in your inbox. It is hard to say what is on the shelf, what has sold, what you have already ordered and what to buy next.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of products, one of stock movements, one of daily sales and one of supplier orders. The workbook works out stock on hand for every product, its value, its margin and whether it is OK, at its reorder level, out of stock or below zero, then counts it all on a dashboard.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee stock value at cost, sales over your own window, gross profit and sales so far this month.\u003c\/li\u003e\n\u003cli\u003eSee which products need ordering, with a Reorder list showing quantity, cost, supplier and stock already on order.\u003c\/li\u003e\n\u003cli\u003eSee sales and stock by category, as tables and a bar chart.\u003c\/li\u003e\n\u003cli\u003eSee open and late supplier order lines, out-of-stock products and slow sellers.\u003c\/li\u003e\n\u003cli\u003eSpot mistakes: a SKU typed wrongly, a duplicate SKU or stock below zero is flagged.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (retail, food and beverage or hospitality) to load suitable lists, then edit them to suit you.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and five export sheets repeat your products, stock movements, sales, supplier orders and suppliers under plain field names.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow stock changes\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eEvery row you type on Daily sales reduces stock on hand by itself.\u003c\/li\u003e\n\u003cli\u003eA supplier order marked Received does not add stock by itself. When a delivery arrives, you record an In movement on the Stock movements sheet.\u003c\/li\u003e\n\u003cli\u003eUse Out for stock that leaves without a sale, and Adjust for a correction after a count.\u003c\/li\u003e\n\u003cli\u003eReorder means stock is at or below the reorder level you typed. A product with no level typed is never marked Reorder.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your business name, choose your industry and type the days your sales window covers.\u003c\/li\u003e\n\u003cli\u003eAdd your products with an opening quantity, then record movements, sales and supplier orders.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard and the Reorder list each week.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Sole traders and small retailers who keep their own stock and want to see what is on hand, what has sold and what to reorder at a glance.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Businesses that need stock-control or point-of-sale software that takes payments, counts stock for you or sends orders to suppliers. This is a spreadsheet: you type the records, and it does not send anything or connect to other software.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e500 products, 2,000 movements, 3,000 sales and 500 supplier order lines are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eThe sales window, the reorder levels and the lead times are your own numbers. Nothing is a built-in rule.\u003c\/li\u003e\n\u003cli\u003eProfit counts a product with no unit cost as zero cost, so type a cost for every product.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up shop shows every sheet working before you start.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eUse this template to capture and improve your business data now. In future you can automate with AI.\u003c\/li\u003e\n\u003cli\u003eGeneral information only. It is not accounting, tax, legal or financial advice.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262124237,"sku":null,"price":29.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_15bb9a94-14bc-40df-89e2-49285fab26eb.png?v=1795098809","url":"https:\/\/www.teleworld.online\/fil\/products\/retail-shop-stock-and-sales-tracker","provider":"TeleWorld Online","version":"1.0","type":"link"}