Overview sheet

This worksheet displays an overview of the finance report.

Field name

Description

Account Type

Indicates the reporting level: either at merchant account, or company account level.

Typical values are:

  • MerchantAccount, Merchant for merchant account level reports.
  • CompanyAccountCompany for company account level reports.

Account Code

Indicates the specific company or merchant account the report has been requested for.

Adyen Settlement

Indicates the settled amount, in the primary settlement currency, for transactions where Adyen is in the money flow.

External Settlement

Indicates the settled amount, in the primary settlement currency, for transactions where Adyen is not in the money flow.

Total in [primary settlement currency]

Indicates the total amount for the line item, in the primary settlement currency.

Row name

Description

Payments received on/in [period]

Total value of the payment requests received by the Adyen payments platform.

Payments authorised on/in [period]

Total value of the authorised payments for the reporting period.

Amount sent for settle on/in [period]

Total value of the transactions with a SentForSettle status during the reporting period.
By the end of the period some of these transactions may change their status to Settled or CaptureFailed, or remain in SentForSettle.

Amount sent for refund on/in [period]

Value of the transactions with a SentForRefund status during the reporting period.
By the end of the period some of these transactions may change their status to Refunded or RefundFailed, or remain in SentForRefund.

Total amount paid out on/in [period]

Total amount of the transactions that were settled to your bank account during the reporting period.

For a breakdown of how this figure was calculated, click the [+] icon on the left side of the Excel sheet.

The Total amount paid out on/in [period] is not the sum of the previous four rows in the report.

Total receivables from Adyen at end of [period]

Total amount of Open captured balance, Open payable balance, and Deposit.

Open captured balance (gross)

Total value of the transactions with a SentForSettle status at the end of the reporting period. This is the amount that Adyen has requested from the shopper's bank but has not yet been received by Adyen.
This is the gross amount, before fees have been deducted.

Open payable balance

Total value of the transactions where Adyen has received the funds from the bank, and where Adyen is holding the funds until the next settlement batch.
This is the net amount, after fees have been deducted.

Deposit

The amount withheld by Adyen to cover risk exposure. This is calculated based upon your merchant potential liability (MPL) and can fluctuate from month to month based on your payment behaviour.