How to track your hours as a freelancer (and bill every one)

To track your hours as a freelancer, write down every block of work as you do it: the date, the client and project, what you did, how long it took and whether it's billable. A timer is the most accurate way to capture it. An end-of-day log is the easiest habit to keep. A spreadsheet is free and holds either.

Once a week, add up the billable hours for each client. That total is your next invoice.

Why track hours on fixed-price work too

On hourly work, an hour you don't record is an hour you don't get paid for. On a fixed price, the log does two other jobs.

First, it tells you what you actually earned. Say a brand identity project paid £1,500. Your log shows 30 hours on it, so you earned £50 an hour. If you'd priced it expecting 20 hours, the job took half as long again as you planned, and your next quote for that kind of work should change. Our guide to pricing your freelance work shows how to turn a day rate into a quote.

Second, it shows where the time went. Scope creep rarely arrives as one big request. It's an extra round of edits here, a quick call there. A log with a task on every line shows which ones added up, and gives you something concrete to point to when you price the next change.

Three ways to track: timer, daily log or spreadsheet

The best way to track freelance hours is the one you'll keep up, so pick by how your days run.

A timer records time as it happens. If you forget to start it, fix the entry straight away, while you still remember the real times.

An end-of-day log suits a day that's in pieces. Before you close the laptop, go through your calendar, your sent emails and the files you touched. Between them they show most of what you did. Do it the same day: by Friday, Tuesday is a guess.

Mixing is fine: a timer for the long blocks, and a quick log for the calls and emails in between.

What to record for every entry

• The date.
• The client and project. One entry, one project: if a call covered two jobs, split it.
• The task, in words the client could read. "Homepage hero, second round of edits" beats "design".
• The time: a start and end, or a duration.
• Billable or not. Quoting, admin and your own marketing usually aren't billable. Log them anyway, because they're hours your rate has to cover.
• Notes: who asked for a change, which revision round it was.

Notes pay off when a client questions an invoice. "Extra mobile layout, asked for on the Thursday call" settles it before it becomes an argument.

Keep the log with your invoices, since it's the evidence behind them. Gov.uk says self-employed people must keep their business records for at least 5 years after the 31 January submission deadline of the tax year they cover.

A simple time tracking template for Google Sheets

Use one row per entry and these columns:

The formulas:

• Hours: =(F2-E2)*24. Sheets stores times as fractions of a day, so multiplying by 24 turns the gap into hours. Format the column as a number, or Sheets shows it as a time.
• Hours rounded up to the quarter hour: =CEILING((F2-E2)*24, 0.25).
• Billable hours for one client: =SUMIFS(G:G, B:B, "Kelso Studio", H:H, "Yes").

Start a new tab each month and the client totals become your monthly invoice figures.

Rounding and minimum increments

Rounding keeps invoices readable. A line saying 1.12 hours reads like a meter running. Pick an increment, usually 15 or 30 minutes, and keep it fair:

• Agree it in writing first. Put it in your proposal or contract: "Time is billed in 15-minute units, rounded up." Then it's a term the client accepted, not a surprise. Our contract toolkit covers what else belongs there.
• Round blocks of work, not every interruption. Round each three-minute email up to 15 minutes and four quick replies become an hour on the invoice. Group small tasks into one daily entry, such as "Emails and calls", then round that.
• Use one rule for every client. Then any invoice can be explained line by line.

A minimum charge works the same way: a one-hour minimum on small fixes covers the time it takes to get back into a client's files.

Turning hours into an invoice

Pick a billing period and keep to it: weekly, monthly or at each milestone, whatever your contract says. Then:

1. Filter the log to that client, that period and billable entries only.
2. Look for gaps. A day you know you worked with nothing logged is money you're about to miss.
3. Group entries into lines the client can follow, by task or by week, not one line per timer entry.
4. Add the period the work covers. Gov.uk's list of what an invoice must include asks for a clear description of what you're charging for and the date the service was provided.
5. Write the invoice number against every entry you billed, so none of them lands on a second invoice.

If a client wants the detail, send the filtered log with the invoice. Our guide to writing invoices that get paid covers the rest of what goes on it.

Spotting an overrun before it costs you

Every fixed price hides an hour budget. Take a £3,000 project. At an hourly rate of £60, that fee buys 50 hours of your time.

Check the log against it once a week. When you've used half the hours, are you halfway through the work? If you're 25 hours in and the hard part hasn't started, you've found out while there's still time to act. On a retainer, the same check tells you when the month's hours are running out.

Then work out which kind of overrun it is:

• The client asked for more: new pages, another round of edits, a change of direction. Price the change in writing and wait for a yes before you start. Your log shows what it added.
• The work was harder than you thought. That's your estimate, not the client's problem. Usually you finish at the agreed price and quote better next time.

Either way, speak up early. A change raised at the halfway point is a conversation. Raised on the final invoice, it's a dispute.

The bottom line

Pick the method you'll actually keep up, record the same six things on every entry, and total billable hours per client each week. Track fixed-price work as well: it's how you learn your real rate and catch the scope growing while it's still cheap to talk about. Agree your rounding before the work starts, and every line on your invoice will have a log behind it.