Home · Time tracking

How to Calculate Your Effective Hourly Rate from Time Logs

Your quoted hourly rate is a marketing number. Your effective hourly rate is what actually landed in the bank divided by all the hours the work consumed — including the unpaid ones. Freelancers who never compute that gap keep saying “I charge $100/hour” while living closer to $40 after revisions, sales calls, and Friday invoice rebuilds.

This guide is a pricing decision tool, not another tagging tutorial. It pairs with How to track billable vs non-billable hours (classification discipline) and How to turn time logs into invoices (line items). For timer context, see the Toggl Track review and Clockify review.

Pricing disclaimer: Tracker plan features and payment fees change — verify on the vendor site. Independent guidance; no affiliate links by default. Not tax, legal, or financial advice. Examples use round numbers for orientation only.

The two rates (and why both matter)

Rate Formula Answers
Quoted / billed rate What the contract or invoice line says per hour What clients formally agree to pay
Effective hourly rate (EHR) Net cash collected ÷ total hours related to that work What your week was actually worth

A healthy practice tracks both. Quoted rate sets the market story. EHR tells you whether that story is honest after friction.

Principle 0 — Decide the denominator before you open the spreadsheet

Effective rate debates die when people mix denominators. Pick one primary definition per review period:

  1. Practice EHR (monthly): All cash cleared this month ÷ all hours logged this month (billable + non-billable).
  2. Client EHR: Cash from that client ÷ all hours tagged to that client (including unpaid support).
  3. Project EHR: Project cash ÷ all hours on that project (including revisions and unpaid discovery if you include them).
  4. Billable-only rate check: Cash ÷ billable hours only — useful, but optimistic; it ignores admin erosion.

Most freelancers should compute #1 monthly and #3 per large project. Use #4 only as a diagnostic, not a celebration metric.

Step 1 — Gather inputs from tools you already use

You need three piles of data:

A. Cash collected
Invoice tool totals for the period (Wave, FreshBooks, Harvest, PayPal, etc.). Prefer cleared payments, not just sent invoices. Subtract refunds. Decide whether you measure pre-tax or after payment processing fees — pick one and stay consistent. Modeling fees honestly usually means after processing.

B. Hours logged
Export from Toggl, Clockify, Harvest, or FreshBooks time. Include all projects you will count in the denominator. If you did not track a week, you cannot compute EHR for that week — estimate once, then fix the habit.

C. Optional adjustments
Software seats, contractors you paid to deliver, and pass-through expenses. For a pure labor EHR, exclude pass-through costs from both numerator and the related hours. For a “business reality” EHR, subtract direct costs from cash first.

Step 2 — Run the core formulas (with a worked example)

Monthly practice EHR

[ \text{EHR} = \frac{\text{Cash cleared in period}}{\text{Total hours logged in period}} ]

Orientation example (not a promise):

Input Value
Cash cleared (after processing) $6,000
Billable hours logged 48
Non-billable hours logged 22
Total hours 70
Quoted rate $125/hr

That gap is the pricing conversation. Classification habits from the billable vs non-billable guide determine whether the 22 non-billable hours are “normal overhead” or “unpriced client work in disguise.”

Step 3 — Separate erosion sources

Not all gaps are the same disease.

Erosion source Symptom Fix lever
Unpaid revisions Project EHR far below quoted Change orders; revision caps
Sales / proposals Practice EHR low; client EHR fine Cap free discovery; paid audits
Invoice admin Friday hours high; cash fine Better time→invoice tool or ritual
Scope creep Hours grow; cash flat Written out-of-scope rate
Under-tracking EHR looks fake-high Honest timer week
Payment fees / FX Cash < invoice totals Price fees into quotes; see international invoicing guide

Compute project EHR for your last three jobs. If two of three sit under your target EHR, your quoted rate (or scope control) is wrong — not your timer brand.

Step 4 — Set a target EHR (not only a target quote)

Pick a floor for the next quarter:

  1. Personal draw / salary need for the quarter
  2. Plus taxes reserve (jurisdiction-specific — ask an advisor)
  3. Plus software, insurance, and buffer
  4. Divide by realistic weekly hours you will actually log (not fantasy 40 billable)

Example orientation: if you need $8,000/month all-in and you honestly log 100 hours/month total, target EHR ≈ $80. If you quote $100 but live at 70% billable utilization with overhead, you may need a higher quote or fewer non-billable hours — EHR math shows which.

Step 5 — Turn logs into a monthly ritual (45 minutes)

Calendar block: last business day of the month

  1. Export payments cleared this month.
  2. Export all time entries for the same dates.
  3. Compute practice EHR.
  4. Flag any project with EHR < 70% of quoted rate.
  5. Write one decision: raise rate / tighten scope / cut unpaid discovery / change tools.
  6. Archive the CSV + PDF invoice summary together.

Do not wait for tax season. EHR is an operations metric.

Step 6 — Reprice with evidence (scripts you can reuse)

Rate increase (existing client)

Hi {{Name}}, looking at the last quarter’s delivery hours versus fees, the effective rate on {{Project}} landed below our sustainable floor. Starting {{Date}}, new work is {{NewRate}}/hr (or a revised retainer of {{Fee}}). Happy to finish the current SOW at the old rate.

Fixed-fee project with low EHR

The last build consumed {{Hours}} hours against a ${{Fee}} fee (~${{EHR}}/hr effective). For the next phase I’ll quote based on a {{Hours2}}-hour estimate at {{Rate}}, with a written change-order rate for out-of-scope items.

Tone stays calm. The spreadsheet is the confrontation — not your email.

Step 7 — Tooling that makes the math cheap

You do not need a new SaaS for EHR. You need honest logs.

Stack EHR workflow
Toggl/Clockify + Wave/PayPal Export hours + payments; spreadsheet monthly
Harvest / FreshBooks Hours and invoices closer; still export for practice EHR
Spreadsheet only Fine at low volume; error-prone at high volume

Upgrade the timer or billing seat when Friday admin exceeds the seat price at your target EHR — the same rule of thumb used across our tool reviews.

Common mistakes (and fixes)

Mistake Fix
Using billable-only hours as “the” rate Report practice EHR with total hours
Counting sent invoices as cash Use cleared payments
Ignoring processing/FX fees Decide pre- vs post-fee; stay consistent
Comparing one weird month Use rolling 3-month EHR
Raising rates without scope rules Pair price with revision caps
Not tracking non-billable You cannot manage what you pretend is zero

Mini case patterns (composite)

Pattern A — Designer at $120/hr quoted: Monthly cash $7,200; 45 billable + 30 non-billable. EHR = $96. Decision: paid discovery for new brands; keep $120 quote.

Pattern B — Developer on fixed builds: Three projects at $5k each; hours 70 / 55 / 90. EHRs diverge. Decision: estimate with buffers; change orders after round two.

Pattern C — Coach on retainers: Flat $2k/mo; hours swing 12–35. EHR swings with utilization. Decision: hour cap + overflow rate (see retainer guide).

These are illustrations, not promises — always match your own logs.

FAQ

Is effective hourly rate the same as utilization?
Related, not identical. Utilization is billable÷total hours. EHR folds in cash. You can have high utilization and low EHR if you under-priced.

Should I include weekends and learning?
If those hours exist in your log and support the practice, include them in practice EHR. For project EHR, include only project-tagged hours.

What if I do not track time?
You cannot compute EHR honestly. Track for four weeks, then decide. A free timer is enough to start.

Is this tax advice?
No. Taxable income rules vary. EHR is for pricing and capacity, not filing.

Affiliate links?
None by default.

Bottom line

Quoted rate is what you announce. Effective hourly rate is what your time logs and cleared cash prove. Compute practice EHR monthly, project EHR on large jobs, and treat gaps as scope, pricing, or admin problems — not personality flaws. Pair this ritual with clean billable/non-billable tags and a boring invoice cadence. When the math says your week is worth less than your website claims, change the quote or the work — not the story you tell yourself on LinkedIn.


Source markdown: /content/how-to-calculate-effective-hourly-rate-from-time-logs.md · Independent review · Not affiliate by default · Verify pricing on vendor sites.