Balance reports
Balance reports provide you with a view of monetary inflows and outflows across your currency accounts, as well as the opening and closing available balances over a specified period of time.
This allows you to determine any actions you need to take on your currency accounts. For example, the transfer of funds between your currency accounts or balance top-ups.
Your balance report also provides a breakdown of total payment-related fees and account-level fees applied to your currency accounts, allowing you to see the net revenue paid out to you over a specified period of time across each of your entities.
Understanding your balance report
Balance reports are available by entity and structured by currency account. For each of your currency accounts, the report features the following types of rows:
Balances & Payouts: shows your currency account opening and closing balance, and financial activity not resulting from payments, such as account-level fees, adjustments, transfers and payouts.
Breakdown: subsequent rows show a breakdown by payment method, including the total payment amount, total payment-related fees and tax. The number of rows depends on the number of payment methods processed to a currency account during the reporting period.
Report format
Balance reports come in .csv format with the file name following this template:
statement_{Entity Id}_{Currency}_{Start Date:YYYYMMDD}_{End Date:YYYYMMDD}.csv
When are the reports available?
The balance report will be available from 12:00:00 UTC each day, and includes any fund movements across your currency accounts that took place between 00:00:00 UTC and 23:59:59 UTC the previous day.
For example, all fund movements on 3 August 2020 (from 00:00:00 to 23:59:59 UTC) will be included in a daily balance report generated and available by 4 August 2020 at 12:00:00 UTC.
Your balance report can be made available on a daily, weekly or monthly basis.
Report fields
Decimal fields with monetary amounts are expressed in their major currency unit, with up to 8 decimal places. For example, an opening balance of $500 will be expressed as 500.00
| Field name | Description |
|---|---|
Report ID string | The unique report Identifier. |
Entity ID string | The unique ID of the entity for which the payment was processed. |
Entity Name string | The name of the entity for which the financial movement was processed. |
Currency Account ID string | The unique ID of the currency account where a balance change has occurred. |
Currency Account Name string | The name of the currency account to which the payment action amount was charged. |
Holding Currency string | Three-digit ISO currency code of the currency account.
|
Report Date datetime | The date on which the report was generated expressed in ISO format in UTC (YYYY-MM-DD THH:MM:SS). |
Reporting Start Date datetime | The start date of all fund movements across your currency accounts that are 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 fund movements across your currency accounts that are included in the report expressed in ISO format in UTC (YYYY-MM-DDTHH:mm:SS:sss). |
Description string | Used to identify whether a row relates to the Balances & Payouts or the Breakdown sections of the balance report for a currency account. |
Opening Available Balance decimal | Funds that had been made available to you for settlement at the start of the reporting period. |
Opening Pending Balance decimal | The funds that had not yet been made available to you at the start of the reporting period. |
Opening Payable Balance decimal | The funds that had been set aside for a settlement at the start of the reporting period. |
Opening Collateral Balance decimal | The collateral balance held at the start of the reporting period. For example, security deposits. |
Payment Method string | The payment method that was used to process the associated transactions. For example, Visa or Mastercard. |
Payments decimal | The total gross value of your payments processed over the scheduled period. |
Refunds decimal | The total gross value of Refunds (including partial refunds) processed in this period. |
Chargebacks decimal | The total gross value of chargebacks (including partial chargebacks) processed in this period. |
Pay To Cards decimal | Placeholder field for the total value 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 a card scheme 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 occur. These fees associated with authorization, verification and void actions whilst using Checkout. |
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 whilst using Checkout. |
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 Fee 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 fee charged for Card Payouts. |
Alternative Payment Method Fees decimal | Placeholder field for 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 your 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. |
Merchant Payout Fees decimal | Placeholder field for the total fees charged for payouts paid to your bank account. |
Pay to Bank Fees decimal | The total fees charged for processing bank payouts. This includes bank payout fees as well as bank payout returned fees. |
Pay to Bank Payouts decimal | The total value of funds paid out to banks. |
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. |
Merchant Payouts decimal | The total value of funds paid to you as part of your scheduled settlements. |
Closing Available Balance decimal | The cleared funds to a currency account available to you at the end of the reporting period. |
Closing Pending Balance decimal | The funds yet to be cleared to a currency account at the end of the reporting period. |
Closing Payable Balance decimal | The funds that have been set aside for a settlement or transfer at the end of the reporting period. |
Closing Collateral Balance decimal | The collateral balance held at the end of the reporting period, such as security deposits. |