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.