How to Track Billable Hours for Freelance Invoices

By Cedar & Ledger

If you bill by the hour, your invoice is only as good as your time log. Hours you forget to write down are hours you worked for free, and a vague total like "about 10 hours" is harder for a client to approve than a short list of dates and tasks. A simple routine fixes both.

The client, hours and rates below are a made-up example to show the steps, not a real job. This is general information, not legal, tax or financial advice.

Quick checklist

• ☐ Agree on your hourly rate and billing increment up front
• ☐ Log start and stop times the same day you work
• ☐ Write one short line about the task for each entry
• ☐ Mark what's billable and what isn't
• ☐ Total the hours per client each week
• ☐ Turn the total into invoice lines (hours x rate)
• ☐ Keep the log in case the client asks

The steps below walk through each one.

Step 1: Agree on the rate and the increment

Before the work starts, write down the hourly rate and how you round time. Many freelancers bill in 15-minute steps (0.25 hours) and round up, so a 50-minute call counts as 1 hour and a 10-minute email counts as 0.25. Say how you round in the quote so it's never a surprise. If you're still setting your rate, see How to Set Your Freelance Hourly Rate.

Example (made up): $55 an hour, billed in 15-minute steps, so each step is $13.75.

Step 2: Log time the same day

Memory is the weak spot. Write the start and stop time when you begin and finish, or at the latest before you stop for the day. A notes app, a paper notebook or a spreadsheet tab all work; what matters is doing it every time. Reconstructing a week on Friday usually means missing small tasks like calls and quick fixes.

Step 3: Add a short task line to each entry

Each entry gets the date, the client, the hours and a few words: "homepage text edits," "call about new menu," "resized photos." These lines are what turn a number into something the client can check.

Step 4: Mark billable vs. non-billable

Not every minute is billable. Decide what counts for each client: maybe calls are billable but sending the invoice isn't. Mark non-billable time anyway; it shows how long a client really takes and helps you price the next quote.

Step 5: Total hours per client each week

Once a week, add up each client's billable hours. The free hours worked calculator totals a week of start and stop times with breaks and multiplies by your rate.

Example (made up): Riverbend Dental, one week:

Quick check: 2.5 + 1.75 + 3 + 0.5 + 2.25 = 10 hours. At $55 an hour that's $550.

Step 6: Turn the total into invoice lines

Put hours in the quantity column and your rate next to it, one line per type of work or one line per week, whichever the client prefers. "Website updates, week of Mar 2: 10 hrs x $55 = $550" is clear and easy to approve. What to Put on a Freelance Invoice lists the other fields every invoice needs, and Invoice Payment Terms Explained covers due dates.

Step 7: Keep the log

Save each week's log with the invoice it went into. If a client asks what the 10 hours covered, you can send the five lines above in a minute. It also shows you which clients take more time than you quoted.

Common snags

• Logging at the end of the week. Small tasks disappear. Log the same day.
• No rounding rule. Pick one increment and use it for every entry.
• One big line on the invoice. "Work, 38 hours" invites questions. Add task notes or split by week.
• Going over a quoted estimate without saying so. Check hours against the quote mid-project and tell the client before you pass it.

A spreadsheet to bill it from

A notebook and a calculator work fine. If you'd like a head start on the invoicing side, the Freelancer Invoice + Client Tracker ($9, Excel and Google Sheets) has a printable invoice with up to 12 line items and a "Qty / hrs" times rate column, a clients tab with billed, paid and outstanding per client, an invoice log where status shows Paid, Open or Overdue on its own, and a dashboard (details). It doesn't have a timer or a daily timesheet tab, so you keep the time log above alongside it and copy the weekly totals in.

Honest note: I make this template and sell it under Cedar & Ledger, so I'd earn from a purchase. General information only, not legal, tax or financial advice.

Related template: read about the freelancer invoice template

See all Cedar & Ledger templates