Enquiries 

...

From here you can download 2 types of reports: 

1. 1. Complete payouts report
      

      Image Removed

      
      

      Image Added

      
      Here you can export the report containing all payouts within a certain date range.
      The top part, will give you a combined data of sales, refunds, costs, adjustments and payouts during the period
      The second part will give you the detail for each payout.
      
      Here you can see how much sales you made in this time period and how the converted to the payouts you received 
      
      Note: if you are settling in several currencies you will need to download this report for each currency you settle in ( you will see an additional dropdown to pick the currency next to the export button ) 
      

      Image RemovedImage Added

      
      
      
      

   2. Full details at lower scale 

...

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 ) 

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

...

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 "Received" 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"  transactions 
      =SUMIFS(Sheet2!N:N;Sheet2!J:J;"Refunded"

   5. You can recognize proximity from e-commerce transactions using the Unique Terminal ID column

   6. You can identify the shopper Country and Issuer country of the transaction using the columns of the same names.

...