Free Stuck Deals Finder for Your Sales Pipeline

What is a stuck deals finder?

A stuck deals finder reads your pipeline and lists every deal that has stopped moving. It checks four things: whether the deal has an owner, whether it has a next follow up date, whether the last contact is older than your limit, and whether the planned follow up date has already passed.

A deal that fails any one check is called stuck. The Stuck Deals Finder on this page runs those checks on a CSV you paste or upload. It runs entirely in your browser, so your data is not uploaded anywhere.

Why does it exist? A pipeline board shows stages, not momentum. A deal in "Negotiation" looks healthy even if nobody has spoken to the customer for three weeks. Managers usually find these deals by asking reps one by one, which is slow and feels like policing. A finder replaces that conversation with a list.

Pipeline hygiene is the habit of keeping every open deal owned, dated and recently touched. This tool measures hygiene in rupees.

Three terms are used throughout this page:

• Stale means no contact for more than N days. The default is 7.
• Overdue means the next follow up date is already in the past.
• Value at risk is the combined value of all stuck deals.

Why do stuck deals matter for Indian sales teams?

Stuck deals matter because most of them are lost quietly. Nobody decides to drop a deal. It simply stops getting attention, and the customer buys from whoever called back.

Indian sales teams are especially exposed. Leads arrive from Meta lead ads, Google ads, IndiaMART, 99acres, MagicBricks, Shiksha, Justdial, walk ins and WhatsApp, often into different sheets and phones. A rep who handles forty open deals across calls and WhatsApp chats cannot hold every promise in memory. Reps also leave. When a telecaller resigns, their open deals often stay assigned to a name that no longer logs in.

Consider the cost side. You paid for every one of these leads, and the sales cycle in your industry may be weeks or months. A site visit in real estate, a counselling session in education or a trial order in manufacturing took real effort to arrange. Letting that deal go cold wastes all of it.

Three patterns show up again and again:

• Orphan deals. The owner field is blank, or points to someone who left. Nobody feels responsible.
• Undated deals. The deal has an owner but no next follow up date. It depends on the rep's memory.
• Slipped deals. A follow up was planned, the date passed, and nothing was logged.

There is also a data protection angle. Under the DPDP Act, you should hold personal data for a defined purpose and keep it accurate. A pipeline full of abandoned records with unclear owners makes that harder to manage. Cleaning it is good sales practice and good governance.

Benchmarks differ by industry, so no single number tells you what share of stuck deals is normal. Your own trend matters more. Run the finder weekly and watch whether the percentage falls.

How to use the Stuck Deals Finder

1. Export your pipeline as a CSV. From your CRM or sheet, export open deals only. Remove won and lost rows first, because closed deals will not have follow up dates and will look stuck.
2. Check the six columns. The tool expects Lead, Owner, Stage, Value, Last contact date and Next follow up date. Rename your headers to match and keep the date format the same in every row.
3. Paste or upload the file. Use the paste box or the upload button. A 12 deal sample loads by default, so you can see the output before using real data.
4. Set the stale threshold. The default is 7 days without contact. Raise it for long cycle sales such as manufacturing quotes, and lower it for hot inbound enquiries.
5. Read the summary tiles. Note total deals, stuck deals, value at risk and the count for each flag.
6. Sort and filter the table. Sort by value to find the biggest stuck deals first. Each row carries flag chips, so you can see why it was caught.
7. Copy the fix actions. The tool groups actions by owner. Copy the text and send it to each rep, or paste it into your team's WhatsApp group.

Once you have the list, do not just forward it. Start with deals that have no owner, since nothing else can happen until someone owns them. Then handle overdue follow ups, then deals with no date, then stale deals. Set a time limit, such as 24 hours, for every flagged deal to get either a logged action or a lost reason.

How does the Stuck Deals Finder work?

The finder applies four plain rules to every row. There is no scoring model and no guesswork, so you can check any result by hand.

No owner = Owner is blank No next step = Next follow up date is blank Stale = Today minus Last contact date is greater than N days Overdue = Next follow up date is earlier than today Stuck = at least one of the above is true Value at risk = sum of Value for all stuck deals

What each input means:

• Lead. The name or ID of the deal. Used only for display.
• Owner. The person responsible. Blank counts as no owner.
• Stage. Shown in the table so you can see where deals are stuck. It does not change the rules.
• Value. The expected deal value in rupees. It drives the value at risk figure.
• Last contact date. The last logged call, WhatsApp message, visit or meeting.
• Next follow up date. The date of the next planned action.
• N, the stale threshold. Default 7 days. You can change it.

Assumptions to keep in mind:

• Dates in the sample are relative to today, so the sample always looks current.
• A deal can carry several flags at once. Flag counts therefore add up to more than the number of stuck deals.
• The tool trusts your data. If reps do not log calls, a healthy deal will look stale. That is itself a finding about your process.

Worked example: a 12 deal pipeline worth ₹38,40,000

This example uses the sample that loads on first view. The sample is illustrative, built to show every flag type. The totals below are what the tool shows.

Now the interpretation. Eight of 12 deals are stuck, but the sample still has 4 healthy deals worth ₹13,60,000 (38,40,000 minus 24,80,000). The average stuck deal is worth ₹3,10,000, slightly under the pipeline average of ₹3,20,000. So the problem is not that small deals are being ignored. Large and small deals are slipping alike.

The flag counts add up to 14 across 8 stuck deals, an average of 1.75 flags each. That means many stuck deals fail more than one test. A deal with no owner and no next date has no one who could act on it, which makes it the most urgent kind.

Stale deals are the largest group at 5 of 12, or about 42% of the pipeline by count. Missing owners affect 3 of 12, or 25%. If this were your pipeline, the first step would be to give owners to the 3 orphans, because the other flags on those rows cannot be fixed without an owner.

Try the same maths on your own file. If the stuck value share is higher than the stuck count share, your biggest deals are the ones slipping, which is worse.

How do you read your stuck deals result?

Read your result by looking at the percentage of pipeline value at risk first, then at which flag dominates. The percentage tells you how big the problem is, and the dominant flag tells you what kind of problem it is.

No official band exists for this measure, and benchmarks vary by industry, team size and sales cycle. Use the sample as a reference point and your own history as the real baseline. The sample, with 67% of deals and 64.6% of value stuck, is deliberately messy.

A practical way to read it:

Also watch the trend. If the stuck share falls steadily week after week, the routine is working. A share that stays flat means the list is being read but not acted on.

Finally, check the stage column for stuck deals. If most are in one stage, say "Quote sent", the cause is probably a stage level problem such as a missing follow up script, not a rep problem.

Stuck deals by industry

Each industry gets stuck in a different place. Use the same four flags, but set the threshold and the first action to match your cycle.

Real estate

Stuck deals cluster after the site visit. Set the stale limit to 5 days for visited leads. Check that every visited lead has a dated next step, such as a revisit with family, a loan discussion or a token amount. Orphaned portal leads from 99acres and MagicBricks are common, so review the no owner flag first, and keep resale and new launch enquiries in separate views.

Education (schools, colleges, EdTech, study abroad)

Deals stall between counselling and application. Stale is the key flag, because parents say they will discuss at home and then hear nothing. Use a 3 to 5 day threshold in admission season. Study abroad teams should also check overdue dates around document, test score and visa deadlines, since a missed week there can cost a whole intake.

Manufacturing and B2B

Long cycles mean a 7 day limit is too tight after a quote. Use 14 days for the quote sent and sample stages, but keep no next step strict. A quote with no follow up date is the classic B2B stuck deal. Check that owners are named for each plant or buyer contact, especially when IndiaMART enquiries reach several people.

Healthcare and clinics

Stuck deals here are patients who enquired, heard a price range by phone and never booked. Use a short threshold of 2 to 3 days for appointment stages. Overdue is the flag to watch, because missed callbacks lose patients fast. Keep patient data minimal in the CSV, and leave out diagnosis details completely.

Automotive

Test drive done but no booking is the main trap. Use a 3 day limit after a test drive and a 7 day limit after a quote. Check owners across showroom walk ins and online enquiries, since the same buyer is often entered twice under two advisors. Exchange valuation and finance approval dates also deserve their own follow up.

Insurance and financial services

Documents pending is where deals stop. A stale flag at the documents stage usually means a missing KYC item, not a lost customer. Set a 4 day limit there. Renewal deals need overdue checks tied to the policy end date, so ask agents to date every promise made on a call or WhatsApp message.

SMBs and services

Small teams often have one person doing everything, so no owner is rare and no next step is common. Proposals sent and never followed up are the typical case. A weekly 15 minute review of the finder output is enough, and a 7 day threshold works well. Add a lost reason before you delete anything.

What mistakes do teams make with stuck deals?

Most mistakes come from treating the list as a blame tool or from feeding the tool poor data. These are the common ones:

• Including closed deals. Won and lost deals have no next date and look stuck. Export open deals only.
• Using one threshold for every stage. A hot enquiry and a manufacturing quote do not age at the same speed. Adjust N by stage or by team.
• Fixing the date instead of the deal. Reps sometimes enter a new follow up date just to clear a flag. Ask for a logged action, not just a date.
• Ignoring no owner. Orphan deals feel like nobody's problem, so they stay orphaned. Assign them in the first meeting.
• Running it once. A one time clean up fades in a month. Run it on a fixed day every week.
• Reading only the count. Eight small stuck deals and two huge ones are different problems. Always sort by value.
• Skipping the lost reason. Some stuck deals are dead. Close them with a reason so the pipeline and forecast stay honest.
• Trusting stale on incomplete logs. If calls happen on personal phones and are never logged, deals look stale when they are not.

How can you improve your stuck deals result?

You improve the result by preventing flags, not just clearing them. Prevention comes from rules that apply at the moment a deal changes, plus a short weekly routine for what slips through.

Fix the data first

• Owner: sales ops, this week. Give every unowned deal a name and remove departed reps from active assignment.
• Owner: team leads, within 3 days. Make sure every open deal has a next follow up date.
• Owner: each rep, within 24 hours. Log the last real contact on every deal you are working.

Build a weekly review

1. Pick one fixed slot, for example Monday at 10:30.
2. Run the finder on a fresh export.
3. Sort by value and review the top 10 stuck deals as a team.
4. For each, record one of three outcomes: next step dated, deal reassigned, or deal closed lost with a reason.
5. Note the stuck share in a running log.

Set stage rules

• Write one exit rule per stage, such as "no deal leaves Quote sent without a dated follow up".
• Set a stale limit per stage and put it in the team handbook.
• Require a lost reason from a short list, so lost deals teach you something.

Use WhatsApp and calls deliberately

• Move conversations onto the WhatsApp Business API so chats are logged against the deal automatically.
• Use approved templates for outbound messages after the 24 hour customer service window has closed.
• Get opt in consent for marketing style messages in line with the DPDP Act.

Pair this tool with the Sales Pipeline Health Grader to score your wider process, and use the Follow Up Cadence Planner to decide what the next step on each deal should be. If many deals are stuck because reps cannot keep up, check workload with the Sales Rep Capacity Calculator.

Stuck deals: spreadsheet, CRM or Erino?

You can find stuck deals in a spreadsheet, a generic CRM or Erino. The difference is how soon you find out. A spreadsheet tells you when you look. A rules based CRM can tell you when you build the report. Erino is designed to flag stuck deals in real time.

A spreadsheet works for a small team. You can add a stale formula and filter on it, and the Sales Pipeline Tracker Template shows how. The weakness is that someone must keep it updated and remember to open it.

Generic CRMs such as LeadSquared, Zoho CRM, Kylas, TeleCRM and HubSpot can all report on aging deals or overdue tasks in some form, but how much setup that needs depends on your plan and configuration. Check each vendor's current plans before assuming a feature is included.

Erino assigns every lead an owner on arrival and creates the next follow up at every stage. That removes two of the four flags at the source. It also flags stuck deals as they happen, and it logs calls and WhatsApp chats against the deal so staleness is measured on real activity. See the Erino platform and the real estate and EdTech pages for industry detail. For a result in the field, Ghar Mil Gaya saw 31% more bookings with Erino.

Pricing is quoted after a free 15 minute demo.

Frequently asked questions

Written by the Erino team

Erino Tech Ventures Pvt. Ltd. builds Erino, an AI first sales CRM for high velocity sales teams in India. Last reviewed 26 Oct 2026. This tool runs in your browser; the numbers you type are not sent anywhere.

Customer results mentioned here come from Erino's published success stories.