Settlement Summary Report

Last updated: February 5, 2025

The Settlement Summary Report lists aggregated amounts for all transactional messages received during a specified a period of time. For each transaction, it includes:

The transaction message and transaction type – For example, presentment, representment, or chargeback
The reconciliation currency, amount, Interchange fee, and date

This report is only relevant if you're a processing-only client.

The report is provided as a CSV file. By default, the file name uses the following format:

issuing_settlement_summary_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv

The report data is refreshed twice daily at around 23:50:00 UTC and 10:50:00 UTC. It's also available through Secure File Transfer Protocol (SFTP) daily at 01:00:00 UTC.

See instructions on how to download the report on demand or on a schedule:

Download a sample report (CSV file).

Information

If using Safari, hold down the Option key when selecting the link to download the file.

Information

Decimal fields with monetary amounts are expressed in the major currency unit, with up to eight decimal places. For example, an amount of 500 USD is expressed as 500.00. For more information, see Format the payment amount.

The report includes all of the following fields in this order:

Field name Description

Field name	Description
File ID string	The unique identifier for the card scheme's bulk file that the transaction messages were extracted from. Example – `0123456789012345678801234`
Entity ID string	The unique identifier for your Checkout.com entity. Example – `ent_abcdef1ghijklmn23opq45r6st`
Entity Name string	The name of your Checkout.com entity.
Client ID string	Your unique identifier from Checkout.com. Example – `cli_abcdef1ghijklmn23opq45r6st`
Client Name string	Your Checkout.com client name.
Transfer Agent ID string	Your Interbank Card Association (ICA) number from Mastercard for settlement. Example – `12345`
Message Type string	The type of transaction message. This can be one of: `chargeback` – When you request the merchant to return funds `fee collection` – When the card scheme collects a fee `pre-arbitration/arbitration` – When you and the merchant worked to resolve a disputed payment before or with arbitration from the card scheme `presentment` – When the merchant first captures the payment request `representment` – When the merchant declines a chargeback and sends a second attempt to recover the amount
Transaction Type string	The type of transaction. This can be one of: `fee collection` – A fee paid between you, the acquirer, and the card scheme – For example, for requesting evidence from the merchant `purchase` – A purchase of goods or services `refund` – A credit to the cardholder's account as a full or partial refund for a purchase `withdrawal` – A cash withdrawal from an ATM `unique transaction` – A quasi-cash payment using, for example, gaming tokens, cryptocurrency, travelers' cheques
Reconciliation Currency string	The currency you settle the transaction with the card scheme in. Format – ISO 4217 code
Reconciliation Amount decimal	The full transaction amount you're settling with the card scheme in the major currency unit. Format – Fixed-point notation with up to eight decimal places Example – 500 USD is represented as `500.00` More information – Format the payment amount
Reconciliation Interchange Amount decimal	The total Interchange fee for the transaction in the major currency unit. Format – Fixed-point notation with up to eight decimal places Example – 500 USD is represented as `500.00` More information – Format the payment amount
Total Transaction Count integer	The total number of transactions in the date range for this report.
Settled On datetime	The date when you expect to settle the card scheme for the transaction in UTC. Format – ISO 8601 Example – `2020-01-31T10:20:30.456`

File ID

string

The unique identifier for the card scheme's bulk file that the transaction messages were extracted from.
Example – 0123456789012345678801234

Entity ID

string

The unique identifier for your Checkout.com entity.
Example – ent_abcdef1ghijklmn23opq45r6st

Entity Name

string

The name of your Checkout.com entity.

Client ID

string

Your unique identifier from Checkout.com.
Example – cli_abcdef1ghijklmn23opq45r6st

Client Name

string

Your Checkout.com client name.

Transfer Agent ID

string

Your Interbank Card Association (ICA) number from Mastercard for settlement.
Example – 12345

Message Type

string

The type of transaction message. This can be one of:

chargeback – When you request the merchant to return funds
fee collection – When the card scheme collects a fee
pre-arbitration/arbitration – When you and the merchant worked to resolve a disputed payment before or with arbitration from the card scheme
presentment – When the merchant first captures the payment request
representment – When the merchant declines a chargeback and sends a second attempt to recover the amount

Transaction Type

string

The type of transaction. This can be one of:

fee collection – A fee paid between you, the acquirer, and the card scheme – For example, for requesting evidence from the merchant
purchase – A purchase of goods or services
refund – A credit to the cardholder's account as a full or partial refund for a purchase
withdrawal – A cash withdrawal from an ATM
unique transaction – A quasi-cash payment using, for example, gaming tokens, cryptocurrency, travelers' cheques

Reconciliation Currency

string

The currency you settle the transaction with the card scheme in.
Format – ISO 4217 code

Reconciliation Amount

decimal

The full transaction amount you're settling with the card scheme in the major currency unit.
Format – Fixed-point notation with up to eight decimal places
Example – 500 USD is represented as 500.00
More information – Format the payment amount

Reconciliation Interchange Amount

decimal

The total Interchange fee for the transaction in the major currency unit.
Format – Fixed-point notation with up to eight decimal places
Example – 500 USD is represented as 500.00
More information – Format the payment amount

Total Transaction Count

integer

The total number of transactions in the date range for this report.

Settled On

datetime

The date when you expect to settle the card scheme for the transaction in UTC.
Format – ISO 8601
Example – 2020-01-31T10:20:30.456

Settlement Summary Report

Report format

Report availability

Sample report

Information

Report fields

Information