{"product_id":"sales-pipeline-and-crm","title":"Sales Pipeline and CRM","description":"\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Enquiries arrive by phone, email and word of mouth. Details end up in inboxes, notebooks and memory, and nobody has one clear view of which deals are open, what they are worth or who is due a call back.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of contacts, one of deals and one of follow-ups. The workbook works out each deal's win chance from its stage, adds up open and weighted value, counts deals by stage, and shows which follow-ups are overdue.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee how many deals are open, their total value, and their value once each stage's win chance is counted.\u003c\/li\u003e\n\u003cli\u003eSee the value won this month.\u003c\/li\u003e\n\u003cli\u003eSee open deals by stage, as a table and a bar chart.\u003c\/li\u003e\n\u003cli\u003eSee which follow-ups are overdue, planned or done, and the minutes you have logged.\u003c\/li\u003e\n\u003cli\u003eSee how your contacts divide by status: new, contacted, qualified, customer or lost.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (home services, professional services or retail) to load suitable lists of lead sources, pipeline stages and call outcomes, 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 three export sheets repeat your contacts, deals and follow-ups 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 and currency symbol, choose your industry, and check the win chance for each stage.\u003c\/li\u003e\n\u003cli\u003eAdd your contacts, then one row per deal and one per call, email or meeting.\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, freelancers, trades and small businesses that win work through enquiries, quotes and proposals and keep track of them by hand.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Teams that already work in CRM software, or that need emails, calls or calendars logged automatically. This is a spreadsheet: it does not connect to your email, phone or calendar, and it does not send anything for you.\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\u003eWorks with any currency: you set the symbol on the Settings sheet.\u003c\/li\u003e\n\u003cli\u003e1,000 contact rows, 500 deal rows and 1,000 follow-up rows are ready, and you can add more by dragging the last row down.\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":48859261763789,"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_bb1206f9-07ad-4cc5-9745-3b0b8a85c186.png?v=1795100174","url":"https:\/\/www.teleworld.online\/vi\/products\/sales-pipeline-and-crm","provider":"TeleWorld Online","version":"1.0","type":"link"}