If you don't want to automate your reconciliation processes on a transaction-level, follow the same approach as outlined in Automate payment reconciliation but total the amounts as required prior to booking them in your accounting system (e.g. using the 'Creation date' in the settlement detail report to link to the day of sale).
Use the following approach:
Validate your sales by summing the Gross Amount (PC) for all Authorised payments in the Payment accounting report.
You could skip this step if you accept a degree of delay in identifying discrepancies.
Reconcile top-down and manage by exception. For example, first validate the total sales for the company and only review details for individual stores or payment methods if you identify a discrepancy.
- Use the aggregate settlement report each week/month, and book settled funds against your receivable balance, either on a rolling basis or against a specific sales period (e.g. sales day/week/month).
- Check that the total paid by Adyen, over multiple batches, balances your sales total.
- Use the corresponding Received payment details, Payment accounting and Open Balance Detail reports as well as the Adyen Customer Area to investigate discrepancies.
Reconcile balances 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.