Level 7, 55 Collins Street, MelbourneMon to Fri, 8.30am to 6pm03 8375 4177
Performance · 7 min read

Customer profitability: which customers actually make you money

How to work out profit by customer: start with gross margin, add the cost to serve each one, read the results, and decide what to do with customers who earn you little or nothing.

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.

Hypothetical example · food service distributor, $3.0m sales, four customer groupsChain B costs more to serve than it earns in gross profit.
Customer groupSalesGross profit after rebatesDelivery and handlingSales and admin timeContribution
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.

Hypothetical example · same distributor, contribution by customer groupThe best gross margin leaves almost nothing behind.
$0 Chain A Mid-size Small Chain B $1.2m sales, 20% GM $0.9m sales, 30% GM $0.6m sales, 35% GM $0.3m sales, 15% GM $140k $180k $20k -$20k best margin, almost nothing left Contribution after delivery, handling, sales and admin time

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.

1

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.

2

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.

3

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.

4

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.

A note on the figures and contracts. Every number in this guide is made up. How costs are spread will differ in your business. Changing prices, service levels or terms for existing customers may be limited by your contracts. Get legal advice before you change or end a customer agreement.

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 Restructuring

General information only, not advice for your circumstances. See our terms.

Tell us about the decision.

We reply within one business day with whether we can help, the service we would start with and its fixed fee.

Call 03 8375 4177Speak with an adviser