Payouts reports
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 name | Description |
---|---|
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.
|
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. |