Find out which of your clients are actually profitable — and which ones are eating your time for less than you think you are earning.
Your favorite client pays $3,000 a project. You would run through a wall for them. Then you actually add up the 52 hours each project quietly eats — the calls, the 'one more tweak,' the chasing of approvals — and your effective rate is $57 an hour. Meanwhile the 'small' client you keep deprioritizing pays $1,800 for 18 honest hours, which is $100 an hour. You have been protecting the wrong relationship. The Client Project Profitability Tracker exists to make that calculation automatic and visible, so you find out before another year goes by.
The dashboard tracks your Profit per Project, your Effective Rate per hour, Scope Creep Alerts when projects run past their estimated hours, and a Client Ranking that shows which clients belong at the top of your business and which need repricing or graduating out. The sample data — total revenue $18,500, 245 total hours, effective rate $75.51, with one scope creep alert — gives you an immediate reference point for your own numbers.
Effective hourly rate: the number hiding behind your project fees
Your stated hourly rate and your effective hourly rate are almost never the same number. The difference is scope creep, revision rounds, client communication, and project management overhead. A creative professional billing $100 per hour and averaging 20% more hours than they estimated on every project has an effective rate closer to $83. Over a year of work, that gap is significant.
The Effective Rate field in the tracker calculates this automatically as you log project hours. You do not need to do the division. You just need to track your hours honestly — including the 45-minute catch-up calls, the two rounds of revisions that were not in the original scope, and the admin time spent sending invoices and chasing approvals. Once you can see the effective rate clearly, repricing decisions become straightforward.
Scope creep alerts: catching the leak before it empties the project
Scope creep is not always a client being difficult. Often it is a well-meaning client whose needs evolved, combined with a freelancer who did not want to have a difficult conversation about the additional work. Both parties are acting reasonably. The outcome is still bad for the freelancer.
The Scope Creep Alert fires when a project's logged hours approach or exceed the estimated hours from the original brief. At that trigger point, you have a natural opening: the project is running long, the data is right there, and the conversation about scope adjustment or repricing is easier to start with evidence than without it. Waiting until the project is finished to notice the scope crept is waiting too long.
Users who track projects with scope creep alerts for one quarter typically see their effective rate improve noticeably — not because clients become more considerate, but because the freelancer has the data to have the conversation earlier and more often.
Client Ranking: which clients deserve your best weeks
The Client Ranking tab ranks your clients by effective rate rather than by total revenue. A client generating $8,000 per year at a $60 effective rate ranks below a client generating $5,000 at a $110 effective rate — because the lower-volume client is actually a better use of your time.
This ranking often produces surprises. The client you enjoy most may not be the most profitable. The one who is a little demanding in communication but has clear briefs and respects your time may be at the top. The client you have been loyal to for years may be at the bottom because the rate was never raised. The ranking does not tell you what to do with this information. It just makes the business reality visible so you can make decisions from data instead of feeling.
The most common action clients take after seeing their Client Ranking for the first time: they raise rates on their bottom-ranked client at contract renewal. The second most common: they realize they have been undercharging a client they actually enjoy, and raise rates without apologizing.
Project Profit Tracker: revenue versus actual cost of delivery
The Project Profit calculation takes your project fee, subtracts the cost of the time you put in at your target effective rate, and shows you the actual profit margin on each project. A $2,500 project that takes 30 hours at a $70 target rate has a labor cost of $2,100 and a profit of $400 — a 16% margin. A $1,500 project that takes 10 hours has $700 labor cost and $800 profit — a 53% margin.
Many freelancers realize through this calculation that their highest-revenue projects are not their most profitable ones. Profitability is about how efficiently you can deliver the output at the agreed rate, not just how high the invoice number is.
Monthly comparison: watching your numbers improve over time
The Monthly Compare tab shows your effective rate, total profit, and scope creep frequency across consecutive months. This view is where the tool starts to act like a business advisor rather than a ledger. A rising effective rate over four months means your pricing power is improving. A rising scope creep frequency means your project scoping or contract language needs work, regardless of what your effective rate is doing.
Export to CSV to share with a business partner, accountant, or mentor. The data stands on its own without requiring explanation — the numbers tell the story. See which clients actually make you money and act on it.
How to use it
- Add each current client project with its agreed fee, your estimated hours, and your target effective hourly rate.
- Log actual hours worked on each project as they occur — include calls, admin, and revision rounds, not just billable production time.
- Review Scope Creep Alerts as they fire and use them as the trigger for a scope conversation with the client.
- Check the Client Ranking tab monthly to see which clients rank highest by effective rate versus total revenue.
- Export the project data quarterly to review with a financial advisor or use in your annual pricing review.
Who it's for
- Freelance copywriter with one client taking 60% of her time — Logs all projects for one month. The high-volume client produces $4,200 in revenue at a $54 effective rate — well below her target. Raises the retainer by 30% at the next renewal. The client agrees. Effective rate climbs to $71.
- Graphic designer with 5 regular clients — Client Ranking reveals the two smallest clients by revenue are the two highest by effective rate. Shifts time allocation toward them. Total revenue stays flat but working hours drop by 12 per week.
- Brand consultant tracking project profitability for the first time — Discovers their lowest-margin projects all share a feature: they involve more than two revision rounds. Adds a two-revision limit to their standard contract. Scope creep frequency drops and effective rate climbs within a quarter.
- Web developer preparing for a rate increase — Pulls the last six months of project data from the tracker. Average effective rate is $67. Target is $85. Uses the data to justify the rate increase in client conversations — showing project hours and outcomes rather than just announcing a new rate.
Key terms
- Effective hourly rate
- Project fee divided by total hours logged — including revision, communication, and admin time. The real rate you earned per hour of your time, as distinct from your stated or quoted rate.
- Scope creep
- The expansion of a project's actual work beyond its originally agreed parameters, without a corresponding change in fee. The primary driver of gaps between stated and effective rates.
- Project profit margin
- Project revenue minus the labor cost (hours times target rate) as a percentage. A measure of how efficiently you delivered the work relative to what the client paid.
- Client ranking
- The ordering of clients by effective hourly rate rather than total revenue — revealing which client relationships are most valuable to your business per unit of time invested.
Frequently asked questions
How do I calculate the effective hourly rate if my projects are fixed-fee?
Divide the project fee by the total hours you logged on the project, including all revision, communication, and admin time. The tracker does this automatically once you log the fee and the hours. The resulting effective rate is what you actually earned per hour of your time on that project.
What triggers a scope creep alert?
When the hours you have logged on a project reach a defined percentage of your original estimated hours — typically 80% — the tracker fires an alert. This gives you a window to address scope before the project is already over budget, rather than discovering the overrun when you are calculating the final invoice.
My effective rate is lower than my stated rate. Should I raise prices?
Possibly — but look at the cause first. If it is consistently being driven by scope creep across projects, better contract language and earlier scope conversations may close the gap without a rate increase. If it is being driven by your projects taking longer than you estimated, that is a quoting problem that a higher rate alone will not fix.
Can I use this tool for a mix of hourly and fixed-fee projects?
Yes. For hourly projects, the effective rate and logged rate will match closely as long as you are billing all your time. For fixed-fee projects, log the fee as the revenue and all hours as the time, and the effective rate calculation shows you how your fixed-fee projects compare to your hourly ones in real terms.