alt

Important information

Unzer

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.

Parameter Type (length) Description
INV_NO string(256) Specifies the invoice number this ETN file belongs to.
INV_DATE float Specifies the date of the invoice this ETN file belongs to.
TRANSACTION_DATE (UTC) float Specifies the timestamp of the processed transaction.
Format dd.mm.yyyy (for example, 31.12.2022)
TRANSACTION_TIME (UTC) float Specifies the timestamp of the processed transaction
Format hh:mm:ss.mmm (for example, 10:25:26.000)
METHOD string (256) Specifies the payment method used for the transaction, for example, card.
BRAND
string (256) Specifies the brand of a method, for example, visa.
TYPE string (256) Specifies the transaction type, that is debit or reversal.
RESULT string (256) Specifies the transaction result, for example, success.
RETURNCODE string (256) Specifies the transaction return code (Unzer internal).
RETURNCODE_DESC string (256) Specifies the description for the return code (Unzer internal)
MODE string (20) Specifies if the transaction was LIVE or TEST transaction
CARD_TYPE_GROUP string (256) Relevant for card payments only
Distinguishes if the card used is a debit or credit card.
TRANSACTION_CARD_CLASSIFICATION string (256) Relevant for card payments only
Distinguishes whether the card used is a commercial card or a consumer card.
CARD_ORIGIN string (256) Relevant for card payments only
Specifies the card region like Domestic.
CHANNELNAME string (256) Specifies the name of the channel used for processing (Unzer internal), for example, onlineshop.de.
CHANNEL_ID string (256) Specifies the identifier of the channel used for processing (Unzer internal).
SHORT_ID string (16) Specifies the identifier of the processed transaction (Unzer internal).
UNIQUE_ID string (16) Specifies the second identifier of the processed transaction (Unzer internal).
TRANSACTION_ID string (256) Specifies the third identifier of the processed transaction. This is an optional value provided by the merchant.
SHOPPER_ID string (256) Specifies the end customer´s order identifier or the shop identifier (if provided by the merchant). This is an optional value provided by the merchant.
INVOICE_ID string (256) Specifies the end customer´s invoice identifier. This is an optional value provided by the merchant.
IBAN string (34) Specifies the bank account number of the end customer.
BIC string (15) Specifies the BIC number of the card used by the end customer
USAGE string (128) Specifies the usage field of the transaction. This is an optional value provided by the merchant.
DESCRIPTOR string (256) Specifies the purpose of use by Unzer.
IP_COUNTRY string (64) Specifies the IP of the device that is used for the transaction.
ACCOUNT_NUMBER string (35) Relevant for card payments only
It is the masked number of the credit card.
EXPIRY_YEAR string (16) Relevant for card payments only
Specifies the expiry year as specified on the card used for the transaction.
EXPIRY_MONTH string (16) Relevant for card payments only
Specifies the expiry month as specified on the card used for the transaction.
TXN_AMOUNT BigDecimal Specifies the amount of the transaction.
TXN_CURRENCY enum Specifies the currency of the transaction
TXN_EXCHANGE_RATE BigDecimal Specifies the applied exchange rate when the payout currency is not equal to the transaction currency. The value is 1 when the transaction and payout currency are the same.
INVOICE_CURRENCY enum Specifies the payout currency of the invoice the ETN belongs to.
DEBIT_INVOICE_AMOUNT BigDecimal Specifies the transaction volume applied to this invoice.
Amount in decimal values (for example, 50.19), will be negative for refund or chargeback.
TXN_FEE_AMOUNT BigDecimal Specifies the fixed fee amount applied to this transaction on this invoice.
Amount in decimal values (for example, 1.29).
TXN_FEE_CURRENCY enum Specifies the base currency for fees and is always EUR.
TXN_FEE_EXCHANGE_RATE BigDecimal Specifies the exchange rate applied to fee amount. It is only relevant if the payout currency does not equal EUR.
TXN_FEE_INVOICE_AMOUNT BigDecimal Specifies the fixed fee amount applied to this transactions for the invoice in the payout currency.
Amount in decimal values (for example, 1.29)
DISAGIO_INVOICE_AMOUNT BigDecimal Specifies the disagio fee amount applied to this transaction for the invoice in the payout currency.
Amount in decimal values (for example, 1.29)
INTERCHANGE_FEE_AMOUNT BigDecimal Only relevant for specific pricing models
Specifies the fee amount applied to this transaction on this invoice.
INTERCHANGE_FEE_CURRENCY enum Only relevant for specific pricing models
Specifies the currency of the fee.
SCHEME_FEE_AMOUNT BigDecimal Only relevant for specific pricing models
Specifies the fee amount applied to this transaction on this invoice.
SCHEME_FEE_CURRENCY enum Only relevant for specific pricing models
Specifies the currency of the service fee.
SERVICE_FEE_AMOUNT BigDecimal Only relevant for specific pricing models
Specifies the fee amount applied to this transaction on this invoice.
SERVICE_FEE_CURRENCY enum Only relevant for specific pricing models
Specifies the currency of the fee.
FEE_EXCHANGE_RATE BigDecimal Specifies the exchange rate applied to fee amounts, only relevant if payout currency does not equal EUR.
FEE_INVOICE_AMOUNT BigDecimal Specifies the sum of all fees amount in the invoice currency applied to this transaction on this invoice, excluding VAT (fee net amount)
Amount in decimal values (for example, 1.00)
TOTAL_FEE_INVOICE_AMOUNT BigDecimal Specifies the sum (in the invoice currency) of all fees applied to this transaction for this invoice, including VAT (fee gross amount).
FEE_VAT_AMOUNT BigDecimal Specifies the tax amount (in the invoice currency) applied to the fee net amount.