Customer Profitability Analysis
Customer profitability analysis measures the net profit each customer generates after all costs to serve them – not just gross margin. In most portfolios we model, 20% of customers create 150-300% of total profit while 20-30% quietly destroy it. The question is never whether this is happening in your customer base. It’s where.
Why gross margin gets it wrong
Your highest-gross-margin customer may be the worst deal you have. Gross margin stops at product cost. It ignores everything that comes after: rush deliveries, split shipments, returns, year-end rebates, weekly sales visits, 120-day payment terms, the support hours nobody logs against an account.
These costs to serve are what separate two customers with identical revenue into opposite profit outcomes – and because almost no system assigns them to customers, the portfolio gets managed on the wrong metric: volume.
How it’s calculated – a worked example
Customer profitability = revenue − product cost − cost to serve. TDABC computes the third term with time equations over data you already have. Two customers, same revenue:
| Customer A | Customer B | |
|---|---|---|
| Annual revenue | €500,000 | €500,000 |
| Gross margin (35%) | €175,000 | €175,000 |
| Orders / year | 24, scheduled | 310, urgent & split |
| Cost to serve (TDABC) | €38,000 | €196,000 |
| Net profit | €137,000 (27%) | −€21,000 (−4%) |
On the sales report, A and B are twins. In reality, B consumes A’s profit – and is probably being treated as a star account, with an extra discount coming at the next renewal.
The whale curve: your portfolio in one picture
Rank customers from most to least profitable and plot cumulative profit, and you get the whale curve. The hump rises fast – a minority of customers builds 150-300% of final profit. Then the tail gives it back. The gap between the peak and where you end the year is margin you already earned and then destroyed.
What to do about the tail (it’s not “fire your customers”)
- Reprice – make price reflect true cost to serve: surcharges for urgency, order minimums, payment terms with teeth;
- Redesign the service – change how you serve: consolidated deliveries, online ordering, self-service support. Customer B above turns profitable with one weekly delivery;
- Renegotiate or release – the last resort, with numbers on the table. Most unprofitable customers would rather change behaviour than change supplier.
The order matters. Companies that lead with “fire the tail” destroy revenue they could have fixed. Companies that never act subsidise their competitors’ best customers with their own best customers’ profit.
What a consulting engagement adds
The concept is simple; the allocation is not. Getting cost to serve right means modelling order handling, logistics, commercial time, technical support and financing cost per customer – without drowning in detail. That is TDABC’s home turf, and ours:
- Profit Check (free, 5 minutes) – scores your current cost-management maturity and tells you if you’re ready for this analysis;
- ProfitAudit 360 (3 weeks, fixed fee) – a TDABC model on your real data, the whale curve of your portfolio, and a margin roadmap with reprice/redesign/release actions quantified per account;
- Live model (optional) – the analysis recalculates nightly in CostCtrl, so customer profitability becomes a managed number, not an annual study.
Frequently asked questions
What is customer profitability analysis?
It is the measurement of net profit per customer after all costs – product cost plus the cost to serve (logistics, commercial, administrative, financing). It distinguishes the customers who create value from those who destroy it, which gross margin alone cannot do.
How is it different from gross margin analysis?
Gross margin stops at product cost. Customer profitability also deducts the cost to serve, which in service-intensive businesses reaches 25-40% of revenue – and is what separates customers with identical revenue into opposite profit outcomes.
How many customers are typically unprofitable?
Across the models we have built, 20-30% of a typical portfolio destroys value – and they are rarely the accounts the sales team suspects. The pattern holds in manufacturing, distribution, logistics and healthcare.
What data does it require?
Invoice-level billing, costs by department, and operational records – orders, shipments, returns, sales visits. Perfect data is not a prerequisite: mapping the gaps is part of the three-week diagnostic.
Want to see your portfolio’s whale curve?
Start with the free Profit Check – or book a scoping call directly.
How to identify which customers are unprofitable
The customers that drain profit are almost never the ones finance suspects. They pass every revenue and gross-margin test, then lose money below the line – in the cost of handling small orders, processing returns, expediting deliveries and answering support calls. To find them you need a true profit figure per customer, built by assigning the full cost-to-serve to each account by the minutes it actually consumes. That is exactly what time-driven activity-based costing does.
The practical sequence is short:
- Pool the costs. Group every operating cost into the resources that serve customers – warehouse, delivery, sales, service, finance.
- Rate the capacity. Convert each resource to a cost per minute using payroll and practical capacity.
- Cost the activity. Use time equations to charge each order, delivery, return and call to the customer that triggered it.
- Rank and read. Sort customers by true profit. The bottom 20-30% that destroy value become obvious – and fixable.
A free Profit Check scores your readiness and shows where the losses likely hide.
Take the Profit Check
How to calculate true profit per customer
True profit per customer is a bridge, not a single number. You start with what the customer pays and subtract, layer by layer, everything it costs to earn it. Gross margin is only the first subtraction; the costs that decide whether a customer is worth having sit below it, in the cost-to-serve. Build the bridge once and every account in the book can be read the same way.
The mechanics, in order:
- Net revenue – after discounts, rebates and credits, which often differ sharply by customer.
- Less product cost – to reach gross margin, where most reporting stops.
- Less cost-to-serve – order handling, delivery, returns, support, financing and account time, assigned by TDABC time equations.
What remains is true profit: auditable, comparable across customers, and refreshable each month from standard ERP exports. SAF-T countries get a head start, because the financial layer arrives in one standardised file.
The ROI of a customer profitability analysis
ROI questions about analysis usually stall on a fair objection: analysis does not earn anything by itself. True – but a customer profitability analysis is not a study, it is a map to money you are already leaving on the table. The return is not hypothetical future sales; it is profit you currently earn on good customers and hand back to bad ones, made visible and recoverable.
Three things make the return fast and defensible:
- The size of the gap – 50-67% of peak profit destroyed by loss-makers is not a rounding error; recovering a slice of it is material.
- The fixed, short cost – a three-week ProfitAudit 360 caps the investment, so payback is usually weeks.
- The nature of the actions – reprice, set minimums, trim cost-to-serve; these need no new customers and little capital.
That is why we lead with a free Profit Check: it estimates the recoverable gap before you spend anything, so the ROI conversation starts with your numbers, not a promise.
Frequently asked questions
How do I identify which customers are unprofitable?
You identify unprofitable customers by measuring each customer’s full cost-to-serve, not just gross margin, then ranking every account from most to least profitable. Customers that look healthy on revenue often destroy value once you add small orders, returns, rush deliveries and support. Across the 150+ cost models we have built since 2010, the bottom 20-30% of customers typically erase 50-67% of peak profit. A free Profit Check shows where your hidden losses sit.
How do I calculate true profit per customer?
True profit per customer is net revenue minus product cost minus the full cost-to-serve that customer – ordering, delivery, returns, support, financing and account management. Gross margin stops at product cost and hides the rest; in complex service businesses cost-to-serve runs 25-40% of revenue, enough to turn an apparently good customer into a loss. Time-driven activity-based costing assigns those service costs by the minutes each customer actually consumes, giving an auditable profit figure per account.
What is customer profitability analysis?
Customer profitability analysis is the practice of measuring the true profit each customer generates after their full cost-to-serve, not just the revenue or gross margin they bring. It reveals which relationships create value and which quietly destroy it, and it underpins pricing, segmentation and service decisions. Our detailed method, a worked example and the value creators-versus-destroyers pattern are set out on our customer profitability analysis page.
Gross margin vs net customer profitability – what’s the difference?
Gross margin measures revenue minus product cost; net customer profitability also subtracts the cost-to-serve – everything it takes to win, keep and serve that customer. A customer with a healthy gross margin can be a net loss once small orders, rush shipments and heavy support are counted. Because cost-to-serve reaches 25-40% of revenue in complex businesses, the two numbers often disagree. We cover the full comparison in our gross margin versus net profitability article.
Should I fire unprofitable customers or fix them?
Fix first, fire last. Most unprofitable customers can be made profitable by changing how you serve them – minimum order sizes, delivery frequency, pricing for rush or fragmented orders, or moving small accounts to self-service – rather than by walking away. Firing a customer removes the revenue but keeps much of the fixed cost. Across our engagements the larger prize is usually repairing the middle of the whale curve, where break-even accounts turn profitable with small structural changes.
How do I turn break-even customers into profitable ones?
You turn break-even customers profitable by reducing their cost-to-serve or repricing what drives it, not by chasing more volume. Typical moves: raise small-order or rush charges, consolidate deliveries, shift routine service to self-serve, and align discounts with actual cost. The middle 60% of the whale curve is usually where the fastest gains sit, because small structural changes move many accounts at once. A free Profit Check highlights which levers matter most for your book.
Customer profitability analysis consultant – who can help?
Cost & Profitability Consulting specialises in customer profitability analysis using time-driven activity-based costing, with 150+ models built across 30+ countries since 2010. We build an auditable profit figure for every customer, reveal the whale curve hidden in your book, and turn it into pricing, segmentation and service decisions. A fixed-price, three-week ProfitAudit 360 diagnostic is the usual starting point; the free Profit Check is a faster first read on where you stand.
Activity-based costing vs standard costing?
Standard costing applies average overhead rates to every unit; activity-based costing traces overhead to the specific activities each product and customer consumes. Standard costing is simple and fine when products are similar, but it hides the cost of complexity – short runs, small orders, rush jobs – by smearing it evenly. ABC, and especially its time-driven form, exposes that complexity so low-volume specials stop looking artificially cheap. For most businesses with variety, ABC is the more honest basis for pricing and mix decisions.
What's the ROI of a customer profitability analysis?
The ROI of a customer profitability analysis comes from recovering profit you already make and then give away: on the whale curve, loss-making customers destroy 50-67% of peak profit, and even recovering part of that gap typically dwarfs the cost of the analysis. The return shows up as repriced contracts, minimum-order rules and trimmed cost-to-serve, not as new sales you have to win. Because the first model is a fixed-price three-week ProfitAudit 360, the payback is usually measured in weeks, not years.