Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Enquiries 

...

MerchantPayin: Funds you transferred in the account 

ReserveAdjustment :The funds being withheld from o

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

...

    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;"Received")+SUMIFS(Sheet2!V:V;Sheet2!J:J;"SentForRefund")

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

      =SUMIFS(Sheet2!Q;Sheet2!J:J;"Settled")+SUMIFS(Sheet2!T:T;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.

...