Optimization Protection

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 Separated 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.

Attention

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 fee details reports.

CO/BU/TD/PE

The following request code block shows how to configure a transaction fee 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,<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": "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 fee details report for entityType = PI.