Aggregate settlement report structure

The aggregate settlement report includes a summary of the report data, containing account code, period and selection criteria ([empty], Store or Terminal, as well country codes).

Merchant/Company

Start date

End date

Aggregation

Country codes

Account code

24/07/2017

30/07/2017

BE,NL,LU

For each settlement batch, total credits and debits as well as count of transactions for all payment-level mutations (e.g. Settled, Refunded, Chargeback) and batch-level bookings (Fees, InvoiceDeduction, MerchantPayout) are reported. These are grouped by merchant account, store, terminal, payment method, journal type and creation date/day of sale. 

Report structure

Field

Format

Description

Company Account

C X80

Static name of your company account as registered in the Adyen payments platform.

Merchant Account

C X80

Static name of your merchant account used to process the original payment.

Country Code

A X2

The country of the merchant account.

Store

I

The merchant store code.

Will be [empty] for balance-level bookings (For example, MerchantPayout, Fees), or if Store is not enabled when running the report.

Terminal ID

C X99

The unique identifier of the terminal.

Will be [empty] for balance-level bookings (For example, MerchantPayout, Fees), or if Terminal is not enabled when running the report.

Batch Number

I

Sequence number of the settlement batch

Batch Closed Date

D

Date on which the settlement batch was closed (resulting in MerchantPayout and/or BalanceTransfer to next batch). This corresponds to the start/end date of the report.

Payment Method

C X30

The payment method type of the payment. For example: visamc, cup, amex.

Creation Date

D

The day of sale for payment-level bookings; relates to transaction date on the terminal, or the date of capture.

In case of balance-level bookings (e.g. MerchantPayout, Fee, etc.), timestamp of the booking in the Adyen payments platform.

TimeZone

A 4

The time zone of the creation date in the previous column. Configured for your company or merchant account.

To check and edit it, go to: Customer Area > Settings > Company/Merchant Settings > Time zone

Payout reference C X15

Unique descriptor (Format: TX...XT) of each bank transfer/merchant payout, which will also be part of the description associated with incoming funds on your own bank account/bank statement. Only populated for the MerchantPayout line in the report.

This is an optional field. To add this to the report, contact the Support Team.

Payable booking date D

Date on which the payment/refund was booked into the the settlement batch; can be used in the context of reconciling the monthly Adyen invoice.

This is an optional field. To add this to the report, contact the Support Team.

Journal Type

A X50

The type of record included in the report, most commonly:

  • Settled
  • Refunded / RefundedReversed
  • Chargeback / ChargebackReversed / SecondChargeback
  • Fee
  • InvoiceDeduction
  • PaymentCost
  • MerchantPayout
  • BalanceTransfer

The SecondChargeback journal type is available from November 5. For more information, see our FAQ.

For a full list of possible entries and further description, see the settlement detail report.

Gross Currency

A X3

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

Gross Debit (GC)

F

The gross debit amount; this is the amount submitted in the transaction requests. For example: 100.00.

Gross Credit (GC)

F

The gross credit amount; this is the amount submitted in the transaction requests. For example: 100.00.

Exchange Rate

FL

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.

Net Currency

A X3

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

Net Debit (NC)

F

The net debit amount; this is the amount submitted in the transaction request, minus Bank/Card Commission. For example: 100.00.

Net Credit (NC)

F

The net credit amount; this is the amount submitted in the transaction request minus Bank/Card Commission. For example: 100.00.

Bank/Card Commission (NC)

F

Total commission (including markup, scheme fee and interchange) charged.

DCC Markup (NC)

F

Dynamic Currency Conversion markup: a negative amount indicates a credit in favour of the merchant (ie additional revenue for merchant).

Num Txs

I

Count of payments for this entry.

To see descriptions of each format, see Aggregate settlement report legend.