Profitability Analysis by Customer: Your Biggest Client Might Not Be Your Best One

There's a conversation I've had more times than I can count with finance leaders at professional services firms. It usually starts with something like: "We know roughly which clients are profitable, but we've never actually run the numbers properly."

When we do run the numbers properly, the results are almost always surprising. The largest client by revenue is rarely the most profitable. The account that feels high-maintenance usually is. And somewhere in the portfolio, there are typically one or two relationships that look fine on the surface but are quietly consuming a disproportionate amount of resource for the return they generate.

Why Revenue Is a Misleading Proxy for Client Value

The problem starts with how most firms measure client performance. Revenue is visible, easy to track, and emotionally satisfying when it's large. Nobody is immediately measuring what it costs to actually service that relationship.

Cost to serve is the metric that changes the picture. It captures everything that goes into maintaining a client relationship: direct delivery time, account management, reporting, support queries, bespoke work that wasn't fully scoped. When you add all of that up and subtract it from the revenue, you get the actual margin — and that number can look very different from the revenue figure.

In professional services particularly, cost to serve varies enormously between clients of similar revenue size. A high-touch client who requires weekly check-ins, custom deliverables and frequent escalations might be generating half the margin of a lower-revenue client who's straightforward to work with and rarely needs anything outside the agreed scope.

The Data Problem That Sits Behind Most Customer Profitability Work

Here's the honest reason most firms haven't done this analysis properly: the data is hard to pull together.

Revenue lives in your finance system. Time and resource data lives in your project management or time-tracking tool. Client interaction data lives in your CRM. To get a complete picture of what a client actually costs to serve, you need all of these sources connected and speaking the same language.

Most firms don't have that. The result is that customer profitability analysis, when it happens at all, tends to be a manual spreadsheet exercise that takes weeks, is already out of date when it's finished, and can't be repeated next quarter without doing the whole thing again from scratch.

Getting this right is a data architecture problem before it's an analysis problem. You need a unified environment where client-level cost and revenue data comes together automatically.

How to Structure a Customer Profitability Analysis

Step 1 — Direct revenue per client. Total fee income attributable to each client, net of discounts and write-offs. Most firms have this readily available. Everything that follows gets more complicated.

Step 2 — Assign direct costs. Delivery team time, direct expenses, subcontractor costs. If your team codes time consistently against client matters, this should be extractable. If they don't, this is usually where the data quality issues first become apparent.

Step 3 — Allocate indirect costs using activity-based logic. Account management, BD effort, compliance overhead, finance and admin support — these need to be allocated based on actual consumption, not a blanket percentage of revenue. Activity-based costing is the right methodology: identify the activities that generate overhead, assign costs to clients based on actual usage data where you have it, and reasonable proxies where you don't.

Step 4 — Calculate and segment. Plot your clients on a matrix — revenue on one axis, margin on the other. The segmentation becomes visually obvious. High revenue, healthy margin. High revenue, weak margin. Low revenue, surprisingly strong margin. Each segment has a different strategic implication.

What to Do With What You Find

The point isn't to fire your least profitable clients immediately. It's to make informed decisions about where to invest, how to price, and what conversations to have.

For clients with strong revenue but weak margins, the question is usually pricing or scope drift. Either the relationship is underpriced relative to the service intensity it requires, or work is being done that wasn't properly agreed or charged. Both are fixable — but you need the data to have the conversation.

For clients with weak revenue and weak margins, the calculation is simpler. Unless there's a genuine strategic reason to retain the relationship, these are worth a frank conversation about repositioning or letting go.

For your genuinely high-value clients, the analysis tells you where to protect and invest. These are the relationships worth deepening.

Making This a Continuous Process

The real value comes from running this regularly rather than treating it as an annual project. When your cost allocation logic is embedded in the system and your data sources are connected, customer profitability reports become part of your standard monthly close — a live management tool rather than a historical snapshot.

Paired with scenario modelling — what happens to our margin mix if we reprice this segment, or if we win more of this type of client — it becomes a forward-looking planning tool as well.

Frequently Asked Questions About Profitability Analysis by Customer

How is customer profitability different from product profitability?
Product profitability measures the margin on what you sell. Customer profitability measures the margin on who you sell to. Two clients buying the same product at the same price can have very different profitability profiles depending on how much resource they consume in the process.

What data do you need to run this analysis?
At minimum: revenue by client, direct delivery costs by client, and a methodology for allocating shared overhead. Data quality varies significantly between firms, and the first step is usually understanding what you actually have before deciding how to structure the analysis.

How should you handle clients who are unprofitable but strategically important?
Identify them explicitly as strategic investments and put a number on what you're spending. The risk of keeping unprofitable clients in a general pool is that the cost never gets surfaced. When you name it as a strategic investment with a defined rationale and a review date, you're making an active choice rather than an accidental one.

How often should customer profitability be reviewed?
Quarterly at minimum. The more dynamic your client base, the more frequently the picture changes — and the more valuable regular monitoring becomes.

Where to Start

If you've never run a proper customer profitability analysis, or if you've run one and found the data quality wasn't good enough to trust the results, the starting point is understanding what your current data environment actually looks like.

We built a free 5-minute Finance Readiness Assessment that covers exactly this. Take the assessment here and get a clear picture of where the gaps are.

Propriety Group specialises in EPM and CRM implementation for professional services firms. We help finance teams build the visibility they need to make confident decisions.