Versions Compared

Key

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


Enquiries 

There are usually 2 Main enquiries categories Here comes the end of the month/year/season and you want to do a financial reconciliation. Here are some documentation that may help you to achieve your goal

  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 over a period of time 

Here is how to answer them : 

DONT FORGET TO ANONYMISE IMAGES !!!!

  1. time

Sales to payout 
Anchor
salesPayout
salesPayout

...

Head to Finance > Sales to payout > Payouts 

Image RemovedImage RemovedImage Added

From here you can download 2 types of reports: 

...

While the first report will help you with general reporting, you may wonder how those numbers were calculated and what is behind them. For instance you may wonder what are those adjustments you see in your payout report. To drill more on each payout you can extract the detail of what element constitute it. 

Image RemovedImage Added

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

...

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/

...

Please check the full details section for documentation 


Net

...

revenues 
Anchor
netRevenus
netRevenus

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: 

...

You can find the refunds amount during this period in this dashboardImage Removedthe insight > payment lifecycle > purchase & refunds 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

...