A report shows exactly what your team typed in
CRM reports do not count sales, they count records of sales. If a rep creates the same client twice, skips the lead source or closes a deal a month after payment, the report counts exactly that. So "the report is broken" almost always turns out to be a problem inside deal records, not in the widget settings.
| What you see | What is wrong in the data | What to fix |
|---|---|---|
| Conversion jumps or tops 100% | Deals created without a lead, or one lead converted twice | One entry route: lead, then deal, created by automation |
| More clients than you have | Duplicate companies and contacts | Merge duplicates, one +971 phone format |
| Source "not specified" | Reps type the source by hand | Source from the form, UTM tags and channel |
| Revenue does not match the books | Amount not updated after a discount, part payments missing | Amount and payment from Zoho Books, QuickBooks or Odoo |
| Deals stuck for months | No closing rule, no time limit per stage | Mandatory loss reason, automation for stalled deals |
| Sales cycle looks too short | "Paid" stage set retroactively or skipped | Stage dates recorded automatically, skipping restricted |
MakeBiz Technologies summary of common CRM data problems, not tied to any specific company.
Duplicates inflate the database and split client history
A duplicate appears when a client messages on WhatsApp and later calls from another number, or when two reps add the same company under slightly different names. The report sees two clients and two histories. In reality it is one buyer who already has two different quotes.
Bitrix24 can find and merge duplicates by phone, email and company name. A one-off clean-up will not last unless you close the door: a check when a record is created, one phone format, and no new company without a search. Who may merge or delete records is an access rights question, covered in our news piece on CRM access rights.
Empty fields turn analytics into guesswork
An empty field is not a zero, it simply drops out of the report. If only some deals have a loss reason, your "why we lose clients" report draws conclusions for everyone from that subset.
Making every field mandatory does not help: reps will type anything just to save the deal. What works:
- keep the 5 to 7 fields you actually decide on
- require each one only at the stage where the information appears: amount at the quote stage, loss reason at closing
- fill in automatically whatever can come from a form, a call or an invoice
- drop fields nobody has opened in a quarter
Every stage has to mean the same thing to everyone
For one rep "Negotiation" is the first call, for another it is an agreed contract. The stage report then shows habits, not your sales process. Give each stage an entry criterion you can check: "Quote sent" means a quote is attached, "Invoice issued" means the invoice exists in the CRM or your accounting system.
Keep as many stages as your client has real decisions, usually 5 to 8. If nobody can describe a stage in one sentence, merge it with the next. Restrict stage skipping, or stage-to-stage conversion stops meaning anything.
