The Excel Tax

Rohit runs a 12-person EPC in Surat. His team does approximately ₹60 lakh in GMV each month, 30 to 35 residential solar jobs, mostly 2–4 kWp PM Surya Ghar systems. He has three salespeople, two site survey engineers, a project manager, four installers, and two admin staff. He has been in the solar business for six years.

He runs everything on Excel.

Or rather, he runs everything on seven different versions of the same Excel file, maintained across five WhatsApp groups, a shared Google Drive folder that half the team has stopped updating, and the individual phones of three salespeople who each have their own "working version."

This is not unusual. According to JMK Research's 2025 India Solar EPC Operations Survey, over 67% of solar EPCs with fewer than 20 employees in India manage their sales pipeline, lead tracking, and proposal generation primarily through a combination of Excel, WhatsApp, and manual effort. Mercom India's residential solar market reports and the IEA's distributed solar analysis further corroborate the dominance of informal operations in the sub-₹5 crore EPC segment. And it is costing them far more than they realise.

We call it the Excel Tax.

What Is the Excel Tax?

The Excel Tax is not a single catastrophic failure. It is the accumulated weight of a hundred small inefficiencies, each individually tolerable, that compound into a significant drag on revenue, margin, and team morale.

The Excel Tax has four components:

1. Time cost, hours spent each week maintaining, reconciling, formatting, and correcting spreadsheets instead of selling or installing.

2. Error cost, the financial impact of formula errors, stale data, and copy-paste mistakes, including subsidy miscalculations and wrong proposals sent to customers.

3. Lead leakage cost, prospects who were never followed up because their details were in someone's personal spreadsheet that did not sync with the team's "master" file.

4. Opportunity cost, deals closed late, at lower margins, because a slow proposal process gave the customer time to get three more quotes from competitors.

These four costs combine into what we call the Excel Tax Formula:

Annual Excel Tax = (Hours/week × Hourly rate × Team size × 52) + (Lost leads/month × Avg deal value × 12) + (Margin erosion from late proposals × Annual GMV)

Let us work through each component for a real business profile.

The Time Cost: What the Clock Says

Across QuickEstimate's installer base, we have surveyed team members about time spent on non-selling administrative work related to lead and proposal management. The findings are consistent enough to use as benchmarks.

For Rohit's 12-person EPC in Surat with 3 salespeople, 2 admin staff, and himself spending about 2 hours/week on reconciliation:

• 3 salespeople × 6.2 hrs/week × ₹500/hr (blended cost) × 52 weeks = ₹4.84 lakh/year
• 2 admin × 3.8 hrs/week × ₹350/hr × 52 weeks = ₹1.38 lakh/year
• 1 manager × 2.1 hrs/week × ₹800/hr × 52 weeks = ₹0.87 lakh/year

Time cost alone: ₹7.09 lakh per year. That is time being paid for but not being spent on revenue-generating activity.

The Failure Modes: What Actually Goes Wrong

Beyond the hourly cost, Excel creates specific, repeatable failure modes in solar businesses. These are not hypothetical edge cases, they are things that happen routinely, every month, in EPCs that rely on spreadsheets.

Version conflict failure. Three salespeople each download the lead tracker on Monday morning. By Friday, Salesperson A has added 8 new leads, Salesperson B has updated statuses on 12 existing leads, and Salesperson C has corrected phone numbers on 5 entries. No one's changes are visible to anyone else. The "official" version still shows data from last week. Rohit has to manually merge three files on Sunday evening to prepare for the Monday morning meeting.

Formula error failure. The PM Surya Ghar subsidy calculation is built into the proposal template as a nested IF formula. Someone on the team edited the formula two months ago to account for a new slab structure and introduced an error on the 3–10 kWp slab. Every proposal since then has shown the wrong subsidy figure. Neither the installer nor the customer noticed, until one customer received his actual CFA disbursement and called to ask why it was ₹9,000 less than the proposal said.

Copy-paste lead loss. Leads come in from Facebook Ads, from a walk-in at a dealer, from a WhatsApp number, and from a referral. Each entry point requires manual copy-paste into the spreadsheet. In the gap between lead arriving and lead being entered, follow-up does not happen. Studies on solar lead response time by CEEW and others consistently show that response time within 30 minutes dramatically improves booking rates, but the average Excel-based EPC has a 6–12 hour lag between lead receipt and data entry.

Subsidy math error, the ₹ case. This one is worth dwelling on. PM Surya Ghar CFA subsidy slabs changed multiple times between the scheme's launch in February 2024 and Q2 2026, per updates on mnre.gov.in and pmsuryaghar.gov.in. An Excel template built in mid-2024 may not reflect the current slab structure. If an installer uses a stale template and quotes a customer ₹78,000 subsidy on a 3 kWp system when the actual entitlement is ₹78,000 (this is correct for FY26), that may seem fine, but if the installer accidentally used the pre-revision ₹54,000 figure on a 2 kWp system calculation and quoted ₹54,000 when the current entitlement is ₹60,000, the customer gets a proposal that undersells the scheme's benefit and reduces price competitiveness.

See current slab data at PM Surya Ghar Subsidy Slabs 2026.

The Worked Example: One Lost Deal Worth ₹1.84 Lakh

Let us reconstruct an actual pattern we see on the QuickEstimate platform when EPCs migrate from Excel. We will call this Rohit's Monday problem.

The sequence:

A referral lead, Mr. Patel, called Rohit's Surat office on a Tuesday at 2 PM. The admin was on a call; the lead's name and number were written on a sticky note. At 4 PM, Salesperson Arjun typed the lead into his personal "working copy" of the lead tracker. The "team copy" on Google Drive was not updated because Arjun had given up on it being accurate three months ago.

Wednesday: no one called Mr. Patel because the lead was in Arjun's file, and Arjun was on a site visit in Ankleshwar all day with no internet.

Thursday: Arjun called. Mr. Patel was interested. Site survey booked for Saturday.

Saturday: survey completed. Arjun measured the roof, noted the DISCOM (UGVCL), system size recommendation 3 kWp, and took photos on his phone.

Sunday: Arjun tried to create a proposal from the Excel template. The subsidy formula was broken, someone had edited it the previous week. Arjun called admin to fix it. Admin was unavailable Sunday. Arjun sent a rough WhatsApp message with a ballpark price: "approximately ₹1.7 to 1.9 lakh, will send full proposal Monday."

Monday: Arjun created the proposal. Sent it Monday at 3 PM. Total time from site survey to proposal delivery: 52 hours.

Monday at 5 PM: Mr. Patel called to say he had received a proposal from another installer on Saturday evening, ₹1.84 lakh, PM Surya Ghar subsidy clearly shown, 25-year savings calculation, branded PDF, and he was going ahead with them.

Deal value lost: ₹1.84 lakh. Not because Rohit's price was wrong, not because his team did a bad job, not because the product was inferior. Because the proposal arrived 52 hours late.

This is not a single incident. On our platform, EPCs migrating from Excel to QuickEstimate consistently show a step-change in stage-2 time (survey to proposal) from 40–72 hours to under 2 hours in the first month.

Calculating the Annual Excel Tax: The Full Formula

Now let us apply The Excel Tax Formula to a real business profile: Rohit's 12-person EPC, ₹60 lakh/month GMV, 3 salespeople, Surat.

Component 1: Time cost

• 3 salespeople × 6.2 hrs/week × ₹500/hr × 52 = ₹4,84,800
• 2 admin × 3.8 hrs/week × ₹350/hr × 52 = ₹1,38,320
• 1 manager × 2.1 hrs/week × ₹800/hr × 52 = ₹87,360
• Subtotal: ₹7,10,480/year

Component 2: Lost lead cost

• Conservative estimate: 2 qualified leads lost per month due to entry lag or version confusion
• Average deal value: ₹1.8 lakh
• Close rate on those leads (assuming they were warm): 35% (referral quality)
• 2 leads × 35% × ₹1.8 lakh × 12 months = ₹1,51,200/year

Component 3: Late proposal deal loss

• Conservative: 1.5 deals lost per month to competitors because proposal arrived 48+ hours late
• Average deal value: ₹1.8 lakh
• 1.5 × ₹1.8 lakh × 12 = ₹3,24,000/year

Component 4: Subsidy error margin impact

• 2 proposals/month with wrong subsidy figure → need revision → 1 in 4 leads drops off from revision fatigue
• 0.5 deals/month × ₹1.8 lakh × 12 = ₹1,08,000/year

Total Annual Excel Tax: ₹7,10,480 + ₹1,51,200 + ₹3,24,000 + ₹1,08,000 = ₹12,93,680

That is approximately ₹12.9 lakh per year in the conservative calculation. In the aggressive scenario (3 lost leads/month, 2.5 late deals/month), the figure crosses ₹21 lakh.

The Hidden Tax: What Excel Does to Team Morale

Numbers tell part of the story. The rest is the quiet frustration of a salesperson who spent Sunday evening repairing a broken formula instead of resting. The site survey engineer who has to call admin three times to get a proposal formatted correctly. The manager who cannot answer "what is our close rate this month?" without spending 40 minutes manually counting rows.

This morale cost is real, if harder to quantify. According to CEEW's research on solar SME workforce dynamics, administrative friction is one of the top-three reasons cited by solar sales staff for wanting to change jobs. In a tight labour market for experienced solar salespeople, particularly those who understand PM Surya Ghar documentation well, this retention cost is significant.

The Cost of Not Migrating vs. The Cost of Migrating

The most common objection we hear from EPCs considering a CRM switch is: "migration will take too long." Let us look at both sides of this calculation honestly.

The migration cost is a one-time 8–12 hour investment to import existing leads, set up templates, and onboard 4 users. This pays back in the first 3–4 deals recovered from faster proposal delivery, often within the first two weeks.

How QuickEstimate Fits the Problem

The Excel Tax is fundamentally a structural problem: a tool that was not designed for multi-person, real-time, mobile solar sales is being used as one. QuickEstimate was built specifically to replace this stack.

• Proposal Generator, Generates a branded, subsidy-correct PDF in under 60 seconds from any mobile. Eliminates the "formula broken, call admin" failure mode entirely.
• Pipeline Management, A single real-time pipeline visible to every team member. No version conflicts, no Sunday evening merges, no invisible leads in personal spreadsheets.
• Sales Reports, Close rates by channel, revenue by month, pipeline stage duration, available without any manual calculation. Gives Rohit the business clarity that Excel's Sunday merge attempts never delivered.

See also: Solar Sales Automation in India and Solar CRM ROI Calculator to run the Excel Tax calculation for your own business.

The Excel Tax Formula: Apply It to Your Business

Before we get to the action steps, here is the framework in its simplest, most applicable form:

The Excel Tax Formula:

Annual Excel Tax = (hrs/week × hourly rate × team size × 52) + (lost leads/month × avg deal value × 12) + (late proposal deal losses/month × avg deal value × 12)

Run this calculation for your team using conservative numbers. If your Excel Tax is more than 3× your annual CRM cost, the decision is made. For virtually every EPC with more than three team members, it will be.

1. 1

   Calculate your hours/week

   Ask each team member to log non-selling admin time for one week. Most teams are shocked by the actual number vs their estimate.

2. 2

   Count last month's lead entries vs enquiries received

   Compare your WhatsApp and Facebook enquiry count to the number of leads actually entered in your tracker. The gap is your lead leakage rate.

3. 3

   Check your proposal template subsidy calculations

   Verify your current Excel template subsidy figures against the live MNRE CFA slabs on pmsuryaghar.gov.in. If they differ, you have been sending wrong proposals.

4. 4

   Plug your numbers into the Excel Tax Formula

   With actual data from steps 1–3, calculate your annual Excel Tax. If it exceeds ₹3 lakh, the CRM investment decision is financially straightforward.

What to Do This Week

The Excel Tax is not a future problem, it is running right now, compounding with every new lead that goes into a personal spreadsheet. Here is the minimum viable action for this week:

1. Do the time log. Send a WhatsApp message to your sales and admin team today: "Please log every hour spent on spreadsheet or pipeline admin this week, I'm calculating something." The number will surprise you.

2. Check your proposal template. Open your current subsidy formula. Cross-check against current PM Surya Ghar CFA slabs at pmsuryaghar.gov.in. Fix any discrepancies immediately. Every proposal sent with wrong subsidy numbers is a trust problem waiting to surface.

3. Count last month's WhatsApp enquiries vs CRM entries. The ratio is your lead leakage rate. If fewer than 90% of enquiries made it into your tracker, you have a structural problem.

4. Run the Excel Tax Formula with your numbers. Use the formula above with your actual hourly rates, team size, deal value, and conservative estimates for lost leads and late proposals. Write down the number.

5. Book a QuickEstimate demo this week. Specifically show your team the proposal generation flow, from site survey entry to WhatsApp PDF delivery in under 60 seconds. Then compare that to your current average proposal turnaround time.

---

Frequently asked questions

What is the Excel Tax for solar businesses?

The Excel Tax is the total annual cost of running a solar EPC's sales and operations on spreadsheets. It has four components: time wasted on spreadsheet admin, leads lost due to entry lag and version conflicts, deals lost to competitors because proposals arrived late, and revenue lost from subsidy calculation errors. For a 12-person EPC doing ₹60 lakh/month GMV, the conservative annual Excel Tax typically falls between ₹12 lakh and ₹22 lakh.

How do I calculate the Excel Tax for my solar business?

Use this formula: Annual Excel Tax = (hours/week × hourly rate × team size × 52) + (lost leads/month × avg deal value × 12) + (late proposal deal losses/month × avg deal value × 12). Start by having your team track non-selling admin time for one week and counting your lead leakage rate (enquiries received vs entries made in your tracker).

What are the most common Excel failure modes in solar businesses?

The four most damaging are: version conflicts where multiple team members edit different copies, formula errors in PM Surya Ghar subsidy calculations that produce wrong proposals, copy-paste lead leakage where leads are entered hours or days after enquiry, and pipeline blindness where the manager cannot see real-time pipeline status without manually reconciling files.

How much does a solar CRM cost vs Excel?

Excel is free, which creates a false zero-cost perception. A purpose-built solar CRM like QuickEstimate costs ₹6,999/user/year, approximately ₹28,000–84,000/year for a 4–12 user solar EPC. Against a conservative annual Excel Tax of ₹12–22 lakh for a 12-person team, this represents a 15–50× return on investment in year one.

How long does it take to migrate from Excel to a solar CRM?

For a typical 12-person EPC, migrating existing leads and setting up templates on QuickEstimate takes 8–12 hours total across 1–2 days. This is a one-time cost that pays back within the first 3–4 recovered deals from faster proposal delivery, typically within the first two weeks of use.

Can PM Surya Ghar subsidy calculation errors in Excel cost me deals?

Yes. MNRE updates CFA slabs and ALMM list requirements periodically. An Excel template built on an older slab structure will produce incorrect subsidy figures. Customers who receive a proposal with an incorrect subsidy amount either trust it (and get confused when the actual disbursement differs) or spot the discrepancy and question your credibility. Both outcomes damage conversion.

What is the biggest single source of the Excel Tax?

Across QuickEstimate's installer base, the biggest single component is time cost from spreadsheet administration, averaging 6.2 hours per salesperson per week. The second largest is late proposals resulting in lost deals. Both are directly solved by a mobile-first proposal generation tool.