Most freelancers and consultants undercharge for their work — not because they lack confidence, but because they do not actually know what they are making per hour once all costs are accounted for. The number you quote a client and the number you actually take home are almost never the same.
This guide shows you exactly how to calculate your true project profit and real hourly rate, and gives you a free Excel calculator that does it all automatically.
The Hourly Rate Illusion
Here is a scenario most freelancers will recognize. You land a project with a $5,000 fee. You estimate 40 hours of work. That is $125 per hour — a solid rate.
Then reality happens:
- The project runs over. You spend 58 hours instead of 40.
- You hire a subcontractor for part of the work. That costs $600.
- You buy a tool or software specifically for this client. $200.
- You spend 8 more hours on sales calls, proposals, revisions, and invoicing.
Now recalculate. $5,000 revenue minus $800 in costs equals $4,200 profit. Divided by 66 total hours equals $63.64 per hour.
That is a $61.36 per hour difference from what you thought you were making. Multiply that across 10 projects per year and you have left over $40,000 on the table.
The Four Costs Most Freelancers Forget
1. Actual Hours Worked
Not the hours you quoted. Not the hours you billed. The total hours you actually worked — including project management, client communication, revisions, and the original scoped work.
2. Subcontractor and Team Costs
Any money paid to other people to complete parts of the project. This reduces your profit directly and must be deducted before calculating your true margin.
3. Direct Project Expenses
Software purchased for the project, advertising spend, travel, or any other cost incurred specifically because of this client engagement.
4. Overhead Allocation
Your ongoing business costs — software subscriptions, equipment, insurance, professional development — need to be spread across your projects. A simple rule of thumb: add 30 percent to your direct costs to cover overhead. This is the cost most freelancers completely forget and why their real margins are always lower than expected.
How to Calculate True Project Profit
The formula for true project profit is straightforward:
True Profit = Project Revenue — Direct Costs — Overhead Allocation
True Hourly Rate = True Profit ÷ Actual Hours Worked
Profit Margin = True Profit ÷ Project Revenue
Running this calculation on every project gives you the data to price accurately, identify which client types are most profitable, and stop undercharging systematically.
Get the Free Excel Project Profit Calculator
Rather than doing this math manually, use our ready-built calculator that handles everything automatically.
The Client Project Profit Calculator includes:
- Revenue input section for project fee and add-ons
- Cost input section for labor, subcontractors, direct expenses
- Auto-calculated gross profit and profit margin
- True hourly rate calculator based on actual hours worked
- Overhead estimator using the 30 percent rule built in
- After-overhead profit showing your real take-home
- All-projects tracker sheet to compare profitability across your entire client roster
Enter your project numbers and see your true profit, margin, and hourly rate instantly.
Download the Client Project Profit Calculator — $13 instant download →
How to Use This Data to Raise Your Prices
Once you have run your last 5 projects through this calculator you will have real data to guide your pricing decisions.
If your target is $100 per hour and your actual average is $65, you need to either raise rates by about 54 percent or reduce costs per project. Both decisions require knowing your actual number first.
Common findings when freelancers first run this calculation:
- Projects with lots of revisions have dramatically lower true hourly rates
- Retainer clients are typically 40 to 60 percent more profitable than one-off projects
- Subcontractor-heavy projects often have margins below 30 percent
- The client who pays the most is rarely the most profitable per hour
This data changes how you sell, scope, and price. That is why this calculator is the most valuable tool in your freelance finance stack.
Frequently Asked Questions
What is a good profit margin for a freelance project?
A healthy project profit margin for freelancers is 50 percent or above after all direct costs. After overhead allocation, 30 to 40 percent is solid. Below 20 percent means the project was barely worth taking at your current rates.
Does this work with Google Sheets?
Yes. The template is an Excel .xlsx file that opens and works fully in Google Sheets.
Can I track multiple projects at once?
Yes. The template includes an all-projects tracker sheet where you can log every client project and compare profitability across your entire roster at a glance.
Stop Undercharging
The first step to charging what you are worth is knowing what you are actually making. Run your last three projects through this calculator today and you will have a clear picture of where you stand — and exactly what to change.