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.

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	Date the transactions/events took place
Entity Type code	Level at which reported event occurred. BU - Business Unit CO - Company TD - Transaction Division
Entity Identifier	Associated CO, BU or TD identification number.
Merchant Order Number	The order number submitted by the merchant with the original sale.
Payment Method Code	Code that identifies the (MOP) method of payment 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	J.P. Morgan assigned fund transfer instruction number.
Transaction Amount in Presentment Currency	Monetary value of the transaction in presentment currency.
Transaction Amount in Settlement Currency	Monetary Value of the transaction in settlement currency.
Settled Deposit Amount	Transaction amount qualified for funding. Only Settled Sales and Settled refunds are considered as Conveyed transaction amount is not funded.
Interchange & Assessment Fees	Total interchange and assessment amount charged for the transaction.
Back Up Withholding Adjustments	Total back up withholding adjustments associated with the transaction.
Chargeback Adjustments	Back up withholding adjustments associated with the transaction.
Discount Fees	Discount fees associated with the transaction.
ECP Return Adjustments	ECP return adjustments associated with the transaction.
Other Adjustments	Other adjustments associated with the transaction.
Processing Fees	Processing fees associated with the transaction. Merchant order number will be blank for non-transactional Fees such as ACH Transfer Fees.
Reserve Adjustments	Reserve adjustments associated with the transaction.
Others	Other fees charged within the reporting period.
Net Financial Activity	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.

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 request code block shows how to configure a transaction free details report for entityType = CO/BU/TD.

Json

{
   "entityType": "CO",
    "entityIds": [
        "1234567"
    ],
    "reportSections": [
        {
            "sectionReportTypeName": "Submission Details",
            "sectionReportTypeId": "3003",
            "sectionSelectedFields": [
                {
                   "reportAttributeName": "Activity Date"
                },
                {
                    "reportAttributeName": "Entity Type Code"
                },
                {
                    "reportAttributeName": "Entity Identifier"
                },
                {
                    "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": "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": "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": "2023-02-21 04:00:00",
        "reportingPeriodEndTimestamp": "2023-02-22 03:59:59"
    }
}

The following request code block shows how to configure a transaction free details report for entityType = PE.

Json

{
    "entityType": "PE",
    "entityIds": [
        "1234567"
    ],
    "reportSections": [
        {
            "sectionReportTypeName": "Submission Details",
            "sectionReportTypeId": "3003",
            "sectionSelectedFields": [
                {
                    "reportAttributeName": "Activity Date"
                },
                {
                    "reportAttributeName": "Transaction Processing Entity Identifier"
                },
                {
                    "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": "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,<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": "2023-02-21 04:00:00",
        "reportingPeriodEndTimestamp": "2023-02-22 03:59:59"
    }
}

Download sample report

Download the sample Transaction free details report.

Preset reports