# JPMC-PDP Documentation from https://developer.payments.jpmorgan.com # Transaction fee details report This report provides the transactions, details of associated transactional and non-transactional fees, and the net financial activity for the transactions processed by the entity during the specified reporting period. **Transaction fee details report information** | 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 Seperated Values (CSV) - Gzip or GNU Zip (GZ) - Portable Document Format (PDF) - MS Excel Workbook (.xlsx) | ## Use cases View the transactions, associated fees, and final net financial activity for a given reporting period. ## Granularity Merchant Order Number, Fund Transfer Instruction Number. ## Fields The following table shows the field details. **Field details** | Field name | Definition | | --- | --- | | Activity Date | The date when the transactions and events took place. | | Entity Type Code | The level at which reported event occurred. Valid values are: - BU - Business Unit - CO - Company - TD - Transaction Division - PE - Processing Entity | | Entity Identifier | The associated CO, BU, TD, or PE identification number. | | Merchant Order Number | The order number submitted by the merchant with the original sale. | | Payment Method Code | The code that identifies the method of payment (MOP) for the transaction. | | 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. | | Foreign Exchange Rate | The foreign exchange rate at which J.P. Morgan qualified the transaction for cross currency transactions. | | Fund Transfer Instruction Number | The J.P. Morgan assigned fund transfer instruction number. | | Transaction Amount in Presentment Currency | The monetary value of the transaction in presentment currency. | | Transaction Amount in Settlement Currency | The monetary Value of the transaction in settlement currency. | | Net Settled Sales Amount | The transaction amount qualified for funding. Only Settled Sales and Settled refunds are considered as Conveyed transaction amount is not funded. | | Interchange & Assessment Fees | The total interchange and assessment amount charged for the transaction. | | Back Up Withholding Adjustments | The total back up withholding adjustments associated with the transaction. | | Chargeback Adjustments | The back up withholding adjustments associated with the transaction. | | Discount Fees | The discount fees associated with the transaction. | | ECP Return Adjustments | The Electronic Check Presentment (ECP) return adjustments associated with the transaction. | | Other Adjustments | Other adjustments associated with the transaction. | | Processing Fees | The processing fees associated with the transaction. Merchant order number will be blank for non-transactional Fees such as ACH Transfer Fees. | | Reserve Adjustments | The reserve adjustments associated with the transaction. | | Others | Other fees charged within the reporting period. | | Net Financial Activity | The total net financial activity for the transaction (Sale/Refund- all charges & adjustments). Merchant order number will be blank for non-transactional Fees such as ACH transfer Fees. | | Platform Identifier | The identifier of the platform used to facilitate the transaction request. | | Platform Name | The name of the platform used to facilitate the transaction request. | | Transaction Division External Identifier | The identifier of the external transaction division. | | Transaction Processing Entity Identifier | The identifier of the transaction processing entity. | | Entity Name | The name associated with the Commerce platform assigned entity identifier. | > Keep in mind that the firm's funding engine aggregates fee amounts for all transactions within a submission ID and submission group, and rounds the total amount to two decimal places. In this report: > > > - The total fee at the submission level is averaged and distributed across all merchant order numbers within the submission. > > - Consequently, fee amounts may appear identical for merchant orders with both higher and lower transaction amounts. However, the total fee amounts for the reporting period will reconcile with the bank statement. > > For a more precise fee amount per merchant order number, the report can be modified to use the **Raw Settled Total Fee Amount** attribute instead of the Settled Total Fee Amount. However, if the Raw Settled Total Fee Amount attribute is used in the report configuration, the totals may not reconcile with the fund transfer amount or bank statement due to rounding differences. > ## Sample report configuration The following samples help you get an idea of how to configure transaction free details reports. ### CO/BU/TD/PE The following request code block shows how to configure a transaction free details report for `entityType` = CO/BU/TD/PE. ```json { "entityType": "CO", "entityIds": [ "1234567" ], "reportSections": [ { "sectionTitle": "Transaction Fee Details", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "reportAttributeName": "Activity Date" }, { "reportAttributeName": "Entity Identifier" }, { "reportAttributeName": "Entity Type Code" }, { "reportAttributeName": "Merchant Order Number" }, { "reportAttributeName": "Payment Method Code" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Foreign Exchange Rate" }, { "reportAttributeName": "Fund Transfer Instruction Number" }, { "reportAttributeName": "Presentment Amount", "alias": "Transaction Amount in Presentment Currency", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Settled Sales\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Settled Refunds\")" } ] }, { "reportAttributeName": "Settlement Amount", "alias": "Transaction Amount in Settlement Currency", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Settled Sales\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Settled Refunds\")" } ] }, { "reportAttributeName": "Settlement Amount", "alias": "Net Settled Sales Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Settled Sales\",\"Settled Refunds\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Interchange & Assessment Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Interchange & Assessment Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Back Up Withholding Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Back Up Withholding Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Chargeback Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Chargeback Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Discount Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Discount Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "ECP Return Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"ECP Return Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Other Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Other Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Processing Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Processing Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Reserve Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Reserve Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Others", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "NOT IN (\"Reserve Adjustments\",\"Interchange & Assessment Fees\",\"Back Up Withholding Adjustments\",\"Chargeback Adjustments\",\"Discount Fees\",\"ECP Return Adjustments\",\"Settled Sales\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Settled Refunds\", \"Other Adjustments\",\"Processing Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Net Financial Activity", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "NOT IN (\"Conveyed Sales\",\"Conveyed Refunds\")" } ] } ], "sectionSortOrderList": [ { "reportAttributeName": "Entity Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Payment Method Code", "sortOrderCode": "desc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] } ], "fileDelimiter": ",", "reportConfigurationName": "Transaction Fee Detail Report", "reportFileName": "Transaction Fee Detail Report,...", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "reportName": "Transaction Fee Detail Report", "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 transaction free details report for `entityType` = PI. ```json { "entityType": "PI", "entityIds": [ "6019581085" ], "reportSections": [ { "sectionTitle": "Transaction Fee Details", "sectionReportTypeName": "Submission Details", "sectionReportTypeId": "3003", "sectionSelectedFields": [ { "reportAttributeName": "Activity Date" }, { "reportAttributeName": "Transaction Processing Entity Identifier" }, { "reportAttributeName": "Merchant Order Number" }, { "reportAttributeName": "Payment Method Code" }, { "reportAttributeName": "Platform Identifier" }, { "reportAttributeName": "Platform Name" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Foreign Exchange Rate" }, { "reportAttributeName": "Fund Transfer Instruction Number" }, { "reportAttributeName": "Presentment Amount", "alias": "Transaction Amount in Presentment Currency", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Settled Sales\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Settled Refunds\")" } ] }, { "reportAttributeName": "Settlement Amount", "alias": "Transaction Amount in Settlement Currency", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Settled Sales\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Settled Refunds\")" } ] }, { "reportAttributeName": "Settlement Amount", "alias": "Settled Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Settled Sales\",\"Settled Refunds\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Interchange & Assessment Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Interchange & Assessment Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Back Up Withholding Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Back Up Withholding Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Chargeback Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Chargeback Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Discount Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Discount Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "ECP Return Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"ECP Return Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Other Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Other Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Processing Fees", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Processing Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Reserve Adjustments", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "IN (\"Reserve Adjustments\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Others", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "NOT IN (\"Reserve Adjustments\",\"Interchange & Assessment Fees\",\"Back Up Withholding Adjustments\",\"Chargeback Adjustments\",\"Discount Fees\",\"ECP Return Adjustments\",\"Settled Sales\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Settled Refunds\", \"Other Adjustments\",\"Processing Fees\")" } ] }, { "reportAttributeName": "Settled Total Fee Amount", "alias": "Net Financial Activity", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Charge Category Text", "aggregateConditionText": "NOT IN (\"Conveyed Sales\",\"Conveyed Refunds\")" } ] } ], "sectionSortOrderList": [ { "reportAttributeName": "Transaction Processing Entity Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Payment Method Code", "sortOrderCode": "desc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] } ], "fileDelimiter": ",", "reportConfigurationName": "Transaction Fee Detail Report", "reportFileName": "Transaction Fee Detail Report,...", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "reportName": "Transaction Fee Detail Report", "frequencyConfig": { "scheduleFrequency": "adhoc", "reportingPeriodStartTimestamp": "2024-02-21 04:00:00", "reportingPeriodEndTimestamp": "2024-02-22 03:59:59" } } ``` ## Download sample report Download the sample [Transaction free details report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Transaction%20Fee%20Details%20Preset%20Report.csv). ## Related [Scheduled and adhoc report configurations](/docs/commerce/optimization-protection/capabilities/reporting/report-configurations/scheduled-adhoc)