How to match an Adyen payout in the Payment report and the Mews Payments balance

To ensure your financial reporting is accurate and to help track specific charges, there may be instances where you need to reconcile payouts from Adyen with the information on your Mews Payments Balance or the Payment Report. Your finance staff can do this using information obtained from the Mews Payments Balance, or by using the correct filters in the Payment report. You can do this when receiving your payouts to help you resolve discrepancies.

In this article you can learn about:

• Matching the Adyen payout in Mews Payments Balance
• Matching the Adyen payout in the Payment Report

Matching the Adyen payout in Mews Payments balance

To match the Adyen payout, you use the ID of the payout, which you find in the Mews Payments Balance. To locate the payout ID:

1. In Mews Operations, go to the main menu  > Finance > Mews Payments Balance.
2. Under Identifier[SG3] , locate the number which matches the ID of the Adyen payout.

3. Click on the Payout to view the charges which were included in this specific payout.

The Payout detail[DF4]  side-window shows the platform fee along with a description of the balancing transaction, with the corresponding payout ID. 

Note: There may be instances where you see an additional transaction in your payout. This happens when Adyen Marketpay creates two transactions for one actual payout. These transaction amounts can be positive or negative. You use them to balance the payout amount to avoid discrepancies in the total payouts shown in the Merchant balance report.

Matching the Adyen payout in the Payment report

You can use the Payment report to see more details including charges, guest information or payment card information.

To locate the payout, you need to check the previous week before this payout was sent. For example, if the payout was created on 03/08/20, you need to check the previous week from 28/07/20 to 03/08/20.

To locate the payout in the Payment report:

1. In Mews Operations, go to the main menu  > Finance > Payment report.
2. Complete the following fields:
   • Mode: Click the drop-down to select Settled.
   • Start: Click to enter the start date.
   • End: Click to enter the end date.
   • Status: Click the dropdown to select Settled.
   • Type: Click the dropdown and select Payment, Chargeback, Chargeback Reversal, and Refund.
   • Filter: Click the dropdown to select Gateway CC payments.

3. Click Export > Export to Excel.

This locates the Adyen payouts in the Mews Payment report. In the exported report, you can filter out all payments included in the given payout by the payout ID.

You can learn more about the Payment report here