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.
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
The following table shows the charge summary section field details.
Field name |
Definition |
|---|---|
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 |
Code that identifies the (MOP) method of payment for the transaction. |
Charge Category Text |
Codes identifying the different categories that group similar fees. Ex: Interchange & Assessment Fees, Processing Fees |
Charge Subcategory Text |
Codes identifying the different sub-categories that group similar fees. Ex: Assessment Fees, Interchange Fees |
Action Type Code Text |
Action type code description. Valid values are:
|
| Merchant Service Fee Schedule Identifier | J.P. Morgan assigned fee schedule ID that is associated with this report data record. |
| Fee Text | Fee type for this fee data record. Ex: MC Connectivity Fee, MC Digital Enablement, MC Acquiring License Fee |
Interchange Qualification Code |
A code that identifies the rate at which J.P. Morgan qualified the transaction. |
Unit Quantity |
Number of items for which the fee in this data record is assessed. |
Unite Fee Amount |
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 |
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 |
State sales tax collected on fees billed to merchants. |
Federal Tax |
Federal tax charged on the line item. |
Provincial Tax |
Provincial tax charged on the line item. |
Total Charge After Tax |
The total fee assessed + tax charged for this data record. |
The following table shows the tax information section field details.
Field name |
Definition |
|---|---|
Transaction Division External Identifier |
Transaction division external identifier. |
Acquirer codices Fiscale |
The Italian tax code assign by the Italian tax office to the merchant acquiring entity. |
Acquirer Legal Entity |
Indicates the J.P. Morgan legal entity contracting with the merchant. |
CPSI GST Registration Number |
Canadian Goods and Services Tax number assigned to Chase Paymentech Solutions Inc. |
CPSI QST Registration Number |
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 |
Merchant address. |
Recipient Legal Entity |
Merchant legal name. |
Sample report configuration
The following request code block shows how to configure a charge summary report for entityType = CO/BU/TD.
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"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\")"
}
]
},
{
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"distinctSelectIndicator": true,
"sectionSelectedFields": [
{
"constantValueText": "Tax Information",
"alias": "Record Type"
},
{
"reportAttributeName": "Transaction Division External Identifier"
},
{
"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\")"
}
]
}
],
"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": "2023-08-27 11:30:00",
"reportingPeriodEndTimestamp": "2023-08-28 02:00:00"
}
}The following request code block shows how to configure a charge summary report for entityType = PE.
{
"entityType": "PE",
"entityIds": [
"1234567"
],
"reportSections": [
{
"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\")"
}
]
}
],
"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": "2023-08-27 11:30:00",
"reportingPeriodEndTimestamp": "2023-08-28 02:00:00"
}
}