Skip to main content

Interchange qualification report

This report provides a summary of different Bankcard Interchange Rates which the transactions have qualified for in a given period, and associated interchange details for each merchant order number. 

Use cases

  • View interchange qualification and downgrades at a transaction level.
  • Research if the transactions are qualifying at the best possible interchange rates.

Granularity

  • Summary Section: Combination of Presentment Currency Code, Settlement Currency Code, Payment Method Code, Interchange Qualification Code, Interchange Qualification Text, Fee Rate, Unit Fee Amount.
  • Details Section: Merchant Order Number

Fields

The following table shows the summary section field details.

Summary section field details
Field name Description
Record Type Defines the section of the report. For summary section, record type value is Interchange Qualification Summary.
Presentment Currency Code The three-character abbreviation for the currency in which the cardholder transaction occurred. This field is suppressed unless cross-currency is selected.
Settlement Currency Code The three-character abbreviation for the currency in which the merchant is being funded.
Payment Method Code Code that identifies the method of payment (MOP) for the transaction.
Interchange Qualification Code Code that identifies the rate at which J.P. Morgan qualified the transaction.
Interchange Qualification Text Description of the reason the transaction qualified for a specific Interchange Qualification.
Fee Rate The percentage rate fee applied to the face value of this transaction. For this field, a positive amount indicates a debit % rate to the merchant. A negative amount indicates a credit % rate.
Unit Fee Amount Fee per item as assessed by the card associations. For this field, a positive amount indicates a debit unit fee to the merchant. A negative amount indicates a credit unit fee.
Sales Count Count of Merchant Order Number grouped by Presentment Currency Code, Settlement Currency Code, Payment Method Code, Interchange Qualification Code, Interchange Qualification Text, Fee Rate, Unit Fee Amount.
Count Percentage of Sales Count grouped by Payment Method Code & Settlement Currency Code.
Sales Amount Sum of settlement amount grouped by Presentment Currency Code, Settlement Currency Code, Payment Method Code, Interchange Qualification Code, Interchange Qualification Text, Fee Rate, Unit Fee Amount.
Amount Percentage of Sales Amount grouped by Payment Method Code & Settlement Currency Code

The following table shows the details section field details.

Details section field details
Field name Description
Record Type Defines the section of the report. For details section, record type value is Interchange Qualification Details.
Entity Identifier Specifies the unique entity identifier.
Presentment Currency Code The three-character abbreviation for the currency in which the cardholder transaction occurred. This field is suppressed unless cross-currency is selected.
Settlement Currency Code The three-character abbreviation for the currency in which the merchant is being funded.
Payment Method Code Code that identifies the method of payment (MOP) for the transaction.
Merchant Order Number The order number submitted by the merchant with the original sale.
Interchange Qualification Code Code that identifies the rate at which J.P. Morgan qualified the transaction.
Downgrade Reason Code The value representing the reason the transaction qualified for a specific interchange qualification.
Downgrade Reason Text The description of the value representing the reason the transaction qualified for a specific interchange qualification.
Account Number Cardholders account number.
Deposit Date Day the deposit transaction was received in UTC time zone.
Amount Max of settlement amount grouped by rest of the attributes in the detail section.
Acquirer Reference Number The acquirer's reference number assigned to the transaction at the time of the sale/refund.
Card Usage Type Specifies if the transaction is a signature debit transaction, PIN debit transaction, or a credit card transaction.

Sample report configuration

The following request code block shows how to configure an interchange report for entityType = CO/BU/TD.

Json
{
    "entityType": "CO",
    "entityIds": [
        "1234567"
    ],
    "reportSections": [
        {
            "sectionTitle": "Interchange Qualification Summary",
            "sectionReportTypeName": "Submission Details",
            "sectionReportTypeId": "3003",
            "sectionSelectedFields": [
                {
                    "alias": "Record Type",
                    "constantValueText": "Interchange Qualification Summary"
                },
                {
                    "reportAttributeName": "Presentment Currency Code"
                },
                {
                    "reportAttributeName": "Settlement Currency Code"
                },
                {
                    "reportAttributeName": "Payment Method Code"
                },
                {
                    "reportAttributeName": "Interchange Qualification Code"
                },
                {
                    "reportAttributeName": "Interchange Qualification Text"
                },
                {
                    "reportAttributeName": "Fee Rate"
                },
                {
                    "reportAttributeName": "Unit Fee Amount"
                },
                {
                    "alias": "Sales Count",
                    "reportAttributeName": "Merchant Order Number",
                    "aggregateOperationText": "count"
                },
                {
                    "alias": "Count %",
                    "customCalculationText": "% of",
                    "customCalculationOn": "Sales Count",
                    "groupBy": [
                        "Payment Method Code",
                        "Settlement Currency Code"
                    ]
                },
                {
                    "alias": "Sales Amount",
                    "reportAttributeName": "Settlement Amount",
                    "aggregateOperationText": "sum"
                },
                {
                    "alias": "Amount %",
                    "customCalculationText": "% of",
                    "customCalculationOn": "Sales Amount",
                    "groupBy": [
                        "Payment Method Code",
                        "Settlement Currency Code"
                    ]
                }
            ],
            "sectionFilterAttributeList": [
                {
                    "reportAttributeName": "Conveyed Settled Code",
                    "filterAttributeCode": "=\"S\""
                },
                {
                    "reportAttributeName": "Deposit Category Code",
                    "filterAttributeCode": "=\"S\""
                },
                {
                    "reportAttributeName": "Fee Text",
                    "filterAttributeCode": "=\"Interchange\""
                },
                {
                    "reportAttributeName": "Entity Type Code",
                    "filterAttributeCode": "=\"TD\""
                },
                {
                    "reportAttributeName": "Payment Method Code",
                    "filterAttributeCode": "IN(\"MC\",\"VI\",\"DI\",\"MD\",\"SW\",\"IM\",\"DD\",\"VR\",\"MR\",\"AX\",\"JC\")"
                }
            ],
            "sectionSortOrderList": [
                {
                    "reportAttributeName": "Payment Method Code",
                    "sortOrderCode": "desc"
                },
                {
                    "reportAttributeName": "Interchange Qualification Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Presentment Currency Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Settlement Currency Code",
                    "sortOrderCode": "asc"
                }
            ]
        },
        {
            "sectionTitle": "Interchange Qualification Details",
            "sectionReportTypeName": "Submission Details",
            "sectionReportTypeId": "3003",
            "sectionSelectedFields": [
                {
                    "alias": "Record Type",
                    "constantValueText": "Interchange Qualification Details"
                },
                {
                    "reportAttributeName": "Entity Identifier"
                },
                {
                    "reportAttributeName": "Presentment Currency Code"
                },
                {
                    "reportAttributeName": "Settlement Currency Code"
                },
                {
                    "reportAttributeName": "Payment Method Code"
                },
                {
                    "reportAttributeName": "Merchant Order Number"
                },
                {
                    "reportAttributeName": "Interchange Qualification Code"
                },
                {
                    "reportAttributeName": "Downgrade Reason Code"
                },
                {
                    "reportAttributeName": "Downgrade Reason Text"
                },
                {
                    "reportAttributeName": "Account Number"
                },
                {
                    "reportAttributeName": "Deposit Date"
                },
                {
                    "alias": "Amount",
                    "reportAttributeName": "Settlement Amount",
                    "aggregateOperationText": "max"
                },
                {
                    "reportAttributeName": "Acquirer Reference Number"
                },
                {
                    "reportAttributeName": "Card Usage Type"
                }
            ],
            "sectionFilterAttributeList": [
                {
                    "reportAttributeName": "Conveyed Settled Code",
                    "filterAttributeCode": "=\"S\""
                },
                {
                    "reportAttributeName": "Deposit Category Code",
                    "filterAttributeCode": "=\"S\""
                },
                {
                    "reportAttributeName": "Fee Text",
                    "filterAttributeCode": "=\"Interchange\""
                },
                {
                    "reportAttributeName": "Entity Type Code",
                    "filterAttributeCode": "=\"TD\""
                },
                {
                    "reportAttributeName": "Payment Method Code",
                    "filterAttributeCode": "IN(\"MC\",\"VI\",\"DI\",\"MD\",\"SW\",\"IM\",\"DD\",\"VR\",\"MR\",\"AX\",\"JC\")"
                }
            ],
            "sectionSortOrderList": [
                {
                    "reportAttributeName": "Entity Identifier",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Payment Method Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Interchange Qualification Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Presentment Currency Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Settlement Currency Code",
                    "sortOrderCode": "asc"
                }
            ]
        }
    ],
    "fileDelimiter": ",",
    "reportConfigurationName": "Interchange Qualification Report",
    "reportFileName": "Interchange Report.<Processing Entity ID>.<frequency>.<From Date YYYY-MM-DD>.<To Date YYYY-MM-DD>",
    "reportHeader": "EntityId=<Processing Entity ID>,ReportTypeName=<Report Type>,Frequency=<frequency>,FromDate=<From Date YYYY-MM-DD>,ToDate=<To Date YYYY-MM-DD>,GenerationDate=<Generation Date YYYY-MM-DD>,GenerationTime=<Generation Time HH:MM:SS>",
    "fileHeader": "BEGIN,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "fileTrailer": "END,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "csvColumnNameDisplayIndicator": true,
    "reportConfigStatus": "active",
    "reportName": "Interchange Qualification Report",
    "frequencyConfig": {
        "scheduleFrequency": "adhoc",
        "reportingPeriodStartTimestamp": "2024-05-06 11:30:00",
        "reportingPeriodEndTimestamp": "2024-05-07 02:00:00"
    }
}

The following request code block shows how to configure an interchange report for entityType = PE.

Json
{
    "entityType": "PE",
    "entityIds": [
        "1234567"
    ],
    "reportSections": [
        {
            "sectionTitle": "Interchange Qualification Summary",
            "sectionReportTypeName": "Submission Details",
            "sectionReportTypeId": "3003",
            "sectionSelectedFields": [
                {
                    "alias": "Record Type",
                    "constantValueText": "Interchange Qualification Summary"
                },
                {
                    "reportAttributeName": "Presentment Currency Code"
                },
                {
                    "reportAttributeName": "Settlement Currency Code"
                },
                {
                    "reportAttributeName": "Payment Method Code"
                },
                {
                    "reportAttributeName": "Interchange Qualification Code"
                },
                {
                    "reportAttributeName": "Interchange Qualification Text"
                },
                {
                    "reportAttributeName": "Fee Rate"
                },
                {
                    "reportAttributeName": "Unit Fee Amount"
                },
                {
                    "alias": "Sales Count",
                    "reportAttributeName": "Merchant Order Number",
                    "aggregateOperationText": "count"
                },
                {
                    "alias": "Count %",
                    "customCalculationText": "% of",
                    "customCalculationOn": "Sales Count",
                    "groupBy": [
                        "Payment Method Code",
                        "Settlement Currency Code"
                    ]
                },
                {
                    "alias": "Sales Amount",
                    "reportAttributeName": "Settlement Amount",
                    "aggregateOperationText": "sum"
                },
                {
                    "alias": "Amount %",
                    "customCalculationText": "% of",
                    "customCalculationOn": "Sales Amount",
                    "groupBy": [
                        "Payment Method Code",
                        "Settlement Currency Code"
                    ]
                }
            ],
            "sectionFilterAttributeList": [
                {
                    "reportAttributeName": "Conveyed Settled Code",
                    "filterAttributeCode": "=\"S\""
                },
                {
                    "reportAttributeName": "Deposit Category Code",
                    "filterAttributeCode": "=\"S\""
                },
                {
                    "reportAttributeName": "Fee Text",
                    "filterAttributeCode": "=\"Interchange\""
                },
                {
                    "reportAttributeName": "Payment Method Code",
                    "filterAttributeCode": "IN(\"MC\",\"VI\",\"DI\",\"MD\",\"SW\",\"IM\",\"DD\",\"VR\",\"MR\",\"AX\",\"JC\")"
                }
            ],
            "sectionSortOrderList": [
                {
                    "reportAttributeName": "Payment Method Code",
                    "sortOrderCode": "desc"
                },
                {
                    "reportAttributeName": "Interchange Qualification Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Presentment Currency Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Settlement Currency Code",
                    "sortOrderCode": "asc"
                }
            ]
        },
        {
            "sectionTitle": "Interchange Qualification Details",
            "sectionReportTypeName": "Submission Details",
            "sectionReportTypeId": "3003",
            "sectionSelectedFields": [
                {
                    "alias": "Record Type",
                    "constantValueText": "Interchange Qualification Details"
                },
                {
                    "reportAttributeName": "Transaction Processing Entity Identifier"
                },
                {
                    "reportAttributeName": "Presentment Currency Code"
                },
                {
                    "reportAttributeName": "Settlement Currency Code"
                },
                {
                    "reportAttributeName": "Payment Method Code"
                },
                {
                    "reportAttributeName": "Merchant Order Number"
                },
                {
                    "reportAttributeName": "Interchange Qualification Code"
                },
                {
                    "reportAttributeName": "Downgrade Reason Code"
                },
                {
                    "reportAttributeName": "Downgrade Reason Text"
                },
                {
                    "reportAttributeName": "Account Number"
                },
                {
                    "reportAttributeName": "Deposit Date"
                },
                {
                    "alias": "Amount",
                    "reportAttributeName": "Settlement Amount",
                    "aggregateOperationText": "max"
                },
                {
                    "reportAttributeName": "Acquirer Reference Number"
                },
                {
                    "reportAttributeName": "Card Usage Type"
                }
            ],
            "sectionFilterAttributeList": [
                {
                    "reportAttributeName": "Conveyed Settled Code",
                    "filterAttributeCode": "=\"S\""
                },
                {
                    "reportAttributeName": "Deposit Category Code",
                    "filterAttributeCode": "=\"S\""
                },
                {
                    "reportAttributeName": "Fee Text",
                    "filterAttributeCode": "=\"Interchange\""
                },
                {
                    "reportAttributeName": "Payment Method Code",
                    "filterAttributeCode": "IN(\"MC\",\"VI\",\"DI\",\"MD\",\"SW\",\"IM\",\"DD\",\"VR\",\"MR\",\"AX\",\"JC\")"
                }
            ],
            "sectionSortOrderList": [
                {
                    "reportAttributeName": "Transaction Processing Entity Identifier",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Payment Method Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Interchange Qualification Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Presentment Currency Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Settlement Currency Code",
                    "sortOrderCode": "asc"
                }
            ]
        }
    ],
    "fileDelimiter": ",",
    "reportConfigurationName": "Interchange Qualification Report",
    "reportFileName": "Interchange Report.<Processing Entity ID>.<frequency>.<From Date YYYY-MM-DD>.<To Date YYYY-MM-DD>",
    "reportHeader": "EntityId=<Processing Entity ID>,ReportTypeName=<Report Type>,Frequency=<frequency>,FromDate=<From Date YYYY-MM-DD>,ToDate=<To Date YYYY-MM-DD>,GenerationDate=<Generation Date YYYY-MM-DD>,GenerationTime=<Generation Time HH:MM:SS>",
    "fileHeader": "BEGIN,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "fileTrailer": "END,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "csvColumnNameDisplayIndicator": true,
    "reportConfigStatus": "active",
    "reportName": "Interchange Qualification Report",
    "frequencyConfig": {
        "scheduleFrequency": "adhoc",
        "reportingPeriodStartTimestamp": "2024-05-06 11:30:00",
        "reportingPeriodEndTimestamp": "2024-05-07 02:00:00"
    }
}

Download sample report

Download the sample Interchange qualification report.

Preset reports