Home / Blog / Client Profitability Analysis
How-to · 2026

Client Profitability Analysis: Find the Clients Costing You Money

Revenue per client is easy to find. What each client costs you in hours is the part that lives in a different tool, so most agencies see the first number and guess the second.

By · Published November 17, 2026 · 7 min read

A client profitability analysis answers one question: for each client, what did the fee bring in, and what did the hours cost? The fee sits in your accounting system. The hours sit in your time tracker. Nothing joins them for you, so most agencies know their revenue per client and have a feeling about the rest.

A worked example

The figures are illustrative: three retainer clients over one month, at a loaded cost of $55 an hour.

ClientFeeHoursCostMarginMargin %Effective rate
A$6,00040$2,200$3,80063.3%$150.00
B$4,00070$3,850$1503.8%$57.14
C$8,00090$4,950$3,05038.1%$88.89
Total$18,000200$11,000$7,00038.9%$90.00

Client C is the largest fee and looks like the best account. Client A is the one making the money. Client B brings $4,000 and takes 70 hours, which leaves $150 a month before any overhead. The effective rate is the quickest read: B is paying you $57 an hour in a business whose cost is $55.

Where the analysis goes wrong

The spreadsheet version

Put revenue by client in one tab and hours by client in another, and join them on a client key rather than a typed name. Then margin is =Fee-Hours*CostRate and the effective rate is =Fee/Hours. The step that takes the time is the join, which is covered in combining Harvest and QuickBooks exports. For one project rather than one client, see Harvest project profitability.

Asking for it from both tools

With Harvest and QuickBooks both connected, Quiriz reads fees from one and hours from the other, and the loaded cost rate and the client-name mapping are definitions you set in Company Context so every answer uses them. In Excel with the Excel add-in:

=QUIRIZ.ASK("margin and effective hourly rate by client last quarter, fees from QuickBooks and hours from Harvest at the loaded cost rate", "table")

What it cannot know. The cost rate is your number. Quiriz uses the one you set and shows it with the answer. Check the first answer against one client you have already worked out by hand, and look for clients whose names differ between the two tools, since those need a mapping.

📚 Connector reference: every dataset and metric definition behind this, and how each is calculated, is in the Harvest connector. All connectors.

Margin per client from the data you already have

Try the questions on sample agency data with no signup, then connect Harvest and QuickBooks and ask for margin by client.

Try Quiriz free →

Frequently asked questions

What is client profitability analysis?
It compares the revenue each client brings in with the cost of serving them, usually the staff hours spent. The result shows which clients make money, which break even and which cost you more than you earn.
How do I calculate a loaded hourly cost?
Add a person’s salary, payroll taxes and benefits, then add a share of overhead such as software and rent. Divide by the hours they work in a year. The figure is higher than their pay rate, and using pay alone makes every client look better than it is.
Should I include non-billable hours?
Yes. Time spent on a client that you cannot bill still costs you. If you leave it out, a client with heavy back-and-forth looks profitable when it is not.
What is a good margin per client?
It depends on your overhead and what you pay people. Compare each client with your own target margin and with the others, not with a published benchmark. The useful finding is usually the spread between your best and worst clients.
How often should I run it?
Quarterly is enough for most agencies, with a look at any client who is new or whose scope changed. Monthly figures are noisy because hours and invoices rarely line up in the same month.