Skip to main content
Performance & Profitability · 12 min read ·

Customer Profitability Analysis — Finding Where You Actually Make Money

How to analyse profitability at the customer level, calculate cost-to-serve, and use the customer profitability matrix to make strategic decisions. Practical methodology for mid-market companies.

Key Takeaways

  • Customer profitability analysis reveals which customers create value and which destroy it — revenue ranking and profitability ranking are often inversely correlated.
  • Cost-to-serve is the hidden variable: order complexity, delivery requirements, returns, support intensity, and payment behaviour consume margin silently.
  • The customer profitability matrix (revenue contribution against cost-to-serve) converts analytical data into strategic decisions: protect, reprice, maintain, or exit.
  • Customer profitability analysis is not about dropping customers — it is about repricing, restructuring service levels, and redirecting resources to where margin exists.
  • Start with the top 20 customers by revenue — this typically covers 60–80 per cent of revenue and exposes the biggest profitability surprises.

Customer profitability analysis reveals which customers create value and which destroy it — revenue ranking and profitability ranking are often inversely correlated, particularly for the largest accounts. Cost-to-serve is the hidden variable: order complexity, delivery requirements, returns, support intensity, and payment behaviour consume margin silently. The customer profitability matrix plots revenue contribution against cost-to-serve, converting analytical data into strategic decisions — protect, reprice, maintain, or exit. This analysis is not about dropping customers; it is about repricing, restructuring service levels, and redirecting resources to where margin exists. Starting with the top 20 customers by revenue typically covers 60-80 per cent of revenue and exposes the biggest profitability surprises. For mid-market companies, applying contribution margin methodology at the customer level closes the gap between knowing what customers pay and knowing what they actually cost.

The largest customer generates the most revenue. The sales team celebrates it. The account manager protects it. The board monitors it. But when someone asks whether that customer is actually profitable — after accounting for the rush orders, the special packaging, the dedicated support, the 90-day payment terms, the returns, and the quarterly rebates — the room goes quiet. Nobody knows.

This is the gap that customer profitability analysis closes. It calculates the true profit contribution of each customer or customer segment after deducting all costs attributable to serving that customer — including costs that never appear on a standard invoice. The results are frequently uncomfortable: revenue ranking and profitability ranking are often inversely correlated, particularly for the largest accounts.

What Customer Profitability Analysis Measures

Customer profitability analysis assigns revenue and costs to individual customers or customer segments to determine the actual margin each generates. It moves beyond gross margin — which treats all customers identically — to reveal the cost-to-serve differences that determine where profit is created and where it is consumed.

The core calculation follows the contribution margin methodology, applied to the customer dimension:

LineDescription
List price revenueWhat the price list says the customer should pay
Minus: discounts, rebates, credit notesNegotiated reductions, volume bonuses, promotional allowances
Net-net revenueWhat the company actually collects
Minus: direct cost of goods/servicesMaterials, labour, and variable costs for what the customer bought
Customer CM IRevenue minus direct costs — before cost-to-serve
Minus: cost-to-serveOrder processing, logistics, special handling, support, payment cost
Customer CM IIThe true profit contribution of this customer

The gap between list price revenue and net-net revenue is the revenue waterfall — the accumulation of discounts, rebates, early payment deductions, credit notes, and free services that reduce what the company actually collects. For many mid-market companies, this gap is 8–15 per cent and growing.

Why This Matters

Revenue concentration hides risk

In most mid-market companies, the top 10 per cent of customers generate 50–70 per cent of revenue. If those customers are profitable, the concentration is a strength. If they are margin-negative after cost-to-serve, the concentration is an existential risk — the company is effectively subsidising its largest accounts from the margins generated by smaller, less demanding customers.

Cost-to-serve varies dramatically

Two customers buying the same product at the same price can have radically different profitability. One places monthly bulk orders with standard delivery and pays within 30 days. The other places weekly rush orders in small quantities, requires special packaging, generates frequent returns, demands dedicated account management, and stretches payment to 90 days. The product margin is identical. The customer margin is not.

Sales incentives reinforce the wrong behaviour

Without customer profitability data, sales teams optimise for revenue. Commission structures, quarterly targets, and annual bonuses reward top-line growth regardless of margin. A sales representative who wins a £2M account at 5 per cent margin and heavy service demands is celebrated. A representative who grows a £500K account to £800K at 35 per cent margin receives less recognition. Customer profitability data does not replace revenue targets — but it makes the true cost of revenue visible.

The macro context compounds the urgency

Deloitte research shows that a 1 per cent increase in selling prices improves operating profit by 12.3 per cent. But price adjustments must be targeted. Raising prices on already-profitable customers risks losing them. Adjusting pricing or service terms for high-cost-to-serve customers — where the margin is being consumed — is where the profit recovery exists. Without customer profitability data, the targeting is impossible.

The PARP (Polish Agency for Enterprise Development) data reinforces this: as mid-market companies grow their customer base, cost-to-serve complexity grows faster than revenue if left unmanaged. Micro-firms with fewer customers and simpler service models consistently achieve higher profitability ratios than medium-sized firms. Customer profitability analysis makes this complexity visible and manageable.

How to Build a Customer Profitability Analysis

Step 1: Build the revenue waterfall

Start with list price revenue per customer. Then subtract, layer by layer:

Revenue LayerExample
List price revenue£1,200,000
Minus: negotiated discounts(£96,000) — 8% contractual discount
Minus: volume rebates(£36,000) — 3% annual volume bonus
Minus: credit notes(£18,000) — returns, quality claims
Minus: early payment discounts(£12,000) — 1% settlement discount
Net-net revenue£1,038,000 — 13.5% below list price

Most companies track the contractual discount. Fewer track the cumulative effect of rebates, credit notes, settlement discounts, and free services. The net-net revenue is the number that matters — it is what actually arrives in the bank.

Step 2: Assign direct cost of goods or services

Calculate the direct variable cost of what each customer actually purchased. This comes from the bill of materials or service delivery cost for the specific product mix the customer bought. If different customers buy different product mixes, their direct cost ratios will differ even before cost-to-serve is considered.

Step 3: Identify and quantify cost-to-serve

This is where customer profitability analysis departs from standard accounting — and where the most significant insights emerge. Cost-to-serve includes every cost incurred specifically because of how a customer behaves, not what they buy:

Cost-to-Serve CategoryWhat to MeasureData Source
Order processingNumber and complexity of ordersERP order data
Logistics and deliveryDelivery frequency, urgency, special requirementsLogistics records
Special packaging or handlingNon-standard requirementsProduction / warehouse records
Returns and claimsReturn rate, claims frequencyQuality / returns records
Dedicated supportAccount management time, technical support hoursTime tracking, CRM activity
Payment terms costDays sales outstanding × cost of capitalFinance / AR records
Credit riskExpected loss provision for this customerCredit assessment

Cost-to-serve data is rarely available from ERP or CRM in structured form. The first analysis typically requires a dedicated data-gathering exercise — interviews with sales, logistics, and operations managers combined with transaction data extraction. This is a one-time effort that then becomes a repeatable quarterly process.

Step 4: Calculate customer CM I and CM II

Customer CM I = Net-net revenue minus direct cost of goods or services. This shows the margin before cost-to-serve — useful for understanding the impact of product mix and pricing, but insufficient for strategic decisions.

Customer CM II = CM I minus cost-to-serve. This is the true customer contribution — the profit that remains after all costs attributable to serving this customer. A customer with positive CM I and negative CM II is generating revenue but consuming more resources than that revenue justifies.

Step 5: Build the customer profitability matrix

The customer profitability matrix maps customers on two dimensions: revenue contribution (vertical axis) and cost-to-serve intensity (horizontal axis). This creates four quadrants, each demanding a different strategic response:

Low Cost-to-ServeHigh Cost-to-Serve
High RevenueProtect and grow. These are the ideal customers — high revenue with efficient service requirements. Invest in deepening the relationship.Reprice or restructure. Revenue is significant but service costs consume margin. Adjust pricing, renegotiate service levels, or restructure delivery terms.
Low RevenueMaintain efficiently. Profitable relative to their cost, but small. Serve through standardised, low-touch processes.Exit or restructure fundamentally. Low revenue, high service cost. Unless there is a clear path to moving this customer to another quadrant, the relationship destroys value.

The matrix converts analytical data into a strategic conversation. It is not a formula — it is a framework for management discussion about customer portfolio strategy.

Step 6: Compare revenue ranking with profitability ranking

The most revealing output of customer profitability analysis is the side-by-side comparison: customers ranked by revenue next to customers ranked by CM II. In most mid-market companies running this analysis for the first time, at least two of the top ten revenue customers fall below the median in profitability ranking. This is the “aha” moment that makes the business case for ongoing customer profitability monitoring.

Common Pitfalls

Equating high revenue with high profitability. The largest customers frequently have the lowest margins. They negotiated the deepest discounts, demand the most service, and stretch payment terms the furthest. Revenue is a measure of size, not value creation.

Ignoring below-the-line costs. Payment terms have a real cost (days outstanding multiplied by the cost of capital). Credit risk has a real cost (expected loss provision). Returns and claims have a real cost (processing, restocking, disposal). Free services — “we’ll throw that in” — have a real cost. Excluding these costs from customer profitability analysis systematically overstates the margin on demanding customers.

Averaging cost-to-serve across all customers. The entire purpose of customer profitability analysis is to reveal variance, not to average it away. Using an average cost-to-serve per customer destroys the signal. The analysis must capture the difference between a low-maintenance customer and a high-maintenance one — that difference is where management action exists.

Analysing customer profitability once and not updating it. Customer behaviour, product mix, pricing terms, and service demands change. A customer that was profitable two years ago may have negotiated additional discounts, increased return rates, or demanded faster delivery since then. Quarterly refresh is the minimum cadence.

Using customer profitability analysis only to exit customers. The primary use is to reprice, restructure service levels, and redirect resources — not to terminate relationships. A high-revenue, high-cost-to-serve customer in the “reprice or restructure” quadrant may become highly profitable with adjusted terms. Exiting should be the last option, applied only when restructuring has been attempted and failed.

Assuming CRM data equals customer profitability data. CRM tracks revenue and activity. It does not track cost-to-serve. Customer profitability requires integrating finance data (revenue, COGS, cost of capital), operations data (order processing, logistics, returns), and commercial data (discounts, rebates, terms). The CRM is one input, not the answer.

Industry Considerations

Manufacturing: Key account profitability with tooling, setup, and quality cost allocation. Long-term contracts create opportunities for repricing at renewal. The cost-to-serve difference between a customer ordering in production-run-sized batches and one ordering in small, frequent batches is often 15–25 per cent of revenue.

Professional and business services: Client-level profitability with utilisation and scope-creep adjustments. Project overruns are a form of hidden cost-to-serve — the client receives more work than was priced. Business development and proposal costs are customer acquisition overhead that should be tracked at the client level.

Retail and distribution: Channel profitability (online vs. physical) with delivery and fulfilment cost-to-serve as the primary differentiator. The cost of free returns in e-commerce can consume the entire margin on certain customer segments.

Frequently Asked Questions

How many customers should I analyse? Start with the top 20 customers by revenue. In most mid-market companies, this covers 60–80 per cent of total revenue and exposes the largest profitability surprises. Extend to the next tier (top 50) once the methodology is established. For the long tail, segment-level analysis (small customers grouped by behaviour) is more practical than individual analysis.

What if I cannot quantify cost-to-serve precisely? Use estimates. A reasonable approximation of cost-to-serve — based on order frequency, delivery requirements, return rates, and support intensity — is vastly more useful than no cost-to-serve analysis at all. Start with categories you can measure (order frequency, returns) and add precision over time.

How do I handle shared customers across divisions? Analyse at the entity level first. If a customer buys from multiple divisions, each division’s contribution is calculated separately. The consolidated customer view is the sum of divisional contributions, which may reveal that a customer unprofitable in one division is highly profitable in another.

Should I share customer profitability data with the sales team? Yes — selectively and with context. Sales teams need to understand margin impact to make better commercial decisions. But sharing raw profitability data without guidance can lead to counterproductive behaviour (abandoning large accounts rather than renegotiating terms). Frame the data around action: which customers need repricing conversations, which need service-level restructuring, which should receive more investment.

Where This Fits in Our Expertise

Customer profitability analysis applies the contribution margin methodology to the most strategically important dimension — the customer. It is part of the profitability analysis cluster within Performance & Profitability .

The customer profitability matrix is the diagnostic output: it converts granular financial data into a portfolio view that enables strategic decisions about pricing, service levels, resource allocation, and customer development. Revenue data alone cannot inform these decisions. Cost-to-serve data — the element most frequently cited by practitioners as “never properly analysed” — is what makes the difference.


Sources

  1. Deloitte — Pricing and Profitability Management — 1% increase in selling prices improves operating profit by 12.3%
  2. BCG — Cost Management 2025 — only 48% of cost-saving targets achieved; customer-level cost reduction fails without cost-to-serve visibility
  3. PARP — Polish Agency for Enterprise Development — micro-firm profitability exceeds medium-firm profitability; cost-to-serve complexity grows faster than revenue as firms scale
  4. PIE — Polish Economic Institute, Enterprise Profitability Report 2024 — net profitability fell from 4.3% to 3.4%, worst in a decade
  5. IMA — Institute of Management Accountants — management accounting practice gaps at mid-market level

Martin Duben is the founder of Onetribe, where he works with mid-market finance leaders on profitability analysis, management reporting, and performance measurement across Central and Eastern Europe.

Related Expertise

Performance & Profitability

See how this concept fits into our approach.

Explore

Let's go!

Transform your financial controlling

From reporting foundations to comprehensive managed services, we help finance teams see clearly, decide confidently, and act decisively.

Book a free consultation