A large customer can generate less profit than a smaller, simpler account
Build customer-profitability MIS from net customer revenue, matched product or delivery costs, and the activities required to serve that customer. Show unallocated common costs separately and reconcile back to the entity’s books. Revenue rank and product gross margin alone can miss repeated small orders, urgent deliveries, returns, support work and expensive credit terms. A reported customer loss after allocated common costs is also not, by itself, a reason to stop serving that customer.
This is an internal management-analysis method, checked on 23 October 2026. It does not prescribe a new statutory accounting policy, an Ind AS segment-disclosure requirement or a tax deduction. ICAI’s profitability-analysis teaching material, including customer-wise analysis and ICAI’s activity-based-costing material provide the conceptual foundation. The customer cases, reconciliation and decision controls below are original applications; the older teaching material is used for management concepts, not as evidence of a 2026 statutory amendment.
Use a layered customer statement with clearly named subtotals
| Layer | Build it from | What the subtotal means |
|---|---|---|
| Net revenue | Gross sales less supported customer discounts, returns and rebates on a consistent reporting basis | Revenue attributable to the customer after the defined adjustments |
| Product/service delivery cost | Matched cost of the goods or services actually reflected in net revenue | Customer gross profit on the stated cost basis |
| Assigned cost to serve | Orders, dispatches, visits, support, returns and other causally supported customer activities | Customer surplus after the defined assigned costs, before unallocated common costs |
| Separate management adjustments | Explicit funding or risk assumptions where useful | A decision view, reconciled separately if not part of accounting profit |
| Entity reconciliation | Unallocated common costs, unused capacity and other reconciling items | Connection between customer analysis and the books |
Use consistent names. A subtotal after allocated fixed service costs is not automatically the same as variable-cost contribution. State whether costs are actual, standard, absorbed, incremental or avoidable. If the dashboard uses both a fully assigned performance measure and a decision contribution, show both and explain the bridge. Avoid comparing one customer’s fully loaded margin with another’s contribution before overhead.
Assign service costs through evidenced activity drivers
Create cost pools from the general ledger and operational records. Identify which activity consumes the resource: order lines processed, dispatches, support hours, return cases or documented kilometres may be better drivers than sales value for particular costs. Choose the driver for its causal fit and data quality, not because it happens to produce the desired customer ranking. Keep direct customer expenses out of a shared pool if they are already charged separately.
Retain the cost-pool amount, period, denominator, rate, customer activity quantity and allocated amount. Reconcile all allocated amounts and any unassigned balance to the original pool. A change of driver or denominator can move margin between customers without changing the entity’s cash or profit; explain the policy change and restate comparatives where necessary for a meaningful management comparison.
Show unused capacity rather than hiding it in a customer rate
Management may choose an actual-volume absorption view or a separately labelled capacity-based view for a service pool. Define the approach before calculating it. A lower activity denominator spreads a fixed pool over fewer events and can make customers appear more expensive even when their service behaviour has not changed. A practical-capacity view can instead isolate the unconsumed resource cost. Neither view creates cash savings merely by changing an allocation rate.
Use stable measurement periods and investigate operational changes. If a customer consolidates shipments, compare like-for-like delivery costs and service levels. A reduction in assigned activity cost may include both avoidable spending and staff or equipment capacity that remains paid for. Separate realised cash saving from capacity released for another productive use.
Treat credit and commercial decisions as explicit additional layers
If management wants a funding charge, specify the receivable balance, assumed funding rate and time basis. An average balance multiplied by a monthly management rate is a model assumption, not automatically the actual loan interest booked for that customer. Likewise, a chosen risk charge for collection uncertainty is not itself an Ind AS 109 expected-credit-loss calculation or a deductible bad debt. Reconcile these management overlays separately from recorded finance costs and impairment.
Before changing prices or ending an account, distinguish assigned cost from cost that would actually disappear. Consider contractual exit costs, replacement demand, service commitments, capacity constraints and customer relationships. An account that appears loss-making after an arbitrary common-cost allocation may still generate positive avoidable contribution. Conversely, a positive gross margin can conceal a service pattern that consumes scarce resources.
Reconcile the dashboard and convert it into a measured action list
Link net revenue to customer-coded sales and credit notes, product costs to the relevant accounting basis, and service pools to the ledger. Separate tax collected on behalf of government from the chosen revenue base and avoid mixing tax-inclusive receivables with an unexplained tax-exclusive funding denominator. Unassigned costs and timing differences should be visible reconciling lines, not silently spread to force every customer’s result to look complete.
The action report should name the commercial change, owner, baseline and expected measurable effect: order consolidation, minimum dispatch size, return reduction, collection improvement, support terms or selective repricing. Review actual outcomes against the approved case. A customer ranking is useful only if management can see which part reflects behaviour, estimation, accounting policy or an actionable change.
Worked illustrations
These illustrations use fictional facts and expressly stated assumptions. Amounts are Indian rupees unless a different currency or unit is specified. They are independent examples, not findings about any actual client.
Illustrative example 1: Start with net revenue and matched costs
Gross customer sales are ₹10,00,000, supported discounts ₹1,00,000 and returns ₹50,000. Net revenue is ₹8,50,000. Assume matched product cost after the relevant return adjustments is ₹5,50,000, giving gross profit ₹3,00,000. Assigned customer service cost ₹40,000 leaves ₹2,60,000 before unallocated common costs, or 30.59% of net revenue rounded to two decimals. This is the defined customer subtotal, not the entity’s final net margin.
Illustrative example 2: Equal sales and gross profit, different service use
Customers A and B each have net revenue ₹5,00,000 and product cost ₹3,50,000. Assumed activity rates are ₹500 per order, ₹1,000 per dispatch and ₹1,500 per support hour. A uses 10 orders, 5 dispatches and 2 hours: cost ₹13,000, leaving ₹1,37,000. B uses 50 orders, 20 dispatches and 10 hours: cost ₹60,000, leaving ₹90,000. The customer-subtotal difference is ₹47,000 despite identical gross profit.
Illustrative example 3: Make the capacity denominator visible
A service pool costs ₹1,20,000. Actual activity is 600 orders, while the separately evidenced practical capacity is 1,000 orders. Actual-volume absorption gives ₹200 per order and ₹8,000 for a 40-order customer. A defined practical-capacity view gives ₹120 per order and ₹4,800 for that customer; total used-capacity cost is ₹72,000 and unused capacity ₹48,000. The customer difference of ₹3,200 is a measurement-policy effect, not a cash saving.
Illustrative example 4: Separate funding and risk assumptions
A customer subtotal is ₹50,000 before management overlays. Average receivables are ₹4,00,000; assume a 12% annual funding charge using exactly one-twelfth of a year. The charge is ₹4,000. A separately assumed internal risk charge is ₹6,000, leaving a management-adjusted result of ₹40,000. Neither assumed overlay is automatically the booked finance expense, statutory impairment or tax deduction.
Illustrative example 5: A common-cost allocation can reverse the apparent answer
A customer contributes ₹30,000 after all costs that would be avoided if the account stopped. An allocated common overhead of ₹50,000 produces a reported fully assigned loss of ₹20,000. If that common overhead will not fall and there is no replacement use of capacity, dropping the account reduces entity profit by ₹30,000, ignoring other changes; it does not save the allocated ₹50,000.
Illustrative example 6: Distinguish activity reduction from cash saving
Dispatches fall from 40 to 10 at an assigned rate of ₹600 each. Assigned dispatch cost falls from ₹24,000 to ₹6,000: reduction ₹18,000. Assume only 60% of that rate represents spending actually avoidable with fewer dispatches. Cash saving is ₹10,800; the remaining ₹7,200 represents assigned capacity cost released, not an automatic bank-cash saving.
Illustrative example 7: Replacing an account has transition economics
Assume retaining the current customer produces ₹1,20,000 avoidable contribution for the next year. A feasible replacement using the same constrained capacity produces ₹1,70,000, but requires ₹30,000 incremental transition spending. The isolated first-year improvement is ₹1,70,000 − ₹1,20,000 − ₹30,000 = ₹20,000. Confirm contracts, actual capacity and replacement demand before acting; this is not a discounted multi-year valuation.
Illustrative example 8: Bridge customer results back to entity profit
In a separate fictional portfolio, customer subtotals after assigned service costs are ₹2,60,000, ₹1,37,000 and ₹90,000: total ₹4,87,000. Unallocated central costs are ₹2,00,000 and separately identified unused-capacity cost ₹48,000. With no other reconciling items, entity operating profit is ₹2,39,000. Do not leave the ₹2,48,000 difference between customer totals and entity profit unexplained.
Ten-step verification table
| Step | Verification | Evidence to retain |
|---|---|---|
| 1 | Define customer and reporting scope | Entity, period, customer IDs and aggregation policy |
| 2 | Reconcile net customer revenue | Sales, discounts, rebates and credit-note schedule |
| 3 | Match product/service delivery costs | Consistent cost basis and return adjustments |
| 4 | Identify direct and pooled service costs | Ledger-linked pools with no double allocation |
| 5 | Validate activity drivers and quantities | Operational evidence, owner and period cut-off |
| 6 | Approve the denominator and rate method | Actual-volume or capacity policy and unused-cost treatment |
| 7 | Separate management overlays | Funding/risk assumptions and bridge to accounting entries |
| 8 | Test action economics using avoidable costs | Contract, capacity, transition and replacement-demand evidence |
| 9 | Reconcile all customers to the entity result | Common costs, unused capacity and timing differences |
| 10 | Measure commercial actions against outcomes | Owner, baseline, target saving and actual cash/capacity effect |
Sixteen practitioner FAQs
1. Is the highest-revenue customer necessarily the best customer?
No. Discounts, returns, product costs, service intensity and collection behaviour can materially change the result.
2. Should analysis begin with invoiced gross sales?
Reconcile gross sales, but use a clearly defined net-revenue measure after relevant customer adjustments for the profitability calculation.
3. Can returns be deducted without changing product cost?
Match the cost treatment to the actual accounting and commercial facts. Leaving unrelated cost amounts can distort the margin.
4. Why not allocate every cost by revenue?
Some activities are driven by orders, dispatches or support time rather than sales value. Choose a supported causal driver for each pool.
5. How should directly identified customer expenses be treated?
Assign them directly where appropriate and exclude them from any pool that would charge them again.
6. Is customer surplus always variable-cost contribution?
No. An assigned service pool can include fixed costs. Name the subtotal and distinguish it from an avoidable-contribution decision view.
7. Can the activity rate change profit without operational improvement?
It can change assigned customer results when the denominator or policy changes. Explain the effect and reconcile to entity costs.
8. Should unused capacity be forced onto active customers?
State the chosen measurement policy. A separately identified capacity view can show unused cost explicitly rather than concealing it in the rate.
9. Does a lower allocated cost prove a cash saving?
No. Distinguish spending actually avoided from paid-for capacity released for possible alternative use.
10. Is an internal receivable funding charge actual bank interest?
Not automatically. It is a model assumption unless supported by the actual financing allocation; keep its time and rate basis explicit.
11. Is a management risk charge an Ind AS 109 provision?
Not by itself. Statutory impairment requires its own applicable measurement analysis; do not relabel a dashboard assumption as a compliant provision.
12. Should every loss-making customer be dropped?
No. Examine avoidable contribution, costs that would remain, exit obligations and replacement opportunities before deciding.
13. How should replacement demand be assessed?
Use evidenced feasible demand, constrained capacity and incremental transition costs rather than comparing optimistic revenue alone.
14. Can this model replace statutory segment reporting?
No. Internal customer analysis and applicable financial-reporting disclosure requirements are separate frameworks.
15. What makes the reconciliation complete?
Customer subtotals plus clearly shown common costs, unused capacity, overlays and other timing/classification differences should explain the entity result.
16. What should management do with the ranking?
Assign a specific commercial or operational action, owner and measurable baseline, then distinguish achieved cash savings, capacity release and changes caused only by allocation policy.
Conclusion
Use the customer statement to identify a measurable commercial change. Reconcile the result to books and distinguish assigned costs, avoidable spending and capacity that remains available.