Track Billable vs Unbillable Hours Across Clients

To track billable versus unbillable hours across clients, log every working hour against a client and tag it as billable or unbillable, then surface two numbers per client on a single dashboard: total hours worked and the percentage of those hours that turned into revenue. The gap between the two is where most freelance income quietly leaks, and a client who looks profitable on the invoice often looks very different once the unbillable scoping calls, revisions, and admin are counted.

Most freelance designers and writers track billable time well enough to invoice. The blind spot is unbillable time: the discovery call that ran long, the third round of "small tweaks," the proposal that never closed, the chasing of an overdue payment. None of it appears on an invoice, so none of it appears in any sense of how a client is actually performing. A dashboard that puts billable and unbillable hours side by side per client converts that invisible drain into a number you can act on.

Why the invoice lies about client profitability

An invoice records what you charged, not what the work cost you in time. Two clients can each pay for 10 billable hours in a month. Client A required exactly 10 hours of work. Client B required those same 10 billable hours plus 6 hours of unbillable back-and-forth: scope clarification, a redesigned brief, and an unpaid revision round. On paper they are identical. In reality, Client A pays your full stated rate and Client B pays roughly 62% of it.

That ratio (billable hours divided by total hours worked) is the single most useful metric a freelancer can track, and almost nobody does. The pattern is not unique to freelancing. The American Bar Association's Law Practice Magazine describes the same problem in law firms, where the reduction from billable hours worked down to realized amounts is tracked as "cash leakage." If billing-by-the-hour specialists treat that leak as a profit issue worth monitoring, a solo designer juggling Slack threads and Figma comments should too. (Note that a law firm's realization rate, which compares what is collected to what is billed, is a different measurement from the freelancer billable ratio described here; do not read them as the same number.) The fix is not more discipline at invoice time. It is making the leak visible the moment it happens.

The effective rate scorecard

The number that ends the argument about which clients to keep is your effective hourly rate per client. Calculate it as total revenue from a client divided by total hours worked for that client, including unbillable time. A designer charging $90/hour who spends 40% of a client's hours on unbillable work is really earning $54/hour on that account, and a client paying a "low" $70/hour with almost no unbillable overhead may be the better business.

Use this five-point scorecard to grade each client every month:

• Billable ratio: billable hours / total hours worked. Many client-services freelancers treat anything above roughly 75% as healthy, and time-tracking guides for freelancers note that billing 50 to 70% of working hours is common, with the rest lost to admin, marketing, and proposals.
• Effective rate: total revenue / total hours worked, compared to your target rate.
• Unbillable category mix: is the unbillable time scoping, revisions, admin, or chasing payment?
• Trend: is the billable ratio for this client improving or sliding over the last three months?
• Revenue concentration: what share of your total income depends on this one account?

A client that scores poorly on ratio and effective rate but high on concentration is the most dangerous combination: low-margin work you cannot easily walk away from.

A worked example

Consider a freelance writer with four retainer clients in a 120-hour month. Three look fine. The fourth, a mid-sized B2B software firm, pays well and is the writer's favorite to work with, so it never gets questioned. Once every hour is logged and tagged, the dashboard tells a different story: that client consumed 50 total hours, but only 30 were billable. The other 20 were strategy calls, Slack threads, and rewrites requested verbally after copy was approved. The billable ratio is 60%, and the effective rate has quietly fallen to about $48/hour against a $80 target.

The fix was not firing the client. It was a single conversation, backed by the dashboard, that moved verbal revision requests into a capped two-round process and converted the recurring strategy calls into a separate paid advisory line item. The following month the same client's billable ratio rose to 84%, with no change in the relationship and a meaningful jump in real income. The data did the negotiating.

What to track, and how to keep it effortless

A tracker only works if logging time costs almost nothing. Capture four fields per entry: client, hours, billable or unbillable, and a category for the unbillable ones. That is enough to compute every number on the scorecard. The reporting layer should then roll those entries into a per-client view with billable ratio, effective rate, and a month-over-month trend line, plus a portfolio view that ranks all clients by effective rate so the worst account is impossible to ignore.

The trap is building the report by hand in a spreadsheet that you stop updating by week three. A purpose-built dashboard that ingests your time log and computes these ratios automatically removes the maintenance tax that kills most tracking habits. MyDashBorg offers a freelancer client tracker template designed for exactly this, with the billable-ratio and effective-rate math built in, and the "Ask your data" feature lets you type "which client has the lowest effective rate this quarter" and get an answer without writing a formula.

The point of separating billable from unbillable hours is not guilt about unpaid work, which is unavoidable in client services. It is information. Once you can see your true effective rate per client, you can raise prices on the accounts that earn it, restructure the ones that leak, and stop subsidizing low-margin work with the profit from your best clients.

Frequently Asked Questions

What counts as an unbillable hour for a freelancer?

Unbillable hours are any time spent on client work or business operations that you do not invoice for. Common examples include discovery and scoping calls, revisions beyond the agreed rounds, project management and email, chasing late payments, and writing proposals that do not convert. Tracking them does not mean you should bill for all of them; it means you can see how much they cost.

What is a healthy billable ratio for freelancers?

There is no universal number, but many client-services freelancers treat a billable ratio above roughly 75% as healthy, meaning at least three of every four worked hours generate revenue. Ratios that drift below about 60% on a specific client usually signal scope creep, unpaid revisions, or excessive admin that should be addressed through pricing or process changes rather than absorbed silently.

How is effective hourly rate different from my stated rate?

Your stated rate is what you charge per billable hour. Your effective rate is total revenue from a client divided by every hour you worked for them, including unbillable time. A $90/hour designer with heavy unbillable overhead might have an effective rate closer to $54/hour, which is the number that actually reflects what an account is worth to your business.

Do I need software, or can I track this in a spreadsheet?

A spreadsheet works at first, but it relies on you manually computing ratios and updating reports, which most freelancers abandon within a few weeks. A dashboard that ingests your time log and calculates billable ratio and effective rate automatically removes that maintenance burden and keeps the numbers in front of you, which is what makes the habit stick. You can compare approaches and costs on the pricing page.