Enquiries
...
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/
...
Calculate the sales :
Sum the "Captured" amount of the "Settled" type transaction=SUMIFS(Sheet2!N:N;Sheet2!J:J;"Settled")
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")
Calculate the Acquiring fees
Sum the "Commission", "Markup", "Scheme Fees" and “interchange Fees” “Interchange” 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")+SUMIFS(Sheet2!T:T;Sheet2!J:J;"Settled")
Calculate the refunds
sum the "Refunded" transactions
=SUMIFS(Sheet2!N:N;Sheet2!J:J;"Refunded"You can recognize proximity from e-commerce transactions using the Unique Terminal ID column
You can identify the shopper Country and Issuer country of the transaction using the columns of the same names.
...