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 the sample ETN file
  
• Download sample invoice

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.

View reconciliation details in Unzer Insights

1. To download the file, log in to Unzer Insights and select Unzer Invoices.
2. Select Download.

The file is downloaded in your preferred location.

View reconciliation details using Unzer Insights API

Exports using Unzer APIs

Unzer Insights provides an API to fetch your available scheduled and order exports that you have configured or created in your account. The API works according to HTTP and JSON standards. You can only access the API with an account that has the user role Admin 1 or Admin 2.

We recommend that you create a new user in Insights for this purpose and use it exclusively for the API.

Generate a token

Get a valid token by sending a POST request to the /auth.token endpoint:

POST https://insights.unzer.com/api/auth.token?

{"email,":john.doe@company.com,
"pwd": ei298hnf23fij09u4i234tf243
 }

{
"ok": true,
"token": "fe78e9fh9238hf96f089w0eed2"
}

The request body must contain the following parameters:

If you sign in to Unzer Insights with the account that is already in session, a new token is created, and the token that you previously requested using the API, loses its validity.
Similarly, if you fetch a new token using the API, the valid token in the application expires and the account is automatically logged out.

List of available files

You can retrieve the list of all the available files for the last 14 days by sending a POST request to the /filetransfer.list endpoint:

POST https://insights.unzer.com/api/filetransfer.list?

The request body must contain the following parameters:

The request body must contain the following parameters:

POST https://insights.unzer.com/api/invoiceFiles.list?
{
 "token": "fe78e9fh9238hf96f089w0eed2",
 "page": "1",

}

{
"ok": true,
"limit": 20,
"skip": 0,
"total": 20,
"data": [
{
"id_invoice_document": 4240,
"invoice_number": "ELU2307011019325",
"merchant_id": 3538,
"merchant_name": "QaApprove_1674032632-551",
"file_name": "ELU2307011019325.csv",
"file_size": 1161,
"file_type": "INVOICE_APPENDIX_CSV",
"billing_period_start": "2023-07-01 00:00:00",
"billing_period_end": "2023-07-01 00:00:00",
"status": "PAID",
"invoice_type": "STANDARD"
},
{
"id_invoice_document": 4267,
"invoice_number": "ELU2307011019325",
"merchant_id": 3538,
"merchant_name": "QaApprove_1674032632-551",
"file_name": "ELU2307011019325.pdf",
"file_size": 66622,
"file_type": "INVOICE_PDF",
"billing_period_start": "2023-07-01 00:00:00",
"billing_period_end": "2023-07-01 00:00:00",
"status": "PAID",
"invoice_type": "STANDARD"
},
...

Download ETN and invoice files

ETN (csv) or pdf file

You can also download a CSV or a PDF file by sending a POST request to the /filetransfer.download endpoint:

POST: https://insights.unzer.com/api/invoiceFiles.download?

The request body must contain the following parameters:

POST https://insights.unzer.com/api/filetransfer.download?token=fe78e9fh9238hf96f089w0eed2&id_invoice_document=4240
{
 "token": "fe78e9fh9238hf96f089w0eed2",
 "id_invocie_document": "4240"
}

A successful response returns a binary file for the specific report that you requested.

INV_NO";
"INV_DATE";
"TRANSACTION_DATE (UTC)";
"TRANSACTION_TIME(UTC)";
"METHOD";
"BRAND";
"TYPE";
"RESULT";
"RETURNCODE";
"RETURNCODE_DESC";
"MODE";"CARD_TYPE_GROUP";
"TRANSACTION_CARD_CLASSIFICATION";
"CARD_ORIGIN";"CHANNELNAME";"CHANNEL_ID";
"SHORT_ID";
"UNIQUE_ID";
"TRANSACTION_ID";
"SHOPPER_ID";"INVOICE_ID";"IBAN";
"BIC";
"USAGE";
"DESCRIPTOR";
"IP_COUNTRY";
"ACCOUNT_NUMBER";"EXPIRY_YEAR";"EXPIRY_MONTH";
"TXN_AMOUNT";"TXN_CURRENCY";
"TXN_EXCHANGE_RATE";
"INVOICE_CURRENCY";
"DEBIT_INVOICE_AMOUNT (Negative if refund/chargeback)";
"TXN_FEE_AMOUNT";
"TXN_FEE_CURRENCY";
"TXN_FEE_EXCHANGE_RATE";
"TXN_FEE_INVOICE_AMOUNT";
"DISAGIO_INVOICE_AMOUNT";
"INTERCHANGE_FEE_AMOUNT";
"INTERCHANGE_FEE_CURRENCY";
"SCHEME_FEE_AMOUNT";
"SCHEME_FEE_CURRENCY";
"SERVICE_FEE_AMOUNT";
"SERVICE_FEE_CURRENCY";
"FEE_INVOICE_AMOUNT";
"TOTAL_FEE_INVOICE_AMOUNT";
"FEE_VAT_AMOUNT"
"ELU2307011019325";
"2023-07-02";"2023-07-01";"12:00:00.000";
"INTERNAL_SERVICES";
"MONTHLY";
"TIMED";
"ACK";;;;
"UNSPECIFIED";;
"DOMESTIC";;
"f73daf682ba74c88ab308798e911c207";;
"INTERNAL_SERVICES";;;;;;;;;;;;"0,0000";
"EUR";"1,0000";
"EUR";"0,0000";
"22,5000";
"EUR";"1,0000";"22,5000";"0,0000";"";"";"";"";"";"";"22,5000";
"26,1000";
"3,6000" 

List of ETN file parameters and description