--- title: "Aggregate settlement details report" description: "Use this report to match settlement batches to the day of sale." url: "https://docs.adyen.com/essentials/aggregate-settlement-report" source_url: "https://docs.adyen.com/essentials/aggregate-settlement-report.md" canonical: "https://docs.adyen.com/essentials/aggregate-settlement-report" last_modified: "2026-05-13T12:57:19+02:00" language: "en" --- # 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](/essentials/sales-payouts#validate-payouts-against-sales). 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](/essentials/users#roles). 1. Log in to [Essentials](https://essentials-live.adyen.com/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](/franchisees/aggregate-settlement-details-report/SAMPLE_settlement_report_aggregate_yourMerchantAccount___2019-03-01_2019-03-31.csv) 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](/reporting/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 - MerchantPayinFor a full list of possible entries and further description, see the [Settlement details report](/reporting/settlement-reconciliation/transaction-level/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. | #### Additional 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 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 `MerchantPayout` entry. | | Settlement Flow | String | The Adyen flow into which the transaction was booked. |