Freelancer: how to know if a client is making or losing you money

Every freelancer has a client they love to hate. The one who sends 12 Slack messages a day, asks for "one last little tweak" at 6:45pm on a Friday, and schedules 45-minute calls to approve a color change. You know intuitively that this client costs you dearly. But you don't know exactly how much. And more importantly, you don't have the numbers to make the decision that's needed.

The opposite also exists: the quiet client who pays little, whom you handle between bigger projects. You think of them as a "small client." Except that when you run the numbers, this client turns out to be the most profitable in your portfolio -- because they require little time, pay on time, and generate zero stress.

A client's profitability isn't measured by the amount invoiced. It's measured by the ratio between what they bring in and what they cost in time. This article gives you the method to calculate this profitability, analyze your full portfolio, and make the right decisions.

The big client illusion: high revenue doesn't mean a profitable client

Revenue creates a halo effect. A client generating EUR 2,000 per month is spontaneously perceived as a better client than one generating EUR 800. It's an understandable reflex, but it's a trap that can cost a freelancer thousands of euros per year.

The mechanism is simple. Revenue only accounts for one side of the equation: what the client pays. It completely ignores the other side: what the client consumes in time. And it's the ratio between the two that determines whether you're making or losing money.

Let's take a concrete case. You have three regular clients this month:

• Client A -- Communications agency. Invoiced: EUR 2,000. But this client sends you 4 to 5 briefs per week, requests daily 15-minute calls, demands intermediate deliverables at every stage, and regularly changes their mind. Total time spent this month: 50 hours.
• Client B -- B2B SaaS. Invoiced: EUR 800. Clear brief sent at the start of the month, a single 30-minute validation call, one-time delivery, payment upon receipt. Total time spent: 8 hours.
• Client C -- Consulting firm. Invoiced: EUR 1,500. Two projects this month, decent briefs but slow validation process (3 stakeholders). Total time spent: 25 hours.

At first glance, Client A is the "best" client because they generate the most revenue. But let's look at the effective hourly rates.

Client A, the one generating the most revenue, effectively pays you EUR 40 per hour. If your target daily rate is EUR 450 (roughly EUR 56/h based on an 8-hour day), this client is costing you EUR 16 for every hour worked. Over a month, that's EUR 800 in lost revenue. Over a year, EUR 9,600.

Client B, the "small" client, is actually the one that values your time the most. They pay you EUR 100 per hour -- nearly double your target. Every hour spent on them is an extremely profitable hour.

Key figure: According to a study by the Creme de la Creme collective published in 2024, 73% of digital freelancers have at least one client whose effective hourly rate is below their target daily rate. And 41% of them don't realize it, due to a lack of time tracking.

The simple formula: Revenue invoiced / total hours = effective hourly rate

The basic formula is elementary:

Effective hourly rate = Revenue invoiced (excl. tax) / Total hours spent

The difficulty isn't in the formula. It's in the numerator and the denominator.

The numerator: what counts as revenue?

Take the total amount invoiced to the client over the analyzed period (ideally 6 to 12 months to smooth out variations). Include:

• Recurring services (monthly retainers, maintenance subscriptions).
• One-off projects delivered and invoiced.
• Extras and change orders that were billed.

Don't include unsigned pending quotes or projects not yet delivered.

The denominator: what counts as hours?

This is where most freelancers get it wrong. They only count production time -- time spent at the screen coding, designing, or writing. But total time includes every hour you wouldn't have spent if this client didn't exist:

• Production time: design, development, writing.
• Project management time: planning, organization, tool updates.
• Communication time: calls, video meetings, emails, Slack messages. A 20-minute call is never just 20 minutes -- count the preparation time and the follow-up notes.
• Revision time: every round of feedback is time consumed.
• Pre-sales time: writing quotes, proposals, qualification calls for new projects with this client.
• Administration time: invoicing, payment follow-ups, contract management.
• Support time: troubleshooting, post-delivery questions, small requests that "take 5 minutes" (and actually take 25).

Common mistake: Only counting production hours in the calculation. If you spend 30 hours producing for a client but 15 additional hours on calls, emails, and support, your total time is 45 hours, not 30. Using 30 hours in the formula gives you an effective hourly rate that's 50% too high -- and a falsely optimistic view of the client's profitability.

Complementary metrics

The effective hourly rate is the primary indicator. But two additional metrics enrich the analysis:

The production-to-total time ratio. Divide pure production time by total time spent for this client. A healthy ratio sits between 70 and 80%. Below 60%, the client generates too much unproductive time (meetings, revisions, support).

The opportunity cost. Every hour spent on an unprofitable client is an hour not spent on a profitable one, or on prospecting for better clients. Client A from the earlier example consumes 50 hours per month. If those 50 hours were billed at Client B's rate (EUR 100/h), they would generate EUR 5,000 instead of EUR 2,000. The opportunity cost is EUR 3,000 per month.

Analyzing your client portfolio: a practical exercise

Let's move from theory to practice. Here's an exercise you can complete in 1 to 2 hours, and it can transform your commercial approach.

Step 1: List all your active clients

Take your clients from the last 6 to 12 months. Include both one-off and recurring clients. If you had a client for a single project, include them anyway.

Step 2: Reconstruct time spent

For each client, estimate the total time spent over the period. If you have time tracking data, it's immediate. If you don't, use your calendar, email history, and invoices to piece together an estimate. It won't be perfect, but it's better than nothing.

Step 3: Build the profitability table

Here's an example of a complete table for a freelance web developer with a target daily rate of EUR 450 (EUR 56/h).

Step 4: Visualize the allocation

Calculate the percentage of your total time devoted to each client and compare it to the percentage of revenue generated.

The analysis is clear: Client A represents 33% of revenue but consumes 44% of your time. Client B represents only 13% of revenue but consumes just 7% of your time. If you could replace Client A with 6 Client B-type clients, you'd earn the same revenue (EUR 24,000) while working 240 hours instead of 600. That's 360 hours freed up -- more than 2 months of work.

Real-world example: Clara, a freelance UX designer based in Bordeaux, ran this exercise after 18 months of activity. She discovered that her biggest client (38% of her revenue) had an effective hourly rate of EUR 35/h -- below the minimum wage when you factor in charges. The main culprit: validation cycles involving 4 stakeholders that tripled the revision time. By renegotiating the validation process (a single decision-maker), she reduced time spent on this client by 40% and brought her effective hourly rate back up to EUR 58/h.

The 3 possible decisions for an unprofitable client

Identifying an unprofitable client is half the battle. The other half is deciding what to do. There are exactly three options, and each is legitimate depending on the context.

Decision 1: Renegotiate

When to apply: the client is strategic (reference account, growing sector, volume growth), the problem is identifiable and fixable, the relationship is good.

How: present the data factually. "Over the last 12 months, I've devoted X hours to our collaboration for revenue of Y EUR. My effective hourly rate is Z EUR, which is below my cost price. To continue working together under good conditions, I propose [rate adjustment / capping revisions / support retainer]."

The most effective renegotiation levers:

• Raise rates by 15 to 25% to reflect the time actually consumed.
• Cap revisions included in the quote (3 rounds maximum, then billed at actual time).
• Bill for support and out-of-scope requests.
• Streamline communication: one structured weekly meeting instead of 5 ad-hoc calls.

Decision 2: Restructure the relationship

When to apply: the client has potential, but the way you work together is inefficient.

How: without changing rates, change the collaboration framework.

• Move from a reactive model (the client reaches out whenever they want) to a proactive model (you deliver according to a defined schedule).
• Require a structured brief using a template the client must fill out before each project.
• Centralize communication on a single channel (no Slack + email + SMS + WhatsApp).
• Define clear SLAs: 24 business-hour response time, no urgent requests unless billed at a premium rate.

For a deeper dive into identifying profitable clients, a dedicated article explores these mechanisms in detail from an agency perspective.

Decision 3: End the collaboration

When to apply: renegotiation has failed or isn't feasible, the client isn't strategic, the deficit is structural rather than circumstantial.

How: professionally, with reasonable notice. Complete current commitments, offer a transition (recommend a peer if possible), and free up the time for targeted prospecting toward more profitable client profiles.

The psychological difficulty is real. Letting go of a client who generates revenue, even unprofitably, creates a gap in the schedule and in short-term cash flow. But every freed-up hour is an hour available for a client who pays you what you're worth.

Key takeaway: There are no "bad" clients -- there are underpriced clients and poorly structured relationships. The profitability calculation isn't a judgment tool. It's a decision tool. It allows you to treat each client relationship for what it is: an investment of your most precious resource (your time) in exchange for a financial return. When the return is insufficient, you adjust. That's management, not emotion.

Implementing systematic tracking

A one-time exercise is useful for raising awareness. But the real value comes from continuous tracking. When you measure each client's profitability in real time, you detect drift before it becomes critical.

Freelancers who structure their business with regular time tracking see an average 15 to 20% improvement in their effective hourly rate over 12 months. Not because they work more, but because they work smarter: they identify unprofitable clients sooner, renegotiate faster, and direct their prospecting toward the most profitable profiles.

Measurement changes behavior. When you see, in black and white, that Client A costs you EUR 40 per hour while Client B earns you EUR 100, you make different decisions. You say no more easily to out-of-scope requests. You raise your rates with more confidence. And you invest your time where it generates the most value.

That's the difference between steering your business and being at its mercy. And this difference is measured, at year's end, in tens of thousands of euros. Don't let your least profitable clients dictate how you spend the time that either brings you closer to -- or further from -- your financial goals. Measure, compare, and if clients are causing you to underestimate the time spent, that's a signal you shouldn't ignore.