External settlement detail report

External settlement detail report contains the transactions done over external acquiring, for example external AMEX acquiring or PayPal. The report is available under your company account (not your merchant account) in the Adyen Customer Area (CA).

Position

Column Name

Data Type

Description

1

Company Account

C X80

The static name of your company account within the Adyen payments platform.

2

Merchant Account

C X80

The static name of the merchant account that was used to process the original payment request. The report may contain line items for multiple merchant accounts.

3

Psp Reference

C 16

In most instances, this is Adyen's unique 16 character reference for the payment; it denotes the PSP reference for the original authorisation request.
For Unmatched transactions, this field may be populated with a reference from the Acquiring bank and the Data Type format may vary to match the format of the Acquiring bank.
For the transfer line item (Type = 'AcquirerPayout') this field will contain the unique Acquirer settlement batch number, you will also find this on your bank statement for the deposit into your bank account.

4

Merchant Reference

C X80

This is the reference number that was provided when initiating the payment request.

5

Payment Method

C X30

The payment method type of the payment which was processed. For example: visa, mc, amex.

6

Creation Date

D+" "+T

The timestamp of when the payment was received by the Adyen payments platform. The format is YYYY-MM-DD HH:MM:SS, for example: 2012-07-26 19:58:55.

7

TimeZone

A 4

The time zone of the previous column. This is the ISO Code for the timezone which is set up on your company account:
Customer Area > Settings > Company Settings > Time Zone (BST, CET, CEST etc)

8

Type

C X50

The possible values are (see description of journal types):

  • AcquirerPayout
  • AdjustmentExternallyWithInfo
  • SettledExternallyWithInfo
  • ChargebackExternallyWithInfo
  • ChargebackReversedExternallyWithInfo
  • RefundedExternallyWithInfo
  • SettledInstallmentExternallyWithInfo
  • RefundedInstallmentExternallyWithInfo
  • AdvancementCommissionExternallyWithInfo
  • UnmatchedRefundedExternallyWithInfo
  • UnmatchedSettledExternallyWithInfo
  • UnmatchedChargebackExternallyWithInfo
  • UnmatchedChargebackReversedExternallyWithInfo
  • UnmatchedBatchExternallyWithInfo

9

Modification Reference

C

In most instances, this is Adyen's unique 16 character code child reference that is associated with the modification request (capture, refund, chargebacks, etc). This will be returned to you via the direct soap response of the modification request and the notification server.
For Unmatched transactions, this field may be populated with a reference from the Acquiring bank and the Data Type format may vary to match the format of the Acquiring bank.

10

Gross Currency

A 3

This is the three character ISO code for the currency which was used for processing the payment (transaction currency).

11

Gross Debit

F

The gross debit amount; this is the amount submitted in the transaction request. For example, 100.00.

12

Gross Credit

F

The gross credit amount; this is the amount submitted in the transaction request. For example, 100.00.

13

Exchange rate

F

The exchange rate used for converting the gross amount into the net amount. This will be 1 if you process and settle in the same currency.

14

Net Currency

A 3

The three character ISO code for the currency which was used for processing the payment (settlement currency).

15

Net Debit

F

The net debit amount; this is the amount submitted in the transaction request minus Acquirer fees. For example, 100.00.

16

Net Credit

F

The net credit amount; this is the amount submitted in the transaction request minus Acquirer fees. For example, 100.00.

17

Commission

F

The commission fee that was withheld by the acquirer. This should be the difference between the gross and net amounts.
If the Acquirer provides the transaction information at the interchange level Adyen will split the commission into the Markup, Scheme Fees and Interchange. In this scenario column 17 will be empty and columns 18, 19, and 20 will be populated.
If the Acquirer does not provide the transaction information at the interchange level Adyen will populate the total commission in column 17 and columns 18, 19, and 20 will be empty.

18

Markup

F

The fee charged by the Acquiring bank. This field will be empty if Acquirer does not provide the transaction information at the interchange level.

19

Scheme Fees

F

The fee which is charged by Visa / MC. This field will be empty if Acquirer does not provide the transaction information at the interchange level.

20

Interchange

F

The fee charged by the Issuing bank. This field will be empty if Acquirer does not provide the transaction information at the interchange level.

21

Payment Method Variant

C X30

The payment method sub-type of the payment which was processed. For example: visa classic, mc, amex.

22

Acquirer

C X80

The name of the Acquirer that processed the original payment. For example: Cielo, Redecard.

23

MID

C X50

The merchant ID from the Acquirer that was used for processing the payment.

24

ARN

C X50

Acquirer Reference Number, a unique number that tags a credit card transaction when it goes from the merchant's bank (The Acquiring Bank) through to the card scheme at the cardholder's bank (The Issuer).

25

Acquirer Reference

C X80

The Acquirer's unique ID for the payment (if provided).

26

Modification Merchant Reference

C X80

For modifications like capture or refund, the (optional) modification reference supplied by the merchant.

27

Reserved7/Installments

Where installment transactions are applicable, this field will show the installment that this line item pertains to. For example, 6/9 to indicate that this is the 6th of 9 installments.
For all other scenarios this field is reserved for future enhancements.

28

Reserved8

Reserved for future enhancements.

29

Reserved9

Reserved for future enhancements.

30

Reserved10

Reserved for future enhancements.