CRM Audit: Duplicates, Forgotten Deals and 5 Reports Every Manager Should See

A CRM audit usually starts with an uncomfortable discovery: the system is in place, the sales team "works" in it, yet the owner still hears about problems from customers. Take a company with 5 sales reps and 300 inbound leads a month. If 10% of leads simply get lost with no next step, that's 30 prospects. At a 15% conversion rate and an average deal of $1,000, the company misses out on roughly $4,500 in revenue every month. The numbers are illustrative, but the scale of the loss is realistic.

The good news: you can find most of these problems in a couple of hours if you know where to look.

Signs your CRM is lying to you

• Sales figures in the CRM don't match accounting or your spreadsheets.
• One customer exists as three records owned by different reps.
• Deals sit in "Negotiation" for months.
• The "Source" field is empty or says "Other" everywhere.
• Plan vs. actual is calculated by hand in a spreadsheet at month-end.
• Ask "how many hot deals do we have?" and every rep gives a different answer.

If three or more of these ring true, you're making decisions based on inaccurate data.

Where duplicates come from

The most common cause is inconsistent phone formats. To a person it's one number; to a CRM it's four different strings:

• +380 67 123 45 67
• 067-123-45-67
• 380671234567
• (067) 1234567

Add leads from different channels (calls, website forms, Telegram), old spreadsheet imports, and reps who create a new contact instead of searching for the existing one.

A reliable approach is to compare the last digits rather than the whole number — for example, the last 8 digits, so country codes and leading zeros stop getting in the way. Don't merge duplicate groups automatically: show them to someone responsible first, because different people from the same family or company can share a number.

The one flag that matters: deals with no next step

Of all the checks, one is the most useful: an open deal or lead with no scheduled activity — no call, meeting or task. If there's no next step, nobody is working that customer, even if the deal is formally "in progress".

A real project shows how big this is. At one construction company, this single flag caught 217 of 711 deals and 178 of 327 leads — almost one in three deals and more than half of all leads.

It's tempting to add more "forgotten" criteria. But when four criteria were combined on the same data, 97% of records were flagged. A report where almost everything is a problem is useless: reps stop looking at it. One clear flag you can act on today works better.

5 reports every manager should see

1. Lead sources and conversion

How many leads came from each channel and how many became sales. It tells you where to put your ad budget and which channels bring empty inquiries.

2. Response time

How long it takes from a lead arriving to first contact. A lead answered the next day has often already gone to a competitor.

3. Forgotten deals by rep

Deals and leads with no next step, broken down by each salesperson. It's not a tool for blame — it's a daily "who to call" list.

4. Plan vs. actual

Progress against targets for revenue, number of deals and conversion — as of today, not at month-end when it's too late to change anything.

5. Lost reasons

Why customers don't buy: price, timing, chose a competitor, couldn't be reached. This report is impossible without a mandatory "reason" field, so make it part of your sales process.

Report	Question it answers	How often to check
Sources and conversion	Which channels bring in money	Weekly
Response time	Are we losing hot leads	Daily
Forgotten deals by rep	Who is nobody working on right now	Daily
Plan vs. actual	Are we on track this month	Daily or weekly
Lost reasons	What to fix in the product or the sales process	Monthly

Self-audit checklist for your CRM

1. Export contacts and check for duplicates by the last 8 digits of the phone number.
2. Filter open deals and leads with no scheduled activities.
3. Group them by the responsible rep.
4. Find deals that haven't changed stage in more than 30 days.
5. Check what share of leads has a source filled in.
6. Check whether a lost reason is recorded when deals are closed.
7. Compare last month's revenue in the CRM with your accounting.
8. Check whether pipeline stages are documented — does everyone agree on what "Negotiation" means?

Even if you stop after step two, you'll already have a list of customers to call today.

What it looks like in practice

For a renovation and construction company on Bitrix24 I built a set of add-ons. Duplicate search by the last 8 digits of the phone number processes about 10,000 contacts in roughly 100 seconds. A CRM audit app shows "forgotten" deals and leads with no next step, groups of duplicates, and a breakdown by rep.

The same project added daily and monthly sales reports: around 25 plan metrics, conversion for 4 business lines, and plan vs. actual. They replaced a report that used to be assembled by hand in Excel. A knowledge base inside Bitrix24 documents 15 lead stages and 11 pipelines, so everyone reads the stages the same way.

When automating the audit isn't worth it

• You have 1–2 reps and a few dozen deals a month. A saved CRM filter and 20 minutes on Friday are enough.
• Nobody actually works in the CRM. You need a process and discipline first — a report on empty data fixes nothing.
• Nobody is ready to act on the results. A report no one reads is just an expense.

Also, a lot can be done in Bitrix24 and other CRMs with built-in filters and reports, no development needed. I always check that option first.

How much it costs

Bitrix24 or other CRM setup starts at $300. A single report or dashboard starts at $150. A package of duplicate search, an audit app and management reports is a turnkey project from $1,500 with staged payments. Ongoing support and improvements start at $100 a month.

Let's check your CRM together

Book a free 30-minute process review: we'll look at your pipeline, I'll show you where customers are most likely slipping through, and suggest what you can fix on your own. More about the service on the Bitrix24 and CRM implementation page.