Most Freelancers Treat Their Timesheet as a Billing Tool. It's Actually a Pricing Engine.
Every Monday, before email, before standups, before the first cup of coffee even makes it to the keyboard, run this 5-minute audit on last week's tracked time. It will quietly transform how you price your work.
The Problem: You're Sitting on Pricing Data and Ignoring It
Most freelancers track time for one reason: to invoice. Hours go in, line items come out, send. Done.
But your timesheet contains something far more valuable than billable hours: the ground truth of your effective hourly rate per client. Most of us never look at it that way.
The contract rate you negotiated and the effective rate you actually earn are almost never the same number. The difference is hidden in:
- Scope creep that didn't get billed
- "Quick questions" that turned into 20-minute Slack threads
- Revisions you absorbed instead of charging for
- Strategy calls that weren't on the SOW
- Context-switching tax across multiple of their projects
You feel this in your body — "this client is exhausting" — but you can't prove it. The audit makes it provable.
The 5-Minute Audit
Open last week's tracked time. For each client, calculate two numbers:
- Total hours logged (billable + unbillable for that client)
- Total revenue earned from that client this week
Divide. That's your effective hourly rate for that client. Compare it to your nominal rate. The gap is what you are silently donating.
For example: Client A logs 12 hours and pays $1,200 — that is $100/hr (matches your nominal $100). Client B logs 18 hours and pays the same $1,200 — that is $66/hr, a 34% gap. The second client is your worst-paying gig dressed up as your best one.
What to Do With the Gap
Three responses, depending on the size:
- Gap under 10%: Acceptable rounding error. Move on.
- Gap 10–25%: This is scope creep. Tighten your SOW. Push small extras into change orders.
- Gap over 25%: Reprice or fire the client.
The freelancers I know who consistently raise their rates aren't the ones doing harder work. They're the ones who can point to a six-month chart of effective hourly rates and say "this client costs me $40/hour to keep."
Why This Requires Real Tracking, Not Reconstruction
This whole exercise breaks if your time data is sketchy. Estimates from memory tend to flatter the client — we round our hours down out of imposter syndrome, especially on the clients we like personally.
You need actual logged time, captured at the moment of work. Whatever tool you use, log every session as it happens, including the unbillable bits. The audit only works if the data is honest.
How FillTheTimesheet Fits In
I built FillTheTimesheet partly because I wanted this audit baked into the product: per-client effective-rate dashboards, a Monday review prompt, and one-tap session capture so the data is actually accurate. But the habit comes first — any tool that gives you per-client hours and lets you mark unbillable time will work.
Key Takeaways
- Your timesheet is pricing data, not just billing data
- Calculate effective hourly rate per client every Monday
- Gaps over 25% mean reprice or drop
- Honest, in-the-moment tracking is the prerequisite — reconstructed time will lie to you
- The freelancers who raise rates well are the ones with data, not nerve
Follow The Speed Engineer on Medium for more on building leaner workflows.
Top comments (0)