Optimization Protection

Charge Summary report

This report includes:

Charge summary section that provides assessed fees and associated tax for the selected reporting period.
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: Combination of 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. Ex: Interchange and Assessment Fees, Processing Fees
Charge Subcategory Text	The different sub-categories that group similar fees. Ex: 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 this report data record.
Fee Text	The fee type for this fee data record. Ex: 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 this data record is assessed.
Unite 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 this data record.
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.
Total Charge	The total fee assessed for this 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 this data record.
Entity Identifier (O)	The associated CO, BU, TD, or PE identification number.
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
Entity Name (O)	The name associated with the Commerce platform assigned entity identifier.
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.
Fund Transfer Instruction Number (O)	The funds transfer instruction number associated with the reported activity.
Secure Bank Account Number (O)	The Commerce platform assigned secure bank account number.
Action Type Code (O)	The code that identifies the type of transaction performed in relation to the associated charge.
Interchange Qualification Text (O)	The description of the reason a transaction qualified for a specific interchange qualification.
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.

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`.
Transaction Division External Identifier	The identifier of the external transaction division.
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 address.
Recipient Legal Entity	The merchant legal name.
Entity Identifier (O)	The associated CO, BU, TD, or PE identification number.
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
Entity Name (O)	The name associated with the Commerce platform assigned entity identifier.
Transaction Division External Identifier (O)	The identifier of the external transaction division.
Transaction Processing Entity Identifier (O)	The identifier of the transaction processing entity.
Platform Identifier (O)	The identifier of the platform used to facilitate the transaction request.
Platform Name (O)	The name of the platform used to facilitate the transaction request.
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.

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.

Json

{
    "entityType": "CO",
    "entityIds": [
        "1234567"
    ],
    "reportSections": [
        {
            "sectionTitle": "Charge Summary",
            "sectionReportTypeName": "Submission Details",
            "sectionReportTypeId": "3003",
            "sectionSelectedFields": [
                {
                    "constantValueText": "Charge Summary",
                    "alias": "Record Type"
                },
                {
                    "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"
                },
                {
                    "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\")"
                }
            ]
        },
        {
            "sectionTitle": "Tax Information",
            "sectionReportTypeName": "Submission Details",
            "sectionReportTypeId": "3003",
            "distinctSelectIndicator": true,
            "sectionSelectedFields": [
                {
                    "constantValueText": "Tax Information",
                    "alias": "Record Type"
                },
                {
                    "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": "Transaction Division External Identifier",
                "filterAttributeCode": "IS NOT NULL"
              }

			]
        }
    ],
    "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": "2026-03-24 02:00:00",
    	"reportingPeriodEndTimestamp": "2026-03-25 01:59:59"
    }
}

PI

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