At a glance
- Sales by customer tells you who buys the most. It does not tell you who earns you the most.
- To find out, start with gross margin by customer, then take off the cost to serve them: delivery, handling, small orders, rebates and the time your team spends on them.
- The answer can be surprising. A high-margin customer can earn little once the cost to serve is counted, and a big name can lose money.
- The fix may not be to drop customers. Repricing, changing how you serve them, or growing the ones that pay can come first.
Why sales and gross margin are not enough
Accounting systems can usually show sales by customer. Many can also show gross margin by customer, if costs are coded to jobs or customers. Both leave out a large part of the picture: what it costs to look after each customer once the goods or the work have been delivered.
Two customers can buy the same amount at the same margin. One places a single large order a month, pays on time and never calls. The other places twenty small orders, wants each one delivered the same day, asks for changes and pays late. On the profit and loss they look the same. In real life, one costs far more to serve.
Step 1: gross margin by customer
Start with sales less cost of sales for each customer, or for each group of similar customers. Take off everything that reduces the real price: discounts, rebates, free freight and credits for returns. Rebates and credits are sometimes recorded in other accounts, so they do not show against the customer. Bring them back in.
If you have hundreds of customers, group them. Your largest few on their own, then the rest by size, type or channel. You need enough groups to see a pattern, not a line for every account.
Step 2: add the cost to serve
Next, work out the costs that rise and fall with how you serve each customer. You do not need perfect numbers. Use simple drivers you can count:
- Delivery and freight. Number of deliveries, or distance, times your average cost per delivery.
- Picking and handling. Number of orders or order lines, times a cost per order.
- Sales time. Visits, calls and quoting time, at the cost of the person doing it.
- Admin and support. Order entry, invoicing, chasing payment and handling queries.
- Paying late. A customer who takes 70 days instead of 30 ties up cash that you may be paying interest on.
Leave out the costs that would stay whatever your customers did, such as rent on the head office, the owner's salary and the accounting fee. Keep those as one line at the bottom.
A worked example
Take a made-up food service distributor with $3.0m of sales a year. It splits its customers into four groups.
| Customer group | Sales | Gross profit after rebates | Delivery and handling | Sales and admin time | Contribution |
|---|---|---|---|---|---|
| Chain A (one customer) | $1,200k | $240k (20%) | $60k | $40k | $140k |
| Mid-size (30 customers) | $900k | $270k (30%) | $45k | $45k | $180k |
| Small (120 customers) | $600k | $210k (35%) | $90k | $100k | $20k |
| Chain B (one customer) | $300k | $45k (15%) | $40k | $25k | -$20k |
| Total | $3,000k | $765k | $235k | $210k | $320k |
Contribution is gross profit less the cost to serve. Shared overheads of $170k sit below this, leaving $150k profit. Figures made up, excluding GST.
Contribution is what each group leaves to pay the shared overheads and make a profit. The chart shows it more clearly.
Lime: earns a solid contribution. White: earns little. Coral: costs more than it earns. GM is gross margin after rebates.
Three things stand out.
Small customers have the best gross margin and the thinnest positive contribution. At 35%, they look like the best customers on a margin report. But 120 accounts placing frequent small orders eat $190k in delivery, handling and admin. Only $20k is left.
Chain B loses money. Its 15% margin after rebates does not cover the cost of serving it. On these numbers, Chain B costs more to serve than it earns in gross profit. Whether the business is better off without it depends on which of those costs would really go, as the next sections show.
Chain A is solid, and large. It earns $140k of contribution, but it is also 40% of sales. That is a separate risk, covered in our guide on customer concentration.
What to do with the answer
The tempting response is to drop the customers that lose money. Sometimes that is right. Usually there are better moves first.
Reprice
Start with the groups that earn least. Review rebates, discounts and free delivery for those accounts. Our guide on how to raise prices covers how much volume you can lose and still be ahead, and how to roll a rise out.
Change how you serve
Fewer delivery days for small accounts, online ordering instead of phone orders, phone contact instead of visits. Match the service to what the account earns.
Grow the good ones
Mid-size customers earn the most in total here. Find out what they have in common, and look for more like them.
Let go, carefully
If a customer still loses money after repricing and changes to service, it may be time to part ways. Check first which costs would really go with them.
Check which costs really go
This is where customer profitability analysis can mislead. The costs in the table are spread across customers using simple drivers. Not all of them disappear when a customer leaves.
If Chain B goes, its $45k of gross profit goes with it. The $40k of delivery and handling only goes if the truck runs fewer kilometres or a casual shift is cut. If the truck runs the same route anyway, that cost stays. The $25k of sales and admin time only saves money if someone's hours actually change. If none of the cost to serve goes, losing Chain B would cost the business $45k, not save it $20k.
So before you act, go through each cost line and ask: would we really spend less? Our guide on customer concentration shows the same kind of profit walk for losing a large customer.
Keep it simple and keep it going
The first version will be rough, and that is fine. The aim is to rank customers from best to worst, not to get every dollar right. Once you have the method, repeat it once or twice a year so you can see whether repricing and service changes are working.
It also helps to add contribution by customer group to your management reports, so new accounts are set up on terms that pay from the start.
Find out which customers pay their way
Business Improvement and Restructuring works out the real cost to serve each customer group, shows where pricing and service have drifted apart, and sets out practical changes your team can deliver. Quoted after a first call. Figures in this guide are hypothetical, not a forecast for your business.
See Business Improvement and RestructuringGeneral information only, not advice for your circumstances. See our terms.

