{"product_id":"client-crm-sales-pipeline-tracker","title":"Client CRM Tracker Spreadsheet","description":"\u003cp\u003eThis client CRM tracker keeps every live opportunity, its odds and the next thing to do in one sheet, with your books underneath. It suits consultants, service businesses and anyone who wants a freelance CRM without a monthly subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eA pipeline you can plan against\u003c\/h2\u003e\u003cp\u003eEach opportunity has a value and the odds you give it, and the two are multiplied. A 118,000 project at 30% shows as 35,400 of pipeline, which is the number you can actually plan against. Every row also carries the one thing to do next.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003ePipeline: 40 live deals, weighted by the odds you set\u003c\/li\u003e\n\u003cli\u003eA next step on every row, and what closes inside 30 days\u003c\/li\u003e\n\u003cli\u003eValue and weighted value by stage\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThe books underneath\u003c\/h2\u003e\u003cp\u003eThe whole bookkeeping engine sits below: clients, income, expenses, invoices, monthly and quarterly views, profit and loss and a year-on-year comparison, all reading two registers. So client management and the money side live in the same file, and the invoice tracker reads the same ledger as the reports.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e1,000 ledger rows, with two years of demo data in the filled copy\u003c\/li\u003e\n\u003cli\u003eProfit and loss by category, with monthly and quarterly views\u003c\/li\u003e\n\u003cli\u003eA custom date range, and a year-on-year comparison\u003c\/li\u003e\n\u003cli\u003eEvery figure calculated: totals, margins and percentages\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers, not pictures\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eFifteen connected tabs\u003c\/h2\u003e\u003cp\u003eEverything recalculates from two registers, money in and money out. Nothing is typed twice, and there are no pivot tables to refresh. The sales pipeline and the bookkeeping never disagree because they read the same rows.\u003c\/p\u003e\u003cp\u003eYou get a filled-in copy with two full years already entered, so you can click through it working, and a blank ready for your own numbers, in Excel and Google Sheets. There are no dynamic arrays, no macros and no add-ins, and the Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros, no subscription and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The Start Here tab walks you through setup in a few minutes. The files are for use in your own business; please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. You get Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make Google Sheets copies with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow is the weighted pipeline calculated?\u003c\/h3\u003e\u003cp\u003eEach opportunity's value is multiplied by the odds you give it, and the totals are shown by stage and for deals closing inside 30 days.\u003c\/p\u003e\u003ch3\u003eCan I note the next step for each client?\u003c\/h3\u003e\u003cp\u003eYes. Every row in the pipeline has a next-step column.\u003c\/p\u003e\u003ch3\u003eDoes it include invoices and bookkeeping?\u003c\/h3\u003e\u003cp\u003eYes. Clients, income, expenses, invoices, monthly and quarterly views, profit and loss and a year-on-year comparison are all included.\u003c\/p\u003e\u003ch3\u003eHow much can it hold?\u003c\/h3\u003e\u003cp\u003e40 live deals in the pipeline and 1,000 ledger rows.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864206430,"sku":"OPX-073","price":25.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/client-crm-sales-pipeline-tracker-01.jpg?v=1790832344","url":"https:\/\/opxviashop.com\/products\/client-crm-sales-pipeline-tracker","provider":"OPXVIA","version":"1.0","type":"link"}