An association can create e-invoices from its existing Excel template. Whether it must issue them depends on the transaction and its VAT treatment. Charitable status alone does not answer that question. This guide explains how to assess the requirement and use TabellenFaktura to turn an actual association service into a structured invoice.

When does an association need an e-invoice?

What matters is the area in which the association acts. Business activities can fall under German domestic B2B rules. A transaction solely in the non-business area does not create the corresponding e-invoice issuing or receiving requirement. An association may have both areas. A blanket statement covering every association payment would therefore be wrong.

First identify the transaction: who provides what service to whom? Is the recipient acting as a business? Is the transaction taxable or exempt? A membership contribution is not automatically the same as a separately paid service. A donation receipt likewise does not replace an invoice for a paid service.

Distinguish charitable status from the small-business VAT rule

A charitable association may also carry out business activities. This does not automatically establish a VAT rate or require every document to be an e-invoice. For transactions exempt under section 19 UStG, section 34a UStDV continues to allow other invoices. Assess this status separately from other exemptions and transition deadlines.

When voluntarily issuing a structured invoice without charging VAT, the tax category and exemption reason must match the actual service. Do not simply enter zero percent when a different VAT treatment applies. Clarify uncertain cases with your tax adviser before export.

Which transition rules apply through 2028?

In 2026, the general issuing transition remains available. In 2027, the turnover-based extension depends on whether the issuer’s previous-year turnover does not exceed €800,000. This general extension ends in 2028. Independent exceptions must still be assessed. Receiving and issuing are different matters; issuing relief does not generally postpone receiving requirements for associations acting as businesses.

Prepare the existing Excel template

Make a working copy of your invoice template. Clearly identify the association’s full name as issuer, its address, relevant tax identifier, recipient, invoice number and date. Include a service description and date, quantities, units and prices. The role of treasurer does not replace the name of the association providing the service.

In TabellenFaktura, map the invoice fields to the relevant Excel cells or line-item columns and check the imported values in the preview. Protected or inaccessible areas must be unlocked by an authorised person. TabellenFaktura does not decide which VAT area an association’s income belongs to.

A practical example without assuming tax treatment

Fictional example: an association invoices a separately agreed service with two units at €150.00 net each. The net amount is €300.00. Only if that actual service is subject to 19% VAT does this produce €57.00 VAT and €357.00 gross. The example does not prescribe a VAT rate for association services. An exempt transaction requires different invoice settings.

Check the same three points in Excel and in the imported data: do quantity and unit price agree? Does the VAT treatment match the service? Do the total and amount due agree? An attractive template alone does not ensure consistency.

Choose ZUGFeRD or XRechnung for the recipient

Agree the format with the recipient. A ZUGFeRD invoice using version 2.5.2 (PDF/A-3) contains a readable PDF and embedded data. XRechnung is a structured XML file. Public-sector recipients may also specify a routing ID and delivery channel. Renaming an XLSX file does not replace either export.

Check before sending and filing

Check the file technically and also review its content: correct association, recipient, actual service and agreed amount. For ZUGFeRD, the visible invoice and embedded data must agree. Keep the original output file in your organised filing process. Recreating it later from an edited Excel file is not the identical original document.

Sources and scope

As of 18 November 2026. Sources: section 14 UStG, section 27(38) UStG, section 34a UStDV and the Finance Ministry’s e-invoicing FAQ for associations. This article provides general guidance and does not replace individual tax advice.

For the practical workflow, try TabellenFaktura for Excel free for 30 days. Then optionally €49.95 excluding VAT per year, €59.44 including 19% VAT, for one Windows PC. No automatic subscription. All updates during the licence period are included. Microsoft Excel and Windows are required.

The complete guide

Related practical guides

FAQ

Frequently asked questions

Must every charitable association issue e-invoices?

No. The transaction, business activity and exceptions matter. Charitable status alone means neither a general requirement nor a general exemption.

Can the association keep its Excel invoice template?

Yes. TabellenFaktura reads mapped data from the configured template and creates the selected e-invoice format. VAT treatment and factual accuracy must be established first.

Can an association using the small-business VAT rule continue sending other invoices?

For transactions exempt under section 19 UStG, section 34a UStDV continues to allow other invoices. Distinguish this exception from transition deadlines and invoice receipt.