How to Track Billable Hours and Calculate Your Real Hourly Rate as a Freelancer
You charge $100 an hour. You’re proud of that rate — it took years to get there.
Now do this: add up everything you earned last month, subtract your business expenses, and divide by every hour you spent on work. Not just the hours you billed. The proposal you wrote that went nowhere. The four scoping calls. The invoicing. The Slack messages. The revision round that wasn’t in scope but you did anyway.
Most freelancers who run this calculation for the first time find a number between $40 and $60. Some find less. That number — not the one on your rate card — is what you actually earn per hour of your life.
The Gap Between Your Rate and Your Reality
There are two rates in freelancing, and only one of them is real.
Your quoted rate is what you tell clients. It’s a marketing number. It applies only to hours a client agrees to pay for.
Your effective hourly rate is net profit divided by total hours worked. It’s the number that determines whether freelancing is actually a good deal for you.
The gap between them is created by two forces working together. First, utilization — the share of your working hours that are billable at all. Second, expenses — the cut of your revenue that goes to software, fees, insurance, and equipment before you see a dollar.
Run the arithmetic. At a $100 quoted rate and 60% utilization, you’re earning $60 per hour worked. Take 15% off for business expenses and you’re at $51. And that’s before income tax and before self-employment tax at 15.3% — 12.4% for Social Security plus 2.9% for Medicare — which applies once net earnings from self-employment reach $400.
The $100/hour freelancer is, in a meaningful sense, a $51/hour freelancer. Nothing is wrong. That’s just what the number is. The problem isn’t the gap — it’s not knowing the gap exists.
Why This Is Suddenly Urgent
The freelance market is repricing itself, and quoted rates are becoming a worse and worse guide to earnings.
Upwork’s Future Workforce Index 2026 — a survey of 2,400 skilled U.S. knowledge workers combined with platform data — found a sharp split in how AI work is being paid. Contract starts for generative AI and creative production work rose 90% year-over-year, while per-contract earnings actually declined 13%. Volume up, pay down. Meanwhile, freelancers doing complex, high-level AI-augmented work saw earnings jump 45% year-over-year, with AI-augmented professional services growing 72% in volume and hourly earnings rising 22%.
Same broad category. Opposite outcomes. “There is a puzzle in the AI data: adoption is everywhere, but productivity gains are still hard to see,” notes Nick Bloom, Professor of Economics at Stanford and a member of Upwork’s Economic Advisory Council. “The value is concentrated in more complex work where people are applying expertise, judgment, and business context on top of AI.”
In a market splitting like that, the freelancers who know their per-project effective rate can see which side of the split they’re on. The ones who don’t just feel vaguely busier and no richer, and can’t explain why.
What to Actually Track
You need three things logged, and none of them are hard.
1. Every hour, tagged. Date, client or project, hours, and a billable/non-billable flag. That flag is the entire game. Without it you’re tracking effort; with it you’re measuring your business.
2. What each hour was for. A short description. “Client call,” “revisions,” “proposal,” “invoicing.” After three months this tells you where your unpaid time actually goes, and the answer is almost never what you’d guess.
3. Revenue and expenses per client. You need both halves. Hours alone give you utilization; hours plus money give you your effective rate.
Three columns of discipline. That’s the price of admission.
Calculating Utilization Rate
Utilization = billable hours ÷ total hours worked.
If you worked 160 hours last month and billed 96, you’re at 60%. Solo freelancers commonly land somewhere between 50% and 70% — the business itself eats the difference. Marketing, admin, invoicing, chasing payments, proposals, learning: all real work, none of it billable.
There’s no universal correct number, and chasing 100% is a fantasy that ends in burnout. The value is in three things:
- Knowing your baseline so your rate math is honest
- Watching the trend — a dropping utilization rate means unpaid work is expanding somewhere
- Comparing clients — some clients are utilization sinks and you can prove it
The Freelancer Finance Hub has a Time Tracker that logs billable hours per client and project with auto-calculated earnings, plus utilization rate tracking for billable versus non-billable time — so this is a lookup rather than a monthly arithmetic exercise.
Calculating Your Effective Hourly Rate
Effective rate = net profit ÷ total hours worked.
Net profit, not revenue — expenses come out first. Total hours, not billable hours — all of it counts.
Do this monthly and a lot of things stop being mysterious. Why a busy month didn’t feel lucrative. Why the client who “pays great” leaves you exhausted. Why your income rose but your life didn’t.
Then do it per client, and it gets genuinely uncomfortable in a useful way:
- Client A: $4,000 billed, 40 hours total → $100/hour effective
- Client B: $6,000 billed, 95 hours total (including 22 hours of unpaid calls, revisions, and rescoping) → $63/hour effective
Client B pays more. Client B looks like your best client on every income report you’ve ever made. Client B is quietly worth 37% less per hour of your life — and you would never know without tracking non-billable time against them.
That’s not an argument for firing Client B. It’s an argument for raising their rate, tightening their scope, or at minimum making the decision with your eyes open.
The Flat-Fee Trap
“I charge per project, so I don’t need to track hours.”
This is exactly backwards. On an hourly contract, scope creep costs the client money. On a flat fee, scope creep costs you money — every additional hour comes directly out of your effective rate, and nothing stops it automatically.
A $3,000 project scoped at 25 hours is a $120/hour job. The same project at 60 hours is a $50/hour job. The invoice is identical. Your year is not.
Log hours against flat-fee projects and you learn two things fast: which project types you systematically underquote, and which clients reliably consume double their estimate. Both are directly actionable — you reprice, or you rescope, or you stop taking that work. None of it is visible without the log.
Start This Week
You don’t need a new app or a system. Open a sheet. Five columns: date, client, hours, billable yes/no, what you did. Fill it in for four weeks — as you go, not from memory at week’s end.
At the end of the month: total hours, billable hours, utilization. Then net profit divided by total hours. One number.
That number might be lower than you’d like. It’s still better to know it than not, because it’s the only number that answers the questions that actually matter — which clients to keep, which rates to raise, and whether the business you’re running is the one you think you’re running.
Featured on ReadySheetGo
The Freelancer Finance Hub includes a Time Tracker for logging billable hours per client and project with auto-calculated earnings and utilization-rate tracking for billable vs. non-billable time. Pair it with the built-in Profit & Loss statement and Client Dashboard and your effective hourly rate calculates itself from data you’re already entering. The workbook also covers invoice tracking with auto-aging, an Income Log, a 15-category Expense Tracker, a Quarterly Tax Estimator (federal, state, and self-employment), 1099 Tax Prep, and an Annual Summary — 10 tabs, 300+ auto-calculating formulas. Works in both Microsoft Excel and Google Sheets. One-time purchase — $17.99 instant download.
Frequently Asked Questions
How do I calculate my real hourly rate as a freelancer?
Take your net profit for a period — income minus business expenses — and divide it by every hour you spent on the business, billable and non-billable. That includes admin, proposals, invoicing, and client emails. The result, your effective hourly rate, is almost always dramatically lower than your quoted rate, and it's the only rate that reflects what you actually earn per hour of your life.
What is a good utilization rate for a freelancer?
Utilization rate is billable hours divided by total hours worked. Solo freelancers commonly land somewhere between 50% and 70%, because running the business — marketing, admin, invoicing, proposals — consumes real time that no client pays for. There's no universal target; the value is in tracking your own number over time and knowing that at 50% utilization, a $100 quoted rate is a $50 effective rate before expenses.
Should I track non-billable hours if nobody pays me for them?
Yes — non-billable hours are the hidden cost of every client. A client who takes three unpaid hours of scoping calls for every ten billable hours is far less profitable than one who sends a brief and disappears. If you only track billable time, those two clients look identical on paper, and you'll keep choosing the wrong one.
How do I track billable hours if I charge a flat project fee?
Log hours anyway, tagged to the project. Flat fees make time tracking more important, not less, because the fee is fixed and only your hours can move. Dividing the project fee by actual hours spent gives the effective rate for that project, which is the only way to know whether your flat pricing is working or whether a project quietly turned into an $18-an-hour job.