Consider a mid-sized industrial equipment distributor in Bursa: their longest-standing client, a large factory, places regular monthly orders but pays on a forty-five day term, requires at least two sales visits per week, and generates a steady stream of returns and technical support requests. Another client orders once a quarter, pays upfront, and never causes problems. Looking at the revenue table, the factory appears to be the most valuable customer. But when a real profitability calculation is done, the picture can flip entirely. This is exactly where customer profitability analysis comes in, replacing intuitive judgment with data-driven evaluation.
Customer profitability analysis compares the revenue generated from a customer against the total cost of serving that customer. The cost side goes well beyond the cost of goods sold — it includes sales visits, order processing time, return handling, collections follow-up, technical support, and even storage allocation. Most of these costs get absorbed into general overhead and become invisible on a per-customer basis. Analytical reporting tools address this by distributing overhead costs to individual customers using activity-based costing logic, producing a true profitability picture for each account.
The software used for this kind of analysis typically sits on top of an ERP system, or pulls data from platforms like SAP, Logo, or Netsis via ODBC connections or flat file exports into a separate reporting layer. Order, invoice, and cost data held in the ERP is transferred to the reporting tool, which then generates customer-level profit and loss statements, service cost breakdowns, and segment comparisons. Reports can be reviewed on screen or printed out and brought to management meetings.
The most immediate benefit of this analysis is making the ‘high revenue, low profit’ trap visible. Customers with large order volumes but long payment terms, high return rates, or heavy post-sale support requirements often end up at the bottom of the profitability ranking. When analytical reporting identifies these accounts individually, the manager reaches a concrete decision point: renegotiate pricing, change service terms, or reduce the resources allocated to that relationship. The intuitive ‘this customer is important’ judgment gives way to a measured assessment.
A second significant benefit is the clarification of what a profitable customer profile actually looks like. Once it becomes clear which sectors, company sizes, and payment behaviours consistently produce higher net margins, the sales team’s energy can be directed toward that profile. The same profile can serve as a screening criterion for new customer acquisition. This approach delivers a noticeable efficiency gain particularly in SMEs where the sales team is small and cannot dedicate equal time to every account. A third benefit is that it provides a foundation for pricing decisions: customer segments with high service costs can be assigned dedicated price lists or minimum order quantities.
That said, there is a real obstacle standing in the way of this kind of analysis: data quality. Calculating service cost per customer requires that sales visit durations, return transactions, and support requests are entered into the system consistently. In many SMEs, this data is either not recorded at all or maintained differently by different people. Sales reps report their visits by e-mail, return records sit in a separate spreadsheet, and technical support calls exist only in verbal exchanges. This fragmented structure directly affects the reliability of the data being fed into the analytical reporting tool. Standardising data collection processes therefore becomes a more urgent step than selecting the analysis software itself.
For an SME manager evaluating customer profitability analysis, the key question should be: how complete is the per-customer cost data in our current ERP or accounting system? If most service costs are being absorbed into general overhead, the first task is to define a methodology for how those costs will be allocated. Once the analytical reporting tool is configured according to that methodology, the first report typically delivers a surprise: the largest customer is often not the most profitable one. That surprise becomes the starting point for concrete action — on pricing, on service conditions, and on how customer relationships are managed going forward.
This article was originally written in Turkish by Gökhan MERCANOĞLU on April 6, 2009 and has been automatically translated into English and other languages using machine translation.