Sales CRM

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

CRM

Tables

Accounts, Leads, Opportunities, Tasks

Fields

41

Views

grid, kanban, form, calendar, dashboard

Updated

2026-11-19

Tables, columns and sample rows

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.

Accounts

12 fields · 4 sample rows

  • Accounts (Grid)
AccountTextIndustrySingle selectSizeSingle selectTierSingle selectWebsiteURLCountryTextAccount ownerTextLeadsLink to another tableOpportunitiesLink to another tableOpen dealsCountPipeline valueRollupWeighted pipelineRollup
Zenith LogisticsLogistics1000+Strategichttps://zenithlogistics.inIndiaPriya SharmaVikram JoshiZenith — fleet tracking rollout, Zenith — analytics add-on2₹50,00,000₹30,20,000
NovaPayFintech201–1000Growthhttps://novapay.ioSingaporeAlex TurnerMei TanNovaPay — support desk seats1₹18,00,000₹9,00,000
FreshCartRetail51–200Standardhttps://freshcart.inIndiaPriya SharmaRohan KapoorFreshCart — starter plan1₹3,60,000₹90,000
MediLink HealthHealthcare201–1000Growthhttps://medilink.aeUAEAlex TurnerOmar HaddadMediLink — pilot1₹9,50,000₹9,50,000
Field details
Account · Text
Industry · Single select
SaaS, Fintech, Retail, Logistics, Healthcare, Manufacturing
Size · Single select
1–50, 51–200, 201–1000, 1000+
Tier · Single select
Strategic, Growth, Standard
Website · URL
Country · Text
Account owner · Text
Leads · Link to another table
Links to Leads
Opportunities · Link to another table
Links to Opportunities
Open deals · Count
Pipeline value · Rollup
sum of Amount via Opportunities
Weighted pipeline · Rollup
sum of Weighted via Opportunities

Leads

10 fields · 5 sample rows

  • Leads (Grid)
  • Lead board (Kanban)
  • Request a demo (Form)
LeadTextAccountLink to another tableTitleTextEmailEmailPhonePhoneSourceSingle selectStatusSingle selectFit scoreRatingCreatedDateAge (days)Formula
Vikram JoshiZenith LogisticsVP Operations[email protected]+91 98201 33445Trade showQualified5/515 Oct 202635
Mei TanNovaPayHead of Customer Success[email protected]LinkedInQualified4/529 Oct 202621
Rohan KapoorFreshCartFounder[email protected]+91 99100 22110WebsiteWorking3/510 Nov 20269
Omar HaddadMediLink HealthCIO[email protected]ReferralNurturing4/530 Sep 202650
Jenny ParkOps Manager[email protected]Google AdsNew2/518 Nov 20261
Field details
Lead · Text
Account · Link to another table
Links to Accounts
Title · Text
Email · Email
Phone · Phone
Source · Single select
Website, Referral, Instagram, LinkedIn, Google Ads, Walk-in, Trade show, Cold outreach
Status · Single select
New, Working, Nurturing, Qualified, Disqualified
Fit score · Rating
Created · Date
Age (days) · Formula
IF({Created}, DATETIME_DIFF(TODAY(), {Created}, 'days'), BLANK())

Form view “Request a demo” asks for: Lead, Title, Email, Phone.

Opportunities

12 fields · 5 sample rows

  • Pipeline (Grid)
  • Deal board (Kanban)
  • Close dates (Calendar)
  • Forecast (Dashboard)
OpportunityTextAccountLink to another tableStageSingle selectAmountCurrencyProbabilityPercentWeightedFormulaClose dateDateDays to closeFormulaOwnerTextNext stepTextTasksLink to another tableOpen tasksCount
Zenith — fleet tracking rolloutZenith LogisticsNegotiation₹42,00,00070%₹29,40,0007 Dec 202618Priya SharmaLegal review of MSASend redlined MSA1
NovaPay — support desk seatsNovaPayProposal₹18,00,00050%₹9,00,00019 Dec 202630Alex TurnerPricing call with CFOCFO pricing call1
FreshCart — starter planFreshCartDiscovery₹3,60,00025%₹90,0003 Jan 202745Priya SharmaDiscovery workshop1
MediLink — pilotMediLink HealthClosed won₹9,50,000100%₹9,50,0007 Nov 2026-12Alex TurnerKick-off & onboarding1
Zenith — analytics add-onZenith LogisticsProspecting₹8,00,00010%₹80,0002 Feb 202775Priya SharmaProduct demo for ops leads1
Field details
Opportunity · Text
Account · Link to another table
Links to Accounts
Stage · Single select
Prospecting, Discovery, Proposal, Negotiation, Closed won, Closed lost
Amount · Currency
INR
Probability · Percent
Weighted · Formula
{Amount} * {Probability}
Close date · Date
Days to close · Formula
IF({Close date}, DATETIME_DIFF({Close date}, TODAY(), 'days'), BLANK())
Owner · Text
Next step · Text
Tasks · Link to another table
Links to Tasks
Open tasks · Count

Tasks

7 fields · 5 sample rows

  • My tasks (Grid)
  • Calendar (Calendar)
TaskTextOpportunityLink to another tableTypeSingle selectDueDateOwnerTextDoneCheckboxOverdueFormula
Send redlined MSAZenith — fleet tracking rolloutEmail20 Nov 2026Priya Sharma
CFO pricing callNovaPay — support desk seatsCall22 Nov 2026Alex Turner
Discovery workshopFreshCart — starter planMeeting17 Nov 2026Priya SharmaOverdue
Kick-off & onboardingMediLink — pilotMeeting11 Nov 2026Alex TurnerYes
Product demo for ops leadsZenith — analytics add-onDemo28 Nov 2026Priya Sharma
Field details
Task · Text
Opportunity · Link to another table
Links to Opportunities
Type · Single select
Call, Email, Meeting, Demo, Follow-up
Due · Date
Owner · Text
Done · Checkbox
Overdue · Formula
IF(AND(NOT({Done}), {Due}, DATETIME_DIFF(TODAY(), {Due}, 'days') > 0), 'Overdue', '')

Why each part of the base is there

Accounts table

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.

Leads: Source, Status and Fit score

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.

Leads: Age (days)

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.

Opportunities: Stage, Amount, Probability and Weighted

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.

Opportunities: Close date, Days to close and Next step

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.

Tasks table and the Overdue formula

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.

About the Sales CRM template

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.

Who it is for

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.

How to use it

  1. 1

    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.

  2. 2

    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.

  3. 3

    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.

  4. 4

    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.

  5. 5

    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.

Connected templates in other Edesy apps

Sales CRM: frequently asked questions

Yes. 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.

About the app

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.

Related templates