{"product_id":"purchase-orders-and-supplier-register","title":"Purchase Orders and Supplier Register","description":"\u003cp\u003eSupplier contact names, emails and phone numbers can be personal information. Keep your copy private and share it only with people who need it.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Supplier details sit in one file, orders in emails and quantities received in someone's head. Nobody has one clear view of what is still to come, which deliveries are late or how much has been ordered from each supplier.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of suppliers, one of purchase orders and one of the lines on each order. You type the quantity received as goods arrive. The workbook works out the value of each order, what is still to come, which deliveries are late and how much you have ordered from each supplier.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee open orders, the value still to come and how many deliveries are late.\u003c\/li\u003e\n\u003cli\u003eSee lines that have arrived in part, and orders arriving within a window of days you choose.\u003c\/li\u003e\n\u003cli\u003eSee orders by status, as a table and a bar chart.\u003c\/li\u003e\n\u003cli\u003eSee ordered and outstanding value for each supplier, and a list of late deliveries with days late.\u003c\/li\u003e\n\u003cli\u003eType your own order statuses and choose whether each counts as Open, Closed or Cancelled. Nothing is built in as a rule.\u003c\/li\u003e\n\u003cli\u003eType a default lead time, and an optional lead time for each supplier, to work out an expected date when you have none.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (retail, wholesale and distribution, or trades) to load a suitable supplier type list, then edit it to suit you.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and three export sheets repeat your suppliers, purchase orders and order lines 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 order statuses and lead time on Settings.\u003c\/li\u003e\n\u003cli\u003eAdd your suppliers, then your purchase orders and their order lines.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Shops, wholesalers, tradespeople and small teams who order from suppliers and want to see what is on order, what is late and what has been spent, in one place.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Businesses that need orders sent to suppliers, approvals or reminders. This is a spreadsheet: it does not send anything or connect to your email or calendar.\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\u003e300 suppliers, 1,000 purchase orders and 3,000 order lines are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eAmounts are plain numbers in your own currency. No tax is calculated.\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\u003eThis workbook is a record-keeping tool and general information only. It is not accounting, tax, legal or financial advice. General 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":48859262615757,"sku":null,"price":36.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_a00a2306-2c2b-4117-9d2c-3286a7b7cde0.png?v=1795096753","url":"https:\/\/www.teleworld.online\/en-ca\/products\/purchase-orders-and-supplier-register","provider":"TeleWorld Online","version":"1.0","type":"link"}