The Client Asked About Hours: Track Freelance Projects in Excel

2026-10-12

It's 4:40 on a Thursday afternoon, and an email has just landed from a client you like.

Quick question: could you send me a summary of the hours on the website project so far? Our finance person is asking.

Simple question. Friendly tone. And your stomach drops anyway.

Because you know what "the hours so far" means. Some of them are in the timer app, the ones you remembered to start. Some are in the paper notebook next to your keyboard, in handwriting you can only half read. A few are only in your head: the long call on Tuesday, the two rounds of revisions you did on the train.

And the invoices? One is in a folder called Invoices_NEW. One is in Invoices_final. You think there was a third, but you're not sure whether it was ever sent.

You open a blank spreadsheet and stare at it. The cursor blinks. You haven't typed anything yet, and you already feel a little bit like a fraud.

The quiet tax of "I'll sort it out later"

Nobody warns you about this part of freelancing.

The work itself is fine. You're good at the work. It's the remembering around the work that wears you down: which project is at what stage, how many hours went into it, what has been billed, what hasn't, and what is due when.

So you keep it all in your head, and your head quietly becomes a very busy office with no filing cabinet.

The cost doesn't arrive as one big bill. It comes in small pieces:

• The Sunday evening you spend rebuilding last month from bank statements and calendar entries.
• The invoice that goes out a week late because you weren't sure of the number.
• The moment a client asks a perfectly normal question and you answer, "Let me get back to you," because you can't answer honestly right now.
• The faint suspicion that you worked more than you billed, but no way to prove it, so you let it go.

That last one is the loudest. Not because of one missing invoice, but because you can't tell. Not knowing is its own kind of weight.

Forty minutes you didn't plan on

Back on Thursday. You do what you always do. You dig.

You export the timer data. You open the notebook and squint. You scroll your sent emails looking for the word "invoice." You find one. Then another. You add up numbers on your phone calculator and get two different answers, so you do it again.

Forty minutes later you have a number. You think it's right. You write the reply, delete a sentence that sounds defensive, and add "approximately" in two places. You hit send.

Then you sit there, and the thought arrives, the one you try not to look at directly:

I run a business. Why does it feel like I'm guessing?

It isn't that you're disorganised. You're someone who is doing the work of five roles, with the tools of none of them.

The moment it clicks

The turning point is rarely dramatic. It's usually small.

Maybe it's a friend, also freelance, who mentions in passing that she just "looks at the sheet." That's all. She doesn't dig, she doesn't reconstruct. When a client asks about hours, she has the answer before her coffee cools.

You realise she isn't more disciplined than you. She isn't working harder. She simply has one place where everything lives: clients, projects, hours, invoices, side by side. A place that remembers so she doesn't have to.

And you think: It doesn't have to be like this.

Not a giant software suite with a monthly fee and forty menus. Not an accounting course. Just one quiet, ordinary spreadsheet that knows what you've done and what you're owed.

What a normal Monday feels like after

Picture a different Monday.

It's 9:15. You make tea, open one file, and look at it for about a minute. It tells you which projects are active, how many hours have gone into each, and which invoices are out in the world. Anything that has slipped past its due date is simply visible, with no detective work required.

There's no little knot in your stomach when you open it. Nothing in there is going to surprise you.

At 11:00 a client writes, "Can you tell me where we are on hours?" You answer in two minutes, with a real number, and you mean it. No "approximately." No "let me get back to you."

The end of the month stops being an event. It's just the month ending. The invoice goes out when the work is done, with the next number already waiting, and your Sunday evenings go back to being yours.

The work is the same. You are the same person. But you feel like someone who runs a business, and it turns out that feeling was mostly about knowing where things stand.

If you saw yourself in that Thursday

If any of this sounded familiar, the notebook, the three folders, the "approximately," you don't need to become a different kind of person. You just need somewhere to put things.

That's what we built the Freelancer Project, Time & Invoice Tracker for. It's an Excel file for your clients, projects, hours and invoices, with automatic invoice numbers, due dates, overdue flags and a simple dashboard. It comes with sample data so you can see how it looks when it's filled in, and a PDF guide for when you want it.

It's small on purpose. It won't run your business for you, and it isn't tax or legal advice. It just gives your head a filing cabinet.

If you'd like to take a look, it's here: Freelancer Project, Time & Invoice Tracker (Excel)

And if you're not ready, that's fine too. Maybe just notice how it feels the next time a client asks a simple question. That feeling is worth listening to.

An illustrative story, written with AI assistance.