Profitability Analysis Granularity: From Company-Wide to Transaction-Level Insights
Why This Matters
The level at which you can analyze profitability determines the quality of every strategic and operational decision your organization makes. A company that can only see profitability at the enterprise level is like a physician who can only measure body temperature - the reading tells you something is off, but it cannot tell you where the problem is or what to do about it.
Cross-industry research consistently reveals that approximately 30% of every company's business is unprofitable. This unprofitable segment is not small or marginal - it includes products, customers, channels, and transactions that actively destroy value, consuming the profits generated by the healthy parts of the portfolio. The challenge is that without sufficient granularity, these loss-making elements are invisible, averaged away in aggregate profitability numbers that mask the true picture.
The economic impact of insufficient granularity is amplified by the whale curve phenomenon. When organizations first analyze profitability at the customer level with accurate cost data, they consistently discover that their top 20% of customers generate 150% to 300% of total reported profits, while the bottom 10% to 20% destroy 50% to 200% of that value. This pattern is remarkably consistent across industries, yet it remains invisible to any organization that cannot disaggregate profitability below the division or product-line level.
The Four Maturity Levels
Level 1: Company-Wide P&L Only
Profitability is visible only at the total company or entity level. The income statement shows total revenue minus total costs, but there is no systematic way to disaggregate this into product, customer, channel, or regional profitability.
Example from the Health Check: “We can only see profitability at the company-wide P&L level - no breakdown by product, customer, or channel.”
What this means in practice: Every product appears equally profitable on a percentage basis. Every customer looks the same. There is no basis for portfolio decisions, no way to identify where value is being created or destroyed, and no mechanism to prioritize improvement efforts. Strategic decisions default to revenue volume because there is no alternative signal.
Level 2: By Business Unit or Product Line
Profitability can be analyzed at the business unit, division, or major product line level. The organization can identify which segments contribute more or less to overall profitability, but cannot drill deeper within each segment.
Example from the Health Check: “We analyze profitability by business unit or major product line, but not at a more granular level.”
What this means in practice: This level enables strategic portfolio decisions at a macro level - which business units to invest in, which product lines to expand. However, it masks critical variation within each segment. A product line that appears marginally profitable may contain both highly profitable and deeply unprofitable individual products. A business unit may have customers generating enormous value alongside others that destroy it.
Level 3: By Product, Customer, and Channel
The organization can analyze profitability at the individual product, customer, and channel level. Multi-dimensional analysis is possible - examining how profitability varies when the same product is sold to different customers or through different channels.
Example from the Health Check: “We can analyze profitability by individual product, customer, and channel, including multi-dimensional views.”
What this means in practice: This level represents a significant capability leap. The organization can build whale curves, identify its most and least profitable customers, understand which products drive margins and which erode them, and compare channel economics. However, it still relies on averaged costs per product-customer combination rather than actual transaction-level cost attribution.
Level 4: Transaction-Level, Multi-Dimensional
Profitability is analyzed at the individual SKU, customer, and transaction level. Every order, invoice, service interaction, and delivery is costed based on the actual resources it consumed. The organization can slice profitability by any combination of dimensions simultaneously.
Example from the Health Check: “We analyze profitability at the individual SKU, customer, and transaction level with full multi-dimensional drill-down.”
What this means in practice: This is the level at which truly actionable insight emerges. The organization knows not just that a customer is unprofitable, but exactly which transactions, order patterns, and service demands are driving that unprofitability. Pricing can be customized to reflect the actual cost-to-serve. Resources can be allocated based on where they generate the most value. Every strategic and operational decision is supported by precise, granular profitability data.
How to Move Up: Practical Steps
From Level 1 to Level 2: Segment Your P&L
- Structure your chart of accounts to capture revenue and direct costs by business unit or major product line
- Allocate indirect costs to segments using the best available driver data, even if imperfect
- Produce monthly segment profitability reports and identify which units are above and below average margin
- Present segment-level results to leadership to build appetite for deeper granularity
From Level 2 to Level 3: Build Product and Customer Profitability
- Assign costs to individual products using activity-based or multi-pool allocation methods
- Build a customer profitability model that captures revenue, cost of goods sold, and cost-to-serve for each customer
- Create your first whale curve to visualize profit concentration across your customer base
- Establish quarterly profitability reviews where product and customer results are discussed with operations and commercial teams
From Level 3 to Level 4: Implement Transaction-Level Costing
- Implement TDABC with time equations that assign costs based on actual transaction characteristics (order size, complexity, channel, delivery requirements)
- Integrate transactional data from ERP, CRM, and operational systems into a dedicated costing platform
- Build self-service dashboards that allow business users to explore profitability by any dimension combination
- Reduce reporting cycle time from weeks to days so profitability data is available when decisions are being made
Industry Benchmarks
| Industry | Typical Level | Key Challenge |
|---|---|---|
| Manufacturing | Level 2–3 | 91% prepare product profitability analysis, but only 74% do customer profitability; transaction-level remains rare |
| Healthcare | Level 1–2 | Per-procedure profitability is critical for resource allocation but rarely available outside leading academic medical centers |
| Financial Services | Level 2–3 | Product proliferation demands granular analysis; leaders achieve transaction-level visibility across millions of accounts |
The median score for manufacturing companies on profitability granularity is 2.4 out of 4. Healthcare averages 1.7. Financial services leads at 2.6, with top performers achieving full transaction-level visibility across their entire portfolio.