Start with a diagnosis
ZELVU Business logoZELVU BUSINESSBuild · Operate · Grow · Trade

Free sample lesson · no sign-up needed

Lead-to-cash mapping: finding where enquiries and deals leak before you buy any CRM

From CRM & Sales Automation · Module 1 — CRM foundations: mapping your sales process, pipeline and data · 8 min read

Most Indian businesses that say "CRM did not work for us" did not choose the wrong software; they automated a sales process nobody had written down. Enquiries land on the owner's personal phone, a salesperson's diary, the IndiaMART inbox, the showroom register and an Instagram DM, and nobody can say how many became paid orders. Before you spend a rupee on software, you need one honest map of how an enquiry becomes money in your bank account, and a count of exactly where it drops out.

What you need to know

What a CRM actually does. A Customer Relationship Management system is a shared record of people, companies and deals, a history of every interaction with them, and a set of rules that tell your team what to do next. It answers three questions at any moment: who is in the pipeline, what happened last, and what must happen next, by whom, by when. It is not a lead-generation machine, an accounting package or a replacement for a sales conversation. If your process is unclear, a CRM simply records the confusion faster.

Lead-to-cash, not lead-to-order. The full path runs: enquiry → first response → qualification → discovery (call, site visit, demo or sample) → quotation → negotiation → order and advance → delivery or installation → invoice → payment received → repeat order or referral. Many owners stop the map at "order confirmed". In an MSME, an unpaid invoice is not revenue you can pay salaries with, so the map must run until cash is in the bank.

Leakage. A leak is any point where volume falls without anyone deciding it should. Typical leaks in Indian SMEs:

  • Enquiries that never get a reply because they arrived after hours or on a channel nobody watches.
  • Leads contacted once and never again because nobody owns the second call.
  • Quotations sent on WhatsApp or email with no follow-up date.
  • Orders delayed because production or dispatch did not know the deal was won.
  • Invoices overdue because collection is "everyone's job" and therefore no one's.

Stage conversion and overall conversion. For each stage, conversion = number that reached the next stage ÷ number that entered this stage. Overall conversion is the product of all stage conversions. If 100 enquiries → 70 responded (70%) → 35 qualified (50%) → 14 quoted (40%) → 7 won (50%), overall conversion = 0.70 × 0.50 × 0.40 × 0.50 = 0.07, or 7%. The value of this arithmetic is that it shows which stage, if improved, moves the final number most. Raising the 70% response rate to 90% lifts overall conversion to 9% without a single extra rupee of marketing.

Cycle time per stage. Average days a deal spends in each stage. Where days balloon, deals go cold. A common rule of thumb: when a stage's cycle time is more than twice its normal average, the deal needs a manager's attention, not another reminder.

Manual effort. Count the minutes your team spends each week on repetitive work: copying enquiries into Excel, sending the same price list, reminding people, preparing the Monday sales report. This is the realistic time budget that automation can return to you, and it is how you will later judge whether the CRM is paying for itself.

Decision rule: process first, software second. If you cannot state in one sentence what must be true for a deal to move from one stage to the next, that stage is not ready to be automated. Write the sentence first.

Step-by-step method

  1. List every channel that brought an enquiry in the last 90 days: calls, WhatsApp, website form, marketplace (IndiaMART, JustDial, TradeIndia), Meta or Google ads, walk-ins, dealers, referrals, exhibitions.
  2. Collect a real sample of at least 50 recent enquiries across those channels from phones, registers, email and marketplace panels. Do not rely on memory.
  3. For each enquiry, record the date received, source, who handled it, the furthest stage it reached and today's status.
  4. Draw your stages as boxes from enquiry to payment received. Use the words your team already uses, such as "site visit done" or "sample dispatched".
  5. Count how many of your sample reached each stage and calculate stage conversion and overall conversion.
  6. For deals that reached quotation or beyond, note the dates and calculate average days between stages.
  7. Write the name of the one person who owns each stage. Any stage with "everyone" or a blank is a leak waiting to happen.
  8. Put a rupee value on the two biggest leaks: lost volume × later-stage conversion × average order value.
  9. List the repetitive manual tasks per stage with estimated minutes per week.
  10. Write a three-line CRM problem statement: the two leaks you will fix first, the manual tasks you will remove and the numbers you will track.

Worked example

Worked example

A modular kitchen and interiors firm in Baner, Pune, has seven people: the owner, three sales designers, a site supervisor and two office staff. Enquiries come from Instagram, Google Business Profile calls, showroom walk-ins and architect referrals.

For this example assume that last quarter the firm traced its enquiries as follows:

  • 420 enquiries received.
  • 290 got a response within 24 hours (290 ÷ 420 = 69%).
  • 180 were qualified on budget and possession date (180 ÷ 290 = 62%).
  • 110 had a site measurement (61%).
  • 72 received a quotation (65%).
  • 30 placed an order (30 ÷ 72 = 42%).
  • Average order value, assumed: ₹3,20,000.

Booked orders = 30 × ₹3,20,000 = ₹96,00,000. Overall conversion = 30 ÷ 420 = 7.1%.

Leak 1 — 130 enquiries never received a timely reply. Of those that were answered, 30 ÷ 290 = 10.3% became orders. If the unanswered group behaved similarly, 130 × 10.3% ≈ 13 orders, or roughly ₹43 lakh of order value was at stake. This is an estimate of what the leak is worth, not a promise of what fixing it will produce.

Leak 2 — 25 of the 72 quotations had no follow-up after the first send. At the 42% close rate, that is about 10 deals, worth about ₹34 lakh, left to chance.

Manual effort: office staff spent about 9 hours a week copying enquiries from Instagram and call logs into Excel and forwarding them on WhatsApp.

The owner's CRM problem statement: "Capture every enquiry from all four sources automatically and assign it within one working hour; create a mandatory follow-up task for every quotation; track response rate, quote-to-order rate and days from quote to advance every week."

Apply it

Template / checklist

Lead-to-cash map for ____ (business name), period ____ to ____

StageEntry rule (what must be true)OwnerCountConversion to nextAvg days in stage
Enquiry received________________%____
First response________________%____
Qualified________________%____
Discovery / visit / demo________________%____
Quotation sent________________%____
Order + advance________________%____
Invoice paid____________—____
  • Every source listed and sampled? Yes / No
  • Every stage has one named owner? Yes / No
  • Biggest leak (stage): __ Rupee value at stake: ₹__
  • Second leak (stage): __ Rupee value at stake: ₹__
  • Manual tasks to remove (minutes per week): ____

Common mistakes

  • Drawing the ideal process from memory instead of tracing real enquiries, which hides the leaks you most need to see.
  • Ending the map at "order received" and ignoring advance, invoice and collection, where many MSMEs lose the most cash.
  • Treating the marketplace inbox or a salesperson's personal WhatsApp as "outside the system" and leaving those enquiries uncounted.
  • Defining stages by what your team did ("called twice") rather than what the buyer did ("agreed to a site visit").
  • Buying a CRM before the problem statement exists, then configuring every feature because nobody knows which ones matter.
  • Valuing leaks at full order value instead of multiplying by the later-stage conversion rate, which inflates the case.

Apply it

20-minute action task

Take the last 30 enquiries you can find from at least three different sources. In a sheet, note source, date, handler, furthest stage reached and status. Count how many reached each stage and calculate one conversion rate per stage. Output: a one-page lead-to-cash map with counts and your single biggest leak circled.

Ask the AI Business Tutor

  • "I run a [type of business] in [city] with [number] salespeople. My enquiries come from [list of sources]. Last month I had [number] enquiries, [number] responses, [number] quotations and [number] orders worth about ₹[amount]. Help me draw my lead-to-cash stages, calculate conversion at each stage, and identify the two leaks worth fixing first, with the rupee value at stake."

Found this useful?

30 more lessons like this are waiting.

Enrol to unlock the complete CRM & Sales Automation programme (7 modules · 31 lessons), the AI Business Tutor for questions about your own business, practice labs and 12 months of access.

One-time fee, paid upfront through ICICI Bank · bank financing assistance available · no subscription or auto-renewal.

Full programme

₹6,999

Enrol now