Customer profitability: compare revenue, cost to serve and payment terms
Compare customer revenue, service and fulfilment costs, and the capital tied up in receivables on a consistent basis.
A customer buying RMB 36 million a year may not contribute more to the business than one buying RMB 24 million. Dedicated promotions, split deliveries, after-sales work and a long payment term can absorb the apparent advantage. Compare both accounts on the same period and cost basis before deciding where to invest the sales team's time.
The useful starting point is attributable operating contribution: sales after relevant returns, less product cost and the additional costs of serving that customer. Assess the funding tied up in receivables separately, and then consider capacity, credit exposure and the relationship's future potential.
A larger account can contribute less
Assume one company supplies customers A and B over one financial year. The table is in RMB millions, excluding VAT. Revenue and corresponding product costs have already been adjusted for returns and allowances relevant to that year. Each serving cost relates to the same year's business and is not already included in another line.
| Item | Customer A | Customer B |
|---|---|---|
| Revenue after returns and allowances | 36.0 | 24.0 |
| Product cost | 23.0 | 14.0 |
| Revenue less product cost | 13.0 | 10.0 |
| Customer-specific promotions and channel services | 1.8 | 0.8 |
| Attributable warehousing and delivery | 3.0 | 1.6 |
| Attributable customer support and after-sales work | 1.6 | 0.6 |
| Attributable operating contribution | 6.6 | 7.0 |
A generates RMB 12 million more revenue but RMB 400,000 less contribution under this calculation. Promotional and channel service fees here are separately borne by the business. If a channel deduction has already reduced the revenue line, do not subtract it again.
This contribution is not accounting net profit: it does not deduct all company-wide overhead, income tax or other unallocated items. For shared warehouses, support teams or delivery routes, document a defensible allocation using evidence such as shipments or staff time. Keep amounts that cannot be allocated reliably visible rather than spreading every head-office cost by sales. ACCA's explanation of activity-based management describes using activities and cost drivers to understand customer profitability.
Measure what payment terms tie up
Suppose A's average outstanding receivables for the year are RMB 15 million, and B's are RMB 5 million. For this management comparison the company assumes an annual 8% opportunity-cost rate. The balances reflect actual collections and only amounts attributable to the respective customer during the period.
| Payment-term comparison, RMB millions | A | B |
|---|---|---|
| Average receivables balance | 15.0 | 5.0 |
| Opportunity cost: average balance × 8% | 1.2 | 0.4 |
| Contribution after opportunity cost | 5.4 | 6.6 |
A's adjusted management comparison is RMB 1.2 million below B's, even though A has the higher sales. The 8% rate is an assumption, not a market quote. Select a rate relevant to the company's funding constraints and test how a different rate changes the conclusion.
Opportunity cost is a management measure; it is not necessarily interest paid, an accounting expense or a tax deduction. Avoid deducting the same financing cost twice if an equivalent charge is already included above. Outstanding principal is not itself a loss: past-due balances, credit exposure and impairment need their own assessment. Calculate the average from periodic balances when possible rather than treating the year-end balance as the year's average. Start with a receivables and bank receipt reconciliation.
Build a comparison finance and sales can both review
- Contracts and entities: Decide whether entities in one customer group should be shown separately or together; document prices, rebates, channel services and credit terms.
- Sales and returns: Reconcile order, delivery, revenue and return timing. Keep VAT-inclusive orders, VAT-exclusive revenue and cash receipts distinct.
- Product and fulfilment: Match cost to the products and shipments sold, then review warehousing, transport, expedited orders, refused deliveries and return logistics. Explain shared-cost drivers.
- Promotions and service: Identify dedicated campaigns, platform fees, onsite support, customer service, repair and rework. Check whether another line already contains them.
- Receivables and disputes: Match due dates to bank receipts, ageing and disputed amounts; an amount not yet due is not automatically a bad debt.
Where records are incomplete, show the verified portion and the gap. A supported cost range can be more useful than inserting zero; test whether the customer ranking changes across that range.
Turn the comparison into a commercial decision
For a strategically useful but lower-contribution account, model changes separately: consolidate deliveries, reduce special handling, renegotiate rebates, charge for a dedicated service or shorten payment terms. Check contractual commitments and the effect on service before making changes. A high-contribution account may still create concentration, credit or supply risk. Document credible future opportunities separately rather than adding unearned sales to realised contribution.
Once revenue, cost and collection records have been aligned, see the profit analysis example, or contact CaiGeek, an AI financial assistant for small and medium-sized businesses.
Move the work forward with CaiGeek.
Start with your question, supported by business context, data and memory.