Bank Payments Won't Match Your Invoices? The Paint Mixer

2026-10-28

Tuesday, 10:20 am. You are standing at the paint counter of a hardware store, holding a tin of white for the spare room. The machine behind the counter shakes it with a long rattle. The sign says twelve minutes.

You take out your phone and open the banking app. Not because you want to. Because you have been meaning to check since Friday.

Three new deposits. One says SEPA CREDIT REF 4471. One says Zahlung Rechnung, nothing else. One is just a company name you half recognise, and an amount that isn't any number you invoiced.

You are a freelance illustrator. Let's call you Mara. You have five invoices out. You can feel that at least two of them are paid. You just can't say which.

The rattle and the guessing

You open your invoice folder on the phone. It's a list of PDFs with names like Rechnung_final_v2. You scroll. You squint. You try to do the sum in your head while the machine rattles on.

Is 1,190 the Hartmann job with VAT? Or the logo for the bakery, with the rush fee you added at the last minute?

You don't know. And the quiet part is worse: you don't really know who still owes you. You know it feels like a lot. That feeling sits low in your stomach, like a coin you swallowed.

So you do what you always do. You tell yourself you'll sort it on Sunday. You have told yourself that on four Sundays.

What it quietly costs

Nobody warns you about this part of working for yourself. It isn't the big, dramatic unpaid invoice. It's the fog.

The fog means you hesitate before writing a reminder, because what if they already paid and you just can't see it? Imagine writing "Just a gentle nudge about invoice 2031" to someone who transferred the money two weeks ago. You'd want the floor to open.

So you wait. And waiting means the client who really is late gets another week of silence, and you get another week of low-grade worry.

The fog also means that when your accountant asks for a list, you lose an afternoon to it. And when a slow month appears, you can't tell whether it's slow, or whether the money simply arrived and you didn't notice.

You are not bad at this. You are doing the job of a back office with a banking app and a good memory. A good memory is not a system.

The turn, between the shelves

The paint is ready. The man at the counter wipes the lid and presses it down with the heel of his hand. "There you go. Mixed to the exact shade."

Exact. You turn the word over on the walk to the till.

What if the numbers in your business could be that exact? Not complicated. Just one place where each invoice has a number, a due date and a plain status: open, paid, late. And where a payment you see in the bank has somewhere to land, so you tick one line and the picture updates.

Not a project. A habit the size of a cup of tea.

You realise you don't need a better memory. You need the answer to be written down in one spot, in the same way every time, so that your head can stop holding it.

A different Tuesday

Picture the same morning, a few weeks later.

You are in the same queue, or one just like it. The banking app buzzes: a deposit, vague reference, a familiar amount. You smile a little. You know where that goes. Tonight, or tomorrow with your coffee, you'll mark it, and one line turns from open to paid.

On Friday you take ten minutes with a list that tells you plainly: two invoices are open, one is a few days past due. You write one calm, friendly reminder to the one that is actually late. No guessing. No wincing.

The coin in your stomach is gone. You didn't earn more that week. You simply know what you have. It turns out that knowing is most of the relief.

And on Sunday, you go for a walk instead of sorting through PDFs.

If this is you at the counter

If you recognise yourself in the vague bank lines and the Sunday that never comes, there is a simple place to start. It's an Excel tracker we made for exactly this: clients, projects, hours and invoices in one workbook, with automatic invoice numbers, due dates, overdue flags and a dashboard that shows who owes you what. It comes with sample data, so you can see it working in the first few minutes, plus a short PDF guide.

It keeps your records organised. It doesn't replace a tax professional, and the decisions stay with you.

Get Paid On Time – Freelance Invoice, Hours & Client Tracker (Excel)

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

An illustrative story, written with AI assistance.