{"product_id":"wholesale-orders-and-stock-tracker","title":"Wholesale Orders and Stock Tracker","description":"\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Orders sit in one place, stock counts in another, and customer prices in a third. It is hard to see which orders are late, how much you really have available, or what to reorder before you run out.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of products, one of trade customers, one of orders and their lines, and one of stock movements. The workbook works out each customer's tier price, each order's total and days late, and each product's stock on hand, available stock and stock value at cost, then counts them 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 outstanding orders, overdue orders and orders due soon, with their value, by status as a table and a chart.\u003c\/li\u003e\n\u003cli\u003eSee stock on hand, stock available after open orders, and stock value at cost, by category.\u003c\/li\u003e\n\u003cli\u003eSee which products are at or below the reorder level you typed.\u003c\/li\u003e\n\u003cli\u003ePrice each order line from the customer's price tier, with an override or a line discount when you need one.\u003c\/li\u003e\n\u003cli\u003eCheck each customer's open order value against a credit limit you typed. It is a prompt for you: nothing is blocked.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (food and beverage, packaging and supplies, or retail) 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 six 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 price tiers and due-soon window.\u003c\/li\u003e\n\u003cli\u003eAdd your suppliers, products and trade customers.\u003c\/li\u003e\n\u003cli\u003eAdd your orders and their lines, and record stock coming in, going out and corrections.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard and the outstanding orders each day.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Sole traders, small wholesalers and small teams who take trade orders and hold stock, and want to see late orders, stock and reorders at a glance.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Businesses that need accounting, invoicing or warehouse software. This is a spreadsheet: it does not take payments, raise invoices, send alerts, or connect to accounting software, couriers or any other system.\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\u003eOrders do not change stock by themselves. When you send the goods, record an Out movement on the Stock movements sheet, then set the order to Dispatched.\u003c\/li\u003e\n\u003cli\u003eA product is flagged for reorder when its stock on hand is at or below the reorder level you typed.\u003c\/li\u003e\n\u003cli\u003eNothing connects to accounting software or couriers. You type your records in.\u003c\/li\u003e\n\u003cli\u003e1,000 order rows, 2,000 order lines, 2,500 stock movements and 500 products are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003ePrice tiers, the due-soon window and reorder levels are your own numbers, typed in the workbook. Nothing is a built-in rule.\u003c\/li\u003e\n\u003cli\u003eNo tax is added or worked out. Amounts are in whatever currency you use.\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":48859262157005,"sku":null,"price":39.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_d23d77ff-7ead-4443-bade-a10fd1d8abeb.png?v=1795098684","url":"https:\/\/www.teleworld.online\/da\/products\/wholesale-orders-and-stock-tracker","provider":"TeleWorld Online","version":"1.0","type":"link"}