Tax Return Panic: Can't Find Your Freelance Invoices and Hours

2026-10-13

The email arrives at 9:12 on a Tuesday morning, while the kettle is still ticking.

Subject: Unterlagen für Ihre Steuererklärung. Please send everything by Friday.

You read it standing up. Then you sit down, because your legs have decided for you.

Let's call you Jana. You are an illustrative freelance illustrator, three years in, working from a small table by the window. Nothing about this story is a real case. But you may know the table.

The folder that wasn't a folder

You open the laptop with the confidence of someone who has surely kept this together.

There is a folder called "Rechnungen 2025". Good sign. Inside: eleven files. You sent more than eleven invoices. You know this the way you know you left the stove on, a small cold feeling under the ribs.

So you search the email. Sent items. "Rechnung". Some are PDFs, some are screenshots, one is a Word file named Rechnung_final_NEU2. One client got an invoice with a number that doesn't fit anywhere. Did you skip a number? Did you send one twice?

Then the hours. Your tax adviser doesn't ask for hours directly, but you want them. You want to know what the year actually looked like. And the hours are in three places: a notebook with a coffee ring on the cover, a phone note that starts in March and quietly stops in June, and your memory, which is not a database.

The quiet arithmetic of dread

By 10:40 you have stopped working on the task and started working on the feeling.

You think: A real business would have this ready. You think: Other people don't do this. You think about the client from the autumn who paid in two parts. Did the second part ever arrive? You scroll the bank statement with one finger on the trackpad, squinting at transfer references that say things like "Danke und Gruß".

This is the part nobody talks about. It isn't the tax itself. It's the small shame of not being sure of your own year. The sense that you worked hard and still can't show it.

And it costs something. Not just this morning. The two evenings you'll spend piecing it together. The sleep you'll lose on Thursday. The invoice you might not find, which means income you can't account for, or work you did and never billed. You don't know which, and that not-knowing is heavy.

At noon you eat toast over the keyboard. A crumb lands between the N and the M. You leave it there.

The call with the adviser's assistant

At 14:30 the assistant from the tax office calls, kindly, because you asked a question by email.

"Do you have a list of your invoices with dates and whether they're paid?"

A list. Such a simple word.

"I'm putting it together," you say. Which is true in the way that digging for a key is putting together a house.

She is not unkind. She says, "Don't worry, it's very common." And somehow that is both comforting and a little sad. Common. As if this is just what working for yourself costs.

You hang up and look at the window. A neighbour is carrying groceries up the steps, perfectly unbothered. You think: Next year, it can't be like this.

But you thought that last year too.

The moment it tips

Here is the small thing that changes the afternoon. Not a miracle. A thought.

You realise the problem was never that you're disorganised. You were never given one place. Invoices lived in one corner, hours in another, payments in your bank app, and "who owes me" in your head. You were asking yourself to be the glue. Every day. For free.

What if the invoice, the hours behind it, the due date and the word bezahlt all sat on the same line? Not a grand system. Just a line per invoice, and a page that fills in when you add one.

You don't fix everything today. For Friday you do the honest, slow thing: you rebuild the year from the bank statement and your sent mail, one invoice at a time, and you write the gaps down as questions instead of guessing. It takes two evenings. It's fine. You get through it.

But you close the laptop on Wednesday with one decision made: January will not find you like this again.

A Monday that feels different

Picture a Monday, a few months on.

It's 8:50. Coffee, the same table. You open one file. You log Friday's two hours for the poster project, and the sum for that client moves by itself. You see that one invoice has turned from "offen" to "überfällig" overnight, a gentle colour, not an alarm, and you know exactly whom to write to, and what number to quote.

It takes ten minutes. You close the file.

When the email comes next autumn, Please send everything by Friday, you read it standing up, finish your tea, and export the list. The assistant on the phone says, "Oh, that's very clear, thank you."

That's all. No drama. Just a year you can actually show.

If you recognise the table

If some part of this was your Tuesday, there's a German-language Excel template made for exactly this: time tracking, invoices with automatic numbering, due dates, a status of offen, bezahlt or überfällig, and a dashboard that shows where you stand. It comes with sample data so you can see it working before you enter your own, and a 30-day money-back promise, so you can try it without holding your breath.

It organises your records. It doesn't replace your tax adviser, who keeps the decisions about your return.

Rechnungs- & Zeiterfassungs-Tracker für Freiberufler (Excel, Deutsch)

You did the work. It's fine to be able to see it.

An illustrative story, written with AI assistance.