Leak 33 · Sales & Quoting - Customer and product churn hidden inside aggregate revenue
Revenue is up 3%. Underneath, twenty accounts are shrinking, five are gone, and two big wins covered it all. The 3% hides a problem that will show up next year.
Diagnostic note. Symptoms, the records to bring, and a practical first check with your team.
What is it?
Top-line growth is the sum of many opposite movements. Without a bridge from last year’s revenue to this year’s, management sees the net and misses the churn. The same is true of products: a growing category can hide a dying line inside it. The leak is the decisions not made because the decline was invisible.
- Family
- Sales & Quoting
- Primary owner
- CFO / VP Sales
- Secondary owners
- Product Managers, Sales Managers
- Primary impact
- Revenue
- Typical data source
- ERP sales by customer, product, and period
- Detection difficulty
- 30-day measurability
Ask yourself
Can you split last year’s revenue change into new customers, lost customers, growth in retained customers, and decline in retained customers?
Yes, partially, no, or don’t know. “Don’t know” is the most useful answer, because it points at the test below.
What does it look like?
Look for these patterns, then use the check below to trace the issue in your own records.
- Revenue reported in total and by rep, but not bridged year to year.
- Growth concentrated in a few accounts.
- Lost customers discovered after the fact.
What data do I need?
The minimum viable set. Most of it is already in your ERP.
| Field |
|---|
| Sales by customer and product for two full years |
| Customer start dates |
The initial check
Start with a small sample. Ask the person who owns the records to gather the exports and agreements, then work through these steps together.
- 1Export sales by customer for the last two years.
- 2Classify each customer: new, lost, retained-growing, retained-declining.
- 3Sum revenue change in each group.
Revenue change = new + (retained growth − retained decline) − lost
Then ask one question: Is the retained-declining group larger than the growth story suggests?
How much could it be costing us?
A conservative range, not a headline. The goal is a number management can trust enough to investigate.
Gross profit in declining and lost accounts × share recoverable with earlier intervention
Common root causes
Fixes fall into three layers. Not every problem needs software, and almost none needs AI first.
- Process
- Management reporting stops at totals and rep summaries.
- Data
- No stable customer identifier across years, so the bridge is hard to build.
- Technology
- Reporting tools show totals, not movement.
What should we do?
Start with the simplest intervention that could solve it. Move down the list only if the one above is not enough.
Level 1
Visibility
A quarterly revenue bridge by customer and product group.
Level 2
Process
Declining accounts reviewed in the sales meeting with an action and an owner.
Level 3
Workflow
An automated bridge and decline alerts delivered monthly to sales management.
Where AI helps
- Explaining the likely cause of a decline from order history, quotes, and service records, to make the review faster.
Where AI probably doesn’t
The bridge is arithmetic. A spreadsheet does it.
Before you call it a leak
- Customer mergers and account restructuring create false churn. Clean customer records first.
Think this might be happening in your business?
Turn the finding into a next step.
If the numbers say there is something there, send us what you found and we will help you decide whether it is worth a full investigation. No transaction files needed for that conversation.
Related leaks
- Leak 32 · SalesDormant customers going unnoticedA customer who bought every month for six years stopped in March. It is now September. Nobody called, because no report said so.
- Leak 31 · SalesCustomers buying only one product categoryA good customer buys bearings from you and everything else from someone else. They are one supplier consolidation away from leaving, and one conversation away from doubling.
- Leak 39 · DataDuplicate customer and product recordsAcme Mfg, ACME Manufacturing, and Acme Manufacturing Inc. Three records, three price files, three credit limits, and a sales report that shows none of them as your biggest customer.
Let’s start with one thing.
Give your team more time for the work that needs them.
Show us the quoting, order-entry, or follow-up work that keeps piling up. We’ll map it with you and find a practical place to start.
Start with a free workflow conversation with Alex.