Enquiries
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:
Sales to payout.Typical questions :
How to make sure all my sales were payed out ?
How to know what sales where paid out in <time period>
Sales to invoices. Typical questions :
Why am I paying this amount this month?
How to find which transactions led to the invoices in < month> ?
Net revenues over a period of time
...
From here you can download 2 types of reports:
Complete payouts report
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 )
Full details
...
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/
3. Full details at large scale
| Anchor |
|---|
...
|
...
|
To get a visibility of all transactions that are used to calculate the sales, fees and refunds at larger scale you can download the report> Interactive payment accounting report to get all transactions over a certain period ( select all events )
From this report you may
...
If what you are trying to do is to understand what transactions constitute your invoice your best tool is the report > interactive payment accounting report with the dates of the month of the invoice.
Please check the full details section for documentation
Net revenues
| Anchor | ||||
|---|---|---|---|---|
|
...
You can always calculate it from the interactive report
Fees
For 1 month you can use the fees from the invoice.
...
You can always calculate it from the interactive report ( processing + acquiring )
...
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"
...