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.
You can download the sample file here: Download ETN file
The main characteristics of the fully extended ETN format of E-Com invoices are the following:
-
The ETN file (CSV) is based on a single, unified format now, covering and supporting all relevant payment methods.
-
It includes additional fields, which might be filled with merchant-specific data if provided (for example,
TRANSACTION_IDorUSAGE). -
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_IDis specific for the processing transactions because it is an Unzer-internal processing specific value.CARD_ORIGINis 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. The amount will be zero for rejected transactions and non-cash flow transactions. |
| 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_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. |