Search

Are you looking for test card numbers?

Would you like to contact support?

Reportin icon

Aggregate settlement details report

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

About this report

This report is based on the time zone setting of your account.
See Downloading reports.

The Aggregate settlement details 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 details report provides this for each settlement batch on a transaction level (for each merchant account), you can run the Aggregate settlement details 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.

Download a sample report

Review the sample report before you begin implementing your own process for managing reports. The sample report will give you an example of the kind of data that will be provided in your own reports.

To download a sample Settlement details report, click here.

Report structure

The Aggregate settlement details 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. 

To learn how to add additional columns or change the order of columns, refer to Configure report columns.

Standard columns

# Column Data type 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 request.
3 Country Code Alpha Text (2 character) Country of your merchant account.
4 Store Unicode text (255-character) 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, 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 of the Creation Date. To configure for your company or merchant account, open the Customer Area and go to Account > Account settings.
11 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
  • ReserveAdjustment
  • MerchantPayin
For a full list of possible entries and further description, see the Settlement details report.
12 Gross Currency Alpha Text (3 character) Three-character ISO code for the currency that was used for processing the payment (transaction currency).
13 Gross Debit (GC) Fixed point number Gross debit amount; this is the amount submitted in the transaction requests. For example: 100.00.
14 Gross Credit (GC) Fixed point number Gross credit amount; this is the amount submitted in the transaction requests. For example: 100.00.
15 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.
16 Net Currency Alpha Text (3 character) Three character ISO code for the currency that was used for processing the payment (settlement currency).
17 Net Debit (NC) Fixed point number Amount submitted in a debit transaction request, minus Bank/Card Commission. For example: 100.00.
18 Net Credit (NC) Fixed point number Amount submitted in a credit transaction request minus Bank/Card Commission. For example: 100.00.
19 Bank/Card Commission (NC) Fixed point number Total commission (including markup, scheme fee and interchange) charged.
20 DCC Markup (NC) Fixed point number Dynamic Currency Conversion markup: a negative amount indicates a credit in your account (ie additional revenue).
21 Num Txs Integer Count of payments for this entry.

Additional columns

To learn how to add additional columns, refer to Configure report columns.

Column Data type Description
Payable booking date Date field (Format: YYYY-MM-DD) Date on which the payment/refund was booked into the settlement batch; can be used in the context of reconciling the monthly Adyen invoice.
Payout reference Unicode Text (max. 15-characters) 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.
Settlement Flow String The Adyen flow into which the transaction was booked.

Configure report columns

If you want to add additional columns to a report, you can do so in the Customer Area. You can also change the order of columns, for example if this is required by third-party software that you're using.

Changing report columns can have an impact on automatic reconciliation.

To configure report columns, you need to have one of the following user roles:

  • Merchant admin
  • Merchant report role
  • Merchant financial
  • Merchant POS Report role

To configure report columns:

  1. Log in to your Customer Area.
  2. Go to Account > Report columns.
    This opens a page with all reports that can be configured. 1
  3. Find the report that you want to configure and select Configure.
  4. Select check boxes to indicate which columns should be included in the report.
  5. Drag the columns into the order you want them to appear in.
  6. Select Save configuration to save your changes.

1 If you don't see the page, go to the report overview page and toggle Automatic generation on for the report for which you want to configure the columns. You can leave automatic generation on, or turn it off again if you don't want to generate the report automatically.