TabellenFaktura for Excel · Manual

Configure the Excel folder

An assignment determines from which cells TabellenFaktura reads the invoice data. The appearance of the invoice remains in Excel.

Version 1.6.17 Updated 9 November 2026

Use the guided device

If the invoice is not yet set up, the setup wizard will open in the visible Excel session. e-invoice → Help → Setup it can be reopened at any time. Started steps can be continued.

  1. Check start and existing setup.
  2. Open the Excel template and select the billing sheet.
  3. Assign accounting fields and position columns.
  4. Set the number circle and archive.
  5. Set up customer management if necessary.
  6. Set up Outlook and email templates if required.
  7. Check a completed invoice.
  8. Get to know the safety and help.
  9. Check the device and complete it.

Customer management and Outlook are optional. Lack of mandatory assignments are specifically named. The setup check does not replace the check of each completed invoice. Field aids appear when staying with the mouse or via F1 in the selected field. The following sections explain the individual settings.

Setup wizard 1.6.14 with nine steps and selection of the Excel template
The setup combines template, mandatory information, number circle, archive and backup.

1. Start working with a working copy

Either the Download Model Account The model invoice provided contains only examples of the information provided, which will be replaced in full before a real invoice.

  1. Save the mappe locally, open in Excel and activate the invoice sheet.
  2. Prepare seller data, address, tax details, bank details and later changeable buyer data.
  3. Control formulas for positions, net, VAT and total amount.
  4. The File → Print check which pages Excel will output.

A template without macros can be .xlsx existing macros need a suitable format such as .xlsm; more is in the chapter Macros.

2. Assign fields

  1. e-invoice → Preparing your own Excel template → Excel template and the
  2. Select the location consciously: Central suitable for a uniform layout on this PC. Only in this Excel file keeps the settings for the respective mappe and is useful for different templates.
  3. Assign fields and check minimum information and the
  4. The areas General, Seller, Buyer, Positions, VAT, Sums, Payment and if necessary Invoices The
Prepare a window Excel template with location, field assignment and unit selection
Template preparation combines field assignment, minimum check and the unit selection list.

Select, connect a cell via "From Excel

  1. The appropriate field Select from Excel click.
  2. In the Excel folder, select the cell with the actual value and confirm the selection. For example, select the number for the invoice number itself, not the heading "Invoice number,.
  3. Check the value and the shown cell reference in the wizard.
  4. Repeat the process for all required fields.
Assignment wizard with seller details and select the buttons from Excel
Cell references link the existing invoice with the structured billing data.

Direct input This type of input does not automatically change the visible Excel cells or the print layout. For changing values such as buyers, date and amount, cell assignments are the better basis. For changes, PDF view and structured data must match.

Information in logos, images, printhead and printfoot is not read as invoice fields alone. These data are also provided in cells or are specifically recorded in the assistant. In connected cells, assign the left upper cell of the composite.

3. Set position range and columns

The Line items First, the first and last position line are set. Alternatively, a range or a designated area can be specified. Then, the columns are assigned:

InformationWhat is assigned
ArticleThe column with the complete service or article description.
QuantityThe actual number, duration or quantity.
UnitThe unit column or explicitly a fixed unit for all positions, for example piece, hour, meter or lump sum.
Net price per unitThe unit price excluding VAT, not the total amount of the line.
VAT rate/tax categoryIn the case of a mixed tax rate, the rate is fixed at the rate of the tax.
Article NoThe article ID is yours.
Total price for the testThe net amount of the counter-checking line calculated in Excel.

Here are Columns The H or AINo invoices. Select column from Excel takes over the column by selecting a matching cell. Recognised positions check that all services and the right quantities and prices appear.

Automatic detection is a suggestion. After inserting new lines or for foreign layouts, check the area again. Multiple print pages and separate position blocks are described separately.

Combine several description columns

Under “Items → Additional description columns”, add further text columns to the item description. The main item description comes first. Additional columns are appended in the displayed order.

Use “Add column”, “Move up”, “Move down” and “Remove” to choose and arrange columns. Select “Join with line breaks” or “Join with spaces” for the separator.

Check the full item preview to ensure that all description parts belong to the correct service. Existing continuation text before or after the priced row can still be assigned. The visible Excel invoice and the structured description must agree.

Items in TabellenFaktura 1.6.17 with additional description columns
Combine description columns in the desired order.

Keep mappings when the template changes

After mapping the item range and columns, choose “Secure references”. TabellenFaktura creates visible Excel defined names so that Excel can adjust the secured references when rows and columns are inserted. Existing unambiguous defined names are preferred when selecting cells.

Save the mappings and the Excel file. After changing the sheet structure, choose “Check references”, then check the item range, every column and the full item preview. Reassign missing or deleted references using the Excel selection and secure them again.

“Release references” removes the secured column mappings. Column letters can then be edited directly again. The item range is selected separately.

4. Set unit and text updates

A fixed unit or a split unit

If all positions use the same unit, below Positions → Unit and textual updates the option A fixed unit for all positions and select the unit. No additional Excel column is required. You will be notified if existing units differ.

For different units, assign the appropriate Excel column and do not use a fixed unit. For this column, the template preparation can set up a selection list:

  1. Select cells in Excel select and select only the input cells of the unit column, for example AC27:AC48.
  2. Activate the required units, about piece, hour and lump sum.
  3. Configure Selection List The

A flat-rate performance also requires a suitable unit. TabellenFaktura translates the understandable terms into the intended unit codes.

Descriptions over several lines

The Description of performance choose consciously: Only the price line, Text lines before the price line or Text lines after the price line. Thus, pure description texts can be assigned to the corresponding price line. From this no invented quantities or prices. Unarranged texts and the complete description of each recognized position before saving control.

5. Check minimum details and save template

Check minimum information shows missing assignments. Click on hints and add the affected fields. Save Assignments and then save the Excel file. A template may still contain placeholders; for a final invoice, real, complete information must be entered.

Keep the mappe as the original template. Create a working copy for each new invoice. Assignments that were only stored in the mappe are retained when a complete file copy is made; simply copying individual cells does not replace it.

6. Prepare email account and message

New email profiles use HTML. An explicitly saved plain-text setting is retained. If the Outlook default produces Rich Text, the invoice draft is prepared as HTML. Check the format, signature and attachment in the opened draft.

  1. Configure classic Outlook with the intended email account and open it once regularly.
  2. e-invoice → Email → Email Settings The
  3. Set the storage centrally or only for the current Excel file.
  4. The desired E-mail account select; if necessary Reload Accounts The
  5. E-mail format select: default Outlook format, HTML or Text only.
  6. Let the matching Outlook signature be selected automatically, select an existing signature, or No signature The
  7. Edit subject and message text, check preview and Save Settings The
Email settings with location, account, message format, signature and text template
Account, format, signature and text template are set up once. The recipient comes from the respective invoice later.

Placeholders remain in the template including the curly brackets. {Rechnungsnummer}, {Rechnungsdatum}, {Fälligkeitsdatum}, {Empfänger}, {Verkäufer}, {Betrag}, {Währung}, {Dokumentart}, {Leitweg-ID} and {Dateiname}.

One possible subject is: {Dokumentart} {Rechnungsnummer} vom {Rechnungsdatum}. The buyer email in the field assignment is the later recipient address; the seller email is an invoice statement. The selected Outlook account, however, determines the sender of the draft.

Open image