Full-funnel B2B CRM linking accounts, leads, opportunities and tasks, with weighted pipeline and overdue-task tracking.
A sales CRM template is a ready-made database that keeps the companies you sell to, the people you talk to, the deals you are working and the follow-ups you owe in linked tables, so the whole pipeline can be seen and totalled in one place.
Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.
Category
Tables
Accounts, Leads, Opportunities, Tasks
Fields
41
Views
grid, kanban, form, calendar, dashboard
Updated
2026-11-19
The 4 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.
12 fields · 4 sample rows
| AccountText | IndustrySingle select | SizeSingle select | TierSingle select | WebsiteURL | CountryText | Account ownerText | LeadsLink to another table | OpportunitiesLink to another table | Open dealsCount | Pipeline valueRollup | Weighted pipelineRollup |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Zenith Logistics | Logistics | 1000+ | Strategic | https://zenithlogistics.in | India | Priya Sharma | Vikram Joshi | Zenith — fleet tracking rollout, Zenith — analytics add-on | 2 | ₹50,00,000 | ₹30,20,000 |
| NovaPay | Fintech | 201–1000 | Growth | https://novapay.io | Singapore | Alex Turner | Mei Tan | NovaPay — support desk seats | 1 | ₹18,00,000 | ₹9,00,000 |
| FreshCart | Retail | 51–200 | Standard | https://freshcart.in | India | Priya Sharma | Rohan Kapoor | FreshCart — starter plan | 1 | ₹3,60,000 | ₹90,000 |
| MediLink Health | Healthcare | 201–1000 | Growth | https://medilink.ae | UAE | Alex Turner | Omar Haddad | MediLink — pilot | 1 | ₹9,50,000 | ₹9,50,000 |
10 fields · 5 sample rows
| LeadText | AccountLink to another table | TitleText | EmailEmail | PhonePhone | SourceSingle select | StatusSingle select | Fit scoreRating | CreatedDate | Age (days)Formula |
|---|---|---|---|---|---|---|---|---|---|
| Vikram Joshi | Zenith Logistics | VP Operations | [email protected] | +91 98201 33445 | Trade show | Qualified | 5/5 | 15 Oct 2026 | 35 |
| Mei Tan | NovaPay | Head of Customer Success | [email protected] | Qualified | 4/5 | 29 Oct 2026 | 21 | ||
| Rohan Kapoor | FreshCart | Founder | [email protected] | +91 99100 22110 | Website | Working | 3/5 | 10 Nov 2026 | 9 |
| Omar Haddad | MediLink Health | CIO | [email protected] | Referral | Nurturing | 4/5 | 30 Sep 2026 | 50 | |
| Jenny Park | Ops Manager | [email protected] | Google Ads | New | 2/5 | 18 Nov 2026 | 1 |
Form view “Request a demo” asks for: Lead, Title, Email, Phone.
12 fields · 5 sample rows
| OpportunityText | AccountLink to another table | StageSingle select | AmountCurrency | ProbabilityPercent | WeightedFormula | Close dateDate | Days to closeFormula | OwnerText | Next stepText | TasksLink to another table | Open tasksCount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Zenith — fleet tracking rollout | Zenith Logistics | Negotiation | ₹42,00,000 | 70% | ₹29,40,000 | 7 Dec 2026 | 18 | Priya Sharma | Legal review of MSA | Send redlined MSA | 1 |
| NovaPay — support desk seats | NovaPay | Proposal | ₹18,00,000 | 50% | ₹9,00,000 | 19 Dec 2026 | 30 | Alex Turner | Pricing call with CFO | CFO pricing call | 1 |
| FreshCart — starter plan | FreshCart | Discovery | ₹3,60,000 | 25% | ₹90,000 | 3 Jan 2027 | 45 | Priya Sharma | Discovery workshop | 1 | |
| MediLink — pilot | MediLink Health | Closed won | ₹9,50,000 | 100% | ₹9,50,000 | 7 Nov 2026 | -12 | Alex Turner | Kick-off & onboarding | 1 | |
| Zenith — analytics add-on | Zenith Logistics | Prospecting | ₹8,00,000 | 10% | ₹80,000 | 2 Feb 2027 | 75 | Priya Sharma | Product demo for ops leads | 1 |
7 fields · 5 sample rows
| TaskText | OpportunityLink to another table | TypeSingle select | DueDate | OwnerText | DoneCheckbox | OverdueFormula |
|---|---|---|---|---|---|---|
| Send redlined MSA | Zenith — fleet tracking rollout | 20 Nov 2026 | Priya Sharma | |||
| CFO pricing call | NovaPay — support desk seats | Call | 22 Nov 2026 | Alex Turner | ||
| Discovery workshop | FreshCart — starter plan | Meeting | 17 Nov 2026 | Priya Sharma | Overdue | |
| Kick-off & onboarding | MediLink — pilot | Meeting | 11 Nov 2026 | Alex Turner | Yes | |
| Product demo for ops leads | Zenith — analytics add-on | Demo | 28 Nov 2026 | Priya Sharma |
One row per company, so several leads and deals at the same customer stay together. Industry, Size and Tier are select fields you can filter and group by, and Open deals, Pipeline value and Weighted pipeline are counted and summed from the linked opportunities, so nobody has to add them up by hand.
Source records where each lead came from (Website, Referral, Instagram, LinkedIn, Google Ads, Walk-in, Trade show or Cold outreach), so you can see which channels bring qualified buyers. Status moves from New to Working, Nurturing, Qualified or Disqualified, and the Lead board groups leads by it. Fit score is a 1 to 5 rating for quick prioritisation.
A formula counts the days since the Created date. Sorting by it shows leads that have been waiting too long for a first call, which is where most small teams lose deals.
Each deal carries an amount in rupees and a probability; Weighted multiplies the two. Summed on the account and on the forecast dashboard, the weighted figure is a more honest forecast than the total of every open deal.
Days to close counts down to the expected close date, the Close dates calendar lays deals out by month, and Next step keeps the one action that moves the deal forward visible on the grid.
Calls, emails, meetings, demos and follow-ups are linked to their opportunity, and the opportunity counts its open tasks. The Overdue formula marks any task that is not done and past its due date, so the My tasks view doubles as a daily follow-up list.
This sales CRM template is a four-table base for B2B selling. Accounts holds each company with its industry, size band, tier, website, country and account owner, and rolls up the pipeline value and weighted pipeline of every opportunity linked to it. Leads holds the people at those companies with their title, email, phone, source, status and a fit score, and a formula shows how many days old each lead is. Opportunities tracks each deal through six stages from Prospecting to Closed won or Closed lost, with an amount in rupees, a probability, a weighted value worked out as amount times probability, a close date and a countdown of days to close. Tasks keeps the calls, emails, meetings, demos and follow-ups attached to each deal and flags anything past its due date as Overdue. Views include a lead board, a deal board, a close-dates calendar, a forecast dashboard and a Request a demo form that adds new leads.
It suits founders and small sales teams selling to other businesses, such as SaaS companies, IT services firms, agencies, distributors and manufacturers, that have outgrown a shared Excel sheet but do not want a heavy CRM. Indian teams can use it as it is: amounts are in INR with lakh and crore grouping, and the lead sources include Instagram, LinkedIn, Google Ads, walk-ins and trade shows. Sales managers get the weighted forecast and per-account pipeline without building formulas, and each rep can filter My tasks by their own name.
Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base, with its sample accounts and deals, into your workspace.
Edit the select options to match how you sell: your industries and size bands in Accounts, your lead sources in Leads and your deal stages in Opportunities.
Delete the sample rows, then import your existing contacts or deals from a CSV or Excel (.xlsx) file into the Leads and Opportunities tables and link each one to its account.
Share the Request a demo form on your website so enquiries land in Leads with their name, title, email and phone, and work them from the Lead board.
Review the Forecast dashboard and Close dates calendar every week, update each opportunity's stage and probability, and tick off tasks as they are done.
Track deals from lead to won or lost with value and company on every card.
7 columns · 7 sample cardsEdesy FormsLead Capture FormCapture enquiries with a lead capture form: contact details, what they are interested in, budget and timing.
10 questionsEdesy FlowSales Pipeline Management WorkflowInbound leads are scored and either put through a staged pipeline — meeting, opportunity work, proposal and negotiation — or enrolled in a Mailchimp campaign and re-evaluated later.
9 steps · 2 rolesEdesy AgentsSales AgentQualifies inbound interest around the clock: learns what the prospect needs, shares the right product information, captures budget and timeline, and books a call with your sales team.
Lead Generation · 3 actionsYes. Amounts are in INR and display in lakhs and crores, the sample accounts include Indian and international customers, and the lead sources cover the channels Indian B2B teams commonly use, such as Instagram, LinkedIn, Google Ads, walk-ins and trade shows. Change any option to suit your market.
Each opportunity's Weighted field is its Amount multiplied by its Probability. The Accounts table sums Weighted across the account's linked opportunities, and the Forecast dashboard totals it across the pipeline, so a ₹10 lakh deal at 50 percent counts as ₹5 lakh.
Yes. The Leads table has a Request a demo form view that asks for the lead's name, title, email and phone. Share its link or embed it on your site and every submission becomes a new lead row.
Yes. Save your sheet as .xlsx or .csv and import it into the Leads or Opportunities table; you map the columns to the template's fields. Link each imported row to its account afterwards so the rollups work.
Yes, with an automation. Trigger it when an opportunity is updated or matches a filter such as Stage is Closed won, and have it post a message to a connected Slack channel, call a webhook or create a follow-up task.
Every member of the workspace can open the base, with a role of owner, admin, editor, commenter or viewer. For a personal list, filter the My tasks or Pipeline view by the Owner field and save it as your own view.
Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.
Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.
Keep your congregation, giving, small groups and events connected, so pastors and coordinators see each member’s involvement at a glance.
4 tables · 37 fieldsClient Database TemplateA clean client register with every call, email and meeting logged against it, so you always know who is due a follow-up.
2 tables · 23 fieldsLightweight CRMOne tab, one pipeline: capture leads from a form, drag them through stages and see weighted pipeline value without CRM overhead.
1 table · 12 fieldsPersonal CRMStay close to the people who matter: set a keep-in-touch rhythm per person, log catch-ups and see who you are overdue to call.
2 tables · 22 fieldsSimple CRMContacts and their deals in two linked tabs — enough structure to run a pipeline, little enough to set up in five minutes.
2 tables · 20 fieldsSmall Business CRMCapture enquiries from walk-ins, WhatsApp and social, send quotes against them and see which channels actually convert.
2 tables · 23 fields