{"product_id":"warehouse-stock-and-locations-register","title":"Warehouse Stock and Locations Register","description":"\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Stock figures live in several places. Goods arrive on one sheet, orders leave on another, and the count on the shelf does not match either. Nobody has one clear view of what is on hand, what is running low or which bin is full.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of products, one of locations and one record of every stock movement. Stock on hand comes only from the Stock movements sheet plus the opening quantity you type on Products. Receiving, picking and stocktake counts are checks: they show whether each line agrees with your records and never change stock. The workbook works out stock on hand for each product and each location, then counts what needs attention 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 units on hand and stock value at the unit cost you type.\u003c\/li\u003e\n\u003cli\u003eSee products at or below the reorder level you typed, and products out of stock.\u003c\/li\u003e\n\u003cli\u003eSee negative stock, so you can find the missing receipt or the wrong SKU.\u003c\/li\u003e\n\u003cli\u003eSee units held by zone and by location, bins over capacity and bins nearly full, as a table and a bar chart.\u003c\/li\u003e\n\u003cli\u003eCheck goods in and goods out against your stock movements, and stocktake counts against your records.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (storage and fulfilment, wholesale and distribution or retail) to load suitable zone and category 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 seven export sheets repeat your records under plain field names.\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 your count and nearly-full settings.\u003c\/li\u003e\n\u003cli\u003eAdd your locations, then your products and suppliers, then every stock movement.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard each week.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Sole traders and small teams who look after their own stock and want to see what is on hand, what to reorder and where it sits.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Businesses that need warehouse management software. This is a spreadsheet: it does not send anything, place orders or connect to your email or 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, 3,000 stock movements, 300 locations, 1,000 receipt lines, 2,000 pick lines and 1,000 count lines are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eReorder shows when stock on hand is at or below the level you type. The count-again days and nearly-full percentage are your own numbers.\u003c\/li\u003e\n\u003cli\u003eUse whole units. Choose the smallest unit you count.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up business 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":48859262222541,"sku":null,"price":24.95,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_ab5a9473-b617-403a-a1a2-162e853b21a7.png?v=1795098369","url":"https:\/\/www.teleworld.online\/de-de\/products\/warehouse-stock-and-locations-register","provider":"TeleWorld Online","version":"1.0","type":"link"}