Customer Profitability Sort

Why this question matters

The customer with the largest invoice total may also create the most revisions, urgent deliveries and collection work. Revenue alone does not reveal those costs. This tool compares revenue with direct delivery cost and additional service cost for up to eight customers or customer groups. It helps identify relationships whose operating economics deserve a closer look. The purpose is to improve the relationship model, not to label customers as good or bad people.

Use anonymous labels such as Customer A or Regional Retailers. The calculation does not need names, telephone numbers, contract details or personal information. Choose a consistent period for all rows. Enter the revenue earned from that customer group, the cost directly associated with delivering it and additional service costs that can be reasonably attributed. Keep those categories separate so that the same work is not counted twice.

Additional service cost may include unusual support time, bespoke reporting, repeated changes, special delivery arrangements or collection effort. Estimate the time using a defensible cost basis and keep notes outside the public tool. Distinguish a recurring pattern from an exceptional incident. If one unusual project distorted the period, compare a second period before drawing conclusions about the long term relationship. Averages become more useful when their limitations are visible.

Understand the method

1. Customer contribution = revenue − direct cost − additional service cost.
2. Customer contribution margin = contribution ÷ revenue × 100.

Customer contribution equals revenue less direct cost and additional service cost. The tool orders the entered relationships from lowest contribution upwards and reports the total contribution across the rows. It also identifies how many relationships have negative contribution. Where revenue is positive, the row note shows contribution as a percentage of that revenue. These outputs describe the entered period, not the lifetime value of the customer.

Read the amount and the percentage together. A modest percentage on a large relationship may still support substantial overhead, while a high percentage on a small relationship may contribute little in total. Then examine the capacity consumed and the timing of collection. A customer that pays reliably may be valuable in ways that this contribution calculation does not monetise. Conversely, a positive contribution can still require significant working capital.

Use the lowest rows to prepare a commercial conversation about scope and terms. Possible responses include clearer service boundaries, a standard delivery schedule, better order information, a revised package or a price that reflects genuine additional work. Review whether internal errors caused some of the service burden before attributing it to the customer. An improvement in your own process may protect the relationship and improve contribution at the same time.

Keep the result in perspective

This is a transparent planning calculation or self assessment, not a sector benchmark, professional valuation or a prediction of an outcome.

Use anonymous labels. Consider strategic value and contract terms before changing a relationship. Shared overhead is not allocated here.

Shared overhead is not allocated in this model, so the result is contribution rather than net customer profit. Allocation choices can also be subjective. A rough estimate of support time may be useful for prioritising investigation, but it should not be presented as a precise audited cost. Keep the method consistent when comparing customers, and check whether direct costs are avoidable if the relationship changes.

The tool does not estimate referrals, future growth, strategic learning, customer lifetime value or the legal consequences of changing a contract. A negative result is not an instruction to end a relationship. Consider commitments and the wider commercial context. Where no revenue is entered for a row, the percentage margin is unavailable even though the entered costs can still produce a negative contribution.

Read the full limitations or explore how Ayodeji approaches this work.