How to Compare Profitability Across Clients at the End of Each Quarter

At the end of every quarter, most freelancers look at one number. Total revenue. They see if it went up or down from last quarter and move on.

That number tells you almost nothing useful.

The question that actually matters is: which clients generated that revenue, how many hours did it take, and what did each one cost you in time you cannot bill?

When you break it down that way, the client list looks different. Usually, one or two names surprise you.

What You Are Actually Comparing

For each client you worked with this quarter, pull four numbers:

- Total hours logged
- Total revenue invoiced
- Total non-billable hours tied to that client (communication, admin, revisions you absorbed, scope work you never charged for)
- Effective hourly rate (revenue divided by total hours, including the non-billable ones)

That last number is the one that changes things. It accounts for all the time a client actually consumed, not just the time you charged for.

How to Pull This From Your Time Logs

If you have been tagging your entries by client and using consistent project names, this takes maybe thirty minutes. Filter your tracker by client, add up the hours, and split them into billable and non-billable.

If you have not been tracking non-billable time by client, start now. It does not need a fancy system. When you answer a long email, jump on a quick call, or fix something the client broke, log it. Tag it as non-billable. Assign it to the client.

You do not need to charge for it retroactively. You need to see it.

What the Numbers Usually Show

There is typically a pattern when you run this for the first time.

The client who generates the most revenue is rarely the most profitable. They often come with high communication overhead, frequent scope questions, and revision requests that eat into the hours you planned.

The client who feels small or easy often has the best effective rate. They brief well, trust your judgment, pay on time, and do not chase you between deliverables.

The gap between those two types of clients is not just about how much they pay. It is about how much they cost.

How to Use This Information

Once you have the effective hourly rate per client, you can make better decisions.

If a client's effective rate is significantly below your target, something has to change. You either raise the rate, tighten the scope, start charging for what you currently absorb, or acknowledge that the relationship has run its course.

If a client's effective rate is strong, that is a client worth investing in. Find out what makes the engagement work and look for more clients who fit that profile.

This is how you grow revenue without adding hours. You shift the mix toward clients who pay well per unit of your actual time.

Quarterly Beats Annual

Doing this once a year is better than never. But doing it quarterly means you catch a deteriorating client relationship before it costs you a full year of underpriced work.

A client can change. New stakeholders, new internal pressure, a scope that quietly expands. Running the numbers every quarter lets you see the shift while there is still time to address it.

What Time-Trak Gives You Here

The data for this comparison exists in your logs if you have been tracking consistently. Time-Trak stores everything locally, keeps it organized by project and client, and makes it easy to filter and review without exporting to a spreadsheet just to answer a basic question.

The habit of logging everything, billable and not, is what makes the quarterly comparison meaningful. Without the non-billable hours, you are only seeing half the picture.

The Client List You Think You Have vs. the One You Actually Have

Revenue totals make every quarter look like a business decision. Effective rates show you whether those decisions were actually good ones.

Run the comparison. The answer is almost never what you expected.

Track your time, bill every minute.

Time-Trak is a native Mac and Windows time tracker with a floating timer, automatic screenshots, and one-click invoicing.

Free during beta.

macOS + Windows · Floating widget · Auto screenshots