{"product_id":"stock-and-inventory-tracker","title":"Stock and Inventory Tracker","description":"\u003cp\u003e\u003cstrong\u003eGeneral information only.\u003c\/strong\u003e This workbook is a record-keeping tool. It is not accounting, tax, legal or financial advice.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e You run out of the things that sell, you over-order the things that do not, and you cannot say what your stock is worth.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep a list of your products and add one line each time stock comes in or goes out. The workbook works out how much of each product you hold, what it is worth, what to reorder and how many days it will last.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee on-hand quantity for every product, worked out from your movements.\u003c\/li\u003e\n\u003cli\u003eGet a reorder list: everything at or below its reorder level, with a suggested order quantity, estimated cost and days of stock left.\u003c\/li\u003e\n\u003cli\u003eSee your stock value, the number of products at or below reorder level, how many are out of stock, and stock value by category.\u003c\/li\u003e\n\u003cli\u003eSee top sellers by units, and slow movers: stock that has not sold for a number of days you choose.\u003c\/li\u003e\n\u003cli\u003eCount the shelves on a stocktake sheet, see short and over with the value of each difference, and copy the differences into your movements.\u003c\/li\u003e\n\u003cli\u003eKeep adding movements: on-hand and sales totals read whole columns, so the list has no row limit.\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, currency symbol and product categories once.\u003c\/li\u003e\n\u003cli\u003eAdd your products, then one line per stock movement.\u003c\/li\u003e\n\u003cli\u003eWork down the reorder list, count the shelves now and then, and check the dashboard each week.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eHow stock value is worked out.\u003c\/strong\u003e Units on hand multiplied by the latest unit cost you entered on a Received line. It is not FIFO and not an average cost. Negative stock is shown in red and counts as zero value.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Small retailers, online sellers, market stallholders and cafes that want to stop running out and stop over-ordering.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Businesses that need a till or shop integration, batch or serial numbers, best-before tracking or recipes. This is a spreadsheet tracker: it does not connect to anything and does not order for you.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later (Windows or Mac). No macros, no add-ins, no subscription and no AI.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eWorks with any currency: you set the symbol.\u003c\/li\u003e\n\u003cli\u003e500 product rows and 3,000 movement lines are prepared. The movement totals read whole columns; the check and cost helper columns are extended by dragging down, and the dashboard warns you if you have gone past them.\u003c\/li\u003e\n\u003cli\u003ePosting stocktake differences is a copy and paste step you do yourself. There are no macros.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859261632717,"sku":null,"price":19.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_e2826a6d-3abe-4738-93a1-ab99602abe7b.png?v=1795093007","url":"https:\/\/www.teleworld.online\/da\/products\/stock-and-inventory-tracker","provider":"TeleWorld Online","version":"1.0","type":"link"}