What a sales pipeline audit covers

A sales pipeline audit is a structured read of every open deal, set against the record that is supposed to describe it. It looks at four things: how the stages are defined, how long deals have been sitting, how many survive each step, and where the CRM and the real world disagree. It ends with a shorter, more honest pipeline and a ranked list of what to fix. It is not a review of individual salespeople, and treating it as one guarantees you get the wrong answer.

Stage definitions, before anything else

The first hour goes on what each stage means. Not what the CRM's default settings call it. What has to be true about the buyer for a deal to sit there.

Two questions expose most of it. Can two people look at the same deal and agree which stage it belongs in? And is the test something the buyer did, or something your executive is intending to do? Stages named Follow-up, Interested or Hot fail both, and they appear in nearly every small business pipeline.

This matters more than it sounds. Every number further down, the conversion rates, the coverage, the forecast, is calculated from these definitions. Fix them last and you have measured nothing.

Ageing, and the deals that are quietly dead

Every open deal gets two dates: when it entered its current stage, and when a human last spoke to the buyer. Sort by the second one.

What comes back is uncomfortable. The bottom of that list holds deals nobody has spoken to since April, carrying values that are still sitting in this quarter's forecast. They get counted when the owner decides whether to hire a third executive. They are gone.

The audit also looks at where deals get stuck rather than simply how old they are. A single stage that is far slower than the rest points to one broken step. Proposal sent is the usual offender: quotations go out and nobody is responsible for what happens next.

Which step loses the most deals

Most owners know their enquiry-to-order rate. Far fewer know which step loses the most, and that is the number that tells you where to spend money.

Read down the column of drop-offs and the weakest step is obvious. Then compare the same rates by source and by salesperson. When one channel converts at a fifth of the others, that channel is a budget decision, not a coaching problem.

What the CRM says against what happened

This is the part that makes the audit worth paying for, and it cannot be done from a dashboard.

Take a sample of fifteen to twenty deals across stages and outcomes. For each one, read the CRM record, then find the truth: the WhatsApp thread, the email, the quotation file, the recorded call, the salesperson's own account of it. Then compare.

The gaps repeat. Deals marked won with no purchase order behind them. Losses recorded as "price" when the recording shows the buyer never got a call back. Next actions dated in the past. A value field that is somebody's hope. And enquiries that never reached the CRM at all, because they came to a personal number and lived on one phone.

Count the mismatches out of twenty. That fraction is your forecast's real accuracy, and it settles a lot of arguments.

What comes out of it, and what it should cost

Five things, in writing. Corrected stage definitions. A cleaned pipeline with the dead deals moved out. Conversion rates by stage and by source. A revised forecast you would be willing to plan cash against. And a ranked list of fixes, each with a named owner. If what arrives is a deck of observations, you have bought a report and not an audit.

The fixes themselves belong in a routine. Rules about what may sit where, and who clears the stale deals, are pipeline hygiene and governance. Without them the same audit finds the same things in a year. The weekly habit of working the corrected list is pipeline management.

There is no standard rate for a sales pipeline audit, and the quotes you collect will vary widely because the scope does. The price moves with the number of open deals and salespeople, and with how many systems the data has to be pulled out of. It moves much more with whether recorded calls and quotations are read alongside the CRM, and whether the fixes get implemented or only recommended.

Ask three things before you agree to anything. What exactly will be read, deal by deal. What documents you receive at the end. And who does the work of cleaning the pipeline afterwards, you or them. A sales audit that stops at the findings leaves the hardest part on your desk.

Ours is free, and it asks the pipeline questions above alongside the ones about how enquiries arrive and how fast they are answered. The report that follows is written and scored, ranked by what to fix first.

Before you pay anyone, spend an afternoon on this

Most of the first pass is yours to do. Export your open deals to a spreadsheet and work through this list.

• Every open deal has a next action with a date. Count the ones that do not, as a percentage.
• No deal has sat in the same stage for more than twice the average for that stage.
• Last contact date is filled on every deal. Anything past sixty days is moved to a nurture list today.
• Deal values are what the buyer was quoted, not what you hope they will order.
• Lost deals from the last quarter have a reason recorded, and the reasons are specific.
• Every enquiry from last month is in the CRM, including the ones that arrived on a personal WhatsApp number.
• Two people, given ten deals, put them in the same stages.
• Your three largest deals are not more than half the quarter's forecast.

For example, an industrial valve supplier in Peenya ran this on a Saturday morning. Of 96 open deals, 58 had no dated next action and 19 had not been touched since April. On the screen the pipeline was ₹2.6 crore. After cleaning it was nearer ₹1.4 crore. Those figures are illustrative, and the pattern behind them is not: the cleaning is worth more than the analysis.

What to do next

Do the afternoon checklist before you talk to anybody about a paid audit. Two of the eight lines will fail badly, and fixing those two will change next quarter more than any report will. Then decide whether the remaining questions, the ones that need somebody reading twenty deals against the evidence, are worth an outside pair of eyes.