FileMaker Experts, Database Engineering
DEEN
ZUGFeRD & E-Invoice Digital invoice processing in FileMaker – simple, standards-compliant and future-proof Get started now

ZUGFeRD & E-Invoice

ZUGFeRD & E-Invoice

Digital invoice processing in FileMaker – simple, standards-compliant and future-proof

Our proven add-on makes ZUGFeRD integration child's play – no complicated programming, no weeks of training

Our solution generates electronic invoices in the Factur-X / ZUGFeRD 2.x and UBL formats based on the European standard EN 16931. Incoming e-invoices are read in directly and processed automatically in FileMaker. This keeps you legally compliant and compatible with all common portals and ERP systems.

Ready to use within one hour – guaranteed!

ZUGFeRD integration ZUGFeRD AI mapping

1-hour guarantee

From installation to the first ZUGFeRD invoice

  1. Install the add-on (5 minutes)
  2. Map fields (20 minutes)
  3. Create the first ZUGFeRD PDF (35 minutes)
  4. Read in e-invoices and process them in FM

New · ZUGFeRD Suite Version 3

E-invoicing from FileMaker: the ZUGFeRD Suite

From 1 January 2027, companies in Germany must issue their invoices to other companies electronically; from 2028 this applies to all of them without exception. Anyone who writes their invoices from FileMaker does not need to rebuild their solution for this. The ZUGFeRD Suite sits alongside it, reads the document via a mapping and returns a ZUGFeRD PDF or XRechnung. One call, two formats, everything on your own server.

Mapping with preview: for each row the value from the real document, green if filled, red if empty
Mapping with preview: for each row the value from the real document, green if filled, red if empty

The deadline

Since 2025, every company must be able to receive electronic invoices. For issuing them, a phased schedule applies: from 1 January 2027 for companies with a prior-year turnover of more than 800,000 euros, from 1 January 2028 for everyone. A PDF sent by e-mail will then no longer count as an invoice. What is required is a structured format according to the European standard EN 16931, which in Germany comes in two variants:

FormatPackagingFor whom
ZUGFeRD Factur-Xa PDF as you know it, with the XML attached. People read the PDF, the accounting software reads the XML.Between companies
XRechnung UBLpure XMLthe form that public authorities and many large corporations require

Both describe the same invoice. What differs is the packaging.

What the Suite does

The ZUGFeRD Suite is a FileMaker file plus a small server component in PHP. The invoicing program calls a script with three parameters: document type, document number, format.

The call is a Perform Script on ZF_Beleg_erzeugen in the Suite, with a small JSON as the parameter:

{ "beleg" : "Rechnung", "nr" : "RE100001", "format" : "zugferd" }

The Suite finds the document, reads the values, sends them to the server, fetches the result and stores it in a container on the document. For the XRechnung, the same call with "format" : "ubl". Credit notes are a separate document type with type code 381 and are built as a credit note, in the XRechnung as a CreditNote.

Before output, the result is checked against the validation rules of the standard. Whatever the Suite outputs has passed the EN 16931 Schematron validation and, for the XRechnung, additionally the KoSIT rules. The profile is EN 16931, i.e. the full scope: line items with discounts, shipping costs, overall discount, multiple tax rates, intra-community supply, export.

Preferences: URL of the server component, key, result as ZUGFeRD PDF and UBL XML
Preferences: URL of the server component, key, result as ZUGFeRD PDF and UBL XML
The finished ZUGFeRD PDF in the preview
The finished ZUGFeRD PDF in the preview

The mapping: set up once

The connection to your own solution is called the mapping. It tells the Suite where each value of the e-invoice is located. It is set up on a page in the web viewer, one tab per document type, with the values in five sections: Document, Seller, Buyer, Payment, Line Items.

Each value is a FileMaker expression that is evaluated in the context of the document:

ValueExpression
Document numberRECHNUNG::#RechnungNr
StreetTrim ( GLOBAL::Straße & " " & GLOBAL::Hausnummer )
CurrencyIf ( IsEmpty ( RECHNUNG::Währung ) ; "EUR" ; RECHNUNG::Währung )
Customer's VAT IDADRESSEN::#UStID_Nr
Unit'C62'

A field, a formula, a constant – the same mechanism. Related fields work because FileMaker resolves them in an expression anyway. No helper fields are needed in your own solution, nor layouts with objects: one empty layout on the document per document type, nothing more. The line items come from an SQL query that the page assembles from the mapping and displays below the table.

Document tab: one expression per value, with the BT key of the standard next to it
Document tab: one expression per value, with the BT key of the standard next to it
Seller tab: company data from your own solution
Seller tab: company data from your own solution
One tab per document type, here the credit note (type code 381)
One tab per document type, here the credit note (type code 381)
The mapping as JSON, for export and import between systems
The mapping as JSON, for export and import between systems

The AI suggestion

One button sends the names and types of the fields to your own server, which queries a language model, and for each value an expression with a justification comes back. For an inventory management system with more than three hundred fields, the test produced 29 suggestions from the AI, 14 decided by name, 5 open, in nine seconds. Anything that changes compared to the saved state carries the label "New" or "Changed", next to it the old value and a "back" button. Document data never leaves the premises, only field names. The API key belongs to the customer.

AI suggestion: one expression with justification per value, changes labelled "New" or "Changed"
AI suggestion: one expression with justification per value, changes labelled "New" or "Changed"

The preview

The preview shows for each row the value from the real document, green if filled, red if empty. Enter the document number, preview, then "Test PDF" and "Test UBL": that is the path from the mapping to the first e-invoice, in a single session.

Where the data stays

The server component runs on the customer's premises, on their own web server or with their own hosting provider. There is no vendor server, no cloud in between, no telemetry. The license key is verified on the customer's server, without any outside connection. Anyone using a trial version receives a key with an expiry date; after that the mapping is retained, only the generation stops.

This is deliberate. Invoices contain personal data, and the simplest way to handle it properly is the one in which it never leaves the company.

The integration

What a FileMaker developer has to do for this can be counted on one hand:

  1. Place the PHP package on the web server and enter the address in the Info tab.
  2. Connect the customer file as an external data source and drag the table occurrences into the Suite's relationship graph.
  3. One empty layout per document type.
  4. Mapping: AI suggestion, review, preview, save.
  5. A button on the invoice that calls the script.

The instructions are included in the Suite itself, as a tab next to the mapping, with an error table in case a message appears. Part of it is written so that it can be passed on to the accounting department.

Relationship graph: the customer file as an external data source, one table occurrence per document type
Relationship graph: the customer file as an external data source, one table occurrence per document type
Instructions tab: the five steps and the error table, directly in the Suite
Instructions tab: the five steps and the error table, directly in the Suite

For whom

For companies that write their invoices from FileMaker and want to meet the deadline without touching their invoicing program. For FileMaker developers who integrate this for their customers; there is a developer license for that. And for everyone who wants to know where their data is when it comes to e-invoicing.

Trial version and license: ronny@filemaker-experts.de

New · ZUGFeRD Reader Version 3

The other direction: incoming invoices

Issuing is one half of the deadline, receiving is the other. Every company has had to be able to receive e-invoices since 2025. The ZUGFeRD Reader accepts an incoming e-invoice, whether ZUGFeRD PDF, UBL or CII XML, reads it via the same server, validates it and displays it in readable form. For an XRechnung without a print image this is the only view a human can read.

An XRechnung as UBL, read and validated: mandatory fields complete, totals add up, line items with discount and tax rate
An XRechnung as UBL, read and validated: mandatory fields complete, totals add up, line items with discount and tax rate

The ZUGFeRD Suite includes the Reader, in the same tab next to the Creator. Those who only need to read take the Reader on its own.

ZUGFeRD components

The 6 main areas of invoice processing

Structured data management for standards-compliant e-invoices

1

Invoice (Header / Document Level)

General invoice details: number, date, currency, totals, payment terms, free text and global references with normalized date values (YYYY-MM-DD) and ISO currency codes.

2

Seller (Seller / Supplier)

Company data of the invoice issuer: name, legal form, address, VAT ID, tax number, contact channels and bank details with ISO country codes.

3

Buyer (Buyer / Customer)

Customer data mapping: name, address, contact person, e-mail, customer number as well as separate billing and delivery addresses.

4

Delivery / Service (Delivery / Performance)

Service period, delivery date, delivery address, delivery reference (delivery note number, IncoTerms) and project/contract IDs with normalized dates.

5

Payment / Bank (Payment)

Payment information: terms (14 days net, cash discount), bank details (IBAN, BIC), payment method and payment reference.

6

Line Items (Items / Line Items)

Line items: item description, SKU, quantity, unit (UN/ECE code), unit price, VAT rate, tax category and order reference.

Normalization & quality assurance

Automatic data processing

Stable mappings with built-in helpers and validation

1

Automatic conversion

  • Numbers automatically converted from comma to point
  • Date values normalized to YYYY-MM-DD
  • Units restricted to upper case and UN/ECE codes
  • Empty values transferred correctly instead of placeholders
  • Texts trimmed and quotation marks escaped

2

Built-in validation

  • Check ZUGFeRD mandatory fields per section
  • Profile-dependent validation (Basic, Comfort, Extended)
  • Show missing mappings immediately
  • Prevent faulty exports before generation
  • Immediate feedback on discrepancies

3

Preview & test run

  • Preview of the resulting data structure
  • JSON/CSV export for review
  • Logging of the layouts used
  • Discrepancies immediately visible
  • Test before ZUGFeRD file generation

4

Versioned mappings

  • Mapping stored versioned per file/client
  • Export/import between systems
  • Duplicate mappings for similar customers
  • Switch between alternative layouts
  • Multi-client capability built in

License models

Three license models for every use case

ZUGFeRD Suite V3 as single user or server, Enterprise on request. Creator and Reader are also available separately, see AddOns

Suite Single User

Suite Single User

349€

Single users, small companies, 1 workstation

  • One workstation
  • Create and import e-invoices
  • Full ZUGFeRD functionality
  • Easy installation
  • Standard support
Buy now
Suite Server

Suite Server

1.100€

Companies with a central FileMaker Server, multiple users

  • Multiple users
  • Create and import e-invoices
  • Central administration
  • FileMaker Server integration
  • Extended support
Buy now
Enterprise

Enterprise

2.999€

Developers, agencies, large companies – incl. source code & unlimited use

  • Source code included
  • Unlimited use
  • Commercial reuse
  • White label possible
  • Premium support
Get in touch

Frequently asked questions

ZUGFeRD & E-Invoicing FAQ

Do I have to restructure my FileMaker fields?

No, you use your existing layouts and fields. The ZUGFeRD add-on merely handles the mapping between your fields and the ZUGFeRD standards. Your data structure remains unchanged.

How is VAT handled?

The VAT rate is entered in the item mapping for each line item. The global tax blocks are automatically aggregated from the line items and stated at invoice level. So you only need to maintain the tax information once per line item.

What happens if a mandatory field is missing?

The built-in validation shows missing mappings immediately. You can adjust the mapping or – where permitted by the ZUGFeRD profile – leave an optional field empty. Faulty exports are prevented before a ZUGFeRD file is generated.

Does the add-on support multiple languages?

Yes, all ZUGFeRD keys are displayed with German and English labels and tooltips. You can customize the labels as you wish and use the add-on in multiple languages.

Can I use different ZUGFeRD profiles?

Yes, the add-on supports all ZUGFeRD profiles (Basic, Comfort, Extended). The validation automatically adapts to the selected profile and checks the corresponding mandatory and optional fields.

Does the add-on work with multiple clients?

Yes, the mappings are stored versioned per file/client. You can export/import configurations between systems, duplicate them for similar customers or switch between alternative layouts.

Can incoming e-invoices (ZUGFeRD/UBL) also be read in?

Yes, our add-on reads incoming ZUGFeRD and UBL invoices directly and processes them automatically in FileMaker. The data is imported in a structured form, validated and can be processed immediately in your accounting. This saves time on manual data entry and reduces errors. You can find more details on our ZUGFeRD Reader page.

Ready for e-invoicing?

Integrate ZUGFeRD into FileMaker

Start implementing your ZUGFeRD solution now

Demonstrations

ZUGFeRD & E-Invoice - Demonstration

ZUGFeRD & E-Invoice demonstration

Demonstration of the ZUGFeRD integration with FileMaker

Watch video on Loom

ZUGFeRD AI Mapping - Demonstration

ZUGFeRD AI Mapping Video

Demonstration of ZUGFeRD AI mapping with FileMaker

Watch video on Loom