TabellenFaktura for Excel · Manual

Create and send your first invoice

After setup, complete your Excel workbook, validate the invoice in the wizard and check the generated file before sending it.

Version 1.6.17 Updated 9 November 2026

Change application

1. Prepare the invoice in Excel

  1. Create a copy of the finished template and save it under a unique name.
  2. Enter the buyer with address and e-mail or via Customer → Insert customer The
  3. Add the invoice date, the date or period of supply and the payment due date.
  4. Enter each line item with its quantity, unit and net unit price.
  5. Recalculate the formulas, check the totals and print preview, and save the workbook.

Example: A setup to 780,00 €, four workshop hours to 120,00 € and a documentation to 190,00 € result 1.450,00 € net. If the patient is 19 % VAT the 275,50 € Control and 1.725,50 € bru toto. This is a calculation example; recipients, data and tax treatment of the actual invoice must fit.

Three identified sample items with quantity, unit, unit price and net amount
The three sample positions are 1.450,00 € net. Compare this list in the wizard with the performances in Excel.

Something not quite right?Report an error

2. Use a unique invoice number

If the Number circle is established; e-invoice → Accounting management → New number The number is reserved and written in the allocated invoice number cell. Only then will the final invoice be created.

A unique number can be used for an existing number system. Do not take an old number from the copied workbook. The final creation checks the number against the local journal.

Something not quite right?Report an error

3. Open and check ZUGFeRD invoice

  1. Activate the correct billing sheet and Create ZUGFeRD invoice The
  2. The General Check the billing, number and data.
  3. Salesman and Buyer check.
  4. The Line items compare the complete list with the Excel invoice, taking into account the last position and any subsequent pages.
  5. VAT, Totals, Payment and where appropriate: Invoices The
  6. Check click on error messages, correct causes and check again.

Preferably correct values in the Excel workbook to match print image and structured data. After changes in the wizard, compare both views again.

Something not quite right?Report an error

4. Create the final file

  1. Create ZUGFeRD PDF The
  2. Check and save the proposed file name and location.
  3. Completely await the preparation and the technical audit.
  4. Compare PDF and embedded invoice data in the results view: Recipient, number, date, all items, tax and payment amount.
Result window with PDF preview left and embedded ZUGFeRD data right
The result view connects the readable PDF and its structured data.

Existing output and archive files are not overwritten. In case of a collision use a new file name; in case of already finalized invoice number use the existing document or a technically appropriate correction process. The final invoice is also stored in the archive and recorded in the journal. A successfully generated file has not yet been sent to the customer. Technical validation does not replace the verification of the actual business process.

Pass the generated file unchanged.

The finished ZUGFeRD PDF is not again "print as PDF, edit afterwards or replace it with an ordinary PDF export. In doing so, embedded invoice data can be lost or no longer fit the visible document.

Something not quite right?Report an error

5. Control and send to Outlook

  1. In the Result View Send by e-mail The
  2. Check the recipient, sender account, subject and message. The stored email template is filled with the invoice data.
  3. Open the Outlook draft.
  4. Check the recipient, sender, signature and actual PDF attachment in Outlook again.
  5. Only then in Outlook Send The
Light Outlook draft with recipient, subject and PDF invoice as attachment
TabellenFaktura prepares the design. The shipment is only made via "Send, in Outlook".

For other mail programs, attach the finished file manually. In XRechnung, the generated XML is transmitted via the channel specified by the recipient, if necessary a billing portal instead of e-mail. TabellenFaktura does not confirm delivery or payment; control the dispatch in the used mail program or portal.

Something not quite right?Report an error

6. After the first invoice

In Journal control the final entry and a Data backup Start with a copy of the created template for the next invoice. Do not overwrite an invoice that has already been created with the same number.

Something not quite right?Report an error

Open WebP