Customer profitability reporting

The largest customer is not necessarily the most profitable. Large accounts often bring smaller orders, more delivery points, more returns, custom packaging, and longer payment terms. Revenue ranking counts the benefit and ignores the cost of serving it.

Small orders are the usual culprit. An account that places ten orders a month for small quantities can consume more picking, packing, and delivery time than an account twice its size that orders once a week. Revenue per order hides that difference.

Customer profitability reporting puts a profit and loss account behind each account. The aim is not precision to two decimal places. It is a reliable ranking that shows which accounts fund the business and which consume it.

Start with net revenue after discounts, rebates, and returns. Deduct cost of goods sold to get gross margin. Then deduct the costs incurred to serve that customer: order processing, picking, delivery, installation, support, returns handling, payment fees, and account management.

Show contribution after those costs before allocating fixed overhead. Contribution is the number a sales team can influence; fully loaded profit is the number the board sees. Publishing both, clearly labelled, avoids arguments about allocations.

Use the same revenue definition as the management accounts, and keep cost of goods sold on the same standard or actual basis. If the customer profit and loss uses a different margin from the product report, the two will disagree and trust in both will fall.

Allocating cost to serve by revenue assumes a large customer costs proportionally more to serve, which is rarely true. Use activity drivers: number of orders, deliveries, support tickets, return units, or hours booked.

Keep the number of drivers small. Four or five cost pools are enough for most small and mid-sized businesses. More precision than the underlying data supports creates confidence without accuracy.

A simple test of a driver is whether the cost would disappear if the activity stopped. If cancelling a weekly delivery removes the cost, the delivery count is a valid driver. If the cost remains, it belongs in fixed overhead.

Plot margin percentage against revenue and mark the quadrants. High revenue with healthy margin is the core. High revenue with thin margin needs a service or price review. Low revenue with high margin is a growth candidate. Low revenue with negative margin needs a decision.

Also look at cumulative profit. Test whether a small group of accounts carries the total, and check what happens to the business if one of them leaves.

The quadrant view is a conversation starter, not a verdict. An account in the low margin quadrant may still be worth keeping for cash flow, capacity fill, or access to a market.

Use the analysis to set service tiers rather than to shame customers. A tier can define order minimums, delivery frequency, support response, payment terms, and whether customisation is chargeable.

Set thresholds in advance and apply them for a full quarter before changing anything. A customer that looks unprofitable in one busy month may look different over a year, especially if the cost allocation is new.

For example, a tier might require a minimum order value, charge for deliveries below it, and reserve named account management for accounts above a contribution threshold. The rules should be published, not applied quietly to one customer.

Do not allocate all overhead by revenue and call the result customer profitability. Do not ignore growth potential or strategic value. Do not use last year's cost rates. And do not publish a ranking without a plan for the accounts at the bottom.

Review the model annually, refresh the cost rates, and check a sample of accounts against the ledger. A customer profit and loss is a decision tool, not an audited statement.

Finally, check the direction of causation. A customer may look expensive because the relationship is new and still ramping, or because a temporary service issue generated support calls. One year of data is a better basis than one quarter.