The Aggregate settlement details report shows details of payout batches in a specific date range. You can use this report to perform reconciliation on a batch level.
For each settlement batch, the report shows credits, debits, and counts of transactions for all payment-level status entries (e.g. Settled, Refunded, Chargeback) and batch-level booking entries (Fees, InvoiceDeduction, MerchantPayout). These are grouped by merchant account, store, terminal, payment method, journal type and creation date/day of sale.
Download a sample Aggregate settlement details report for examples of the included data.
Based on your account and settings, a report you generate in your account can contain additional data or columns that are not included in the sample report.
The first two lines of the report shows a summary of the data:
|Merchant/Company||Your merchant or company account code.|
|Start date||The start date of the data in the report.|
|End date||The end date of the data in the report.|
Under the header line, each line in the report is a separate entry.
|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 > Settings.|
|11||Journal Type||Alpha Text (50 character)||Type of record included in the report, most commonly:
|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.
|14||Gross Credit (GC)||Fixed point number||Amount submitted in the transaction request.
|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.|
You can configure report columns to add these to your report:
|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 identifier of a merchant payout, formatted like TX...XT. This also appears in the description of the transfer in your bank account or bank statement. Only applies to the
|Settlement Flow||String||The Adyen flow into which the transaction was booked.|
Configure report columns
If you want to add additional columns or change the order of columns to a report, you can do so in the Customer Area. If you have an automated system that uses the report's data, configuring the report columns can affect how your automated system gets the report's data.
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:
- Log in to your Customer Area.
- Go to Account > Report columns.
This opens a page with all reports that can be configured. 1
- Find the report that you want to configure and select Configure.
- Select checkboxes to indicate which columns should be included in the report.
- Drag the columns into the order you want them to appear in.
- Select Save configuration to save your changes.