Skip to main content

Settlements

docs image

Settlements

Manage payment settlements

EVA has its own record of received payments, and in some scenarios, finance finds it necessary to double-check those payments against the payment settlement information received from the Payment Service Provider (PSP). This can be done by means of payment settlement file(s) uploads. The information then flows through Cookbook for airtight ledger bookings.

Settlement files​

Settlement files need a certain 'handler'. There are two handler options, ADYEN-CSV which handles Adyen .csv files, and another called GENERIC, also a .csv files but for other payment service providers.

To check all available settlement file handlers you can use GetAvailablePaymentSettlementFileHandlers.

Here is an example:

{}

To upload payment settlement files, use UploadPaymentSettlementFile or the Settlements chapter of Admin Suite.

Here is an example:

{
  "Name": "test",  
  "Handler": "ADYEN-CSV",
  "Data": "your-data-here",
  "MimeType": "text/csv"
}

The data properties expect a Base64 encoded .csv file.

Impacted financial period

Corresponding settlement events will be created on the financial period that is open at the time of the upload.

Some additional settlement file related services are:

Generic settlement files​

The generic settlement .csv file consists of the following fields:

PaymentReference, CurrencyID, Amount, ExchangeRate, Type

Example 1: AXT54784, EUR, 100, 1, Netto
Example 2: ART15478, EUR, 0.10, 1, Commission
Example 3: RXT87456, EUR, 0.05, 1, SchemeFees

Here is a sample payment settlements .csv file, whereas:

  • PaymentReference: This field contains the reference to the EVA transaction.
  • CurrencyID: It represents the currency of the transaction. If the currency differs, we apply an exchange rate.
  • Amount: The amount to be settled.
  • ExchangeRate: This field indicates the exchange rate to be applied if the currency differs. If the field is left empty, the current exchange rate will be used.
  • Type: This is a free field where you can specify the reason or type of settlement.

Cookbook for generic settlements​


Cookbook provides the following information for generic settlements:

  • Variable Type: Generic
  • Variable SubType: The type specified in the file (Netto/Commission/SchemeFees/...) or others as configured.
note

If matching a transaction(s) is not resolved, the settlements will then be booked on the fallback organization unit.

Offsets​


The settlements table contains up to four different offsets. These four columns are filled with additional information sent by Adyen in the payment. Starting off with Offset 1, they contain the following data:

  1. Payment method - VISA for example.
  2. (Journal) Type - this column shows the type of payment, such as Fee, MiscCosts, MerchantPayout or Refunded. All possible types are supported.
  3. Batchnumber - the payment reference number.
  4. Terminal ID - this Point of Sale Terminal ID is optional and has to be specifically configured in your Adyen account if you want this data to be added to the settlement file.

You can also filter your transactions based on these offsets, by using the following service: ListPaymentTransactions

{
  "PageConfig": {
    "Filter": {
      "SettlementOffset1": "VISA"
    }
  }
}

Settlement files on Admin Suite​

Apart from using the Settlement files services, uploading files can also be done via the Admin Suite namely, the Settlements chapter.

The initial overview displays payment settlements based on the right pane filter input(s).


About the Financial period displayed

Please bear in mind that the FP shown in this overview, is when the original payment took place. That does not mean however that the settlement took place during that FP as well. Usually the settlement is processed later, and therefore is included in another FP.

Uploading a file can be done by clicking the 'upload' payment settlement icon located in the top right corner of the filtered payment settlement card.

note

Your uploaded file should be similar to the generic settlement file sample given.


Once uploaded you will be notified of the upload status (processing, processed, failed).


You can revisit this using the other icon called 'uploads' where you can also view details of other uploads and download the respective files in Excel format.


Further, a Monitor namely, Payment Settlement Files, can be created to trace any failed attempts.

Conditions can be filled in as shown in the below screenshot which in turn means that if the payment settlement file is more than 1 day in processing status, an email will be sent notifying of that incident.


Email stencil

A stencil configuration is required for the email notifications. The stencil template is called PaymentSettlementFileMonitorNotification.