How to find out which clients and projects are really profitable
Revenue is not profit. A four-step method to allocate labour, direct costs and overhead to each client, with a three-client example computed line by line.

Billing a client $8,000 a month tells you nothing about whether the client makes you money. The answer depends on the hours your team spent, what you paid for on their behalf, and a fair share of the rent and software that keep the lights on. This post shows a four-step method and a full worked example you can copy into a spreadsheet.
The four steps
- Revenue per client. What you invoiced for the period, excluding pass-through costs you simply re-billed at cost.
- Direct labour. Hours spent on that client multiplied by your cost per hour of staff time.
- Direct expenses. Costs incurred only because of that client: contractors, licenses, stock, ad fees you paid.
- Overhead share. A fair slice of everything else, allocated in proportion to hours.
Profit per client is revenue minus steps 2, 3 and 4. Do it monthly or quarterly, and for the same period every time.
What you need before you start
- Hours by client. Without time records, step 2 is a guess. Even a rough weekly log beats memory.
- A cost per hour for staff. Take annual salary plus employer costs, then divide by the hours you actually pay for.
- A list of overhead for the period: rent, software, insurance, admin and anything else not tied to one client.
If you track time in HireOrSell, entries can be logged against projects and clients link to projects. Time tracking is on the Pro plan, and the Free plan does not include it, so check the pricing page for current prices.
The worked example
Take a hypothetical agency with three clients in one month. Staff time costs $40 an hour, and monthly overhead is $6,000.
- Client A: revenue $8,000, 80 hours, direct expenses $300.
- Client B: revenue $5,000, 60 hours, direct expenses $0.
- Client C: revenue $3,000, 60 hours, direct expenses $200.
Total hours: 80 + 60 + 60 = 200.
Step 2: direct labour
- A: 80 x $40 = $3,200.
- B: 60 x $40 = $2,400.
- C: 60 x $40 = $2,400.
Step 4: overhead per hour, then per client
Overhead per hour is $6,000 / 200 = $30.
- A: 80 x $30 = $2,400.
- B: 60 x $30 = $1,800.
- C: 60 x $30 = $1,800.
Profit per client
- A: $8,000 - $3,200 - $300 - $2,400 = $2,100. Margin: $2,100 / $8,000 = 26.25%.
- B: $5,000 - $2,400 - $0 - $1,800 = $800. Margin: $800 / $5,000 = 16%.
- C: $3,000 - $2,400 - $200 - $1,800 = -$1,400. Margin: -$1,400 / $3,000 = -46.7%.
Check the total. Revenue is $16,000. Costs are $8,000 labour + $500 direct expenses + $6,000 overhead = $14,500. Profit is $16,000 - $14,500 = $1,500. The three client profits, $2,100 + $800 - $1,400, also give $1,500, so the allocation is complete.
Read the result carefully
The revenue per hour tells the same story from a different angle.
- A: $8,000 / 80 = $100 an hour.
- B: $5,000 / 60 = $83.33 an hour.
- C: $3,000 / 60 = $50 an hour.
Client C earns you $50 for each hour of work that costs $40 in wages and $30 in overhead, which is $70 in total. That is why it loses money.
Be careful before you drop C, though. Look at profit before overhead, which is revenue minus labour and direct expenses.
- A: $8,000 - $3,200 - $300 = $4,500.
- B: $5,000 - $2,400 = $2,600.
- C: $3,000 - $2,400 - $200 = $400.
C still contributes $400 towards your fixed costs. If you drop C and cannot replace the 60 hours with paying work, overhead stays at $6,000 and profit falls from $1,500 to $1,100 (that is $1,500 - $400). So the real question is whether you can fill the freed hours with better work, or fix C's price or scope.
Choose an allocation method and stay with it
Allocating overhead by hours is simple and works for many time-based services. Two alternatives are worth knowing.
- By revenue: each client carries the same percentage of overhead. Simple, but it flatters low-priced clients.
- By direct labour cost: close to hours if everyone costs the same.
The method matters less than using it every time. Compare clients to each other and to their own past.
A spreadsheet layout
One row per client and one column per step is enough.
- Columns: client, revenue, hours, labour cost (hours x $40), direct expenses, overhead (hours x $30), profit, margin %, revenue per hour.
- A totals row at the bottom, which you check against your overall profit for the month.
- A second tab for each month, so you can compare months side by side.
Common mistakes
- Leaving out unbilled time. If you spent 10 hours on client C and logged 6, the loss is bigger than it looks.
- Counting only invoiced hours. Include meetings, rework and internal reviews.
- Mixing periods. Use the same month for revenue and costs.
- Treating the figure as precise. It is a guide for decisions, not an audit.
What to do with the answer
For each client with a low or negative margin, there are four choices: raise the price, reduce the scope, change how you deliver the work, or end the engagement. One possible cause is scope that crept after the start, so the client onboarding checklist for agencies is worth reading to see how a clear start prevents it.
This is general information, not accounting advice. How you count labour and overhead may need to follow rules that apply to you.
Next step
Pick last month and your three largest clients. Write revenue, hours and direct expenses in a table, compute overhead per hour and work out profit for each. It takes under an hour, and it will tell you where to look first.
Ready to run it all in one place?
Projects, clients, time tracking and invoicing in one platform.