How to Compare Freelance Client Profitability Fairly

Choose the unit before comparing clients

A monthly retainer and a one-off project do not naturally share the same reporting period. Pick a unit that matches the decision: one completed engagement, one retainer month or a defined quarter. Then use that same unit for every comparison in the set.

Keep revenue and costs attached to that period. If one retainer is summarized by a month but another is summarized across a full year, the totals cannot tell you which relationship uses time more effectively.

Record the time around the deliverable

Include the work that belongs to the client relationship, not only the visible production hours. Depending on the engagement, that can mean calls, preparation, revisions, status updates, chasing materials, handover and project administration.

Use the same rule across the clients you compare. If you have tracked hours for one relationship but only estimated the other, mark that difference instead of treating the numbers as equally precise.

Apply one cost rule to every project

List the direct costs you want to count, such as subcontracting or a project-specific asset. Decide consistently whether payment fees belong in the comparison. Keep general overhead and tax separate unless you have a clear allocation method; a simple client review is not a full profit-and-loss statement.

This lets you compare the amount remaining after selected direct costs and, where useful, divide it by recorded hours. That hourly figure is a comparison measure under your stated assumptions, not a complete measure of business profit.

Investigate the difference before changing the rate

If one project appears to leave less per hour, use the inputs to find what differs. Did the work exceed the estimate? Were there extra revisions or deliverables? Did a client dependency create rework? Was a direct cost missed in the quote? Those are different problems and call for different responses.

One project can be unusual. Look for a repeated pattern before changing your pricing or ending a client relationship. A comparison helps you decide what to inspect next; it does not tell you why a result occurred.

Keep the review tied to a decision

Write down the question before you calculate: do you need to scope the next engagement differently, revise your estimate, or understand where unplanned time went? Once you have that answer, review only the records that help with it. Revisit the same measures after the next comparable project rather than changing several assumptions at once.

The Client Profitability Analyzer is an Excel workbook with a seven-page PDF tutorial. It helps organize client and project revenue, time, costs and profitability measures; check the product page for the exact current inputs and outputs. It is a planning workbook, not accounting software or tax advice.

For pricing a new fixed-scope engagement, the free Project Quote Calculator covers a different decision: building a project quote from hours, buffer, direct costs and payment fees.