Payments Reconcile & Payouts Reconcile Reports

Modified on: Tue, 10 Dec, 2024 at 2:39 PM

Print

We’re pleased to introduce two reconciliation reports for In-platform Payments users: Payments Reconcile and Payout Reconcile. These tools are designed to simplify your financial oversight and ensure accuracy in your transactions.

Payments Reconcile: Track Every Transaction

The Payments Reconcile report helps you track payments in Clock PMS+ within a specified period. It answers the question, "Where is my money?" by showing whether each payment has been paid out, when it occurred, and which payout batch it belongs to, or if it’s still pending. The report summarizes payments by payout batches but allows you to drill down for detailed insights on each group.

  • Settled. Batch #XXX - This section displays all transactions processed during the selected reporting period that have already been paid out to your bank account, identified by the respective batch number.
  • Pending - This section lists transactions processed during the selected reporting period that have not yet been paid out to your bank account.
  • Clicking Details in either section provides a detailed view of all processed transactions. This includes:
    • The PSP reference number
    • Transaction date
    • User who initiated the transaction
    • Associated booking, company, or event, with a direct link
    • A link to the folio where the transaction is recorded
    • The transaction value

Payout Reconcile: Verify Your Payouts

The Payout Reconcile report provides clarity on each payout made to your bank account. It details the transactions included in each payout—such as payments, refunds, and chargebacks—along with the collected fees and commissions, and the net amount transferred. This comprehensive view helps ensure that all payouts are accurate and complete.

Important about Payouts:

  • Adyen processes payouts every weekday (Monday to Friday), except on bank holidays. Note that bank holidays vary depending on the currency of your payout.
  • Transactions processed on a given day are paid out 11 business days later. For example, the payout processed today will cover transactions from 11 business days ago.
  • Payouts are handled in batches. Each batch includes all transactions processed on a specific day.
  • Payouts scheduled for a weekend (Saturday or Sunday) or a bank holiday are grouped with the next available weekday payout.

The report

  • to see results you must always select your Merchant account. Searching only with Merchant account will show all your payouts (batches) since you've started with the service.
  • you can refine your search by entering batch numbers (from/to) or batch dates (payout dates)
  • the results will list each batch with its totals
    • total value of transactions (payments, refunds, chargebacks)
    • total value of processing fees
    • total value of fees for commission based payment methods such as AmEx, Diners/Discover, iDeal and others
    • total value of fees (markup, scheme fee, interchange) for Interchange++ based  payment methods such as Visa, Mastercard, Maestro and others
    • deductions for monthly fees such as TRS or other
    • transferred balances from previous batches that were not paid out, but bundled with this batch
    • total value of the payout

  • clicking on a batch number will open the detailed view for this batch
    • all transactions that are have been paid out to you will be listed with many details - value of the transaction, PSP reference number, payment method, fees, is it a payment, refund or chargeback and more.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

On this page