Client Profitability Calculator: Measure Margin by Account, Project, and Hour

Overview

Revenue alone does not show whether a client is worth keeping, expanding, repricing, or serving differently. Two accounts can produce the same invoice total while requiring very different amounts of coordination, rework, meetings, and support. Customer profitability analysis makes those differences visible.

The basic calculation is:

Client profit = client revenue − direct client costs

Client margin = client profit ÷ client revenue × 100

For a more useful comparison, also calculate the effective revenue per hour:

Effective hourly revenue = client revenue ÷ total client hours

Total client hours should include more than the work listed on a statement of work. Include delivery, project management, meetings, revisions, troubleshooting, reporting, account administration, and unpaid support when those activities are connected to the account.

This is a contribution-style view of profitability. It is useful for pricing and account decisions, but it may not represent final company profit unless you also allocate shared overhead such as rent, general software, insurance, leadership time, and non-client operations. Keep the two views separate rather than mixing overhead into some accounts and not others.

How to estimate client profitability

Use one row per client and one consistent measurement period, such as a month, quarter, project, or completed engagement. A simple worksheet can use these columns:

Then apply the following sequence:

1. Add delivery, revision, support, and coordination hours to get total client hours.
2. Multiply total hours by the appropriate loaded hourly labor cost.
3. Add subcontractor, account-specific software, and payment costs.
4. Subtract total direct costs from revenue.
5. Divide profit by revenue to calculate client margin.
6. Divide revenue and profit by total hours to compare the account with other work.

A spreadsheet formula might look like this:

Total hours = delivery hours + revision hours + support hours + coordination hours
Labor cost = total hours × loaded hourly cost
Total direct cost = labor cost + subcontractors + software + payment fees
Margin = (revenue − total direct cost) ÷ revenue

Use the same formulas for every account. Consistency matters more than false precision.

Inputs and assumptions

Choose the right labor cost

An employee's wage or a freelancer's draw is not necessarily the full cost of an hour. A loaded cost may include employer payroll costs, benefits, paid non-working time, and other directly attributable employment expenses. For an owner or independent freelancer, use a planned cost of capacity or target compensation rather than assuming every available hour is billable.

If different people work on an account, calculate their costs separately. For example, 20 hours from a project manager and 30 hours from a specialist should not automatically use one blended rate unless that rate is a deliberate and documented assumption.

Separate direct and shared costs

Charge costs directly to a client when they would not exist without that account. A client-specific contractor, data purchase, or dedicated software seat belongs in direct costs. General accounting software used across the business may be better treated as shared overhead.

If you allocate shared overhead, define the allocation rule before comparing clients. Possible bases include total hours, revenue, headcount, or usage. Do not change the rule to make one account look better.

Record hidden service work

Scope creep often appears as small activities that are not invoiced separately: extra calls, repeated approvals, emergency messages, additional versions, and reporting requests. Record them as hours or as a clearly estimated cost. If an activity is material enough to affect the decision, it belongs in the calculation.

Use comparable revenue figures

Decide whether the worksheet uses billed revenue, collected revenue, or recognized revenue. Each can answer a different question. Billed revenue helps assess pricing and delivery economics; collected revenue is useful when payment delays and bad debt matter. Do not compare one client using invoices and another using cash receipts without labeling the difference.

Worked examples

Assume two clients each generate $6,000 of revenue during the same period. The examples below use an illustrative loaded labor cost of $55 per hour. These figures are assumptions for demonstrating the method, not benchmarks.

Both accounts produce the same revenue, but Client B uses 10 more hours and has a lower margin. The result does not automatically mean Client B should be dropped. It identifies a question to investigate: are the extra revisions caused by unclear scope, a difficult approval process, underpriced change requests, a temporary issue, or a service feature that the business intentionally provides?

For a project-based account, run the calculation again after the project closes. For a retainer, calculate monthly profitability and also review a rolling three-month view. The rolling view can reduce the risk of reacting to one unusually busy or quiet month.

When to recalculate

Recalculate client profitability whenever a pricing input changes or the account's work pattern changes. At minimum, review active accounts monthly or quarterly, depending on transaction volume and complexity. A project-based freelancer may review at milestones and at completion; a team with several retainers may benefit from a recurring monthly review.

Run an additional calculation when:

• A retainer, hourly rate, package, or project fee changes.
• The client adds meetings, reporting, approval rounds, or support expectations.
• Delivery work moves to a different employee, contractor, or cost structure.
• Software, payment, subcontractor, or compliance-related costs change.
• Actual hours consistently exceed the estimate used for pricing.
• An account's payment timing or collection risk changes.
• You are considering a discount, renewal, upsell, or change in service model.

Turn the results into an action, not just a score. Accounts with healthy margins may support expansion, a longer commitment, or a better documented repeatable process. Accounts with weak margins may need a revised scope, fewer meetings, a change-order rule, a higher fee, or a more efficient delivery workflow. If the issue is capacity rather than pricing, compare the result with a freelancer capacity planning template.

Use related calculations when the decision calls for a different view. A margin versus markup calculator can prevent pricing terminology errors, while a project pricing calculator can convert a target hourly cost and expected workload into a fixed fee. If the account supports a larger hiring or sales decision, a break-even calculator can show how much additional revenue is needed to cover fixed costs.

Save the worksheet with its assumptions and date. When inputs change, duplicate the prior period rather than overwriting it. That creates a practical history of revenue, effort, and margin, making it easier to identify scope creep early and decide which client relationships deserve a pricing or process review.