Serious Numbers – fox logo

Belegfrieden 2026 · EÜR spreadsheet for small business owners (Kleinunternehmer)

Belegfrieden: your cash-basis profit calculation (Einnahmen-Überschuss-Rechnung), sorted month by month.

The spreadsheet template for small business owners (Kleinunternehmer) and part-time self-employed people: you enter what comes in and what goes out, and Belegfrieden assigns it to the lines of the Anlage EÜR 2026. About 15 minutes a month is enough. For Microsoft Excel.

One-off payment, no subscription. Download immediately after payment. Can be used for any number of businesses and clients.

Sound familiar?

Your side business is going well. You write invoices, buy a specialist book now and then, go out for a meal with a customer. The receipts end up in a folder, in your mailbox, in your PayPal account.

And then the tax return comes round. You open ELSTER, see the Anlage EÜR and ask yourself:

That is not a sign of disorder. You simply lack a system that fits your size. You do not need big accounting software for this, but you do not want a blank sheet of paper either.

The solution: Belegfrieden

Belegfrieden is a ready-to-use spreadsheet for your cash-basis profit calculation (Einnahmen-Überschuss-Rechnung) as a small business owner (Kleinunternehmer, § 19 UStG).

I am a bookkeeper and built the file the way I would want it for small self-employed people: you enter only what is necessary, and the file calculates the rest.

How it works

1

Set up once (about 5 minutes)

Year, small-business scheme (Kleinunternehmerregelung) yes/no, prior-year turnover.

2

Once a month (about 15 minutes)

Lay your bank statement next to it, enter income and expenses, choose the category from the list.

3

At year end

The annual totals are ready, sorted by line and code number of the Anlage EÜR 2026. You transfer them to ELSTER yourself.

What the file keeps track of for you

What you get

Ten sheets in one file (sheet names stay in German): Start · Einnahmen · Ausgaben · Kategorien · EÜR-Übersicht · KU-Grenzen · Rechnungsausgang · Belegcheckliste · Jahresabschluss · Hinweise

It also includes a receipt checklist (Belegcheckliste) with twelve monthly tasks, a year-end checklist (Jahresabschluss) with 17 items from reconciling the bank account to the ELSTER transfer, and a check of the mandatory details for small-business invoices.

The file contains no macros. Formulas are secured with sheet protection without a password so that nothing is overwritten by accident. You can add your own categories in the spare rows.

Runs with: Microsoft Excel. Tested in Microsoft Excel. Not tested in LibreOffice Calc.

Delivery format: right after payment you download a ZIP file. It contains the Excel spreadsheet, the example file and the PDF short guide. The download link is valid for 30 days and limited to 30 downloads.

Corrections and updates are free for 12 months from the date of purchase. I send them by email to the address you gave when you bought, or provide you with a new download link. You will receive the 2027 edition free of charge in any case, even if it is only released after the 12 months have expired.

Belegfrieden suits you if you …

  • use the small-business scheme (Kleinunternehmerregelung) under § 19 UStG,
  • determine your profit by a cash-basis profit calculation (Einnahmen-Überschuss-Rechnung, Anlage EÜR),
  • work self-employed or part-time, for example with texts, courses, handmade goods or consulting,
  • file your Anlage EÜR yourself via ELSTER and want clean preparation for it,
  • prefer working with a clear spreadsheet to using large software.

Belegfrieden does not suit you if you …

  • are subject to VAT (umsatzsteuerpflichtig). This version does not cover VAT (Umsatzsteuer), input VAT (Vorsteuer) or the advance VAT return (Umsatzsteuer-Voranmeldung).
  • have to prepare a balance sheet (e.g. as a GmbH).
  • need a solution that logs every change and by itself meets the GoBD requirements for unalterability. A spreadsheet cannot do that.
  • expect the file to take the tax return off your hands or to answer tax questions.

Price

Belegfrieden 2026

14 €

One-off payment, no subscription. Download immediately. The purchase is made directly with me (Serious Numbers, Dorothee Müller), paid via Stripe. The price shown is the final price; any VAT that may apply is included. There are no shipping costs.

Belegfrieden is digital content. You will receive your invoice separately by email. Stripe sends the payment receipt; it is not an invoice.

Intended for self-employed people who are subject to tax in Germany.

Sold only to buyers with an invoicing address in Germany (no sales to the United Kingdom).

Your own entries (e.g. descriptions, customer names) are not translated: they appear on the German output sheets exactly as you entered them. Selection values such as Ja/Nein also stay in German. Labels, categories and fixed values are output by the file in German.

Important before you buy: digital content

Right of withdrawal (Widerrufsrecht): If you are a consumer, you have a right of withdrawal of 14 days from conclusion of the contract. It expires early if, during checkout, you expressly agree that I may begin providing the download before the withdrawal period has ended, and confirm that you thereby lose your right of withdrawal (§ 356 (6) BGB). For this you tick two separate mandatory fields at payment. You receive the confirmation of your contract by email. Please read the withdrawal notice (Widerrufsbelehrung) and the model withdrawal form. As a business customer (Unternehmer) you have no statutory right of withdrawal.

Statutory warranty (Gewährleistung): For digital content there is a statutory warranty right (§§ 327 ff. BGB). More on this under Statutory warranty (Gesetzliche Gewährleistung).

Functionality and compatibility: spreadsheet template without macros and without technical protection measures, for Microsoft Excel. Tested in Microsoft Excel. Not tested in LibreOffice Calc. Updates: corrections and updates are free for 12 months from the date of purchase. I send them by email to the address you gave when you bought, or provide you with a new download link. You will receive the 2027 edition free of charge in any case, even if it is only released after the 12 months have expired. The statutory obligation to provide updates under § 327f BGB remains unaffected.

The General Terms and Conditions (AGB) apply; the German terms remain authoritative. Notes on data protection: Privacy notice for purchases (Datenschutzerklärung Kauf).

Frequently asked questions (excerpt)

Which programs do I need?

Microsoft Excel. Tested in Microsoft Excel. Not tested in LibreOffice Calc. Apple Numbers can open the file but has not been tested.

Does the file apply to the 2026 tax return?

Yes. The lines and code numbers correspond to the official Anlage EÜR 2026 form.

I am not (or no longer) a small business owner (Kleinunternehmer). Does it still work?

No. This version is built only for the small-business scheme (Kleinunternehmerregelung).

How do I get help?

By email to seriousnumbers1971@gmail.com.

Are there corrections and updates?

Yes. Corrections and updates are free for 12 months from the date of purchase. I send them by email to the address you gave when you bought, or provide you with a new download link. You will receive the 2027 edition free of charge in any case, even if it is only released after the 12 months have expired.

Will I get an invoice?

Yes. You will receive your invoice separately by email. Stripe sends the payment receipt; it is not an invoice.

May I use the spreadsheet for several businesses or my clients?

Yes, for any number. You may not pass on or sell the file itself.

All questions and answers →

Ready for more peace of mind with your receipts?

15 minutes once a month, and at year end your figures are ready, sorted.

Note: not tax advice

Belegfrieden is a tool for keeping your own records of income and expenses. The template and the short guide are not tax or legal advice and do not replace individual advice from a tax adviser (Steuerberater) or the tax office (Finanzamt). Rates, limits and line numbers reflect the position as of November 2026. Please check them against the official source before you file. You submit the Anlage EÜR yourself via ELSTER.

Belegfrieden is a product of Serious Numbers · seriousnumbers.de · Legal notice (Impressum)