EnquiriesEnquiries 

There are usually 2 Main enquiries categories : 

1. Sales to payout. Typical questions : 
   1. How to make sure all my sales were payed out ? 
   2. How to know what sales where paid out in <time period> 
2. Sales to invoices. Typical questions :  
   1. Why am I paying this amount this month? 
   2. How to find which transactions led to the invoices in < month> ? 
3. Net revenues in a month period of time 

Here is how to answer them : 

DONT FORGET TO ANONYMISE IMAGES !!!!

Sales to payout 

Anchor
salesPayout salesPayout

...

IMPORTANT: the transaction fees included are NOT the transaction fees of the settled transactions included in this payout, they are all transaction fees that happened in the mentioned date ( see point 3 for more info) 

2. Condensed deep-diving at larger scale 

Anchor
AggregateSettlement AggregateSettlement

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

...

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 "AuthorisedReceived" 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"

...

Please check the full details section for documentation 

Net revenues

If what you are trying to do is to know how much revenue will have gained in a period of time net from all costs regardless of when it has been /will be payed out: 

Transactions that were successfully finished are called “settled”

If what you are looking for is simply what transactions were successfully finished during this period of time you can use the Gross settlements amount in insights > settlements&fees

Image Added

Now, the above amount IS NOT what Adyen ultimately owes you. What Adyen owes you in the end is sales – fees – refunds - misc adjustments.

so you may want to know what sales, costs, refunds and adjustments occurred during this time period regardless of when or if they have already been paid?

In this case you can find those values like this:

• Sales :

You should use the Gross settlements amount in insights > settlements&fees ( see image above). This gives you the sales amount that got settled in between those 2 dates.

If your period of time is 1 month, you can also find this amount in your invoice 

Image Added

You can always calculate it from the interactive report

• Fees

For 1 month you can use the fees from the invoice. 

Image Added

You can always calculate it from the interactive report ( processing + acquiring ) 

• Refunds:

You can find the refunds amount during this period in this dashboard

Image Added

Or alternatively from the interactive report 

• Adjustments :

Other misceleneous items can also after your net revenues for this month. The more common are InvoiceDeductions that are present in your invoice as "Amount due" however other items may enter this category too such as chargebacks, ReverseRefundded etc... The best way to identify those items is to use the Aggregated settlement details report  . Use the documentation and critical thinking to understand those items and identify which ones affect your "owed amount" 

Note that this is the only amount that cannot be found via the interactive report