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.
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.
| Client | Fee | Hours | Cost | Margin | Margin % | Effective rate |
|---|---|---|---|---|---|---|
| A | $6,000 | 40 | $2,200 | $3,800 | 63.3% | $150.00 |
| B | $4,000 | 70 | $3,850 | $150 | 3.8% | $57.14 |
| C | $8,000 | 90 | $4,950 | $3,050 | 38.1% | $88.89 |
| Total | $18,000 | 200 | $11,000 | $7,000 | 38.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
- Mismatched periods. An invoice for March work sent in April lands in the wrong month. Use the period the work was done, or look at a quarter.
- Hours that were never tracked. If the time tracker is missing time, every client looks better. Check tracked hours against capacity before you read the table.
- Pay rate instead of loaded cost. It makes every client look profitable and hides the thin ones.
- Client names that differ between tools. "Acme Ltd" in the books and "Acme" in the tracker will not match, and the unmatched rows drop out of the join without a warning.
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.
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 →