User-management icon

Aggregate settlement details report

Use this report to match settlement batches to the day of sale.

Time zones

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

The Aggregate settlement details report shows details of payout batches in a specific date range. You can use this report to validate funds received in your bank account against the day of sale.

For each settlement batch, the report shows credits, debits, and counts of transactions for all payment journal type entries. The entries are separated by each of the following properties:

  • Merchant account
  • Store
  • Terminal
  • Payment method
  • Journal type
  • Creation date (the date of sale)

Get the report

To generate and download the Aggregate settlement details report, you must have the Merchant report user role.

  1. Log in to Essentials.
  2. Go to Finances > Aggregate settlement.
    This opens a page with all Aggregate settlement details reports that have been generated.

Select Generate report to generate the report manually, or Modify automatic generation to have the reports generated automatically.

Sample

Download a sample Aggregate settlement details report for examples of the included data.

Structure

Summary

The first two lines show a summary of what's in the report:

Column Description
Merchant/Company Your merchant or company account code.
Start date The start date of the data.
End date The end date of the data.
Aggregation If there are special criteria for aggregation of the data.
Country codes If there is more than one country code.

Entries

Under the header line, each line in the report is a separate entry.

Columns

Each column shows specific information about the entries.

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) The time zone of the Creation Date.
This is the ISO code for your time zone setting.
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 Amount submitted in the transaction request.
For example, 100.00.
14 Gross Credit (GC) Fixed point number Amount submitted in the transaction request.
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.