Who Still Owes You? Tracking Unpaid Invoices in Excel, Free

2026-10-12

It's 10:40 on a Tuesday night. The dishes are done, the laptop is open on the sofa, and you're typing a question into your inbox search bar that you've typed a dozen times before: "invoice".

You're not looking for anything specific. You're trying to answer one simple question. Who still owes me money?

The results scroll past. Some threads have a "Thanks, will pay this week!" at the bottom. Some just end with your PDF and silence. One is from March. Or was it April? You open it, squint at the date, and try to remember whether that client ever paid or whether you just stopped thinking about it.

It's a small thing. It's also the thing that makes your stomach tighten a little every time rent day gets closer.

The quiet arithmetic in your head

Here's what nobody mentions about working for yourself: half the job is remembering.

You remember that Studio A pays on time, always, within a week. You remember that the café owner needs a gentle nudge. You remember that the agency said "net 30", but you can't quite recall whether you wrote that on the invoice or only agreed to it in a call.

So you keep a running tally in your head. Roughly this much outstanding, roughly these people, roughly this long ago. It's a fuzzy, low-grade hum behind everything else you do.

And it costs you things.

It costs you the evening, like tonight, spent piecing together a picture that should take five seconds to see.

It costs you the follow-up you meant to send last week, which now feels awkward because so much time has passed. Waiting a bit longer feels easier than writing "Just a quick reminder..." to someone you like.

And it costs you a certain feeling of being professional. You do good work. You'd like your admin to feel as solid as your work does.

The email you almost didn't send

Imagine a freelance designer. We'll call her Mara. She's not real, but you might know her.

Mara finishes a branding project in early spring. She sends the invoice, gets a friendly reply, and moves on to the next job. Then the next one. Then a busy stretch where she's working into the weekends.

In summer she's doing her quarterly tidy-up and notices something: that spring invoice never shows as paid anywhere. She isn't sure whether it slipped through, whether the client forgot, or whether she forgot to log it.

So she has to ask. And asking, after that much time, feels like admitting she wasn't paying attention.

The client, as it turns out, simply missed it. It happens. Everyone's busy. The payment arrives two days after her message, with an apology.

But Mara doesn't feel relieved. She feels a little uneasy. What if I hadn't looked?

The moment it doesn't have to be like this

The turning point rarely looks dramatic. It's usually a small, tired thought on a Tuesday night:

I shouldn't have to dig for this.

Because really, the information already exists. Every invoice you've sent has a number, a date, an amount, a client, and an agreed deadline. It's all there. It's just scattered across PDFs, sent folders, and your memory.

What if it all lived in one calm place instead? A single sheet where each invoice sits in a row, where "due" is simply a date, and where anything past that date quietly announces itself, with no detective work and no guilt?

That's the whole idea. Not a complicated accounting system. Not software with seventeen menus. Just a simple, honest list that does the remembering for you, so your head can go back to doing the work you're actually good at.

A normal Monday, afterwards

Picture it.

It's Monday, 9:05. Coffee is still too hot to drink. You open one file, and in a few seconds you can see it: what's been sent, what's been paid, and what's slipped past its due date.

Two rows are marked. Nothing alarming. Just two invoices that crossed their deadline last week.

You write two short, friendly messages. Not awkward ones, because it's only been a few days, and a few days is an easy thing to mention. "Hi, just checking that invoice 2026-041 reached you, the payment date was last Thursday." Done. Sent. Coffee's finally drinkable.

The rest of the morning belongs to your actual work.

That night, nobody's searching their inbox for the word "invoice". The hum in the background is gone. You know where you stand, roughly to the euro, without having to reconstruct it.

It isn't that you've become a different person. You've just stopped carrying something that never needed to live in your head.

If you recognised yourself in this

If you've ever sat on the sofa late at night trying to work out who owes you what, you probably don't need more discipline. You need a better place to put the information.

You can absolutely build this yourself in Excel, and plenty of people do. If you'd rather start with something already set up, we made the Freelancer Project, Time & Invoice Tracker (Excel): a workbook for 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 feels, and a PDF guide to get you started.

No pressure at all. If it sounds like the quieter Monday you're after, you can take a look here:

Freelancer Project, Time & Invoice Tracker (Excel)

Either way, may your next "who owes me?" question take five seconds, not an evening.

An illustrative story, written with AI assistance.