Settlement details report

The Settlement details report includes all payments that are settled, i.e. paid to you by Adyen.

The report specifies:

• Gross/net settlement amount for captures - Which transactions paid out, and how much.
• Refunds.
• Chargebacks (where present).
• Fee totals.
• Deposit corrections.
• Total settled amount.

Use this report to validate funds received and account for refunds and adjustments, understand withheld costs for each transaction, book payment costs (chargebacks, reversals, and associated costs) and clear your accounts receivable balance.

The report is generated whenever a payable batch closes. Payable batches close according to the payout frequency defined for a merchant account. The transactions in a batch are reported on your bank statement:

The batch number in the settlement to your bank corresponds to the batch number in the Settlement details report. For example: https://ca-live.adyen.com/reports/download/MerchantAccount/[yourMerchantAccountName]/settlement_detail_report_batch_4.csv

Download a sample report

To get an idea of the kind of data that you will see in the Settlement details report, you can download a sample report here. Based on your account and settings, your own report might contain additional columns that are not included in the sample report.

Report structure

Sections

The Settlement details report consists of five sections:

• Column headers - One line, for example, Company Account,Merchant Account,Psp Reference(...)
• Transaction details - Multiple lines, for example, TestCompany,TestMerchant,1813702551707653,3vpzf7,visa,2013-06-03(...)
• Transaction fees - One or more lines, for example, TestCompany,TestMerchant,,,,2013-06-11 04:55:40,BST,Fee,Transaction Fees(...)
• Corrections - One or multiple lines, for example, TestCompany,TestMerchant,,,,2012-05-10 05:37:03,CEST,DepositCorrection,DepositCorrection(...)
• Merchant payout - One or multiple lines, for example, TestCompany,TestMerchant,,,,2013-06-11 04:55:40,BST,MerchantPayout,"TX977148886XT batch 4(...)

Columns

A report is broken into multiple columns, each of which represent data associated with a payment. Each field takes a specific data type.

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

Standard columns

Additional columns

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

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.

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. ¹
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.

¹ 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.

Journal types

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

Types of report lines

Transaction lines

Each transaction is represented by an entry. Each entry is on a separate line in the report. Each transaction line in the report describes the status of the transaction, and the reason why it was included in the settlement batch. For example: Settled or Refunded.

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

A transaction fee line is an entry in the report providing information on chargeable fees. A settlement report includes a transaction fee line 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

If Adyen requires a deposit, this is filled by withholding settlements until the deposit amount is met.

The deposit is a variable amount that may increase or decrease, due to changing risk figures. On a change, a DepositCorrection line item is included. This line can be a credit or a debit.

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

Apart from the deposit held by Adyen, a separate register is created for refunds, payouts or chargebacks. The Reserve is a way of keeping some of your funds in your account, to be made available for refunds, chargebacks or third-party payouts that Adyen processes on your behalf. A ReserveAdjustment line item is included in the Settlement details report. This line can have a credit or a debit to reflect either a release of funds into the payable or a move of funds to the Reserve register.

Invoice deduction lines

At the end of each month, Adyen calculates the final invoice amount. It may happen that we either charged you too much, or too little. For example, this scenario can occur if you apply tiered pricing.

For invoices related to POS hardware sales and POS related services, no amount is deducted throughout the month, and therefore the total amount is deducted from settlement. The outstanding amounts are deducted from the next settlement batch.

To balance it, we book an InvoiceDeduction line item in the Settlement details report, when necessary. The reference includes the invoice number associated with the invoice deduction followed by a descriptive explanation.

Descriptive explanations are:

• "Discounts and additional costs" for processing invoices.
• "Terminal hardware sale invoice amount" for POS hardware sales.
• "Terminal services invoice amount" for POS related services.

In this example, Invoice 201111000553 refers to the invoice number mentioned in the invoice of the given month. The amount may appear with debit or credit columns.

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

Transfer lines

An entry documenting a funds transfer to your bank account. The net debit/merchant payout field holds the total amount paid out to your account, followed by the currency.

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

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