How to find out which of your clients are losing you money

The math is not the hard part. Looking at the numbers is.

If you entered your real top clients into the calculator above, one of two things just happened. Either every client came out green (in which case nudge the overhead allocation higher and look again), or at least one client came out red. The red row is the reason this article exists.

The 2024 Sortlist Agency Operations Survey found that 22% of small-agency clients are unprofitable once overhead is fully allocated. But the same survey found only 8% of agency owners could name which clients those were before they ran the numbers. Most agency owners run their book on instinct rather than data, and the instinct mis-predicts which clients are good for the business.

The reason instinct fails: profitability is not the same thing as revenue, not the same thing as effort, and not the same thing as how much you like the client. A client can feel easy to serve and still lose you money. A client can feel demanding and still be your highest-margin account. The calculator above strips out feeling and shows what the numbers say.

Why long-tenure clients drift into unprofitability.

If the calculator surfaced a loss-client, you can almost certainly predict its tenure: it is one of your longest-running accounts. The 2024 Harvest Agency Profitability Study found unprofitable clients were disproportionately the long-tenure ones. Four patterns explain why.

Pattern 1: Scope creep that never got re-quoted.

You started with a defined scope. Over the months a few extra requests came in and you absorbed them, because the relationship felt collaborative. Eighteen months later the scope is 40% larger than what was originally priced, but the price is the same. The account looks profitable until you log the actual hours.

Pattern 2: Communication overhead nobody is billing.

Long-tenure clients call more. They text. They drop in. The relationship is closer, which is good for retention but invisible in your billing. A 30-minute "quick call" three times a week compounds to roughly six hours a month of un-billed senior time. If your senior rate is $150, that is $900 a month of free work that never appears on an invoice.

Pattern 3: Your cost base went up. The price did not.

Three years ago, your team cost $40 per hour loaded. Today, $55. Their account was profitable at $40 because your cost was lower. It is no longer profitable at $55. Most agencies do not re-price existing accounts when their internal cost base rises. The 2024 AgencyAnalytics Pricing Survey found 73% of agencies raised rates less often than every 18 months.

"We did our first profitability audit and found that the client we had had longest, the one we kept saying we couldn't afford to lose, was actually negative-$12k on the year." — r/agency, 2024.

Pattern 4: Subcontractor markup you forgot to set.

When you started using a freelance designer at $50 per hour, you billed them through at $80 (a 60% markup) to cover management, payment processing risk, and overhead. Then your designer raised their rate to $70 per hour, and you forgot to bump the pass-through price. Now you bill $80 for a $70 cost, plus admin time, and lose money on every hour they work.

What to do when you find a loss-client.

Three options, in order of preference. Most agencies should attempt them in that order rather than jumping to the third.

Option 1: Re-price.

Have the rate conversation, backed by the data the calculator just produced. Frame it as an annual scope and rate review. Pick a renewal moment such as a fiscal year boundary or a contract anniversary. Tell the client in writing 60-90 days ahead. Justify with value delivered and the changing cost base, not with apology.

The clients who accept the re-price are the relationships worth keeping. The clients who push back hardest are often the ones to release.

Option 2: Re-scope.

If the client cannot afford the right price, reduce what you deliver until the price you currently charge actually covers the work. Make the trade-off explicit. "At this price, here is the work we can do. Anything beyond that scope is billed separately at $X per hour."

Re-scoping is harder than it sounds because you have to stop doing the things you have been giving away. But it is the right move when the relationship is genuinely valuable and the client genuinely cannot afford a re-price.

Option 3: Release.

If they refuse to re-price and refuse to re-scope, plan a graceful exit. Hand them off to a smaller provider whose cost base can sustain the rate. Give 60-90 days notice. Wish them well. Use the recovered capacity to take on a profitable client instead.

The agencies who release their largest unprofitable client almost always grow faster in the 12 months that follow. The unprofitable client was not just costing margin; it was blocking capacity that could have been earning.

"Profitability per client is the single highest-leverage report no agency runs." — Hacker News, 2024.

How to track this on an ongoing basis.

Running this calculator quarterly is the right rhythm for active management. The data you need is the same data you should already be capturing: time logged per client, project fees, direct expenses, and your loaded team cost. The friction is that this data lives in different systems for most agencies. Time in Toggl, invoices in FreshBooks, expenses in your bank feed, team cost in a spreadsheet. Stitching it together quarterly is a job nobody owns.

One of the reasons we built Ascend was that the profitability view should not require a stitching job. Time logs against the project record. Invoices generate from those logs. Expenses attach to the same record. The margin view is live, not a quarterly export.

What to do this week.

1. Run the calculator with your top 5 clients. Use honest numbers, especially for hours logged. Most agencies under-count hours on long-tenure accounts because the work feels light.
2. Identify the bottom one. If you have a loss-client or a thin-margin client, you know who they are now.
3. Decide which option fits. Re-price first if the relationship is valuable. Re-scope if they cannot afford the right price. Release if they will not move.
4. Put quarterly profitability checks on your calendar. The next surprise loss-client will be invisible until you look again.

Related resources

• Agency Hourly Rate Calculator — sets the target rate this calculator compares against.
• How to set your agency's hourly rate — the companion piece on the rate side of the conversation.
• The project billing workflow — how time, expenses and invoices stay connected on one record.

Sources cited in this guide

• Sortlist Agency Operations Survey 2024
• Productive.io 2024 Agency Benchmarks
• Harvest 2024 Agency Profitability Study
• AgencyAnalytics 2025 Pricing Benchmark