BoostExcel main content


License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

Description Size Download

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

1563 KB Download

Download this if you want this design to be set as the default template by the installer program.

6.78 MB Download

Screenshots and Images

The printed version.

Sales Invoicing Format for Germany

Open the template in Excel.

Sales Invoicing Format for Germany (IMFE Edition)


As one of the member countries of the EU (European Union), the rules on German VAT registrations, returns and compliance are based on European Union EU VAT Directives which German has transposed into its VAT Act. This free invoicing sample in Excel and PDF format follows the German VAT compliance rules. It charges MwSt VAT tax at 19% by default.

The German tax law is very formal and also the VAT invoice requirements are very strictly. The German rules are conform to the obligations of the EU VAT Directive and its VAT invoice requirements. Refer to German VAT invoice requirements and VAT invoicing rules for more information.

Foreign companies, or ‘non-resident' traders, providing goods or services in Germany to local businesses or consumers may have to register their business for German VAT. They will then have to follow the German VAT compliance rules, including invoicing and VAT rates, as well as pay over any German VAT due. See "hould you register for German VAT" for more details.

Here on we've already have a category of templates for VAT invoicing at VAT Invoice Templates, which lists the Excel forms that could be used to invoicing German-based clients, this template differs from the others in that all the text labels are translated into German. As detailed at 2016 European Union VAT rates, the standard Germany VAT rates is 19% for most goods and services, although a reduced rate could be applied for some foodstuffs; water supplies; medical equipment for disabled persons; some public transport; books; newspapers and periodicals; admission to cultural events; writers and composers; agricultural supplies; hotel accommodation; admission to sports events; social services; medical and dental care. This sample template set the default rate to 19%, and assuming all items on the form are taxable. In case you need to change the tax rate with Invoice Manager for Excel, follow the steps below.

  1. Click the Settings button on the "Invoice" ribbon tab.
  2. Go to the "Taxes" tab.
  3. Enter the tax rate, such as 7% (reduced VAT rate) into the appropriate text box.
  4. Click "Apply". Invoice Manager for Excel modifies the layout of the template according to your settings, including the formulas used to calculate the tax amount.
  5. Close the "Settings" dialog box.
  6. Save the template by clicking the "Save" button on Excel quick access toolbar.

This template shows no currency symbols. If you want to show the EURO symbols with certain cells, follow the steps below.

  1. Click the "Design Mode" button on the "Invoice" ribbon tab.
  2. Click the cell for which you want to change / set the euro currency symbol, or drag your mouse to select multiple cells.
  3. Right-click one of the selected cell, choose "Format Cells" from the shortcut menu.
  4. On the "Number" tab, choose "Accounting" or "Currency" from the "Category" list.
  5. From the "Symbol" list, choose euro "€".
  6. Exit design mode by clicking the "Design Mode" button again on the "Invoice" worksheet.
  7. Save the template by clicking the "Save" button on Excel quick access toolbar.

For a service bill format edition of this template, visit c4099 Service Billing Template for Germany.

If you are not charging VAT (MwSt), you can hide the fields / cells completely by using this "Settings" box. In this case, you'll also need to add a declaration to the invoicing form,

Gemäß § 19 UStG enthält der ausgewiesene Betrag keine Umsatzsteuer.

It states that you're a Kleinunternehmer and that you don't charge VAT.

Format and Specification

Template# c4098
Name Sales Invoicing Format for Germany
Category Sales Invoice Template
Release Date Sunday, November 20, 2016
Format (XLS or XLSX) .xlsx
Feature Gallery
Columns 4
Lines 12
Line Height (Points) 19.50
Print Area $G$3:$O$43
Papaer Size / Orientation Portrait
Default Margins (Points)
Left 18.00
Right 18.00
Top 75.60
Bottom 75.60
Price Free (0.00 USD)
System Windows 7 and later, and Excel 2007 and later.