Enquiries

...

Here is how to answer them : 

Sales to payout 

High level concept

Payout = sales - refunds - fees - adjustments 

To understand your payouts it is essential to understand the items that compose it : 

1. Head to Finance > Sales to payout > Payouts 

...

This report will tell you which settled transactions, refunds, adjustments where included. The fees for the payout are the combination of the acquiring fees for each settled & refund transaction included + the transaction fees for the date mention ( in this example 03-01-2023 )  

2. Aggregate settlement 

To get a visibility at larger scale you can download the report > aggregate settlement details report to get all combined sales, refunds and other movements such as reserve funds, invoice deduction etc... over a certain period

A few explanation of items you will see here: 

Already discussed items: Settled; Refunded; Fee

MerchantPayout: payouts

InvoiceDeduction: "Amount due" from your invoice which are fees left after "Already deducted from settlement" 

Balancetransfer: amount that could not be payout in this batch, will be payed out in next batch. 

MerchantPayin: Funds you transferred in the account 

ReserveAdjustment :The funds being withheld from or released to the account due to funding or for using the Reserve register ( see your reserve balance in finance > balance ) 

other self-explanatory categories: 

Chargeback: 

ChargebackReversed

RefundedReversed

for other items or more precision see: https://docs.adyen.com/reporting/settlement-reconciliation/transaction-level/settlement-details-report/

2. Interactive payment accounting report 

To get a visibility on sales, fees and refunds at larger scale you can download the report> Interactive payment accounting report to get all transactions over a certain period ( select all events )

From this report you may 

1. 1. Calculate the sales  :
           Sum the "Captured" amount of the "Settled" type transaction 

      =SUMIFS(Sheet2!N:N;Sheet2!J:J;"Settled")

   2. Calculate the processing fees 
      Sum the "Processing Fee" amount of the "Authorised" and "SentForRefund" type transaction 

      =SUMIFS(Sheet2!V:V;Sheet2!J:J;"Authorised")+SUMIFS(Sheet2!V:V;Sheet2!J:J;"SentForRefund")

   3. Calculate the Acquiring fees
      Sum the "Commission", "Markup" and "Scheme Fees" amount of the "Settled" type transaction 

      =SUMIFS(Sheet2!Q:Q;Sheet2!J:J;"Settled")+SUMIFS(Sheet2!R:R;Sheet2!J:J;"Settled")+SUMIFS(Sheet2!S:S;Sheet2!J:J;"Settled")

   4. Calculate the refunds
      sum the "Refunded" 
      =SUMIFS(Sheet2!N:N;Sheet2!J:J;"Refunded"

3. Aggregate settlement 

To get a visibility of the adjustments at larger scale you can download the report > aggregate settlement details report to get all combined sales, refunds and other movements such as reserve funds, invoice deduction etc... over a certain period

A few explanation of items you will see here: 

Already discussed items: Settled; Refunded; Fee

MerchantPayout: payouts

InvoiceDeduction: "Amount due" from your invoice which are fees left after "Already deducted from settlement" 

Balancetransfer: amount that could not be payout in this batch, will be payed out in next batch. 

MerchantPayin: Funds you transferred in the account 

ReserveAdjustment :The funds being withheld from or released to the account due to funding or for using the Reserve register ( see your reserve balance in finance > balance ) 

other self-explanatory categories: 

Chargeback: 

ChargebackReversed

RefundedReversed

...

...