Balance Report
Last updated: January 22, 2025
The Balance Report provides an overview of funds movements in and out of your sub-accounts, and the opening and closing Available balances in a specified timeframe. This enables you to identify any actions you need to take on your sub-accounts. For example, transfer funds between sub-accounts or top up balances.
The report also breaks down all payment-related fees and account-level fees charged to your sub-accounts. This represents the net revenue paid out to you in the reporting period for each entity.
This report is available per entity and structured by sub-account. For each sub-account, the report features the following types of rows:
Balances & Payouts – The sub-account's opening and closing balance, and financial activity not related to payments, such as account-level fees, adjustments, transfers, and payouts.
Breakdown – 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 in the sub-account in the reporting period.
This report is created between 03:00:00 and 12:00:00 in the settlement time zone you've configured for the entity. You can generate it on a daily, weekly, or monthly basis.
The daily Balance Report covers any funds 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 your settlement time zone is America/Los_Angeles
Pacific Time (PT), and there were funds movements on August 3, 2024, the daily Balance Report includes all transactions from August 3, 2024, at 00:00:00 to 23:59:59 PT. This report is generated at 12:00:00 PT on August 4, 2024.
See instructions on how to download the report on demand or on a schedule:
The report is provided as a CSV file. By default, the file name uses the following format:
statement_{Entity Id}_{Start Date:YYYYMMDD}_{End Date:YYYYMMDD}.csv
See instructions on how to download the report on demand or on a schedule:
Download a sample Balance Report (CSV file).
Information
If you're using Safari, hold the Option key when you download.
Information
To enable one or more optional fields for your reports, contact your Account Manager.
These fields are added to the report in the same order as they appear in the table.Sub-accounts are referred to as "currency accounts" in the report fields.
All decimal amounts are expressed in the major currency unit, with fixed-point notation with up to eight decimal places. For example, 500 USD is represented as
500.00
.
The report includes the following fields in this order:
Field name | Description |
---|---|
Report ID string | The 13-digit unique identifier for the report. |
Entity ID string | The unique identifier for the entity the financial movement was processed for. |
Entity Name string | The name of the entity. |
Currency Account ID string | The unique identifier for the sub-account where there was a funds movement. |
Currency Account Name string | The name of the sub-account. |
Holding Currency string | The currency of the sub-account. |
Report Date datetime | The time and date when the report was generated, in UTC. |
Reporting Start Date datetime | The start date of the reporting period, in UTC. |
Reporting End Date datetime | The end date of the reporting period, in UTC. |
Description string | Identifies if the row relates to the Balances & Payouts or the Breakdown section of the report. |
Opening Available Balance decimal | The funds available to you for settlement at the start of the reporting period. |
Opening Pending Balance decimal | The funds not yet available to you at the start of the reporting period. |
Opening Payable Balance decimal | The funds 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. |
Opening Operational Funding Balance decimal | The funds held for processing payouts and issuing payments, in case the Available balance is insufficient, at the start of the reporting period. |
Payment Method string | The payment method used for the associated transactions. |
Payments decimal | The total gross amount of your payments processed. |
Refunds decimal | The total gross amount of full and partial refunds processed. |
Chargebacks decimal | The total gross amount of full and partial chargebacks processed. |
Pay To Cards decimal | The total amount paid out to cards. |
Card Payment Interchange Fees decimal | The total Interchange fees charged by issuers for card payments. |
Card Payment Scheme Fees decimal | The total fees charged by card schemes for card payments. |
Acquiring Premiums decimal | The total Checkout.com Premium fees charged for each successful card payment capture. |
Card Payment Gateway Fees decimal | The total gateway fees charged by Checkout.com for card payments when payment actions occurred, including authorizations, verifications, and voids. |
Card Payment Blended Fees decimal | The total agreed card-payment blended fees charged by card schemes for captured payments, if applicable. |
Refunded Interchange Fees decimal | The total Interchange fees charged by issuers that were refunded to you. |
Refund Scheme Fees decimal | The total fees charged by card schemes for refunds. |
Refund Gateway Fees decimal | The total gateway fees charged by Checkout.com for refund actions. |
Chargeback Fees decimal | The total fees charged by Checkout.com for processing chargebacks as part of the disputes process. |
Retrieval Fees decimal | The total fees charged by Checkout.com for retrieval actions as part of the disputes process. |
Representment Fee decimal | The total fees charged by Checkout.com for representment actions as part of the disputes process. |
Pay To Card Interchange Fees decimal | The total Interchange fees charged by issuers for processing pay-to-card payouts. |
Pay To Card Scheme Fees decimal | The total fees charged by card schemes 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 | The total fees charged by Checkout.com for accepting alternative payment methods. |
Adjustments decimal | The total amount of adjustments charged by Checkout.com to the sub-account. |
Tax decimal | The total local value-added tax charged on your fees, if applicable. |
Account Updater Fees decimal | The total fees charged by Checkout.com for the Account Updater service. |
Merchant Payout Fees decimal | The total fees charged by Checkout.com for payouts to your bank account. |
Pay to Bank Fees decimal | The total fees charged by Checkout.com for processing Bank Payouts, including returned Bank Payout fees. |
Pay to Bank payouts decimal | The total amount paid out to banks. |
Transfers In decimal | The total amount of transfers into the sub-account. |
Transfers Out decimal | The total amount of transfers out of the sub-account. |
Merchant Payouts decimal | The total amount paid to you as part of your scheduled settlements. |
Closing Available Balance decimal | The funds cleared to the sub-account that are available to you at the end of the reporting period. |
Closing Pending Balance decimal | The funds yet to be cleared to the sub-account at the end of the reporting period. |
Closing Payable Balance decimal | The funds 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, in case the Available balance is insufficient, at the end of the reporting period. |
Integrated platforms fees decimal optional | The fees charged by Checkout.com for onboarding and managing the sub-entity. |
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 Checkout.com released to you after the agreed reserve period passed. |
Billing Fees decimal optional | The total fees charged by Checkout.com for billing agreements. |
Authentication Fees decimal | The total fees charged by Checkout.com for processing authentications. |
Authentication Scheme Fees decimal | The total fees charged by card schemes for processing authentications. |
Risk Engine Fees decimal optional | The total fees charged by Checkout.com for transactions screened by Fraud Detection Pro. |
Intelligent Acceptance Fees decimal optional | The total fees charged by Checkout.com for transactions optimized by Intelligent Acceptance. |
Network Token Fees decimal optional | The total fees charged by Checkout.com for the Network Tokens service. |
Timezone string optional | The report time zone for all timestamps and which your opening and closing balances are calculated against. |
Vault Fees decimal optional | The total fees Checkout.com charged for storing credentials. |
Acceleration Fees decimal optional | The total fees Checkout.com charged for accelerated payments. |