Search

Are you looking for test card numbers?

Would you like to contact support?

Reportin icon

Company Payouts report

Use this report for an overview of payouts.

About this report

This report is based on the time zone setting of your account.
See Downloading reports.

The Company Payouts report is available in company-level accounts and includes additional data about events that occurred during the payout. We recommend using it to:

  • Get an overview of successful, returned, and non-executed merchant payouts.
  • Analyze the latest status of successfully processed merchant payouts. The report includes the payout status at the moment that the report is generated.
  • Spot returned merchant payouts and analyze the reason.
  • Spot non-executed merchant payouts and analyze the reason.

The report file contains multiple worksheets detailed in the report structure section below.

Download a sample report

Review the sample report before you begin implementing your own process for managing reports. The sample report will give you an example of the kind of data that will be provided in your own reports.

To download a sample Company Payouts report, click here.

Report structure

Overview sheet

This sheet shows:

The journal entries in this report have a one-to-one relationship with entries in the Settlement detail report, which can be generated and downloaded for a merchant-level account.

Payout summary table

This table shows the numbers of entries for each journal type. You can use this table to get an overview of payout-related events.

Column Data type Description
Payout Summary String The journal type. For example: MerchantPayout, BankInstructionReturned, or BalanceTransfer.
Count Numeric The number of entries.

Merchant payout summary

This table shows the numbers of merchant payouts (MerchantPayout journal type) aggregated per executing partner bank and per currency.

Column Data type Description
Executing Bank String The executing bank of the payouts.
Currency String The payout currency.
Status String The payout status.
Count Numeric The number of payouts.

The possible statuses, listed from usual chronological order, are:

  • Created: Merchant payout successfully created.
  • Sent: Merchant payout was successfully sent and acknowledged by our partner bank.
  • Debit Confirmed: Merchant payout has been debited from our accounts. For a successful payout, this is the final status.
  • Rejected: The payout has been rejected because there has been an issue while processing the payout. This status is rare.

MerchantPayout sheet

This sheet shows MerchantPayout entries.

Column Data type Description
Bank Name String The executing partner bank.
JournalType String The MerchantPayout journal type.
Account Code String The Merchant Account code.
Currency String The payout currency.
Amount Numeric The payout amount.
Payable Number Numeric The batch number.
BankInstruction reference String The reference number of the bank instruction. This can usually be found on your received bank statement.
Status String The payout status.
Status Date Date field + Time field The date of the payout status.
Store Code String The store code of the Merchant Account. This does not always appear.

BankInstructionReturned sheet

This sheet shows BankInstructionReturned entries. Each entry is for a returned merchant payout.

Column Data type Description
JournalType String The BankInstructionReturned journal type.
Account Code String The reference code of the payout account.
Currency String The payout currency.
Amount Numeric The payout amount.
Payable Number Numeric The batch number.
BankInstruction Reference String The reference number of the bank instruction. This can usually be found on your received bank statement.
Returned Date Date field + Time field The date that the funds were booked back in the Payable. This is usually the date that the funds reached Adyen's bank account.
Reason Code String The reason code. This appears only if it's provided by the partner bank. The codes are specific to different currencies and regions.
Store Code String The store code of the Merchant Account. This is not always present.

BalanceTransfer sheet

This sheet shows BalanceTransfer entries. Each entry is for a non-executed payout.

Column Data type Description
JournalType String The BalanceTransfer. journal type.
Account Code String The reference code of the payout account.
Currency String The payout currency.
Amount Numeric The payout amount.
Payable Number Numeric The batch number.
Reason Code String The reason code.
Store Code String The store code of the Merchant Account. This is not always present.