Aggregate settlement report

Use this report to perform balance-level reconciliation of funds received against the day of sale.


The aggregate settlement detail report provides a summary specification of all settlements, for example, funds paid out by us in a certain period. It is intended to allow you to perform balance-level reconciliation of funds received against the day of sale.

While the settlement detail report provides this for each settlement batch on a transaction level (for each merchant account), you can run the aggregate settlement report on merchant account and company account level. It includes all batches closed in the chosen period, summarized by merchant account, store, payment method, the day of sale and settlement batch.

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, we report 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). These are grouped by merchant account, store, terminal, payment method, journal type and creation date/day of sale. 

Report structure

#

Column

Format

Description

1

Company Account

Unicode Text (80-character)

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

2

Merchant Account

Unicode Text (80-character)

Name of your merchant account used to process the original payment.

3

Country Code

Alpha Text (2 character)

Country of your merchant account.

4

Store

Integer

Merchant store code.

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

5

Terminal ID

Unicode Text (99-character)

Unique identifier of the terminal.

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

6

Batch Number

Integer

Sequence number of the settlement batch

7

Batch Closed Date

Date field (Format: YYYY-MM-DD).

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.

8

Payment Method

Unicode Text (30-character)

Payment method type of the payment. For example, visa, mc, cup, amex.

9

Creation Date

Date field (Format: YYYY-MM-DD).

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

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

10

TimeZone

Alpha Text (4 character limit)

Time zone the Creation Date. To configure for your company or merchant account, open the Customer Area and go to Account > Settings.

11 Payout reference Unicode Text (15-character)

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.

12 Payable booking date Date field (Format: YYYY-MM-DD).

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.

13

Journal Type

Alpha Text (50 character)

Type of record included in the report, most commonly:

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

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

14

Gross Currency

Alpha Text (3 character)

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

15

Gross Debit (GC)

Fixed point number

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

16

Gross Credit (GC)

Fixed point number

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

17

Exchange Rate

Floating point number

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.

18

Net Currency

Alpha Text (3 character)

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

19

Net Debit (NC)

Fixed point number

Amount submitted in a debit transaction request, minus Bank/Card Commission. For example: 100.00.

20

Net Credit (NC)

Fixed point number

Amount submitted in a credit transaction request minus Bank/Card Commission. For example: 100.00.

21

Bank/Card Commission (NC)

Fixed point number

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

22

DCC Markup (NC)

Fixed point number

Dynamic Currency Conversion markup: a negative amount indicates a credit in your account (ie additional revenue).

23

23 Num Txs

Integer

Count of payments for this entry.