Blog Productivity How to find which clients are profitable with time data
Productivity · Nov 21, 2026
How to find which clients are profitable with time data
Profit per client is fee minus hours times cost rate. Export hours per project from TimeUno as CSV, then do the margin sum in a sheet. Worked example.
To find which clients are profitable, compare what each client pays you with what the hours spent on them cost you. TimeUno gives you the hours per project in a CSV export; the margin sum happens in a spreadsheet. TimeUno has no profit or margin report, and this page says so up front. The TimeUno team wrote it.
If you searched for time tracking software that shows profit margin per client, here is the honest version: the tracker supplies the hours, and a spreadsheet supplies the margin.
What do you need to calculate client profitability?
Three inputs per client, for a set period such as a quarter:
| Input | Where it comes from |
|---|---|
| Hours worked | The time tracker's CSV export, grouped by project |
| Cost rate per hour | Your own numbers: salary, taxes, overhead, divided by working hours |
| Fee earned | Your invoices or retainer agreement |
The formula is: margin = fee earned minus (hours x cost rate). Margin percent = margin divided by fee.
The hours are the part people lack, because without a tracker they are guesses. Automatic tracking helps since it records as people work. See automatic timesheet software.
How do you work out your cost rate?
Cost rate is not what you charge. It is what an hour of a person's time costs you.
Example numbers, invented and round, for illustration only: a designer costs the agency $72,000 a year in salary, taxes and benefits. Add $18,000 of overhead share (rent, software, management time). The total is $90,000. If the designer has 1,800 working hours a year after holidays and leave, the cost rate is $90,000 divided by 1,800, which is $50 per hour.
Use one blended rate if your team is similar, or a rate per role if pay varies a lot. Keep it simple first. You can refine later.
How do you calculate margin for one client? A worked example
Again, these are invented numbers. Say Client A pays a $6,000 monthly retainer. The month's CSV shows 100 hours on Client A's project. At a $50 cost rate:
- Cost: 100 x $50 = $5,000.
- Margin: $6,000 minus $5,000 = $1,000.
- Margin percent: $1,000 divided by $6,000 = 16.7%.
Client B pays $4,000 and used 40 hours:
- Cost: 40 x $50 = $2,000.
- Margin: $4,000 minus $2,000 = $2,000.
- Margin percent: 50%.
Client A looks bigger and brings in more money, but Client B is far more profitable per dollar and per hour. Client A pays $60 per hour worked ($6,000 divided by 100), Client B pays $100 ($4,000 divided by 40). That effective hourly rate is a quick check you can run on every client.
How do you get hours per client out of TimeUno?
- File tracked time to a project per client. TimeUno sorts activity into projects and asks you to correct what it cannot place; corrections stick.
- Review the period so wrong filings are fixed before you export.
- Export a CSV of the period.
- In a spreadsheet, sum hours per project with a pivot table or a SUMIF formula.
- Add columns for fee, cost rate, cost and margin.
Keep one spreadsheet and copy it each quarter. After three or four periods, trends appear, such as a client whose hours grow while the fee stays flat. For the retainer version of that problem, see spotting scope creep with time data.
What if a client pays by project, not retainer?
Use the same sum with the whole project. Invented example: a website project is sold for $12,000 and the CSV shows 190 hours across design and development. At a $50 cost rate, cost is $9,500 and margin is $2,500, or 20.8%. If the quote assumed 150 hours, the extra 40 hours cost $2,000, which is where the margin went. Next time, use this number to quote better.
What does this analysis miss?
Be careful about conclusions from a single month. A low-margin month can come from a launch, and a high-margin month from a client who was quiet. Use at least a quarter.
Also count hidden costs. Account management, sales and meetings might not be tracked to a project. If they are not filed anywhere, the margins look better than they are. Decide a rule, such as adding a fixed percentage of overhead on top, and apply it to every client.
Finally, margin is not the only measure. A low-margin client may bring referrals or steady work. The sum tells you where to look, and you decide what to do. Options include raising the fee, trimming scope or ending the contract. If you work in consulting or law, time tracking for lawyers and consultants covers related habits.
What are the limits of TimeUno here?
TimeUno has no profit, margin or utilization reports, no per-client cost features and no dashboard for this. It exports CSV and PDF timesheets, and everything past the hours is your spreadsheet. It does not do invoicing or accounting and has no integrations with accounting tools. It only sees computer activity, so calls and in-person meetings need manual entries to show up in the hours. Hours are only as accurate as the filing of time to projects, so review before you export.
What is the next step?
Export one quarter of hours, build the spreadsheet above for your five biggest clients, and compare effective hourly rates. TimeUno has a 14-day free trial with no card needed; see pricing or download TimeUno.