Balance Report
Last updated: November 13, 2024
The Balance Report provides you an overview of monetary inflows and outflows across your sub-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 sub-accounts. For example, the transfer of funds between your sub-accounts or balance top-ups.
The Balance Report also provides a breakdown of total payment-related fees and account-level fees applied to your sub-accounts. The enables you to see the net revenue paid out to you over a specified period of time across each of your entities.
This report is available by entity and structured by sub-account. For each of your sub-accounts, the report features the following types of rows:
Balances & Payouts: shows your sub-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 sub-account during the reporting period.
The Balance Report comes in CSV format, with the file name following this template:
statement_{Entity Id}_{Start Date:YYYYMMDD}_{End Date:YYYYMMDD}.csv
This report is created between 03:00:00 and 12:00:00 in the settlement time zone you've configured in your entity account. You can generate it on a daily, weekly, or monthly basis.
The daily Balance Report covers any fund movements across your sub-accounts from the start of the day at 00:00:00 to end of the day at 23:59:59, based on the specified time zone.
For example, if you've set the settlement time zone to America/Los_Angeles Pacific Time (PT), and you have fund movements on August 3, 2023, the daily Balance Report includes all transactions from August 3, 2023, at 00:00:00 to 23:59:59 PT. This report is generated at 12:00:00 PT on August 4, 2023.
Download a sample Balance Report (CSV file).
Information
If you're using Safari, hold the Option key when you download.
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
Information
To enable one or more additional fields for your reports, contact your Account Manager.
The optional fields you choose are added to the report in the same order they appear in the table.
Information
The sub-account is referred to as currency account in the report fields.
| 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. Learn more about ISO currency codes. |
Report Date datetime | The date on which the report was generated expressed in ISO format in UTC ( |
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 ( |
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 ( |
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. |
Opening Operational Funding Balance decimal | The funds held for processing payouts and issuing payments, when the available balance is insufficient at the start of the reporting period. |
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 while using Checkout.com. |
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 while using Checkout.com. |
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 | The total interchange fees charged by an issuing bank for processing pay to card payouts. |
Pay To Card Scheme Fees decimal | The total scheme fees charged by a card scheme for processing pay to card payouts. |
Pay To Card Fees decimal | The total fees charged by Checkout.com for pay to card payouts. |
Alternative Payment Method Fees decimal | Placeholder field for the total fees charged for accepting local payment methods. For example, 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. |
Closing Operational Funding Balance decimal | The funds held for processing payouts and issuing payments, when the available balance is insufficient at the end of the reporting period. |
Integrated platforms fees decimal optional | The fees related to the onboarding and management of your sub-entities with Checkout.com. |
Reserve Deducted decimal optional | The total reserves deducted from your processing and held by Checkout.com for the agreed reserve period. |
Reserve Released decimal optional | The total reserves released after the agreed reserve period has elapsed. |
Billing Fees decimal optional | The total fees charged for billing agreements made with Checkout.com, for example, minimum billing. |
Authentication Fees decimal | The total fees charged for authenticating payments via Checkout.com’s authentication product. |
Authentication Scheme Fees decimal | The total fees applied by card schemes (for example Visa, Mastercard) for authentication processing. |
Risk Engine Fees decimal optional | The total fees applied for transactions screened by Fraud Detection Pro. |
Intelligent Acceptance Fees decimal optional | The total fees applied for transactions optimized by Checkout.com’s Intelligent Acceptance product. |
Network Token Fees decimal optional | The total fees applied for using Checkout.com’s Network Tokens service. |
Timezone string optional | The time setting that your report adheres to. Your opening and closing balances are calculated against this time zone. The timestamps are displayed in this time zone. For example, |