Don't Know Who Has Paid? Freelance Invoices at the Swimming Pool

2026-10-13

The air at the swimming pool is warm and smells of chlorine and wet towels. It is Thursday, 4:10 pm. Your daughter is somewhere in lane three, a small bobbing swim cap among other small bobbing swim caps.

You are on the top bleacher with your phone, because the email arrived just as the lesson started.

Hi, quick question: has invoice 2026-14 been settled? Our accounts team can't find it. Thanks!

You do not know. That is the honest answer, and it sits in your chest like a swallowed stone.

Let's call you Marta. You are a freelance copywriter, six years in. You are good at your work, and your clients say so. Nobody has ever asked you to be good at this.

Three files, none of them sure

You open the spreadsheet. Then you open the other one, the one called Invoices_NEW. Somewhere there is also Invoices_NEW_final, and you can't remember which of them you stopped updating in March.

In one file, invoice 14 has a green cell. In another, the same row is blank. Green might mean paid. Or it might mean you sent it. You made that colour system on a good day and never wrote down what it meant.

So you open your banking app, thumb down through the transactions and squint at the reference lines. Some clients write the invoice number. Some write "Services." One writes your name, spelled wrong.

Down in the pool, a whistle blows. Your daughter waves, and you wave back with the bright face of a person who is fine.

The question underneath the question

The email is not really the problem. It is a perfectly polite email.

The problem is what it shows. For a few minutes you, a professional with a business and a website, cannot say who owes you money. You can't say how much, or since when.

You think of the other things sitting in that inbox. A project you finished in August, and you aren't sure you ever invoiced it. A client who is "probably" ten days late, or maybe twenty. A reminder you meant to send, but you couldn't face the small awkwardness of it, so you told yourself you'd do it tomorrow.

Nobody talks about this part of working for yourself. The work is the easy part. It is the quiet not-knowing that costs you: the low hum of worry in the supermarket queue, the way you check your balance twice before buying the nice coffee, the sense that you're winging it.

It also costs you your standing with yourself. You feel like someone playing at business, even though you have done this for six years.

The answer that took forty minutes

After the lesson, in the damp changing-room corridor, you're holding a towel and a wet backpack and still scrolling. Back in the car, with the heater running, you finally find it. Invoice 14 was paid eleven days ago, by a transfer that said "Services."

You reply. Yes, it was settled on the second. Happy to send the confirmation. The tone is calm and professional, as if you had known all along.

You didn't, and the forty minutes it took to find out are gone. So is the free, easy part of the afternoon you had planned to spend with your daughter.

She climbs into the back seat, hair dripping, and asks if you can get a pretzel. You say yes. You are quiet on the drive home, because you've just noticed something: this was a good case. The invoice was paid. What about the ones that weren't?

What a different Thursday could feel like

Imagine the same email, the same bleacher, the same chlorine air.

You open one file. One. Invoice 14 sits in its row with a clear status, a due date and the day it was paid. You glance at it for ten seconds and type: Yes, settled on the second. Then you put the phone away and watch lane three.

Imagine that on Monday mornings you spend a few quiet minutes looking at a single overview. You see which invoices are open and which are paid. Anything overdue is easy to spot, without a hunt through bank lines. The hours you worked this month sit right next to what you billed, so nothing slips through between "finished" and "invoiced."

The knot loosens, because you can see it. Chasing a late payment no longer feels like begging, since you're simply following up on a fact you already know. And the evenings go back to being yours.

None of this requires you to become a different person, someone who loves admin. It just needs one place where the answer already lives.

If you saw yourself on that bleacher

If Marta's Thursday felt familiar, you don't have to fix it all this week.

We made an Rechnungs- & Zeiterfassungs-Tracker für Freiberufler, an Excel template in German. It brings time tracking, invoices with automatic numbering, due dates, the status open / paid / overdue, and a simple dashboard into one calm workbook. It comes with sample data, so you can see how it looks before you enter your own clients. It supports your organisation and does not replace a tax professional.

There is a 30-day money-back promise: if it doesn't help, you get a full refund, no questions.

Take a look at the tracker here

And if you only take one thing from this story, let it be that "I don't know who has paid" is not a character flaw. It is just what happens when three files try to do one job.

An illustrative story, written with AI assistance.