Solar CRM

From rooftop enquiry to commissioning: size systems, price proposals with subsidy and payback, and schedule installation crews.

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

Clients, Proposals, Installations

Fields

37

Views

grid, kanban, form, dashboard, timeline

Tables, columns and sample rows

The 3 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Clients

13 fields · 5 sample rows

  • Clients (Grid)
  • Sales pipeline (Kanban)
  • Free site survey (Form)
ClientTextPhonePhoneEmailEmailSite addressAddressProperty typeSingle selectRoof typeSingle selectMonthly billCurrencySanctioned load (kW)NumberSourceSingle selectStageSingle selectProposalsLink to another tableInstallationsLink to another tableBest proposal (kWp)Rollup
Ramesh Iyer+91 98440 11223[email protected]22, 4th Cross, Jayanagar, Bengaluru, Karnataka, IndiaResidentialRCC flat₹4,2005.0Google AdsWonP-101 Iyer 5 kWpJ-55 Iyer rooftop5.0
Sunrise Cold Storage+91 98250 44556[email protected]GIDC Phase 2, Vadodara, Gujarat, IndiaIndustrialMetal sheet₹1,85,000150.0ReferralProposal sentP-102 Sunrise 120 kWp120.0
Harpreet Singh+91 98140 77889AgriculturalGround mount₹6,5007.5Walk-inSite survey
Green Leaf School+91 99000 33221[email protected]CommercialRCC flat₹52,00040.0Trade showNegotiationP-103 Green Leaf 35 kWp, P-104 Green Leaf 40 kWp hybridJ-56 Green Leaf (tentative)40.0
Anjali Deshmukh+91 97300 55443ResidentialSloped tile₹2,800InstagramEnquiry
Field details
Client · Text
Phone · Phone
Email · Email
Site address · Address
Property type · Single select
Residential, Commercial, Industrial, Agricultural
Roof type · Single select
RCC flat, Sloped tile, Metal sheet, Ground mount
Monthly bill · Currency
INR
Sanctioned load (kW) · Number
Source · Single select
Website, Referral, Instagram, LinkedIn, Google Ads, Walk-in, Trade show, Cold outreach
Stage · Single select
Enquiry, Site survey, Proposal sent, Negotiation, Won, Installed, Lost
Proposals · Link to another table
Links to Proposals
Installations · Link to another table
Links to Installations
Best proposal (kWp) · Rollup
max of System size (kWp) via Proposals

Form view “Book a free solar site survey” asks for: Client, Phone, Email, Site address, Property type, Roof type, Monthly bill, Sanctioned load (kW).

Proposals

15 fields · 4 sample rows

  • Proposals (Grid)
  • By status (Kanban)
  • Sales dashboard (Dashboard)
ProposalTextClientLink to another tableSystem size (kWp)NumberPanelSingle selectInverterSingle selectPrice per kWpCurrencySystem costFormulaSubsidyCurrencyNet costFormulaTariff (₹/kWh)NumberAnnual generation (kWh)FormulaAnnual savingsFormulaPayback (years)FormulaStatusSingle selectSent onDate
P-101 Iyer 5 kWpRamesh Iyer5.0TOPCon 580WOn-grid₹58,000₹2,90,000₹78,000₹2,12,0007.507,000₹52,5004Accepted25 Oct 2026
P-102 Sunrise 120 kWpSunrise Cold Storage120.0Bifacial 550WOn-grid₹42,000₹50,40,000₹0₹50,40,0008.901,68,000₹14,95,2003.4Sent15 Nov 2026
P-103 Green Leaf 35 kWpGreen Leaf School35.0Mono PERC 540WOn-grid₹47,000₹16,45,000₹0₹16,45,0009.2049,000₹4,50,8003.6Sent9 Nov 2026
P-104 Green Leaf 40 kWp hybridGreen Leaf School40.0TOPCon 580WHybrid₹61,000₹24,40,000₹0₹24,40,0009.2056,000₹5,15,2004.7Draft
Field details
Proposal · Text
Client · Link to another table
Links to Clients
System size (kWp) · Number
Panel · Single select
Mono PERC 540W, TOPCon 580W, Bifacial 550W
Inverter · Single select
On-grid, Hybrid, Off-grid
Price per kWp · Currency
INR
System cost · Formula
{System size (kWp)} * {Price per kWp}
Subsidy · Currency
INR
Net cost · Formula
{System cost} - {Subsidy}
Tariff (₹/kWh) · Number
Annual generation (kWh) · Formula
ROUND({System size (kWp)} * 1400, 0)
Annual savings · Formula
{Annual generation (kWh)} * {Tariff (₹/kWh)}
Payback (years) · Formula
IF({Annual savings}, ROUND({Net cost} / {Annual savings}, 1), BLANK())
Status · Single select
Draft, Sent, Accepted, Declined
Sent on · Date

Installations

9 fields · 2 sample rows

  • Jobs (Grid)
  • Crew schedule (Timeline)
  • Job board (Kanban)
JobTextClientLink to another tableInstall startDateInstall endDateCrewSingle selectStatusSingle selectNet meter application no.TextSite photosAttachmentNotesLong text
J-55 Iyer rooftopRamesh Iyer13 Nov 202615 Nov 2026Crew A — ManjunathNet metering appliedBESCOM/NM/2026/88412
J-56 Green Leaf (tentative)Green Leaf School10 Dec 202617 Dec 2026Crew B — IrfanScheduledPending PO; install during winter break
Field details
Job · Text
Client · Link to another table
Links to Clients
Install start · Date
Install end · Date
Crew · Single select
Crew A — Manjunath, Crew B — Irfan, Subcontractor
Status · Single select
Scheduled, Material dispatched, Installing, Net metering applied, Commissioned
Net meter application no. · Text
Site photos · Attachment
Notes · Long text

Solar CRM: questions

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