Customer Profitability Analysis: Who Actually Makes You Money?

Customer profitability analysis calculates what each customer actually earns after the costs of serving them, and in most B2B and wholesale businesses it reveals that a handful of customers deliver most of the profit while others, sometimes large and prestigious ones, deliver very little or lose money. The reason is that gross margin only counts the cost of the goods. Customers differ in discounts, rebates, freight, order patterns, service demands and payment terms, and those costs can erase a healthy gross margin. This guide gives a method for building a customer-level profit and loss, works a five-customer example in which gross margin and contribution rank the customers in opposite order, and sets out the actions that follow. It belongs to unit economics and budgeting and forecasting, builds on SKU profitability analysis and product margin analysis, and leads to channel profitability and product mix analysis.

Why gross margin is the wrong lens for customers

Two customers can buy the same products at the same list price and have very different profitability. One orders full truckloads quarterly, pays in 30 days and never calls customer service. The other orders small quantities weekly, wants special packaging and labeling, pays in 90 days, claims deductions and returns goods. Gross margin treats them the same. A customer P&L does not.

Building the customer P&L

A five-customer example

Assume a cost of capital of 8 percent. Financing cost for each customer is revenue × days sales outstanding (DSO) / 365 × 8%, rounded to the nearest hundred. For Customer 1: 2,000,000 × 30 / 365 = 164,384; × 0.08 = 13,151, rounded to $13,200.

Check C1: 1,200,000 + 80,000 + 60,000 + 40,000 + 13,200 = 1,393,200; 2,000,000 - 1,393,200 = 606,800; 606,800 / 2,000,000 = 30.3%. C5: 150,000 + 45,000 + 30,000 + 75,000 + 3,900 = 303,900; 300,000 - 303,900 = -3,900. Total revenue = 4,800,000; total contribution = 606,800 + 250,300 + 136,200 + 165,100 - 3,900 = 1,154,500, or 24.1%.

What the table shows

The rankings are reversed. On gross margin, C5 is best at 50 percent and C1 is worst at 40 percent. On contribution margin, C4 (33.0) and C1 (30.3) lead, and C5 is the only loss-maker. Gross margin ranks the customers almost in reverse order of the ranking that matters.

Different causes. C5 earns a high gross margin, because it pays high prices on small orders, but freight, rebates and service costs consume it. C3's problem is a cost to serve of 11 percent of revenue and payment terms of 90 days. C2 has terms of 75 days and high service cost.

C1 and C4. C1 provides $606,800, which is 52.6 percent of total contribution (606.8 / 1,154.5) on 41.7 percent of revenue. It also creates concentration risk. C4, the smallest customer apart from C5, has the best contribution margin, because it orders efficiently and costs little to serve. It may be the best customer to grow. See customer concentration risk.

Actions that follow

A conversation with a customer is easier with a number. For example, with C5 a $75,000 cost to serve, driven largely by small orders and special labels, could be addressed by a $25 order fee or a minimum order, which if applied to 1,200 orders a year would raise $30,000 and move C5 from -$3,900 to +$26,100. The customer can then choose to consolidate orders to avoid the fee. Alternatively, a 4 percent price increase on $300,000 of revenue adds $12,000.

Consumer and direct-to-consumer versions

The same idea works for consumers, using cohorts or segments in place of named accounts. Segment customers by acquisition channel, first product, order frequency, discount use and return rate, and calculate contribution after acquisition cost for each segment. Typical findings: customers who always buy on promotion earn far less than full-price buyers, and customers with high return rates may lose money despite high revenue. See cohort analysis and customer lifetime value.

Allocating sales and marketing

Sales and marketing cost belongs in a strategic review, since it determines whether a customer was worth winning. Allocate by sales time, number of orders or calls, or by direct tracking of key account management costs. Do not mix allocated costs into the day-to-day contribution used for pricing, since they will not vanish if the customer leaves.

Data practicalities

Start with what you have. A reasonable first version can be built from the ERP's invoice data, freight invoices, deduction records and a time estimate for customer service. Accept approximations for cost to serve at first, and refine with activity data. Tie the total contribution of all customers to the company's income statement, so that nothing is missing or double counted. Refresh quarterly.

The planning connection

Customer profitability depends on service levels and availability. Meeting a demanding customer's fill-rate targets may require extra inventory and expedited freight, which belongs in their cost to serve. Planning teams should know which customers are worth the premium. See demand planning and inventory optimization.

Common mistakes

• Using gross margin to rank customers.
• Ignoring rebates, deductions and payment terms.
• Allocating cost to serve by revenue.
• Dropping a customer without considering fixed costs that remain.
• Presenting results as a verdict instead of an opening for negotiation.
• Forgetting concentration risk.
• Analyzing once a year.

Taking the findings to the sales team

Customer profitability is sensitive, because it touches relationships and incentives. Present it as a tool for improving terms, not as a ranking of good and bad customers. Show account managers their customers' P&L alongside what each cost line would be at standard terms, and give them a toolkit of offers: tiered pricing, order minimums, delivery schedules and service packages. Change incentives so that managers are rewarded for contribution, not only for revenue. Without that, the analysis will be filed and forgotten.

FAQs

What is customer profitability analysis?

A method for calculating the profit each customer generates after the costs of serving them, including freight, rebates, service and financing of receivables.

How do you calculate customer profitability?

Start with net revenue, subtract cost of goods, freight, rebates, cost to serve and the cost of financing receivables to get customer contribution.

Why do large customers sometimes lose money?

Discounts, rebates, special service demands, long payment terms and freight can exceed the gross margin they provide.

Should I drop unprofitable customers?

Not before trying to fix the terms, prices and service levels. Dropping a customer helps only if avoidable costs exceed the contribution lost.

How often should I update customer profitability?

Quarterly is typical, and after large changes in pricing, contracts or costs.