E-Com ETN files for financial reconciliation

Learn about the financial reconciliation file and format.

A Single Transaction Report or the Einzeltransaktionsnachweis (ETN) file is an attachment to the invoice (PDF file). On the second page of the invoice there is a link to download this attachment (CSV file). The ETN contains a detailed cost breakdown of all the transactions processed and billed in the agreed billing period.

The main characteristics of the fully extended ETN format of E-Com invoices are the following:

1. The ETN file (CSV) is based on a single, unified format now, covering and supporting all relevant payment methods.

2. It includes additional fields, which might be filled with merchant-specific data if provided (for example, TRANSACTION_ID or USAGE).

3. For every processing card payment transaction, one transaction can now be displayed in two rows. One row for the processing transaction itself and one row for the additional reconciliation data. There are some field inputs specific for each of the rows, for example,

   • CHANNEL_ID is specific for the processing transactions because it is an Unzer-internal processing specific value.
   • CARD_ORIGIN is specific for the reconciliation data because it is a value that is not available during processing but provided later.

   Still, a transaction can be identified based on any given unique data, such as the SHORT_ID.