EÜR template to fill in online
Enter income and expenses, see your profit, download it as an Excel file. The categories follow the German Anlage EÜR.
Income and expenses
The VAT rows then drop out, and you enter all amounts gross.
Business income
Business expenses
Result
Profit
€0.00
- Total business income€0.00
- Total business expenses− €0.00
The template groups rows of the Anlage EÜR. In ELSTER you enter the amounts in the matching rows of the Anlage EÜR.
Your EÜR, ready from your bookkeeping
Norman sorts every booking into the right EÜR row, and bookkeeping is free. Sending the Anlage EÜR to ELSTER starts with the Klein plan.
Start for freeHow to use the template
During the year: Collect your receipts and enter the totals per category. The Google Sheets version keeps a running total; you get it free by email.
At year end: Copy the totals into the Anlage EÜR in ELSTER. The official form has more rows; the template groups them.
Kleinunternehmer: Turn on the option. The VAT rows drop out, and you enter income and expenses gross.
VAT-registered: Enter income and expenses net. VAT, input VAT and payments to the tax office have their own rows.
Who files an EÜR
Freelancers (Freiberufler): may always use it, whatever they earn.
Traders: with at most €800,000 revenue and €80,000 profit a year (§ 141 AO). Above that, the tax office asks for a balance sheet.
GmbH and UG: file no EÜR; they always prepare a balance sheet.
Filing: You file the Anlage EÜR every year electronically through ELSTER, also as a Kleinunternehmer.
Free EÜR template (Google Sheets)
Enter income and expenses. Profit and the official Anlage EÜR lines are calculated automatically.
FAQ
Does the template replace the Anlage EÜR?
No. The template helps you collect during the year and know your profit. With the tax office you file the official Anlage EÜR through ELSTER.
Do I have to file the Anlage EÜR electronically?
Yes. Since 2017 an informal profit statement is no longer enough, also not for Kleinunternehmer.
Do I enter amounts gross or net?
Net if you charge VAT, with the VAT amounts in their own rows. As a Kleinunternehmer you enter everything gross.
What about purchases over €800?
You depreciate them over their useful life (AfA). Enter only this year's share. Up to €800 net you deduct them at once.
When does income or an expense count?
In the year the money moves (cash principle). For regular payments around the turn of the year, the 10-day rule applies.