Skip to content

Payouts reports

Last updated: 8th June 2022

Payouts reports provide an overview of payouts paid to you along with a breakdown of the associated fees over a specific period of time. This allows you to reconcile payouts with amounts paid out to your bank account and shown on bank statements.

Using the payouts and the financial actions reports together, you can reconcile payouts with the associated payments and fees by using the payout ID on both reports.


Understanding your payouts reports

Payouts reports are available for each entity. Each row on the report shows a payout from a currency account, and for each payout the total amount paid out to you, aggregated fees applied to payments processed (for example, interchange fees), and any account level fees applied to the payout (for example, merchant payout fees) are shown.


Report format

Payouts reports come in .csv format with the file name following this template:

payouts_{Entity ID}_{Start Date:YYYYMMDD}_{End Date:YYYYMMDD}_1.csv


When are the reports available?

Reports are available from 15:00:00 UTC. The data includes any settlements created that take place between 12:00:00 UTC the previous day and 12:00:00 UTC on the same day.

For example, a settlement created on August 3rd 2020 at 07:00:00 UTC will be included in a daily payout report generated and available by August 3rd 2020 at 15:00:00 UTC.

Your payouts reports can be made available on a daily, weekly, or monthly basis.

The payout report reflects settlements that are created and can be expected to be settled to you, not whether they have been successfully settled to your bank accounts.


Report fields

Decimal fields with monetary amounts are expressed in their major currency unit, with up to 8 decimal places. For example, a payout of $50 will be expressed as 50.00

Field nameDescription

Client Entity ID

string

The unique ID of the entity for which the payment was processed.

Client Entity Name

string

The designated name of the entity for which the payment was processed.

Sub Entity ID

string

The unique ID of the sub entity for which the payment was processed.

Sub Entity Name

string

The name of the sub entity for which the payment was processed.

Currency Account ID

string

The unique ID of the currency account a payout is settled from.

Currency Account Name

string

The custom descriptor of the associated currency account a payout is settled from.

Holding Currency

string

Three-digit ISO currency code of the currency account. For example, USD for dollars.

Learn more about ISO currency codes.

Payout ID

string

The unique ID of the payout settled from your currency account to your bank account.

Payout Date

datetime

The date on which the payout was settled to your account expressed in ISO format in UTC (YYYY-MM-DDTHH:mm:SS:sss).

Reporting Start Date

datetime

The start date of all payouts included in the report expressed in ISO format in UTC (YYYY-MM-DDTHH:mm:SS:sss).

Reporting End Date

datetime

The end date of all payouts included in the report expressed in ISO format in UTC (YYYY-MM-DDTHH:mm:SS:sss).

Payout Amount

decimal

The total value of funds settled to your bank account.

Merchant Payout Fees

decimal

Placeholder field for the total fees charged for payouts paid to your bank account.

Payments

decimal

The total gross value of your payments processed in this period.

Refunds

decimal

The total gross value of refunds (including partial refunds) processed in this period.

Chargebacks

decimal

The total net amount of chargeback transactions processed.

Pay To Cards

decimal

Placeholder field for the total value of funds paid out to cards.

Card Payment Interchange Fees

decimal

The total interchange fees charged by issuing banks for card payments.

Card Payment Scheme Fees

decimal

The total amount of scheme fees charged for card payments by payment schemes, such as Visa or Mastercard.

Acquiring Premiums

decimal

The total amount of CKO Premium fees applied in each successful capture for card processing payments.

Card Payment Gateway Fees

decimal

The total gateway fees charged for card payments when payment actions (for example, authorization, verification, voiding) occur.

Card Payment Blended Fees

decimal

The total scheme related agreed on card payment blended fees applied to captured payments if applicable.

Refunded Interchange Fees

decimal

The total interchange fees charged by issuing banks refunded.

Refund Scheme Fees

decimal

The total scheme fees charged by a card scheme for refunds.

Refund Gateway Fees

decimal

The total amount of gateway fees charged for refund actions.

Chargeback Fees

decimal

The total fees charged for processing chargebacks as part of the disputes process.

Retrieval Fees

decimal

The total fees charged for retrieval actions as part of the disputes process.

Representment Fees

decimal

The total fees charged for representment actions as part of the disputes process.

Pay To Card Interchange Fees

decimal

Placeholder field for the total interchange fees charged by an issuing bank for processing card payouts.

Pay To Card Scheme Fees

decimal

Placeholder field for the total scheme fees charged by a card scheme for processing card payouts.

Pay To Card Fees

decimal

Placeholder field for the total fees charged for card payouts.

Alternative Payment Method Fees

decimal

The total fees charged for accepting local payment methods, such as Sofort or Klarna.

Adjustments

decimal

Placeholder field for the total amount of adjustments applied to you currency account.

Tax

decimal

The total local value-added tax applied to your fees if applicable.

Account Updater Fees

decimal

The total fees charged for the Account Updater service.

Transfers In

decimal

Placeholder field for the total value of transfers into the currency account.

Transfers Out

decimal

Placeholder field for the total value of transfers out of the currency account.


Sample report

Download a sample payout report. If you're using Safari, hold the Option key when you download. (.csv file)