Client profitability analysis for service firms: How to find the projects that are quietly losing money

Your consulting firm earned $2.4 million last year with a 22% profit margin. Strong numbers. The business is healthy. Clients are happy, and the pipeline looks good.

But here is what you do not know: one client generated 40% of your profit while representing only 15% of your revenue. Another client consumed 20% of your team's capacity while contributing almost nothing to the bottom line. A third client, your longest relationship, has been losing money for two years.

You cannot see any of this in your aggregate P&L. The profitable clients subsidize the unprofitable ones, and the blended average looks fine. Client profitability analysis is the only way to see what is actually happening beneath the surface.

Why does your firm's overall profit margin tell you almost nothing about which clients are making you money?

Because the aggregate margin averages profitable and unprofitable clients together. A 25% blended margin might mean some clients earn 45%, others earn 5%, and some lose money. High-margin clients subsidize low-margin ones invisibly, and revenue growth can mask declining engagement margins as new clients come in below the existing average. The financial statements most service firms review show totals for revenue, labor costs, overhead, and profit. These numbers matter for understanding the overall business, but they obscure the variation that determines where value is created and destroyed.

1. Overall margins average profitable and unprofitable together. A 25% margin might mean every client earns 25%. More likely, it means some clients earn 45%, others earn 5%, and some lose money, with an average of 25%. The aggregate number tells you nothing about the distribution.

This matters because the management actions to improve margins differ significantly depending on the underlying reality. If every client earns a similar margin, you need to improve operational efficiency. If some clients earn great margins while others lose money, you need to fix or fire the unprofitable clients. The aggregate number points you toward the wrong solution.

2. High-margin clients subsidize low-margin clients invisibly. Your best clients are paying for your worst clients. The profit from the engagement where everything went smoothly covers the loss from the engagement that went sideways. The client who pays premium rates and never haggles funds the discount you gave the client who negotiated hard.

This subsidy is invisible unless you measure engagement profitability by client. You experience it as "some projects are harder than others" without quantifying how much harder or whether the revenue compensates for the difficulty.

3. Revenue growth can mask declining service engagement margins. A firm growing 20% annually can have declining margins that never show up in the aggregate numbers. If new clients come in at lower margins than existing clients, growth adds revenue while diluting profitability. The P&L shows more revenue and a similar profit percentage, but the underlying economics are deteriorating.

Growing firms often defer profitability analysis because growth feels like success. By the time growth slows and margin problems surface, the client mix has already shifted toward less profitable work.

What patterns emerge when you calculate a P&L for each client individually?

Profit concentration usually follows an 80/20 distribution, with 20% of clients generating 80% of profit. Some high-revenue clients that appear valuable actually destroy margin through scope changes, premium staffing, and partner involvement. Certain engagement types consistently underperform, visible only when enough engagements are analyzed to see the trend. When you actually calculate client-level P&L, the results are rarely what you expect. Patterns emerge that aggregate numbers never hint at.

1. Profit concentration follows an 80/20 distribution. Project profit analysis typically shows that a small percentage of clients generate a disproportionate share of profit. 20% of clients might generate 80% of the profit. Sometimes the concentration is even more extreme: 10% of clients account for 90% of the profit.

This concentration has strategic implications. Losing one top client is not the same as losing 10% of revenue. It is losing 30% or 40% of its profit. The retention, service, and relationship investment in top clients should reflect their actual profit contribution, not just their revenue.

2. Some clients appear valuable but destroy margin. Revenue and profit are not the same thing. A $400,000 client looks more important than a $150,000 client. But if the large client requires constant scope changes, premium staffing, and partner involvement while the smaller client runs smoothly with junior staff, the smaller client may be far more profitable.

Client profitability analysis frequently identifies "prestigious" clients that actually cost money to serve. The big logo, the impressive reference, and the interesting work all feel valuable. The margin says otherwise.

3. Certain engagement types consistently underperform. Beyond individual clients, patterns emerge by engagement type. Fixed-fee projects might consistently underperform time-and-materials work. Strategy engagements yield better margins than implementation engagements. Certain service lines might be structurally unprofitable.

These patterns only become visible when you analyze enough engagements to see trends. A single unprofitable project could be a matter of bad luck. Ten unprofitable projects of the same type suggest a pricing or scoping problem with that service.

What data do you need to calculate engagement profitability, and which piece is non-negotiable?

Direct labor cost by engagement is the non-negotiable starting point. Without accurate time tracking at the engagement level, the analysis is impossible. Direct client expenses, an overhead allocation methodology applied consistently, and actual collected revenue (not billed) complete the picture. Moving from aggregate financials to client-level P&L requires capturing and allocating costs that most firms track loosely, if at all.

1. Direct labor costs by engagement. This is the foundation. You need to know how many hours each team member spent on each client and what those hours cost you. Not the billing rate: the cost rate is salary plus benefits plus payroll taxes divided by available hours.

If your time tracking does not support engagement-level reporting, or if consultants do not log time accurately, you cannot calculate direct labor cost by client. The time data is the non-negotiable starting point.

2. Direct expenses allocated to clients. Travel, software, subcontractors, and other expenses incurred for specific clients need to be tracked to those clients. Many firms capture these expenses but do not link them to engagements, making them invisible in profitability analysis.

The allocation does not need to be perfect. Reasonable estimates are better than ignoring expenses entirely. But expenses that obviously belong to specific clients should be tracked there.

3. Overhead allocation methodology. The hard question in engagement profitability is how to handle overhead: rent, administrative salaries, technology, insurance, and other costs that benefit all clients but do not belong to any specific one.

Common approaches include allocating overhead as a percentage of direct labor cost, by revenue, or by hours consumed. Each method produces different profitability numbers for the same engagement. The right method depends on your cost structure and what you want the analysis to reveal.

What matters most is consistency. Pick a methodology, apply it consistently, and compare clients. The absolute margin matters less than the relative ranking of clients by profitability.

4. Revenue by engagement, including all billing adjustments. Finally, you need actual collected revenue by client, not billed revenue. Write-offs, discounts, credits, and collection failures all reduce what you actually receive. A client-level P&L based on billed amounts overstates profitability for clients where you discount or write off significant amounts.

How does having client-level P&L data change the decisions you make about pricing, staffing, and client selection?

It tells you which clients to retain and invest in, which to reprice or restructure, which to exit, and which engagement types to pursue or avoid. The founder managing by aggregate numbers makes gut-feel decisions about client value. The founder with engagement profitability data makes decisions based on actual contribution. Once you have client-level P&L visibility, decisions that seemed difficult become obvious.

You know which clients to retain and invest in for relationship development. You know which clients to reprice or restructure. You know which clients to exit gracefully. You know which engagement types to pursue more aggressively and which to avoid.

The founder who manages by aggregate numbers makes gut-feel decisions about client value. The founder who has engagement profitability data makes informed decisions based on actual contribution.

Building this analysis takes effort. Time tracking must be accurate. Expenses must be allocated. Overhead methodology must be defined. But the alternative is running a service business where the most important question (which clients actually make you money) cannot be answered.

Your aggregate margin hides a distribution. Some clients are far more valuable than the average suggests. Others are far less valuable. Client profitability analysis shows you which is which, and that visibility changes everything about how you price, staff, and select the work your firm takes on.