Settlement details report

The Settlement details report includes the details of payments that have been settled and paid out to you by Adyen. You can use this report to see the costs of each transaction and perform reconciliation on a transaction level.

File name format: Includes the batch number, date, and/or a unique identifier, depending on how you generate the report.

Generating and downloading: Get this report manually or automatically.

Time zone: The time zone setting of your account.

Availability: Only available for (one or multiple) merchant accounts.

Generate and download reports

You can generate the Settlement details report for one or for multiple merchant accounts. If you select multiple merchant accounts, the generated report will contain settlement data for all merchant accounts that you selected. This can be useful if your business requires reconciliation across multiple merchant accounts, for example in the hospitality or food and beverage industry.

The default setting is to generate the report per merchant account, per batch. Next payout (Payable) batches close according to the payout frequency defined for a merchant account. Any previously configured generation settings and schedules remain unchanged.

To manually or automatically generate a Settlement details report, or download a previously generated report, you need the Merchant Report user role. You need this role for each merchant account that you want to include in the report.

Manually generate a report

To manually generate a report:

1. Log in to your Customer Area, and switch to a merchant account.

2. Select Reports > Settlement details.

3. Select Manage report > Manual (generate once).

4. Under Accounts, configure for which accounts you want to generate the report:

   • Current account: generate only for the current merchant account.
   • All accounts: generate for all merchant accounts that you have access to.
   • Specific accounts: select the merchant accounts to include in the report.

5. Under Data filtering, select one of the following:

   • Date: generate for a specific date.
   • Single batch: generate a single batch (Current account only).

6. Under File type, select one of the following:

   • CSV (default)
   • XLS_GEN
   • TSV
   • XML
   • XMLE

7. Select Generate report. At the top of your screen you will see a pop-up message that says Report is successfully queued.

Automatically generate a report

To automatically generate a report:

1. Log in to your Customer Area, and switch to a merchant account.

2. Select Reports > Settlement details.

3. Select Manage report > Automatic (generate on a schedule).

4. Under Frequency, configure when you want to generate the report:

   • Daily
   • Weekly > select a day of the week
   • Monthly > select a day of the month from the calendar
   • At batch close

5. Under Accounts, configure for which accounts you want to generate the report:

   • Current account: generate only for the current merchant account.
   • All accounts: generate for all merchant accounts that you have access to.
   • Specific accounts: select the merchant accounts to include in the report.

6. Under File type, select one of the following:

   • CSV (default)
   • XLS_GEN
   • TSV
   • XML
   • XMLE

7. Select Schedule.

Download reports

To download a previously generated report:

1. Log in to your Customer Area, and switch to a merchant account.
2. Select Reports > Settlement details.
3. Under Generated reports, select the name of the report you want to download.

The file name and file name format of the report depend on what you selected when you generated the report. See the table for more details.
In general:

• The default file name extension is .csv.
• If a date is included, the format is YYYY-MM-DD.
• If a unique identifier is included, it is an eight-character alphanumeric string. This identifier is added to the file name when you generate a report for multiple accounts.

Sample report

Download a sample 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.

Report structure

Entries

Under the header line, each line in the report is a separate entry. The types of entries include:

• Transactions
• Transaction fees
• Deposit corrections
• Invoice deductions
• Payouts

Transactions

Each transaction entry shows the status of the transaction. For example: Settled or Chargeback.

TestCompany,TestMerchant,1813702551707653,3vpzf7,visa,2013-06-03 11:26:49,CET,Settled,1713702551795048,GBP,,5.00,1,GBP,,4.88,,0.04,0.01,0.07,visaclassic,,,,,,,,,

TestCompany,TestMerchant,1313642467023511,324959451,visa,2013-03-26 22:37:26,CET,Chargeback,2313642467170922,EUR,349.99,,1,EUR,357.49,,7.5,,,,visaclassic,,,,,,,,,

Transaction fees

The report includes a transaction fee entry for each month that has transactions in the settlement batch.

TestCompany,TestMerchant,,,,2013-06-11 04:55:40,CET,Fee,Transaction Fees May 2013,EUR,,,,GBP,1.46,,,,,,,,,,,,,,,

Deposit corrections

The report includes an entry with the DepositCorrection journal type when a deposit change happens in your account. This can be a credit or a debit.

TestCompany,TestMerchant,,,,2012-05-10 05:37:03,CET,DepositCorrection,Deposit Correction,EUR,,,,EUR,78.93,,,,,,,,,,,,,,,

The report includes another type of deposit correction with the ReserveAdjustment journal type if your Reserve balance changes.

Invoice deductions

The report includes an entry with the InvoiceDeduction journal type if we debit an amount that you owe or credited an amount that you overpaid. This can include your amount due, point-of-sale terminal hardware costs, and in-person payment service costs.

The entry includes a column with the invoice number associated it and a column with a description explanation.

Descriptive explanations include:

• "Discounts and additional costs" for the amount due from your Payment processing invoice.
• "Terminal hardware sale invoice amount" for point-of-sale terminal hardware sales.
• "Terminal services invoice amount" for in-person payment services.

A deduction is in the debit column, and a credit is in the credit column.

TestCompany,TestMerchant,,,,2013-05-10 12:59:53,CET,InvoiceDeduction,Invoice 201111000553,EUR,,,,EUR,,250.22,,,,,,,4,,,,,,,

Merchant payout

The entry with the MerchantPayout journal type shows the payout from Adyen to your bank account. It includes a reference, batch number, and the bank account.

In this example, Adyen paid out EUR 1842.21 to the TestMerchant merchant account. In your bank account statement, TX4313726XT batch 4, TestMerchant is the transaction message.

TestCompany,TestMerchant,,,,2013-06-11 04:55:40,CET ,MerchantPayout,"TX4313726XT batch 4, TestMerchant batch 4, TestMerchant",EUR,,,,EUR,1842.21,,,,,,,,,,,,,,,

Columns

Each column shows specific information about the entries. By default, the report includes standard columns. You can optionally add additional columns.

Standard columns

The table below reflects the standard columns that are included in the report, and the default order. You can add more columns, or change the order of the default columns.

Additional columns

You can configure report columns to add these to your report:

Configure report columns

If you want to add additional columns or change the order of columns in 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 your automated system.

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 Settings > Report columns.
   This opens a page with all the reports that you can configure.
3. Find the report that you want to configure and select Configure.
4. Select checkboxes to indicate which columns you want to include in the report.
5. Drag the columns into the order you want them to appear in.
6. Select Save configuration.

Journal types

The journal types listed below correspond to the Type field in the report structure above.

See also