Reconciliation with the Aggregate settlement report

The aggregate settlement report can be used to both review details of funds received on your bank (against the day of sale) and to review in which batches a day of sale has been settled.

  • For each Batch Number, you can check the funds received on your bank account against the MerchantPayout line. The MerchantPayout is the result/total of all other credit and debit mutations in the batch (e.g. Settled, Refunded, Chargeback). You can identify the original day of sale from the Creation date column.
  • To validate if sales for a day have been completely paid out by Adyen, use a weekly and/or monthly report. By summing all 'Settled' payments for a particular creation date, you will be able to validate that the total [settled in the report period] matches your own sales report, and when/in which batches they were settled.

Please see the Reconciliation manual for more details and additional background information.