Settlement detail report

The settlement detail report is recommended to reconcile your administration. It includes all payments that are settled i.e. paid out to you by us. This report based on the transaction level is generated with the settlement batches to sort out which transactions that went through our system was paid out. Adyen pays out to your merchant accounts twice every week i.e. Tuesday and Friday and should be expected on these days only. This transaction level report specifies the gross/net settlement amounts for captures, refunds, chargebacks (where present), fee totals, deposit corrections, and the total amount settled.

Payments are settled periodically to your bank account. On your bank statement, they are reported in the following way:

28-24-2013

By

1323.94.782

ADYEN

Add

EUR

1842.21

 

 

 

TX4313726XT batch 4, [yourMerchantAccountName]

 

 

 

The fields have the following meaning:

  • 1323.94.782 is Adyen's Dutch settlement bank account. Depending on the country and currency of settlement this number may be different.
  • The payment originates from ADYEN, the Adyen Client Management Foundation that receives and settles your payments.
  • TX4313726XT is the internal Adyen reference code; you can disregard this piece of information, as it is not relevant to you.
  • The batch number, batch 4 in the example, is the settlement sequence number. It starts at 1 to flag the first settlement, and it increases incrementally by one unit with each subsequent settlement.
  • 1842.21 is the total amount of the settlement. This sum matches the payout amount in the settlement detail report.

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

To add a report date to the file name, contact the Support Team.

The settlement detail report itself consists of five sections:

1

Column headers/descriptions
(one line)

Company Account,Merchant Account,Psp Reference,Merchant Reference,Payment Method,Creation Date,TimeZone,Type,Modification Reference,Gross Currency,Gross Debit (GC),Gross Credit (GC),Exchange Rate,Net Currency,Net Debit (NC),Net Credit (NC),Commission (NC),Markup (NC),Scheme Fees (NC),Interchange (NC),Payment Method Variant,Modification Merchant Reference,Batch Number,Reserved4,Reserved5,Reserved6,Reserved7,Reserved8,Reserved9,Reserved10

2

Transaction details
(multiple lines)

TestCompany,TestMerchant,1813702551707653,3vpzf7,visa,2013-06-03 11:26:49,BST,Settled,1713702551795048,GBP,,5.00,1,GBP,,4.88,,0.04,0.01,0.07,visaclassic,<auto>,4,,,,,,,
[...]

3

Transaction fees
(one or multiple lines)

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

4

Corrections
(one or multiple lines)

TestCompany,TestMerchant,,,,2012-05-10 05:37:03,CEST,DepositCorrection,DepositCorrection,EUR,,,,EUR,,78.93,,,,,,DepositCorrection,4,,,,,,,

5

Merchant payout
(one or multiple lines)

TestCompany,TestMerchant,,,,2013-06-11 04:55:40,BST,MerchantPayout,"TX977148886XT batch 4, TestMerchant batch 4, TestMerchant",EUR,,,,GBP,22.50,,,,,,,,4,,,,,,,

Multi-currency transactions 

  • If you have multiple settlement currencies, the settlement detail report contains a merchant payout line for each applicable settlement currency.
  • If a settlement batch contains transactions with processing currencies other than the settlement currency, then these gross amounts are converted to the net amount in the settlement currency.
    For example, if your settlement currency is EUR, and if you also process payments in SEK, you see both currencies and amounts in the reports, including the exchange rate used to convert the processing amount (SEK) to the settlement amount (EUR).
    To check the exchange rate used for the currency conversion, refer to the relevant Adyen's
    daily Exchange Rate Report.

Match settlements to transactions

Depending on your implementation, you can store one or more keys per transaction.
For example, you can configure your implementation to store the merchant transaction identifier generated by your system, and then passed on to Adyen via the reference or the merchantReference fields. Alternatively, you can store the Adyen-generated pspReference.
Adyen reports include both references, so you can easily tie the report line items back to the individual transactions in your system.

We recommend automating the matching process. The following basic guidelines can get you jump-started.

  • Check your bank statements against the settlement records:
    • Identify the line item in your bank statement that contains the TX...XT description and the batch number.
    • Identify the corresponding settlement detail report
    • Verify that the deposit amount matches the amount indicated in the settlement detail report.
  • Using the settlement detail report line items, update each transaction in your system with the appropriate status, as indicated in the report. For example: settled, refunded or chargeback.
  • Optional:
    • You can add a batch number field to your transaction table to look up which batch the transaction was paid out.
    • You can store the settled amount, so you can keep track of the costs per transaction.

A fully automated system leaves no room for errors, and it contributes to making your bookkeeping system correct, as far as Adyen transactions are concerned.

Questions

Can't find something you are looking for? Look at our FAQ for answers or send an email to support.