Most companies rank customers by revenue. It is the easiest number to get, and it is often misleading. A customer who buys a lot at a low margin and demands heavy service can cost more than they bring in. A smaller customer who pays on time and orders in full pallets may be the most profitable account you have.
Customer profitability analysis is about finding out which is which.
Start with margin, not revenue
Gross margin by customer is the first step beyond revenue. It requires a consistent way of costing the products you sold, which is itself a useful discipline. If your product costs are unreliable, fix that first, because everything built on top inherits the error.
Add the cost to serve
The real differences between customers usually sit below gross margin. Consider the costs that vary by customer.
Freight and delivery. Small frequent orders cost more to ship than large infrequent ones, and some customers are expensive to reach.
Returns and credits. Some customers return far more than others.
Discounts and rebates. Volume rebates, early payment discounts and promotions all reduce what you keep.
Special handling. Custom labeling, packaging, documentation and routing requirements add real cost.
Payment terms. Waiting ninety days for payment has a cost, even if it does not appear as a line item.
Service time. Customers who generate many calls, questions and changes use up people's time.
Be sensible about overhead
Allocating all overhead to customers invites endless arguments. Start with the costs you can trace directly to a customer. If you need to allocate shared costs, use simple, defensible drivers, such as number of orders or order lines, and be transparent about how. A rough answer that people accept is more useful than a precise one they dispute.
Look at it over time
A single month can mislead. Look at a rolling year, and watch the trend. A customer whose margin is eroding because of rising discounts is a different case from one that has always been low.
Segment and show it clearly
Group customers into a few categories, for example the most profitable, the middle, and those that cost more than they earn. A waterfall chart that walks from revenue to contribution, one customer at a time, makes the story clear. A simple plot of revenue against margin shows who is where.
What to do with it
The analysis is only worth doing if it changes something. Options include revisiting prices, setting minimum order sizes or charges for small orders, adjusting payment terms, changing service levels, or deciding to grow the most profitable segments. Not every unprofitable customer should be dropped. Some are strategic, and some can be made profitable with a conversation.
Common pitfalls
Starting with an elaborate allocation model and never finishing. Using costs that are out of date. Missing data that is not in the ERP, such as freight billed separately. And showing results without agreeing the definitions first.
For the dashboard side, see how to build a financial dashboard your CFO will actually use, and for agreeing the definitions behind it, building a KPI framework your whole organization agrees on.
If you suspect your biggest customers are not your most profitable ones, reach out. We can usually produce a first view from data you already have.
Have a question about this topic? We work with businesses worldwide.
Get in Touch