Funded transaction fee details report

This report provides the transactions, details of associated transactional and non-transactional fees and the net financial activity for transactions processed during specified reporting period having confirmed fund transfer.

Use cases

View the post funded transactions, associated fees and final net financial activity for a given reporting period.
Locate transaction activity associated with the fund transfer amount deposited to bank account on current day.

Note

Post Funded means fund transfer is confirmed.

Granularity

Merchant Order Number, Fund Transfer Instruction Number, Fund Transfer Identifier, and Action Type code.

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. Values are: BU - Business Unit CO - Company TD - Transaction Division
Entity Identifier	Associated CO, BU or TD identification number.
Payment Method Code	Code that identifies the (MOP) method of payment for the transaction.
Merchant Order Number	The order number submitted by the merchant with the original sale.
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.
Funds Transfer Category Text	Indicates the status of fund transfer. Ex: Effective Funds Transfer, Pending Funds Transfer, Rejected Funds Transfer etc.
Fund Transfer Identifier	Numeric identifier assigned to each unique funds transfer.
Fund Transfer Instruction Number	J.P. Morgan assigned fund transfer instruction number.
Fund Transfer Effective Date	Indicates the date on which the funds transfer is scheduled to be credited to the merchant’s bank account.
Acquirer Reference Number	Identifies a unique number assigned by the payment brand to a credit card transaction for use when it goes from the Firm acting as the acquiring bank through the payment processing network during settlement to the cardholders bank (the issuer).
Account Number	Cardholders account number.
Sale/Refund Code	Codifies transaction type. Valid values are: S - Sale R - Refund
Action Type code	Indicates the action associated with this transaction. Valid values are: Auth Sale Refund Reject Dispute Other
Secure Bank Account Number	Secure bank account number assigned by J.P. Morgan.
Presentment Amount	Monetary value of the transaction in presentment currency.
Presentment Amount in Settlement Currency	Monetary value of the transaction in settlement currency.
Net Settled Sales 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.

Note

Keep in mind that the firm's funding engine aggregates fee amounts for all transactions within a submission 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 Gross Funded merchants, fees amounts on daily report can be blank as they are configured to receive funding on monthly basis. Data appears on funded transaction Fee Details report only after the fund transfer is confirmed for the transactions. Please refer to the Transaction Fee Details report for the prefunded version, which provides information on transactions, fees, and net financial activity for the reporting period, regardless of funding activity.

Sample report configuration

The following request code block shows how to configure a funded transaction free details report for entityType = CO/BU/TD.

Json

{
    "entityType": "CO",
    "entityIds": [
        "1234567"
    ],
    
"reportSections": [
    {
        "sectionReportTypeName": "Fee Details",
        "sectionReportTypeId": "3006",
        "sectionTitle": "Funded Transaction Fee Detail",
        "sectionSelectedFields": [
           { 
                "reportAttributeName": "Activity Date"
            },
            {
                "reportAttributeName": "Entity Type Code"
            },
            {
                "reportAttributeName": "Entity Identifier"
            },
            {
                "reportAttributeName": "Payment Method Code"
            }, 
            {
                "reportAttributeName": "Merchant Order Number"
            },   
            {
                "reportAttributeName": "Presentment Currency Code"
            },
            {
                "reportAttributeName": "Settlement Currency Code"
            }, 
            {
                "reportAttributeName": "Foreign Exchange Rate"
            },   
            {
                "reportAttributeName": "Funds Transfer Category Text"
            },
            {
                "reportAttributeName": "Fund Transfer Identifier"
            },
            {
                "reportAttributeName": "Fund Transfer Instruction Number"
            },
            {
                "reportAttributeName": "Fund Transfer Effective Date"
            },
            {
                "reportAttributeName": "Acquirer Reference Number"
            },
            {
                "reportAttributeName": "Account Number"
            },
            {
                "reportAttributeName": "Sale/Refund Code"
            },
            {
                "reportAttributeName": "Action Type Code"
            }, 
            {
                "reportAttributeName": "Secure Bank Account Number"
            },
            {
                "reportAttributeName": "Presentment Amount"
            },          
            {
                "alias": "Presentment Amount in Settlement Currency",
                "reportAttributeName": "Transaction Amount"
            },
            {
                "reportAttributeName": "Settled Total Fee 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": "Other Fees",
                "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"
                }
            ],
            "sectionFilterAttributeList": [
                {
                    "reportAttributeName": "Settled Total Fee Amount",
                    "filterAttributeCode": "!=0.0"
                },
                {
                    "reportAttributeName": "Settled Conveyed Code",
                    "filterAttributeCode": "='S'"
                }
            ]
    }
],
"fileDelimiter": ",",
"reportConfigurationName": "Funded Transaction Fee Detail Report",
"reportFileName": "Funded 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": "Funded 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 funded transaction free details report for entityType = PE.

Json

{
    "entityType": "PE",
    "entityIds": [
        "1234567"
    ],
    "reportSections": [
        {
            "sectionReportTypeName": "Fee Details",
            "sectionReportTypeId": "3006",
            "sectionTitle": "Funded Transaction Fee Detail",
            "sectionSelectedFields": [
                {
                    "reportAttributeName": "Activity Date"
                },
                {
                    "reportAttributeName": "Transaction Processing Entity Identifier"
                },
                {
                    "reportAttributeName": "Payment Method Code"
                },
                {
                    "reportAttributeName": "Merchant Order Number"
                },
                {
                    "reportAttributeName": "Presentment Currency Code"
                },
                {
                    "reportAttributeName": "Settlement Currency Code"
                },
                {
                    "reportAttributeName": "Foreign Exchange Rate"
                },
                {
                    "reportAttributeName": "Funds Transfer Category Text"
                },
                {
                    "reportAttributeName": "Fund Transfer Identifier"
                },
                {
                    "reportAttributeName": "Fund Transfer Instruction Number"
                },
                {
                    "reportAttributeName": "Fund Transfer Effective Date"
                },
                {
                    "reportAttributeName": "Acquirer Reference Number"
                },
                {
                    "reportAttributeName": "Account Number"
                },
                {
                    "reportAttributeName": "Sale/Refund Code"
                },
                {
                    "reportAttributeName": "Action Type Code"
                },
                {
                    "reportAttributeName": "Secure Bank Account Number"
                },
                {
                    "reportAttributeName": "Presentment Amount"
                },
                {
                    "alias": "Presentment Amount in Settlement Currency",
                    "reportAttributeName": "Transaction Amount"
                },
                {
                    "reportAttributeName": "Settled Total Fee 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": "Othe Fees",
                    "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"
                }
            ],
            "sectionFilterAttributeList": [
                {
                    "reportAttributeName": "Settled Total Fee Amount",
                    "filterAttributeCode": "!=0.0"
                },
                {
                    "reportAttributeName": "Settled Conveyed Code",
                    "filterAttributeCode": "='S'"
                }
            ]
        }
    ],
    "fileDelimiter": ",",
    "reportConfigurationName": "Funded Transaction Fee Detail Report",
    "reportFileName": "Funded 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": "Funded 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 Funded transaction fee details report.

Preset reports