How to Track Billable Hours as a Freelancer (and Actually Get Paid for Them)

2026-11-12来源 dev.toEnglish

How to Track Billable Hours as a Freelancer (and Actually Get Paid for Them)

Most freelancers don't have an income problem — they have a leakage problem. The work gets done, the hours blur together, and by Friday you can only remember about 80% of what you actually did. The missing 20% is money you earned and never billed. The fix isn't working more hours. It's writing the hours down while they're still fresh, and having a system that turns them into an invoice without a second round of detective work.

1. Billable vs. non-billable: sort every hour into one of two buckets

Before you track anything, decide what counts. There are only two buckets, and every hour goes in one of them:

Billable — the client pays for this. Client work, revisions the client asked for, meetings the client requested, research for a specific client project. In this sample week that's 27.5 hours: Client A 12.5 h, Client B 9 h, Client C 6 h.

Non-billable — the business pays for this. Admin, quotes, chasing late invoices, learning a new tool, your own marketing. In this sample week that's 6.5 hours.

The point of the split is the ratio. Billable hours divided by total hours is your utilization: 27.5 out of 34 hours is about 81%. If your utilization sits under 60% for more than a couple of weeks, you're either undercharging or spending too much of your week on work nobody pays for. You can't see that ratio at all if you only track the hours you remember to invoice.

2. Log hours the day you work them — never from memory

The whole system stands or falls on one rule: the log happens the same day, before you close the laptop. A Friday reconstruction from memory is where the leakage lives. In this sample week, reconstructing from memory recovered 24 of the 27.5 billable hours — the missing 3.5 hours were two short client calls and a round of small fixes that felt too small to write down. At $75 an hour, that's $262.50 unbilled in a single week. Over a year, that's the difference between a comfortable month and a tight one.

Keep the entry stupidly simple — four fields and nothing else:

  • Date and client — which day, whose project.
  • What you did, in one line — "Client A: revised homepage mockups" beats a paragraph.
  • Start and end, or just the total — 1.5 h is enough; stopwatch precision is not the goal.
  • Billable or not — one tick box decides which bucket it lands in.

That's it. If logging takes more than 30 seconds, the system is too heavy and you'll stop using it by Wednesday.

3. Price the hour before you sell it

Tracking hours is pointless if the rate is wrong. The rate is not "what feels fair" — it's your costs divided by your billable hours, with margin on top. Work it out once a year and stop guessing:

  • Monthly costs first. Rent, food, software, tax set-aside, a buffer for slow months. In this sample, say the freelancer needs $4,500 a month to cover everything, including tax.
  • Realistic billable hours, not fantasy hours. A 40-hour week is not 40 billable hours. At the sample week's utilization (81%), a 40-hour week gives about 32 billable hours, or roughly 128 a month.
  • Do the division. $4,500 divided by 128 billable hours is about $35 an hour just to break even. The sample rate of $75 an hour leaves real margin — and explains why a week at 27.5 billable hours bills $2,062.50 instead of barely covering costs.

If your rate is below your break-even number, no amount of careful tracking will fix the month. Run the numbers once, write the rate down, and let the tracker tell you whether the hours are actually there.

4. Turn the week's hours into an invoice in minutes, not an evening

The second place hours leak is the gap between the log and the invoice. A clean week log should become an invoice in under ten minutes:

  • Group by client first. Client A gets one invoice: 12.5 hours at $75, $937.50, with the one-line descriptions attached. Three clients, three invoices, no cross-contamination.
  • Attach the log, don't rewrite it. The same one-line entries from the tracker go on the invoice as line items. The client sees exactly what they're paying for, and you never retype anything.
  • Invoice on a fixed day. Every Friday, or the 1st and 15th — pick one and don't move it. In the sample week, Friday's invoices total $2,062.50 and go out the same day the work is done, while the memory is fresh and the client still remembers the calls.

The habit that pays: invoice the week you worked it. A two-week delay isn't just late cash — it's an invoice you're now writing from a log you half-remember, and the disputed line item that comes back is always the one you can't explain.

5. Watch the numbers that tell you if the week worked

Track four numbers once a week, on invoice day, and nothing else:

  • Billable hours — 27.5 in the sample week. Falling for two weeks running means the pipeline is thinning before the bank account shows it.
  • Utilization — billable divided by total hours, about 81% here. Under 60% means admin is eating the week; over 90% for long stretches means you're heading for burnout with no buffer.
  • Effective hourly rate — money invoiced divided by all hours worked, including non-billable. In the sample week: $2,062.50 divided by 34 total hours is about $61 an hour. That's the honest rate — the one that has to cover your costs, not the $75 on the invoice.
  • Unbilled hours found — the 3.5 hours the same-day log caught that memory would have lost. When this number hits zero for three weeks straight, the system is working.

Five minutes on Friday. If the billable hours are up and the effective rate holds, the week worked. If either slides, you know it the same week — not when the rent is due.

6. Build it once, then it runs itself

You can build this in a spreadsheet in an afternoon: one sheet logging date, client, task and hours; one sheet rolling the week up by client so the invoice writes itself; and a small dashboard showing billable hours, utilization and effective rate at a glance. If you'd rather start from a working file than a blank grid, I sell the exact tracker I described here:

Either way, the system is simple: log the hours the day you work them, split billable from non-billable, and invoice the week you worked it. The hours you're not tracking are the hours you're working for free — and in this sample, that's $262.50 a week.

Alex Lin builds spreadsheet tools for freelancers. Questions or a workbook that doesn't fit your situation — fishdp@proton.me.

原文：https://www.a8q9.cn/en/article/how-to-track-billable-hours-as-a-freelancer-and-actually-get-paid-for-them-676dc8.html

相关文章