Skip to main content
Optimization Protection

Charge Summary report

This report includes:

  • A Charge summary section that provides assessed fees and associated tax for the selected reporting period.
  • A Tax information section that provides region-specific attributes required for tax compliance.
Charge summary report details
Report type Supported entity types Supported file formats
Submission details
  • PE - Processing Entity
  • TD - Transaction Division 
  • BU - Business Unit
  • FTI - Fund Transfer Instruction
  • CO - Company
  • RG - Reporting Group
  • PI - Platform Identifier
  • Comma Separated Values (CSV)
  • Gzip or GNU Zip (GZ)
  • Portable Document Format (PDF)
  • MS Excel Workbook (.xlsx)

Use cases

Obtain a summary of charges across various categories, such as Interchange and Assessment, Processing Fees, Chargeback Adjustments, etc., and further refine it to detailed fee-text level.

Granularity

  • Charge summary section: A combination of the following fields - Presentment Currency Code, Settlement Currency Code, Payment Method Code, Charge Category Text, Charge Subcategory Text, Action Type Code Text, Merchant Service Fee Schedule Identifier, Fee Text, Interchange Qualification Code, Unit Fee Amount, and Fee Rate
  • Tax information section: Transaction Division External Identifier

Fields

Charge summary

The following table shows the charge summary section field details. Fields labeled (O) are optional and can be added to the preset report as needed.

Charge summary section field details

Field name

Definition

Record Type The section of the report. For the summary section, record type value is Charge Summary.

Presentment Currency Code

The three-character abbreviation for the currency in which the cardholder transaction occurred.

Settlement Currency Code

The three-character abbreviation for the currency in which the merchant is being funded.

Payment Method Code

The code that identifies the (MOP) method of payment for the transaction.

Charge Category Text

The different categories that group similar fees.

For example: Interchange and Assessment Fees, Processing Fees

Charge Subcategory Text

The different sub-categories that group similar fees.

For example: Assessment Fees, Interchange Fees

Action Type Code Text

The action type code description. Valid values are:

  • AUTH
  • SALE
Merchant Service Fee Schedule Identifier The J.P. Morgan assigned fee schedule ID that is associated with the report data record.
Fee Text

The fee type for the fee data record.

For example: MC Connectivity Fee, MC Digital Enablement, MC Acquiring License Fee

Interchange Qualification Code

The code that identifies the rate at which J.P. Morgan qualified the transaction.

Unit Quantity

The number of items for which the fee in the data record is assessed.

Unit Fee Amount

The fee per item identified in the merchant’s fee schedule for each line item. The unit fee is applied to the unit quantity.

Transaction Amount

The monetary value of the transactions for the data record.

Fee Rate

The percentage rate fee applied to the face value of the transaction. For this field, a positive amount indicates a debit % rate to the merchant. A negative amount indicates a credit % rate.

Total Charge

The total fee assessed for the data record.

Sales Tax

The state sales tax collected on fees billed to merchants.

Federal Tax

The federal tax charged on the line item.

Provincial Tax

The provincial tax charged on the line item.

Total Charge after Tax

The total fee assessed plus tax charged for the data record.

Action Type Code (O)

The code that identifies the type of transaction performed in relation to the associated charge.

Activity Date (O)

Activity date of the transaction in UTC time zone.

Business Unit Identifier (O)

The identifier of the business unit associated with the record.

Business Unit Name (O)

The name associated with the Commerce platform assigned business unit number.

Charge Category Code (O)

The codes identifying the different categories that group similar fees.

Charge Subcategory Code (O)

The codes identifying the different sub-categories that group similar fees.

Company External Identifier (O)

The external company identifier.

Company Name (O)

The name associated with the Merchant Services assigned CO number.

Entity Identifier (O)

The associated CO, BU, TD, or PE identification number.

Entity Name (O)

The name associated with the Commerce platform assigned entity identifier.

Entity Type Code (O)

The level at which the reported event occurred. Valid values are:

  • BU - Business Unit
  • CO - Company
  • TD - Transaction Division
  • PE - Processing Entity

Fund Transfer Instruction Number (O)

The funds transfer instruction number associated with the reported activity.

Funds Transfer Method Code (O)

The fund transfers method code.

Interchange Qualification Text (O)

The description of the reason a transaction qualified for a specific interchange qualification.

Merchant Bank Account Number (O)

The merchant bank account number.

Payment Method Code Description Text (O)

The method used to pay for the exchange of money, goods or services between a merchant and their consumer. Examples: Visa, MasterCard, PayPal, Bill Me Later etc. Also known with the Firm as method of payment or MOP.

Platform Identifier (O)

Identifies the platform used to facilitate the transaction request.

Platform Name (O)

The name of the platform used to facilitate the transaction request.

Receiving Depository Financial Institution Number (O)

Receiving Depository Financial Institution number. For transactions other than ECP or EUDD.

Secure Bank Account Number (O)

The Commerce platform assigned secure bank account number.

Sub Merchant Identifier (O)

J.P. Morgan assigned identifier that uniquely identifies a Sub Merchant/sponsored merchant and its location under a Payment Facilitator (PayFac).

Sub Merchant Reference Identifier (O)

A merchant-assigned reference identifier for the sub-merchant associated with a Payment Facilitator (PayFac).

Transaction Division External Identifier (O)

The identifier for the external transaction division.

Transaction Processing Entity Identifier (O)

The identifier for the transaction processing entity.

Tax

The following table shows the tax information section field details. Fields labeled (O) are optional and can be added to the preset report as needed.

Tax information section field details

Field name

Definition

Record Type The section of the report. For the tax information section, record type value is Tax Information.

Acquirer Codice Fiscale

The Italian tax code assigned by the Italian tax office to the merchant acquiring entity.

Acquirer Legal Entity

The J.P. Morgan legal entity contracting with the merchant.

CPSI GST Registration Number

The Canadian Goods and Services Tax number assigned to Chase Paymentech Solutions Inc.

CPSI QST Registration Number

The Quebec Sales Tax number assigned to Chase Paymentech Solutions Inc.

Merchant Codice Fiscale

The Italian tax code assigned by the Italian tax office to the merchant.

Recipient Address

The merchant's address.

Recipient Legal Entity

The merchant's legal name.

Business Unit Identifier (O)

The identifier of the business unit associated with the record.

Business Unit Name (O)

The name associated with the Commerce platform assigned business unit number.

Company External Identifier (O)

The external company identifier.

Company Name (O)

The name associated with the Merchant Services assigned CO number.

Entity Name (O)

The name associated with the Commerce platform assigned entity identifier.

Platform Identifier (O)

Identifies the platform used to facilitate the transaction request.

Platform Name (O)

The name of the platform used to facilitate the transaction request.

Transaction Division External Identifier (O)

The identifier for the external transaction division.

Transaction Processing Entity Identifier (O)

The identifier for the transaction processing entity.

Sample report configurations

The following samples help you get an idea of how to configure charge summary reports.

CO/BU/TD/PE

The following request code block shows how to configure a charge summary report for entityType = CO/BU/TD/PE.

{
  "entityType": "CO",
  "entityIds": [
    "1234567"
  ],
  "preBuiltConfigurationId": "preset_Unified_Charge_Summary_Report",
  "reportSections": [
    {
      "sectionReportTypeId": "3003",
      "sectionReportTypeName": "Submission Details",
      "sectionSelectedFields": [
        {
          "alias": "Record Type",
          "constantValueText": "Charge Summary"
        },
        {
          "reportAttributeName": "Presentment Currency Code"
        },
        {
          "reportAttributeName": "Settlement Currency Code"
        },
        {
          "reportAttributeName": "Payment Method Code"
        },
        {
          "reportAttributeName": "Charge Category Text"
        },
        {
          "reportAttributeName": "Charge Subcategory Text"
        },
        {
          "reportAttributeName": "Action Type Code Text"
        },
        {
          "reportAttributeName": "Merchant Service Fee Schedule Identifier"
        },
        {
          "reportAttributeName": "Fee Text"
        },
        {
          "reportAttributeName": "Interchange Qualification Code"
        },
        {
          "alias": "Unit Quantity",
          "reportAttributeName": "Unit Quantity Number",
          "aggregateOperationText": "sum"
        },
        {
          "reportAttributeName": "Unit Fee Amount"
        },
        {
          "alias": "Transaction Amount",
          "reportAttributeName": "Settlement Amount",
          "aggregateOperationText": "sum"
        },
        {
          "reportAttributeName": "Fee Rate"
        },
        {
          "alias": "Total Charge",
          "reportAttributeName": "Settled Total Fee Amount",
          "aggregateOperationText": "sum"
        },
        {
          "alias": "Sales Tax",
          "reportAttributeName": "Sales Tax",
          "aggregateOperationText": "sum"
        },
        {
          "alias": "Federal Tax",
          "reportAttributeName": "Federal Tax",
          "aggregateOperationText": "sum"
        },
        {
          "alias": "Provincial Tax",
          "reportAttributeName": "Provincial Tax",
          "aggregateOperationText": "sum"
        },
        {
          "alias": "Total Charge after Tax",
          "reportAttributeName": "Total Charge after Tax",
          "aggregateOperationText": "sum"
        }
      ],
      "sectionFilterAttributeList": [
        {
          "reportAttributeName": "Charge Subcategory Text",
          "filterAttributeCode": "IN (\"Authorization Fees\",\"Interchange & Assessment Fees\",\"PDE Fees\",\"Deposit Fees\",\"Equipment Fees\",\"Monthly Fees\",\"Paymentech Non-Transaction Fees\",\"Funds Transfer Fees\",\"Other Fees\",\"Paymentech Fees\",\"Project Expenses\",\"Promotion Fees\", \"Interchange Fees\", \"Assessment Fees\",\"Monthly Non-Transaction Fees\")"
        },
        {
          "reportAttributeName": "Fee Text",
          "filterAttributeCode": "NOT IN(\"Provincial Tax\",\"Federal Tax\",\"Sales Tax\")"
        }
      ],
      "sectionSortOrderList": [
        {
          "reportAttributeName": "Settlement Currency Code",
          "sortOrderCode": "asc"
        },
        {
          "reportAttributeName": "Payment Method Code",
          "sortOrderCode": "asc"
        },
        {
          "reportAttributeName": "Charge Category Text",
          "sortOrderCode": "desc"
        },
        {
          "reportAttributeName": "Charge Subcategory Text",
          "sortOrderCode": "asc"
        }
      ]
    },
    {
      "sectionReportTypeId": "3003",
      "sectionReportTypeName": "Submission Details",
      "distinctSelectIndicator": true,
      "sectionSelectedFields": [
        {
          "alias": "Record Type",
          "constantValueText": "Tax Information"
        },
        {
          "reportAttributeName": "Entity Identifier"
        },
        {
          "reportAttributeName": "Entity Type Code"
        },
        {
          "reportAttributeName": "Acquirer Codice Fiscale"
        },
        {
          "reportAttributeName": "Acquirer Legal Entity"
        },
        {
          "reportAttributeName": "CPSI GST Registration Number"
        },
        {
          "reportAttributeName": "CPSI QST Registration Number"
        },
        {
          "reportAttributeName": "Merchant Codice Fiscale"
        },
        {
          "reportAttributeName": "Recipient Address"
        },
        {
          "reportAttributeName": "Recipient Legal Entity"
        }
      ],
      "sectionFilterAttributeList": [
        {
          "reportAttributeName": "Charge Subcategory Text",
          "filterAttributeCode": "IN (\"Authorization Fees\",\"Interchange & Assessment Fees\",\"PDE Fees\",\"Deposit Fees\",\"Equipment Fees\",\"Monthly Fees\",\"Paymentech Non-Transaction Fees\",\"Funds Transfer Fees\",\"Other Fees\",\"Paymentech Fees\",\"Project Expenses\",\"Promotion Fees\", \"Interchange Fees\", \"Assessment Fees\",\"Monthly Non-Transaction Fees\")"
        },
        {
          "reportAttributeName": "Entity Identifier",
          "filterAttributeCode": "IS NOT NULL"
        }
      ]
    }
  ],
  "frequencyConfig": {
    "scheduleFrequency": "Adhoc",
    "reportingPeriodStartTimestamp": "2026-04-08 00:00:00",
    "reportingPeriodEndTimestamp": "2026-04-09 23:59:59"
  },
  "reportConfigurationName": "Charge Summary",
  "reportName": "Charge Summary",
  "reportConfigType": "PreBuilt",
  "fileDelimiter": ",",
  "csvColumnNameDisplayIndicator": true,
  "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>",
  "languageCode": "en-us"
}

PI

The following request code block shows how to configure a charge summary report for entityType = PI.

{
  "entityType": "PI",
  "entityIds": [
    "6019581085"
  ],
  "reportSections": [
    {
      "sectionTitle": "Charge Summary",
      "sectionReportTypeName": "Submission Details",
      "sectionReportTypeId": "3003",
      "sectionSelectedFields": [
        {
          "constantValueText": "Charge Summary",
          "alias": "Record Type"
        },
        {
          "reportAttributeName": "Presentment Currency Code"
        },
        {
          "reportAttributeName": "Platform Identifier"
        },
        {
        "reportAttributeName": "Platform Name"
        },
        {
          "reportAttributeName": "Settlement Currency Code"
        },
        {
          "reportAttributeName": "Payment Method Code"
        },
        {
          "reportAttributeName": "Charge Category Text"
        },
        {
          "reportAttributeName": "Charge Subcategory Text"
        },
        {
          "reportAttributeName": "Action Type Code Text"
        },
        {
          "reportAttributeName": "Merchant Service Fee Schedule Identifier"
        },
        {
          "reportAttributeName": "Fee Text"
        },
        {
          "reportAttributeName": "Interchange Qualification Code"
        },
        {
          "reportAttributeName": "Unit Quantity Number",
          "aggregateOperationText": "sum",
          "alias": "Unit Quantity"
        },
        {
          "reportAttributeName": "Unit Fee Amount"
        },
        {
          "reportAttributeName": "Settlement Amount",
          "aggregateOperationText": "sum",
          "alias": "Transaction Amount"
        },
        {
          "reportAttributeName": "Fee Rate"
        },
        {
          "reportAttributeName": "Settled Total Fee Amount",
          "aggregateOperationText": "sum",
          "alias": "Total Charge"
        },
        {
          "reportAttributeName": "Sales Tax",
          "aggregateOperationText": "sum",
          "alias": "Sales Tax"
        },
        {
          "reportAttributeName": "Federal Tax",
          "aggregateOperationText": "sum",
          "alias": "Federal Tax"
        },
        {
          "reportAttributeName": "Provincial Tax",
          "aggregateOperationText": "sum",
          "alias": "Provincial Tax"
        },
        {
          "reportAttributeName": "Total Charge after Tax",
          "aggregateOperationText": "sum",
          "alias": "Total Charge after Tax"
        }
      ],
      "sectionSortOrderList": [
        {
          "reportAttributeName": "Settlement Currency Code",
          "sortOrderCode": "asc"
        },
        {
          "reportAttributeName": "Payment Method Code",
          "sortOrderCode": "asc"
        },
        {
          "reportAttributeName": "Charge Category Text",
          "sortOrderCode": "desc"
        },
        {
          "reportAttributeName": "Charge Subcategory Text",
          "sortOrderCode": "asc"
        }
      ],
      "sectionFilterAttributeList": [
        {
          "reportAttributeName": "Charge Subcategory Text",
          "filterAttributeCode": "IN (\"Authorization Fees\",\"Interchange & Assessment Fees\",\"PDE Fees\",\"Deposit Fees\",\"Equipment Fees\",\"Monthly Fees\",\"Paymentech Non-Transaction Fees\",\"Funds Transfer Fees\",\"Other Fees\",\"Paymentech Fees\",\"Project Expenses\",\"Promotion Fees\", \"Interchange Fees\", \"Assessment Fees\",\"Monthly Non-Transaction Fees\")"
        },
        {
          "reportAttributeName": "Fee Text",
          "filterAttributeCode": "NOT IN(\"Provincial Tax\",\"Federal Tax\",\"Sales Tax\")"
        }
      ]
    }
  ],
  "fileDelimiter": ",",
  "reportConfigurationName": "Charge Summary Report",
  "reportFileName": "Charge Summary 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,
  "totalRowCountDisplayIndicator": false,
  "reportName": "Charge Summary Report",
  "sectionRowCountDisplayIndicator": false,
  "frequencyConfig": {
    "scheduleFrequency": "adhoc",
    "reportingPeriodStartTimestamp": "2024-08-27 11:30:00",
    "reportingPeriodEndTimestamp": "2024-08-28 02:00:00"
  }
}
Is this page helpful?